Support Article
Database-BadTableMapping-KeyPropertyTooBig
SA-150
Summary
When a clipboard page is passivated, an exception is thrown in the PegaRULES log file as column width is only 128 characters and some clipboard page names are longer than that.
Error Messages
STANDARD, page: pyFilterCriteria_pgRepPgSubSectionCLOpportunitiesBB_pxResults_CLOpportunities_2FilterSettings
com.pega.pegarules.pub.database.BadTableMappingException: Database-BadTableMapping-KeyPropertyTooBig pxInsName PegaRULES pr_page_store 128 136 H74F239447BC0DCE8AB5163437983960B!STANDARD!PYFILTERCRITERIA_PGREPPGSUBSECTIONCLOPPORTUNITIESBB_PXRESULTS_CLOPPORTUNITIES_2FILTERSETTINGS System-SavedPages update pr_page_store set PXCREATEDATETIME = ? , PXCREATEOPERATOR = ? , PXCREATEOPNAME = ? , PXCREATESYSTEMID = ? , PXINSNAME = ? , PXOBJCLASS = ? , PXUPDATEDATETIME = ? , PXUPDATEOPERATOR = ? , PXUPDATEOPNAME = ? , PXUPDATESYSTEMID = ? , PYLABEL = ? , pzPVStream = ? where pzInsKey = ?
From: (unknown)
SQL: update pr_page_store set PXCREATEDATETIME = ? , PXCREATEOPERATOR = ? , PXCREATEOPNAME = ? , PXCREATESYSTEMID = ? , PXINSNAME = ? , PXOBJCLASS = ? , PXUPDATEDATETIME = ? , PXUPDATEOPERATOR = ? , PXUPDATEOPNAME = ? , PXUPDATESYSTEMID = ? , PYLABEL = ? , pzPVStream = ? where pzInsKey = ?
SQL Inserts: <2014-07-01 20:37:17.737> <user1> <User Name> <3e159cc776020de7a8b626c872750694>
Steps to Reproduce
It is due to column length restriction in the pr_page_store table.
Root Cause
The root cause of this problem is defect/misconfiguration in the PRPC operating environment. pxInsName was too large for the column.
Resolution
Increased the size of the pxInsName column to 256 characters.
Published February 21, 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.