I have a data store called IPMDS2 using the jdbc/IPMDS2DataSource entry in the c

kevind605 over 11 years ago

I have a data store called IPMDS2 using the jdbc/IPMDS2DataSource entry in the config for an Oracle database. In that data source is an entity called lab_orders which was created automatically from a complex data type called Lab_Orders. I can write to this table using the write to data store entity smart servcie. I can retrieve data from the table using a query rule. But when I try to use the query database smart service and enter a query to retrieve the data, I get: The database returned ARV's that may not be supported. Message: Table \\'ipmds2.lab_orders\\' doesn\\'t exist. Any ideas why? Thanks.
...

Discussion posts and replies are publicly visible

0 Sathya Srinivasan
Appian Employee
over 11 years ago

Are you using any alias columns or expressions in your SQL?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 kevind605 over 11 years ago

Nope. I tried the simplest of queries...select orderID from lab_orders. orderID is one of the fields in the table, and the query rule retrieves it no problem. I made sure I picked the correct data store from the drop-down on the setup tab of the query database smart service. And I used the rule in the same process model as the query smart service, just to eliminate that question.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 elizabeth.epstein over 11 years ago

If you can look at your actual table definitions in Oracle, please verify their capitalization scheme, the table names and whether or not they are surrounded by quotes. Per the default naming strategy, when Appian creates tables/columns in Oracle they may be shortened and/or surrounded by quotes. E.g. you might try select "orderID" from "lab_orders".
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 elizabeth.epstein over 11 years ago

You can also enable debugging of query rules as described here: forum.appian.com/.../Logging
That way you can see exactly what SQL Appian is sending over for the query rules and data store updates which are working correctly.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 kevind605 over 11 years ago

thanks for the suggestions. We'll give them a try.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel