Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
6 replies
Subscribers
4 subscribers
Views
2623 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
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...
OriginalPostID-261246
Discussion posts and replies are publicly visible
Parents
0
bhanuprakashm
over 7 years ago
@sswilliams, Can you please check the column names in the table..if anything is wrong it shows this message..before write this code in this querynode ..please check in db.
if it execute successfully there is no issues,,
Hope it will help you
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
bhanuprakashm
over 7 years ago
@sswilliams, Can you please check the column names in the table..if anything is wrong it shows this message..before write this code in this querynode ..please check in db.
if it execute successfully there is no issues,,
Hope it will help you
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data