Hi,
I'm trying to query an external data base using a!query function, like the next image.
The Data Store have all cdt created from the third party credentials.
I need know if i can use all appian objects normally with an external database.
Discussion posts and replies are publicly visible
How many rows of data does your table have? Can you try querying with a batch size of 10 first? Sometimes, if the table has huge data, then querying the entire data will not work.
Yes and didn't work, this have 31 rows in the table.
If your database connection has no issues, then my next recommendation is to validate the data present in the table.
For example, if a date column has values like "0000-00-00" which is unsupported by Appian, then we will get this error. Please validate your data set once.
the table is make in postgress this is an image of the rows, all is right.
The problem was resolved, thanks a lot to the people who answered. The problem reviewing the logs, was that the user used in the third party credentials had access permissions to the database, but not to the database tables, so the problem was permissions. It has already been resolved in case someone else has the same problem :D.
Did you try to check the logfile tomcat_stdout? Typically there are more details about DB errors.