Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Errors occur on indexing work items

SA-96153

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

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Pega GenAI Athena

Let’s get started! 
Ask me a question or choose a helpful suggestion to start chatting. Keep in mind that I’m always learning, so feel free to give me feedback too!
Remember to avoid sharing personal or sensitive information in your questions, or rely solely on my answers for important decisions.
By chatting with me, you agree to our terms and privacy policy.

Did you find this content helpful?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice