• State Not Answered
  • Replies 13 replies
  • Subscribers 8 subscribers
  • Views 5977 views
  • Users 0 members are here
Related Discussions
Home » Discussions » AI and Rules

Hello Everybody, Has anybody encountered a problem where a datastore

Jin Pheh
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 Children
  • 0 in reply to sayalic0004
    sayalic0004 said:
    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.

© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.