LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Feridun

Hi everyone,

one of our customers is facing an oracle error ORA-01157. The reason seems to be oracle DB specific. However, the query he sends from DB Query node gives the error, while it runs perfectly in SQL Developer Tool.

They believe that the reason might be because they're trying to access data from a live Database.

Do you have any idea why it could happen?

Also, is there a setting in Lavastorm in order to modify this data acquisition process from Oracle?

Thanks in advance

Feridun

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ejones

Interesting error. This seems to be an issue with the database and a DBA would need to be involved with finding out what is happening. Somehow an internal data file used by Oracle for the database is not available because it is locked or maybe missing.

This is a long shot and doesn't quite fit what the error describes. Is it possible that the SQL Developer tool has locked some part of the database making it unavailable to the LAE DB Query node? This might happen if the SQL Developer tool has opened a transaction and Oracle has locked some resource making it unavailable for any other process trying to do the same thing.