Issues in Data transform

[Rakeshr7 (Rakesh kumar)]

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”)

[Veera_Gollapalli (Veera Ganga Babu Gollapalli)]

@Rakeshr7 Please 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.

[Rakeshr7 (Rakesh kumar)]

@VeeraGangaBabu Thank you, we tried it and restarted also. Still issues exists

[NareshRP]

@Rakeshr7 is this issue resolved. We are also seeing same issue. Increased the memory and cleared the cache but no luck.

[NareshRP]

@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