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?