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

DB2 SQLCODE=-302 When Creating SOAP Connector Rule



An SQL error occurs when creating SOAP Connector Rule using the Connector and Metadata Accelerator.

Error Messages

caught db exception: There was a problem getting a list: code: -302 SQLState: 22001 Message: 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.50.152

Steps to Reproduce

Use the Connector Accelerator to create a Connector rule.

Root Cause

A defect in Pegasystems’ code or rules:
The PXINSID has a width of 128 in the database and the {picInput.pxInsId} host variable is of greater width to support generated property names. The property name is not long, but the string variable internally is larger than the database column. This condition throws the error.


Refer to the PDN article given below and perform the local-change:

Published November 8, 2016 - Updated October 8, 2020

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.

Did you find this content helpful?

Want to help us improve this content?

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