Question

3
Replies
44
Views
PRITPAD Member since 2010 12 posts
EY
Posted: 1 year ago
Last activity: 1 year 9 months ago
Closed
Solved

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:

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***

Low-Code App Development Data Integration
Moderation Team has archived post
Share this page LinkedIn