Setting up a Query Database Smart node

sswilliams over 8 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 abhinavg712
Certified Lead Developer
over 8 years ago

Try saving the node without the table alias as 'web'
SELECT
ROWNUM,
APPLICATION_NAME,
ENVIRONMENT,
OS,
INSTANCE_NAME,
HOSTNAME
FROM vw_oracle_dds_inventory
WHERE APPLICATION_NAME = ac!applicationName and
ENVIRONMENT=ac!Environment order by HOSTNAME
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 abhinavg712
Certified Lead Developer
over 8 years ago

Try saving the node without the table alias as 'web'
SELECT
ROWNUM,
APPLICATION_NAME,
ENVIRONMENT,
OS,
INSTANCE_NAME,
HOSTNAME
FROM vw_oracle_dds_inventory
WHERE APPLICATION_NAME = ac!applicationName and
ENVIRONMENT=ac!Environment order by HOSTNAME
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data