Support Article
Obj-browse triggering additional queries
SA-30648
Summary
When executing an Obj-Browse against a fully exposed external database (DB) view, the following query is seen running multiple times.
SELECT pyRuleName as "pyRuleName" FROM MY_RULES_SCHEMA.pr4_rule_property WHERE pxObjClass = 'Rule-Obj-Property' AND UPPER(pyRuleName) IN ('PROPERTY1','PROPERTY2','PROPERTY3',
...
Error Messages
Not Appliacable
Steps to Reproduce
Execute an Obj-Browse against an external DB view.
Root Cause
An issue in the custom application code or rules where properties included in the Obj-Browse did not have associated columns in the fully exposed external DB view.
Resolution
Perform the following local-change: Remove the properties which do not have associated columns, or add the columns to the fully exposed external DB view.
Published November 22, 2016 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.