Support Article
ORA-12899 error during Smart Investigate 7.11 Install
Summary
During import of SIPayment,jar to install the Smart Investigate for Payments v7.11, the install fails to complete with errors that include:
Error Messages
Caused by: com.pega.pegarules.pub.PRException: ORA-12899: value too large for column "PEGA7"."PR4_RULE_VW"."PYLABEL" (actual: 65, maximum: 64)
Steps to Reproduce
Run import
Root Cause
A defect or configuration issue in the operating environment. Some unicode database columns need to be enlarged.
Resolution
Perform the following local-change:
In the media/Hotfixes/Pega7UnicodeFix directory there is a script which provides the database alterations that are needed to modify the database tables in a unicode database. This script also contains database trigger changes that would be needed if installing on Pega 7.1.7 or earlier. In 7.1.8+ these database triggers are no longer needed.
-- Pega 7 database changes to fix column size issues for Unicode databases
-- Alter table start
alter table pr4_rule_property modify pylabel VARCHAR2 (128) ;
alter table pr4_fieldvalue modify pylabel VARCHAR2 (128) ;
alter table pr4_rule_vw modify pylabel VARCHAR2 (128) ;
alter table pr_index_reference modify pxReferencingDescription VARCHAR2 (128) ;
alter table pr4_rule modify pylabel VARCHAR2 (128) ;
-- Alter table end
Published January 31, 2016 - 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.