Posted: 4 Jul 2018 10:43 EDT Last activity: 7 Aug 2018 9:16 EDT
Error during report def execution
I am creating a report definition of Rule-Obj-Flow class to extract a report of the flows with draft on.
The columns i use are .pyDraftModeON, .pyFlowType,.pyRuleSetVersion,.pyClassName.
The filters i use are .pyDraftModeON Is equal true, .pyRuleAvailable Is equal to "Yes" , .pyClassName Starts with "#Class prefix#".
Have mentioned the class Rule-Obj-Flow in the Pages&Classes tab.
The report saved fine and when i try to run it, gives the following sql error:
" An error occured on executing the query for the report definition - There was a problem getting a list: code: 904 SQLState: 42000 Message: ORA-00904: : invalid identifier"
The printed sql and values in log console are :
SQL: SELECT RULES_SCHEMA.pr_read_from_stream('.pyDraftModeON', "PC0".pzInsKey, "PC0".pzPVStream) AS "pyDraftModeON" , "PC0".PYFLOWTYPE AS "pyFlowType" , "PC0".PYCLASSNAME AS "pyClassName", MAX("PC0".PYRULESETVERSION) AS "pySummaryText(1)" FROM RULES_SCHEMA.pr4_rule_flow "PC0" WHERE ( RULES_SCHEMA.pr_read_from_stream('.pyDraftModeON', "PC0".pzInsKey, "PC0".pzPVStream) = ? AND "PC0".PYCLASSNAME LIKE ? AND "PC0".PYRULEAVAILABLE = ? ) AND "PC0".pxObjClass = ? GROUP BY RULES_SCHEMA.pr_read_from_stream('.pyDraftModeON', "PC0".pzInsKey, "PC0".pzPVStream) , "PC0".PYFLOWTYPE , "PC0".PYCLASSNAME ORDER BY 1 ASC, 2 ASC, 4 ASC, 3 ASC
SQL Inserts: <true> <CCC-%> <Yes>
Not sure why its failing. Could you please help.
Is this a known issue for which any hotfix was provided ?
Also i am unable to optimise .pyDraftModeON as upon right clicking this property in App explorer under Rule-Obj-Flow does not show the option to optimise.
Hi pyDraftModeOn is unexposed column so on report defination execution it is using UDF fucntion i think your UDF functions or corrupted. Use below link and verify if UDF fuctions are currupted, then reinstall.