Discussion

1
Replies
258
Views
Close popover
Prakash Karagi (PrakashKaragi)
PEGA
Senior Manager - GSA India
Pegasystems Inc.
IN
PrakashKaragi Member since 2011 5 posts
PEGA
Posted: February 4, 2016
Last activity: April 6, 2018
Closed

ORA-12899: value too large for column length while performing rules Upgrade (Step after rules migration).

Rules upgrade failed with below error while upgrading from PRPC 61 SP1 >> Pega 719

Log:

[java] Caused by: com.pega.pegarules.pub.database.DatabaseException: Database-General There was a problem getting a list 12899 72000 ORA-12899: value too large for column "RBSI_RULES"."PR4_RULE_RULESET"."PYLABEL" (actual: 67, maximum: 64)

[java]

[java] From: (A9892FDA977B1BDD156DD46C0F44BA93B)

[java] SQL: INSERT INTO RBSI_RULES.pr4_rule_ruleset (PXCREATEDATETIME , PXCREATEOPERATOR , PXCREATEOPNAME , PXCREATESYSTEMID , PXHOSTID , PXINSID , PXINSNAME , PXOBJCLASS , PXSAVEDATETIME , PXUPDATEDATETIME , PXUPDATEOPERATOR , PXUPDATEOPNAME , PXUPDATESYSTEMID , PYLABEL , PYRULENAME , PYRULESET , PYRULESETNAME , PYRULESETTYPE , PYRULESETVERSIONID , PYVERSIONSECURE , PZCHECKSUM , PZINSKEY , PZPVSTREAM , pxCommitDateTime) SELECT PXCREATEDATETIME , PXCREATEOPERATOR , PXCREATEOPNAME , PXCREATESYSTEMID , PXHOSTID , PXINSID , PXINSNAME , PXOBJCLASS , PXSAVEDATETIME , PXUPDATEDATETIME , PXUPDATEOPERATOR , PXUPDATEOPNAME , PXUPDATESYSTEMID , PYLABEL , PYRULENAME , PYRULESET , PYRULESETNAME , PYRULESETTYPE , PYRULESETVERSIONID , PYVERSIONSECURE , PZCHECKSUM , PZINSKEY , PZPVSTREAM , CURRENT_TIMESTAMP FROM RBSI_RULES.pr4_rule WHERE pxObjClass IN ('Rule-RuleSet-Version') AND pzInsKey NOT IN (SELECT pzInsKey FROM RBSI_RULES.pr4_rule_ruleset)

[java] SQL Inserts:

[java]

[java] Caused by SQL Problems.

[java] Problem #1, SQLState 72000, Error code 12899: java.sql.SQLException: ORA-12899: value too large for column "RBSI_RULES"."PR4_RULE_RULESET"."PYLABEL" (actual: 67, maximum: 64)

[java]

[java] at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:262)

[java] at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:6283)

[java] at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6676)

[java] at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6632)

[java] at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6613)

[java] at com.pega.pegarules.data.internal.access.Migrator.migrateClassInstances(Migrator.java:83)

[java] ... 33 more

[java] Caused by: java.sql.SQLException: ORA-12899: value too large for column "RBSI_RULES"."PR4_RULE_RULESET"."PYLABEL" (actual: 67, maximum: 64)

[java]

**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.

System Administration Upgrades
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion.