We are doing Bulk Revalidate and Save for our applications. When we are selecting Application option and keeping multithread enabled/disabled, it is not giving us the report even after 3-4 hours. So we are doing it selecting Ruleset option, one ruleset at a time, keeping Version as All. This is working for few rulesets and we are getting the report but for few other rulesets it gets hanged and stays like that for hours.
Any resolution for this?
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
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: "PEGADBOWNER"."PR_READ_FROM_STREAM": invalid identifier
com.pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code: 904 SQLState: 42000 Message: ORA-00904: "PEGADBOWNER"."PR_READ_FROM_STREAM": invalid identifier
SQL: SELECT "PC0".PXCREATEDATETIME AS "pxCreateDateTime" , "PC0".PXUPDATEDATETIME AS "pxUpdateDateTime" , "PC0".PXCREATEOPNAME AS "pxCreateOpName" , "PC0".PXCREATEOPERATOR AS "pxCreateOperator" , "PC0".PYLABEL AS "pyLabel" , "PC0".PXUPDATEOPNAME AS "pxUpdateOpName" , PEGADBOWNER.pr_read_from_stream('.txUtilityType', "PC0".pzInsKey, "PC0".pzPVStream) AS "txUtilityType" , "PC0".PZINSKEY AS "pzInsKey" FROM PEGADBOWNER.pr_bulkuiupg_audit "PC0" WHERE ( "PC0".PXUPDATEOPNAME LIKE ? AND PEGADBOWNER.pr_read_from_stream('.txUtilityType', "PC0".pzInsKey, "PC0".pzPVStream) = ? ) AND "PC0".pxObjClass = ? ORDER BY 1 DESC
You can search for txUtilityType property in the application, it is shipped through ECS Upgrade utilities. Expose that property as a column using the optmize property option. This would be avialable in the Actions menu of the specific property. The class to be optmized for can be all the ECS Upgrade utilities classes and the table would be the audit table of the upgrade utilities.
After it is optimized you can re-launch the landing page and see if you are able to proceed further.