Issues in Data transform
Hi,
When we open the data transform, we could see below error. We have cleared the inactive sessions in DB and made the free space, such that only it occupied 8% of memory before opening this rule. cleared the cache and restarted the servers. But still we are seeing the same issue. Please let us know if anyone aware of this. Thank you.
pzSectionBody_1(); /* Problem executing pzAssemblePreprocess for RULE-HTML-SECTION EMBED-MODELPARAMS PZDEFINITIONACTIONSELECT #20180713T135214.544 GMT com.pega.pegarules.pub.PRRuntimeException: caught DatabaseException while trying to open conclusion Property!: There was a problem getting a list: code: 4031 SQLState: 61000 Message: ORA-04031: unable to allocate 4120 bytes of shared memory ("shared pool","unknown object","KGLH0^5003594","kglnti-2D")
Accepted Solution
Updated: 14 Jan 2022 12:08 EST
Virtusa
IN
@NareshRP It is resolved now. Please try the below steps if you have still issues after clearing the cache,
Step1: Click on "Preferences" on operator id and enable the Diagnostics check box and save
Step2: Search the rule pzDefinitionActionSelect and do private edit and open your Data Transform. If it is working then search for "BulkValidateSave" and validate the above rule then it should work :)
Yash Technologies
SG
@Rakeshr7Please check if below article helps! https://community.pega.com/support/support-articles/databaseexception-trying-open-conclusion-property-pxrdberror
If it doesn't work, try removing the cache from memory and database and give it a try. This might fix the issue.
Wells Fargo
IN
@Veera GollapalliThank you, we tried it and restarted also. Still issues exists
Accepted Solution
Updated: 14 Jan 2022 12:08 EST
Virtusa
IN
@NareshRP It is resolved now. Please try the below steps if you have still issues after clearing the cache,
Step1: Click on "Preferences" on operator id and enable the Diagnostics check box and save
Step2: Search the rule pzDefinitionActionSelect and do private edit and open your Data Transform. If it is working then search for "BulkValidateSave" and validate the above rule then it should work :)