Discussion
Pegasystems Inc.
IN
Last activity: 6 Apr 2018 19:26 EDT
ORA-12899: Value too large for column length while performing Rule Migration (Step before rules upgrade).
We have noticed rule migration failure with two tables
PR_INDEX_WARNINGS"."PXREFERENCINGDESCRIPTION" (actual: 65, maximum: 64)
PR4_FIELDVALUE"."PYFIELDVALUE" (actual: 70, maximum: 64)
Note: Customer is using the SI framework
Log:
ORA-12899: value too large for column "RBSI_RULES"."PR_INDEX_WARNINGS"."PXREFERENCINGDESCRIPTION" (actual: 65, maximum: 64)
[java]
[java] at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
[java] at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
[java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
[java] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
[java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
[java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
[java] at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3482)
[java] at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1373)
[java] at com.pega.pegarules.util.deploy.PegaBulkMover.loadDatabaseTable(PegaBulkMover.java:1063)
[java] at com.pega.pegarules.util.deploy.PegaBulkMover.process(PegaBulkMover.java:567)
[java] at com.pega.pegarules.util.deploy.PegaBulkMover.main(PegaBulkMover.java:222)
[java]
[java] PegaBulkMover:: SQLException loading Database.
[java] at com.pega.pegarules.util.deploy.PegaBulkMover.loadDatabaseTable(PegaBulkMover.java:1080)
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Pegasystems Inc.
IN
Apply below alter statements to specific column in tables and re run the rule migration utility, which might solve your problem
ALTER TABLE RABODATA.PR4_FIELDVALUE MODIFY PYLABEL VARCHAR(128)
ALTER TABLE RABODATA.PR4_FIELDVALUE MODIFY PYFIELDVALUE VARCHAR(128);
ALTER TABLE RABO_DATA.PR4_FIELDVALUE MODIFY PYLABEL VARCHAR(128);
alter table RABO_DATA.pr4_rule_vw modify (PYLABEL varchar2(128 byte));