Need help using a query rule with a DB2 database running on a Linux server.

mariod over 10 years ago

Need help using a query rule with a DB2 database running on a Linux server.
we are using a DB2 database for the first time and while testing the query rule, the following error is displayed:
There was an error testing the rule:
Expression evaluation error in rule 'testsccdrule' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Unexpected error executing query (type: [SCCDDBHIERARCHYALLDT5651], query: [testSCCDRule], order by: [[Sort[hierarchyDescription asc]]], filters:[null])

I can query the view using the database node but I cannot get a CDT to work using a query rule.

The view only has one varchar field and we are on Appian v7.3
...

Discussion posts and replies are publicly visible

Parents

0 mariod over 10 years ago

Eduardo, after looking into the application log as per your suggestion, I did find the following: Caused by: java.sql.SQLSyntaxErrorException: [FMWGEN][DB2 JDBC Driver][DB2]APPIANDB.UPS_ORGHIERARCHY IS AN UNDEFINED NAME
APPIANDB is not defined in the CDT, only UPS_ORGHIERARCHY which is the view name.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 mariod over 10 years ago

Eduardo, after looking into the application log as per your suggestion, I did find the following: Caused by: java.sql.SQLSyntaxErrorException: [FMWGEN][DB2 JDBC Driver][DB2]APPIANDB.UPS_ORGHIERARCHY IS AN UNDEFINED NAME
APPIANDB is not defined in the CDT, only UPS_ORGHIERARCHY which is the view name.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data