Importing SmartDisputeBase_v712.jar causes errors
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.
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
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:
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.
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).
0% found this useful