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

Parents

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

Reply

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

Children

No Data