Support Article
Column length for pxInsName insufficient
SA-57970
Summary
On setting the pxInsName column width to 64 characters, pyCommitError occurs while saving to Federated Case Management (FCM).
Error Messages
•pyCommitError:** The key property pxInsName in database FCMR, table PC_ASSIGN_WORKLIST_CustomName is too big for its column; column size: 64, property size: 65, property value: BNS-CB-BFA-WORK BFA-27271!ADJUDICATIONPROCESSFULLCREDIT!PEGADEV01, instance class: BNS-Data-BWH-Worklist, trying to run SQL: UPDATE DATA.PC_ASSIGN_WORKLIST_CustomName SET ACCOUNTNUMBER = ? , ADDITIONALACCOUNTHOLDERS = ? , ADDITIONALFIRSTNAME = ? , ADDITIONALSURNAME = ? , ASSIGNMENTTRANSIT = ? , BUSINESSLEGALNAME = ? , BUSINESSTRADENAME = ? , ISNEWTASK = ? , ORIGINATINGTRANSIT = ? , PRIMARYCID = ? , PRIMARYFIRSTNAME = ? , PRIMARYSURNAME = ? , PROCESS = ? , PXAPPLICATION = ? , PXAPPLICATIONLABEL = ? , PXASSIGNEDOPERATORID = ? , PXASSIGNEDORG = ? , PXASSIGNEDORGDIV = ? , PXASSIGNEDORGUNIT = ? , PXASSIGNEDUSERNAME = ? , PXASSIGNMENTKEY = ? , PXCREATEDATETIME = ? , PXCREATEOPERATOR = ? , PXCREATEOPNAME = ? , PXCREATESYSTEMID = ? , PXDEADLINETIME = ? , PXFLOWNAME = ? , PXINSNAME = ? , PXOBJCLASS = ? , PXREFOBJECTCLASS = ? , PXREFOBJECTINSNAME = ? , PXREFOBJECTKEY = ? , PXTASKLABEL = ? , PXTASKNAME = ? , PXURGENCYASSIGN = ? , PXURGENCYASSIGNSLA = ? , PXURGENCYWORK = ? , PXWORKGROUP = ? , PYASSIGNMENTSTATUS = ? , PYDESCRIPTION = ? , PYFLOWINERROR = ? , PYFLOWTYPE = ? , PYINSTRUCTIONS = ? , PYINTERESTPAGECLASS = ? , PYLABEL = ? , PYNOTE = ? , PYSYSTEMNAME = ? , PYURGENCYASSIGNADJUST = ? , PZREINDEX = ? , SECONDARYCID = ? , HASSTICKYNOTES = ? , PXURGENCY = ? , pzPVStream = ? WHERE PZINSKEY = ?
Steps to Reproduce
- Set pxInsName column width to 64 characters.
- Save to FCM.
Root Cause
A defect or configuration issue in the operating environment. The length of the column was reduced from the default size.
Resolution
Here's the explanation for the reported behavior,
The default size is 128. Set the column size manually.
Published July 23, 2018 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.