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
2622 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
sswilliams
over 7 years ago
abhinavg712 - the things that are recommended on the website you suggested were done prior to submitting this and were done again. IE - permissions are good. The statement is working fine in our DEV and Production environments.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
sswilliams
over 7 years ago
abhinavg712 - the things that are recommended on the website you suggested were done prior to submitting this and were done again. IE - permissions are good. The statement is working fine in our DEV and Production environments.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data