Support Article
Seeing database serialization failed for requestor error in logs
SA-8307
Summary
Users see 'database serialization failed for requestor' errors in the logs sporadically.
Error Messages
2015-03-05 01:22:38,372 [.PegaWorkManager : 0] [ STANDARD] [RuleSet:01.01.01] ( mgmt.base.DatabaseStorage) ERROR - Database serialization failed for requestor: HB722EB3A805454BCC713D3079F7158F5, thread: TABTHREAD0, page: pyFilterCriteria_pgABCsomelongstringContract_pxResults_WorklistExpandContract_1
com.pega.pegarules.pub.database.BadTableMappingException: Database-BadTableMapping-KeyPropertyTooBig pxInsName PegaDATA pr_page_store 128 137 HB722EB3A805454BCC713D3079F7158F5!TABTHREAD0!PYFILTERCRITERIA_PGREPPGSUBSECTIONWORKLISTEXPANDCONTRACTB_PXRESULTS_WORKLISTEXPANDCONTRACT_1 System-SavedPages UPDATE Schema.pr_page_store SET PXCREATEDATETIME = ? , PXCREATEOPERATOR = ? , PXCREATEOPNAME = ? , PXCREATESYSTEMID = ? , PXINSNAME = ? , PXOBJCLASS = ? , PXUPDATEDATETIME = ? , PXUPDATEOPERATOR = ? , PXUPDATEOPNAME = ? , PXUPDATESYSTEMID = ? , PYLABEL = ? , pxCommitDateTime = CURRENT_TIMESTAMP , pzPVStream = ? WHERE PZINSKEY = ?
From: (unknown)
SQL: UPDATE Schema.pr_page_store SET PXCREATEDATETIME = ? , PXCREATEOPERATOR = ? , PXCREATEOPNAME = ? , PXCREATESYSTEMID = ? , PXINSNAME = ? , PXOBJCLASS = ? , PXUPDATEDATETIME = ? , PXUPDATEOPERATOR = ? , PXUPDATEOPNAME = ? , PXUPDATESYSTEMID = ? , PYLABEL = ? , pxCommitDateTime = CURRENT_TIMESTAMP , pzPVStream = ? WHERE PZINSKEY = ?
Steps to Reproduce
Unknown.
Root Cause
The root cause of this problem is a defect in Pegasystems’ code or rules.
During passivation, certain page names that are very large causes the pxInsName to be larger than 128 characters, which is inturn very large to fit in its associated column in the pr_page_store table.
Resolution
This issue is resolved by making the following change to the operating environment:
Increase the column size of pxInsName in the table Schema. pr_page_store to be large enough to fit the data.
In the error message above, the size required is at least 137 characters.
Published June 12, 2015 - 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.