Support Article
Importing SmartDisputeBase_v712.jar causes errors
SA-9248
Summary
While importing SmartDisputeBase_v712.jar as part of the Smart Dispute 7.12 upgrade process, an error is encountered related to the execution of a trigger.
The database is encoded for the UTF-8 character set.
Error Messages
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "RULES.TRPR4_RULE_PROP_VW_UPD", line 67
ORA-04088: error during execution of trigger 'RULES.TRPR4_RULE_PROP_VW_UPD'
Steps to Reproduce
Not applicable.
Root Cause
The root cause of this problem is defect or misconfiguration in the operating environment. This is related to the issue described in the following PDN article:
https://pdn.pega.com/deployment/issue-error-commit-failed-when-loading-cpm-61-rulesets-into-a-utf-8-encoded-database
Because the database is encoded for the UTF-8 character set, a variable being declared in the trigger is not large enough to store the value being passed to it.
Resolution
To resolve this issue, follow these steps:
1. Update the trigger TRPR4_RULE_PROP_VW_UPD (in the rules schema).
2. Replace SPtpyLabel VARCHAR (64); with SPtpyLabel VARCHAR (128).
Published March 10, 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.