Error while extracting work Object using BIX batch jobs.
We are using Pega BIX 7.1 for extracting data from our Pega App DB which is hosted in DB2. We are receiving the following error:
We are using Pega BIX 7.1 for extracting data from our Pega App DB which is hosted in DB2. We are receiving the following error:
DEBUG - sql statement is: SELECT pzPVStream FROM pca_work WHERE pxObjClass
like ? AND pxUpdateDateTime > ? AND pxUpdateDateTime < ? ORDER BY pzInsKey
[java] 08:25:39,239 [ main] ( engine.database.ExtractImpl)
DEBUG - Generated SQL: SELECT pzPVStream FROM pca_work WHERE pxObjClass like
? AND pxUpdateDateTime > ? AND pxUpdateDateTime < ? ORDER BY pzInsKey
[java] 08:25:40,270 [ main] ( engine.database.ExtractImpl)
INFO - Processing Class: CC-CPM-Work-Claim-ReportADeath with 125.0
instances
[java] 08:25:40,270 [ main] ( engine.database.ExtractImpl)
INFO - BIX Version : 2.3.1
[java] Jan 25, 2019 8:25:40 AM com.pega.pegarules.internal.bootstrap.PRBoot
strap
[java] INFO: PRBaseLoader jar path entry = D:\BIX\lib\pega\base
[java] Jan 25, 2019 8:25:40 AM com.pega.pegarules.internal.bootstrap.PRBoot
strap
[java] 19830421: PegaRULES classes will be loaded from jar files (and NOT t
he database)
[java] Jan 25, 2019 8:25:40 AM com.pega.pegarules.internal.bootstrap.PRBoot
strap
[java] INFO: PRAppLoader jar path entry = D:\BIX\lib\pega\pega
[java] 08:25:40,458 [ main] ( engine.database.ExtractImpl)
ERROR - Unable to process CC-CPM-Work-Claim-ReportADeath: InvalidStr
eam StorageStreamCommon.create(byte []) Invalid signature found in strea
m.
[java] com.pega.pegarules.pub.clipboard.InvalidStreamError: InvalidStream
StorageStreamCommon.create(byte []) Invalid signature found in stream.
[java] From: (unknown)
[java] at com.pega.pegarules.engine.clipboard.StorageStreamCommon.creat
e(StorageStreamCommon.java:491)
[java] at com.pega.pegarules.engine.clipboard.StorageStreamCommon.creat
e(StorageStreamCommon.java:462)
[java] at com.pega.pegarules.engine.clipboard.ClipboardPageImpl.adoptSt
reamForm(ClipboardPageImpl.java:482)
[java] at com.pega.pegarules.engine.clipboard.ClipboardPageImpl.adoptSt
reamForm(ClipboardPageImpl.java:477)
[java] at com.pega.pegarules.engine.clipboard.ClipboardPageFactory.acqu
ireAndAdopt(ClipboardPageFactory.java:148)
[java] at com.pega.pegarules.engine.database.ExtractImpl.doExtract(Extr
actImpl.java:2325)
[java] at com.pega.pegarules.engine.database.ExtractImpl.runExtract(Ext
ractImpl.java:1165)
[java] at com.pega.pegarules.engine.database.ExtractImpl.run(ExtractImp
From the above log I can see, the extract job is able to identify the # of item that needs to be extracted but while trying to parse the object it failed.Please let me know if this is a known issue or how to resolve this.
***Edited by Moderator: Pallavi to update platform capability tags***
Accepted Solution
Pegasystems Inc.
US
Hello,
I believe the database/storageversion=7 is compatible post Pega 7.1.8 onwards i think, may be you need to upgrade your BIX to Pega 7.1.8 verison as reported over here. Hope this might help you.
Regards,
Mahesh M
Pegasystems Inc.
GB
Does this issue apply for one particular workitem? Can you atttach a full BIX log file?
Regards
Simon
EY
US
So to start with, earlier we encounter OOM issue in our JVMs after we implemented some Async Calls. After reviewing our log Pega provided some fix and one of them is as below
<env name=”database/storageversion” value=”7” /> (note this setting before we had value of 6)
<env name=”clipboard/encoder/poolConfig” value=”reset-contents” />
After adding this setting in our prconfig.xml we see the above mentioned error in our BIX log. All extracting jobs are impacted and not related to any single workitem.
Accepted Solution
Pegasystems Inc.
US
Hello,
I believe the database/storageversion=7 is compatible post Pega 7.1.8 onwards i think, may be you need to upgrade your BIX to Pega 7.1.8 verison as reported over here. Hope this might help you.
Regards,
Mahesh M