Discussion
1
Replies
299
Views
Posted: June 4, 2015
Last activity: April 6, 2018
Closed
Upgrade failed with sqlcode=-433 sqlstate=22--1
Hi,
Upgrade failed with insetion error. DB2 SQL Error: SQLCODE=-433, SQLSTATE=22001
What can be the issue ?
**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.
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.
One of the possible reasons can be customizations in rule tables. Since new rule tables have been added in 7.1, the customizations in old rule tables should be applied to the new tables as well.
This issue can be resolved by carrying out upgrade in a multi-step process.
1. Use generateDDL.sh to create the upgrade DDLs
2. Apply the DDLs in the new schema
3. Identify customizations done on the rule tables like pylabel changes or pzpvstream changes
4. Reapply the customizations in newly created rule tables like PR4_RULE_RULESET, PR4_RULE_DECLAREPAGES etc.
5. Run upgrade.sh by setting bypass.schema.generation to true