An Alter process during the Tools Only Upgrade failed with the following error:
ERROR:
————
SQL Build process began on 3/17/2004 at 4:06:26 PM for database ****.
Error: ACCESS_GRP_LANG – Unable to retrieve current DDL space name. Alter processed failed. (76,47)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn. Return code = 1. (76,6)
Error: AE_SYNCGEN_AET – Unable to retrieve current DDL space name. Alter processed failed. (76,47)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn. Return code = 1. (76,6)
Error: AELOCKMGR – Unable to retrieve current DDL space name. Alter processed failed. (76,47)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn. Return code = 1. (76,6)
Error: AERUNCONTROL – Unable to retrieve current DDL space name. Alter processed failed. (76,47)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn. Return code = 1. (76,6)
Error: AERUNCONTROLPC – Unable to retrieve current DDL space name. Alter processed failed. (76,47)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn. Return code = 1. (76,6)
Error: AETEMPTBLMGR – Unable to retrieve current DDL space name. Alter processed failed. (76,47)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn. Return code = 1. (76,6)
Error: APPMSGARCH_AET – Unable to retrieve current DDL space name. Alter processed failed. (76,47)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn. Return code = 1. (76,6)
Error: APPR_HDR_LNG – Unable to retrieve current DDL space name. Alter processed failed. (76,47)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn. Return code = 1. (76,6)
Error: APPR_RULE_HDR – Unable to retrieve current DDL space name. Alter processed failed. (76,47)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn. Return code = 1. (76,6)
SOLUTION:
————–
In the PSSTATUS table, the OWNERID column data was in lowercase. When the data got converted into upper case, the error got resolved and the Alter script ran without any issues.
