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

mariod over 9 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 9 years ago

Eduardo, approach 1, step 1: the schema name for the view is in the DB2 database. If this is what you mean, I will put in a request tomorrow to have it changed. Can you confirm my understand for this step is correct?

Thanks, Mario
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 mariod over 9 years ago

Eduardo, approach 1, step 1: the schema name for the view is in the DB2 database. If this is what you mean, I will put in a request tomorrow to have it changed. Can you confirm my understand for this step is correct?

Thanks, Mario
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data