General SQL error blocking dataset refresh

Question & Answer
1

One of our datasets isn’t refreshing and gives the following error:

This is a general SQL error. This can be caused by query timeouts, resource constraints, unexpected DDL alterations before or during a query, and other database errors. Check your database settings and your query, and try again.

The specific error is below:

ERROR: function textregexeq(integer, unknown) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 10897

This dataset calls upon a view in our database - when I select from that view in our database I don’t receive any errors.

This dataset calls on a view in our database, but the function “textregexeq” isn’t in the view’s definition. The view calls upon many other views - but none use this function name and it is hard to figure out what exact function / data might be causing this error. Any ideas on getting a more descriptive error message or interpreting this one?

1 Like
2

What’s the database involved? Also, are you doing any calculated fields in the dataset? Third, are you casting any of the fields in the view to be different datatype in the dataset? Finally, is there any filters involved as part of the custom SQL on the primary view used by the dataset?

3

Hi @jaipaulmann. Has this been resolved? If so, please help the community by marking the appropriate post as “Solution”. If you still need assistance, please provide additional detail. Thanks!