General Page
You may face the below error while upgrading the sterling b2b integrator:
Error : 1441, Position : 36, Sql = ALTER TABLE YFS_USER_GROUP MODIFY ( USERGROUP_ID CHAR(25) DEFAULT ' ' ) , OriginalSql = ALTER TABLE YFS_USER_GROUP MODIFY ( USERGROUP_ID CHAR(25) DEFAULT ' ' ) , Error Msg = ORA-01441: cannot decrease column length because some value is too big
Error : 1441, Position : 36, Sql = ALTER TABLE YFS_USER_GROUP MODIFY ( USERGROUP_ID CHAR(25) DEFAULT ' ' ) , OriginalSql = ALTER TABLE YFS_USER_GROUP MODIFY ( USERGROUP_ID CHAR(25) DEFAULT ' ' ) , Error Msg = ORA-01441: cannot decrease column length because some value is too big
Root cause:
the default length is modified to accomidate username or for other business reasons.
To mitigate the issue, please follow the below steps:
1. Check the value of USERGROUP_ID char. If any entry exceeds the parameter value, please correct it.
2. After checking this, if the issue is still not resolved, go to
[SI_INSTALL]/install/repository/datatypes/metadata/platform_afc/etc/DataTypes.xml
[SI_INSTALL]/install/installed_data/platform_afc/etc/DataTypes.xml
3. Check the value of USERGROUP in DataTypes.xml.
4. If it is 25, change it to 50(default value) and then try the upgrade.
Note: This will mostly happen when someone is trying a very major upgrade. eg: SI 526 to 612.
[{"Type":"MASTER","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"ARM Category":[{"code":"a8m50000000CjrNAAS","label":"Installation-\u003EUpgrade"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
24 November 2023
UID
ibm17078429