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.
Did you try to check the logfile tomcat_stdout? Typically there are more details about DB errors.