The Invalid SQL error is issued in the following situations:

You have to fix the SQL associated with this query, in order to use an entity available in your application.

You have to fix the SQL associated with this query, in order to use an attribute available in your application.

Depending on your requirements, do one of the following: fix the SQL associated with this query, in order to use an available parameter; or change the input parameters of this query.

You have to fix the SQL associated with this query, in order to have spaces separating your input parameters.

You have to fix the SQL associated with this query, in order to remove the references to any of the above system tables.

Edit this query and set its output structure. How?

You have to fix the Output Structure of this query by doing one of the following: use a different structure with no nested elements; or redefine this structure in order to avoid nested Records or Lists.

Edit the input parameters of this query and do one of the following: set the Expand Inline property of the input parameter; or change the data type of this input parameter to Text.

Edit the query and put each group of Foreign Entities in its separate query - the groups are detailed in the error message to help you. If you have joins between Foreign Entities that have to be separated, join manually the result sets.

Review the logic of your application so that the query you are using is a SELECT statement and thus, have the query count filled with the number of records.

 

Clicking the symbol will take you directly to the parent action flow and highlights the SQL query that has the error.

See Also

About Error Messages