Setting up a Query Database Smart node

sswilliams over 7 years ago

I'm trying to connect to my Oracle database using the Query Database smart node in the process modeler. I run into an issue when I add a 'where' clause to my SQL statement. I get the following error: There was a problem during the validation of the SQL statement with the database. The SQL Query is invalid, ORA-00942: table or view does not exist. This is the SQL statement: select ROWNUM, APPLICATION_NAME, ENVIRONMENT, OS, INSTANCE_NAME, HOSTNAME from web.vw_oracle_dds_inventory where APPLICATION_NAME=ac!applicationName and ENVIRONMENT=ac!Environment order by HOSTNAME. If I remove the 'where' clause from the SQL statement, I'm able to save and close the node. I'm using Appian v16.2. Can someone assist me with this error? Thanks...

Discussion posts and replies are publicly visible

Parents

0 sswilliams over 7 years ago

I removed 'web' from the statement. Still getting the same error. I get the following error on the statement without the 'where' clause and with 'web' removed as well: There was a problem during the validation of the SQL statement with the database. he database returned ARV's that may not be supported. Message: ORA-00942: table or view does not exist.
Is there something else that I can try?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sswilliams over 7 years ago

I removed 'web' from the statement. Still getting the same error. I get the following error on the statement without the 'where' clause and with 'web' removed as well: There was a problem during the validation of the SQL statement with the database. he database returned ARV's that may not be supported. Message: ORA-00942: table or view does not exist.
Is there something else that I can try?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data