Support Article
Errors occur on indexing work items
Summary
Errors occur on indexing a few work items in the Development environment post upgrading to Pega 8.3 from Pega 7.1.9.
Error Messages
ERROR - There was a problem with the database when getting a list:
com.pega.pegarules.pub.database.BadInstanceDataException: Cannot populate page or StringMap from DataStoreResultSet as it has a null or zero length stream (pzPVStream column): code: <none> SQLState: <none> Message: <none>
at com.pega.pegarules.data.internal.access.PageDatabaseMapperImpl.populatePageOrStringMapFromStreamColumnUsingDataStore(PageDatabaseMapperImpl.java:2325) ~[prprivate-data.jar:?]
at com.pega.pegarules.data.internal.access.PageDatabaseMapperImpl.populatePageOrStringMapFromStreamColumn(PageDatabaseMapperImpl.java:2310) ~[prprivate-data.jar:?]
at com.pega.pegarules.data.internal.store.rdbms.ResultPageIteratorImpl.getClipboardPage(ResultPageIteratorImpl.java:1015) ~[prprivate-data.jar:?]
at com.pega.pegarules.data.internal.store.rdbms.ResultPageIteratorImpl.<init>(ResultPageIteratorImpl.java:439) ~[prprivate-data.jar:?]
at com.pega.pegarules.data.internal.store.rdbms.ResultPageIteratorImpl.<init>(ResultPageIteratorImpl.java:345) ~[prprivate-data.jar:?]
at com.pega.pegarules.data.internal.store.rdbms.ResultPageIteratorImpl.createResultPageIteratorForResults(ResultPageIteratorImpl.java:748) ~[prprivate-data.jar:?]
at com.pega.pegarules.data.internal.access.ResultIteratorResultPackagerImpl.packageResults(ResultIteratorResultPackagerImpl.java:176) ~[prprivate-data.jar:?]
at com.pega.pegarules.data.internal.access.Lister.listWithResultPackager(Lister.java:406) ~[prprivate-data.jar:?]
Steps to Reproduce
Upgrade to Pega 8.3 after applying Data Definition Language (DDL) manually.
Root Cause
A defect or configuration issue in the operating environment. At the database level, a few of the older work objects in this column lost reference to the pzPVStream Binary Large Object (BLOB) column content. However, the work object cannot be accessed without the BLOB column.
Resolution
Perform the following local-change:
Remove all of the instances from work table where the pzPVStream column is null.
Published December 23, 2019 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.