Bulk Revalidate and Save not working
Hi,
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.
Pegasystems Inc.
IN
Hi,
Do you see any errors / exceptions in the logs?
Please share the stacktrace, if any.
Try to have the ECS RuleSet in the application stack and then re-trigger it.
Infosys
IN
Found below error in log
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
From: (H8ADA7BCA54C4723039EDE3FEFA62EE58:F34E6D734817C.bankofamerica.com)
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
SQL Inserts: <%.xls%> <BulkRevalidate> <Pega-Landing-PrototypeUtilities-Upgrade>
Caused by SQL Problems.
Problem #1, SQLState 42000, Error code 904: java.sql.SQLSyntaxErrorException: ORA-00904: "PEGADBOWNER"."PR_READ_FROM_STREAM": invalid identifier
Found below error in log
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
From: (H8ADA7BCA54C4723039EDE3FEFA62EE58:F34E6D734817C.bankofamerica.com)
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
SQL Inserts: <%.xls%> <BulkRevalidate> <Pega-Landing-PrototypeUtilities-Upgrade>
Caused by SQL Problems.
Problem #1, SQLState 42000, Error code 904: java.sql.SQLSyntaxErrorException: ORA-00904: "PEGADBOWNER"."PR_READ_FROM_STREAM": invalid identifier
at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:262)
at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:6220)
at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:5916)
at com.pega.pegarules.data.internal.rd.queryexec.SqlQueryExecutor.executeQuery
Pegasystems Inc.
IN
Are UDFs not installed in the environment, is a conscious decision or was it missed during the upgrade process?
Pegasystems Inc.
IN
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.