Hello Everybody, Has anybody encountered a problem where a datastore

Certified Associate Developer
Hello Everybody,

Has anybody encountered a problem where a datastore is valid yet you are unable to query an object from it? I am running into exactly this problem where both queryEntity expressions and query rules fail to read the object and throw the following error:
ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00942: table or view does not exist
...

OriginalPostID-130212

OriginalPostID-130212

  Discussion posts and replies are publicly visible

Parents Reply
  • Facing similar issue. Any solution on this.

    As this thread is 8 years old, you may want to start one on your specific scenario and all of the details on your specific issue.

    What I can note however, is that if the Oracle object's owning schema is different than your account's schema, you may need to create a synonym in the DB under the schema of the account, to point to the table you are trying to access.  This is due to a difference in java libraries used by Appian in datastore validation, and datastore usage (assuming it is still the same it has been in the past), where objects in different schemas can be seen, but not used.

Children
No Data