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

PRPC generated query is giving error

SA-3244

Summary



The Errror log is :
Problem #1, SQLState 72000, Error code 1461: java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column.


insert into pc_history_work (PXADDEDBYID , PXADDEDBYSYSTEM ,
PXASSIGNMENTELAPSEDTIME , PXASSIGNMENTPASTDEADLINE ,
PXASSIGNMENTPASTGOAL ,
PXCOVERINSKEY , PXEFFORTACTUALDELTA , PXFLOWACTION ,
PXHISTORYFORREFERENCE , PXINSNAME , PXOBJCLASS ,
PXRESOLUTIONCOSTDELTA ,
PXTASKELAPSEDTIME , PXTIMECREATED , PXTIMEFLOWSTARTED ,
PYASSIGNEDTO ,
PYASSIGNEDTOWORKGROUP , PYASSIGNMENTCLASS , PYFLOWKEY ,
PYFLOWNAME ,
PYFLOWTYPE , PYHISTORYTYPE , PYLABEL , PYMEMO , PYMESSAGEKEY ,
PYPERFORMACTIONTIME , PYPERFORMASSIGNMENTTIME , PYPERFORMER ,
PYPERFORMTASKTIME , PYSUBSTITUTIONVALUES , PYTASKID , PYTASKNAME ,
PYWORKCLASS , pzInsKey , pzPVStream) values


Error Messages



The Error log is :
Problem #1, SQLState 72000, Error code 1461: java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column.


Root Cause



DB char set is UTF16.   Each character is represented as minimum 2 bytes (max 4 bytes) and see the column PYWORKCLASS VARCHAR2 (64) is the one throwing “ORA-01461: can bind a LONG value only for insert into a LONG column”. If you see the mapping PYWORKCLASS the value is “HN-FW-DOFRFW-Work-Claim-SCCIDList” which is 33 characters (or 66 characters if UTF16) which exceeds the 64 bytes limit.

 

Another table pr_log_dataaccessaudit has PYWORKCLASS VARCHAR2 (96) and PYWORKCLASS actually maps  to PXOBJCLASS column in all other PRPC tables which is again VARCHAR2 (96).

 

Resolution



Increase the size of PYWORKCLASS in PC_HISTORY_WORK table from VARCHAR2 (64) to VARCHAR2 (96)
 

Published January 31, 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