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

Database insert failing, value of host variable is out of range

SA-557

Summary



A database insertion fails, when trying to save an instance of a class. with PRPC 6.2 SP1.

Error Messages



com.pega.pegarules.pub.database.DatabaseException: Database-Saver-InsertUpdatefail
From: (HC0C639C3338D8DFA4E35A6A17AD66A57:127.0.0.1)
SQL: update pr_sys_queue_pcm_new set PXCREATEDATETIME = ? , PXINSNAME = ? , PXLASTEXECUTIONDATETIME = ? , PXOBJCLASS = ? , PXPROCESSINGNODEID = ? , PYAGENTNAME = ? , PYATTEMPTS = ? , PYITEMID = ? , PYITEMSTATUS = ? , PYMAXATTEMPTS = ? , PYMINIMUMDATETIMEFORPROCESSING = ? , PYPRIORITY = ? , PYSELECTID = ? , pzPVStream = ? where pzInsKey = ?
SQL Inserts: <> <> <1> <> <> <> <> <>

Caused by SQL Problems.
Problem #1, SQLState 22001, Error code -302: com.ibm.db2.jcc.am.SqlDataException: The value of a host variable in the EXECUTE or OPEN statement is out of range for its corresponding use.. SQLCODE=-302, SQLSTATE=22001, DRIVER=3.65.77

Steps to Reproduce



Use an activity to try saving an instance of System-Queue-PCMClient.

Root Cause



The root cause of this problem is a defect in the DDL for the
pr_sys_queue_pcm table.  The PZPVSTREAM BLOB size was set to 5 bytes.

Resolution



Drop the pr_sys_queue_pcm table and recreate it with the PZPVSTREAM BLOB size set to 5 Mb.
Suggest Edit

Published November 12, 2015 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

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

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
Contact us