Hi ,

while try to open cases system we are seeing error at the step :Obj-open-by-handle

What we understand there is a failure while trying to read pzPVStream column. it is happening only for few production cases and not able to reproduce in lower environment

DB error :

ORA-29532: Java call terminated by uncaught Java exception: com.pega.pegarules.data.internal.clipboard.directstream.BadStreamDataException: Array index out of bounds during getInt. array length: 61540, source offset: 201454107

Pega Stack trace error :

MSG][Error occurred performing a "read" operation in a transaction][STACK][com.pega.pegarules.pub.PRRuntimeException: PRRuntimeException at com.pega.pegarules.data.internal.access.CompressImpl.inflate(CompressImpl.java:184) at com.pega.pegarules.data.internal.clipboard.StorageStreamCommonImpl.inflateStream(StorageStreamCommonImpl.java:627) at com.pega.pegarules.data.internal.access.PageDatabaseMapperImpl.populatePageOrStringMapFromStreamColumnUsingDataStore(PageDatabaseMapperImpl.java:2238) at com.pega.pegarules.data.internal.access.PageDatabaseMapperImpl.populatePageOrStringMapFromStreamColumn(PageDatabaseMapperImpl.java:2174) at com.pega.pegarules.data.internal.access.PageDatabaseMapperImpl.createPageFromResultSetDatabase(PageDatabaseMapperImpl.java:499) at com.pega.pegarules.data.internal.access.PageDatabaseMapperImpl.createPageFromResultSet(PageDatabaseMapperImpl.java:458) at com.pega.pegarules.data.internal.store.AutoCommitTransaction.getResultFromResultSet(AutoCommitTransaction.java:459) at com.pega.pegarules.data.internal.store.AutoCommitTransaction.performQuery(AutoCommitTransaction.java:359) at com.pega.pegarules.data.internal.access.Opener$1.getResultPageFromDatabase(Opener.java:744) at com.pega.pegarules.data.internal.access.Opener$1.action(Opener.java:727) at com.pega.pegarules.data.internal.access.Opener$1.action(Opener.java:724) at com.pega.pegarules.data.internal.store.DataStoreManager.readInTransaction(DataStoreManager.java:70) at com.pega.pegarules.data.internal.access.Opener.openData(Opener.java:755) at com.pega.pegarules.data.internal.access.Opener.openData(Opener.java:469) at com.pega.pegarules.data.internal.access.Opener.open(Opener.java:2390) at com.pega.pegarules.data.internal.access.DatabaseImpl.open(DatabaseImpl.java:2627) at com.pega.pegarules.pub.runtime.AbstractActivity.objOpenByHandle(AbstractActivity.java:121) at com.pegarules.generated.activity.ra_action_open_1025c7b64a55f65f19df4e381e643503.step8_circum0(ra_action_open_1025c7b64a55f65f19df4e381e643503.java:1110) at com.pegarules.generated.activity.ra_action_open_1025c7b64a55f65f19df4e381e643503.perform(ra_action_open_1025c7b64a55f65f19df4e381e643503.java:195) at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3421) at com.pegarules.generated.activity.ra_action_douiaction_49ab53cffbb13c5523107e9938f4dbb5.step28_circum0(ra_action_douiaction_49ab53cffbb13c5523107e9938f4dbb5.java:2922) at com.pegarules.generated.activity.ra_action_douiaction_49ab53cffbb13c5523107e9938f4dbb5.perform(ra_action_douiaction_49ab53cffbb13c5523107e9938f4dbb5.java:527) at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3421) at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:646) at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.runActivitiesAlt(PRThreadImpl.java:484) at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.runActivities(HttpAPI.java:3467) at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequestInner(EngineAPI.java:417) at sun.reflect.GeneratedMethodAccessor144.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1368) at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1105) at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:959) at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequest(EngineAPI.java:354) at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.invoke(HttpAPI.java:855) at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl._invokeEngine_privact(EngineImpl.java:331) at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:274) at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:251) at

***Edited by Moderator: Pallavi to update platform capability tags***