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
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.