Hello Everybody, Has anybody encountered a problem where a datastore

Have you turned on logging to output your SQL statements?

Add the following to your appian_log4j.properties:
log4j.logger.org.hibernate.SQL=DEBUG

Once you turn on SQL trace statements, try to determine if the tables in the SQL statements exist in your database.

Doesn't the datastore validation guarantee that the table exists and that appian has access to it?

There are a couple of things that could be going on and the detailed log statements will help to determine the root cause. Can you also attach the full stack trace to this post?

That's another concerning thing - that was the entire stack trace. There are no further lines with matching timestamps (at least nothing with a couple of minutes).

17:57:42,602 INFO [stdout] (ajp-/0.0.0.0:8009-6) 2014-11-25 17:57:42,602 [ajp-/0.0.0.0:8009-6] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00942: table or view does not exist
17:57:42,602 INFO [stdout] (ajp-/0.0.0.0:8009-6)

Here is the debug output from the jboss log with the SQL debug enabled.

LogOutput.txt

You may also want to check directly in the database if the table/view exists and if the schema configured with Appian has the appropriate privileges granted. It may be possible that the table may have been deleted after the validation was done.

I have verified the data store many times before and after the error occurred. It still says the connection and table are correct. For what it's worth I have also checked the permissions and access on the database directly.

what is the database Oracle or My SQL ? If Oracle, look into the case mismatch in table, primary key field name, etc.

Did you experiment with Query Database node? To try out a simple query to the affected table/view via both 'pre-defined data source' and 'custom data source' options.

Same issue we are also facing.. datastore created successfully, but not able to query data using query entity and record as well