APAR status
Closed as program error.
Error description
Maximo 7 upgrade -alter table A_APPLICATIONAUTH add constraint A_APPLICATION_NDX1 primary key () error - Error: DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: );N_NDX1 primary key (;<unique_col_list> The maxtable.uniquecolumnname colunm has an empty string instead of a NULL value so an index is being created. Work around - set empty string to NULL
Local fix
Work around - set empty string to NULL
Problem summary
**************************************************************** * USERS AFFECTED: clients upgrading 6 to 7 * **************************************************************** * PROBLEM DESCRIPTION: Maximo 7 upgrade -alter table * * A_APPLICATIONAUTH add constraint * * * * A_APPLICATION_NDX1 primary key () * * * * error - Error: DB2 SQL error: SQLCODE: * * -104, SQLSTATE: 42601, * * * * SQLERRMC: );N_NDX1 primary key * * (;<unique_col_list> * * * * The maxtable.uniquecolumnname colunm * * has an empty string instead * * * * of a NULL value so an index is being * * created. * * * * Work around - set empty string to NULL * * * * LOCAL FIX: * * * * Work around - set empty string to NULL * * * **************************************************************** * RECOMMENDATION: if possible, determine how the errant values * * got into the client database in the first * * place. * * * **************************************************************** ERROR - ERROR: DB2 SQL ERROR: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: );N_NDX1 PRIMARY KEY (;<UNIQUE_COL_LIST>
Problem conclusion
Client database has bad data - instead of null, several values are empty strings. The fix for this APAR is contained in the following maintenance package: | release\fix pack | REL 7.1.1.7 - BS
Temporary fix
Comments
APAR Information
APAR number
IZ67504
Reported component name
MAXIMO INSTALL
Reported component ID
5724R46IT
Reported release
710
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2010-01-05
Closed date
2010-01-08
Last modified date
2010-01-08
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
MAXIMO
Fix information
Fixed component name
MAXIMO INSTALL
Fixed component ID
5724R46IT
Applicable component levels
R710 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCHPMC","label":"Maximo Install Tool"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"710","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
06 September 2022