Troubleshooting
Problem
New install of Control Center was running for a while but then would no longer start.
Symptom
Control Center startup fails - in nohup.out
E R R O R
An error occurred while executing SQL command.
ALTER TABLE CD_STATS_LOG SWITCH PARTITION $PARTITION.CD_PART_FUNC('2021/06/17') TO TEMP_CD_STATS_LOG
SQL Error code = 4944
Error code : InstallErrorCodeList.4008
Error : ALTER TABLE SWITCH statement failed because column 'MEMBER_NAME' has data type nvarchar(255) in source table 'CD_STATS_LOG' which is different from its type varchar(9) in target table 'TEMP_CD_STATS_LOG'.
E R R O R
An error occurred while executing SQL command.
ALTER TABLE CD_STATS_LOG SWITCH PARTITION $PARTITION.CD_PART_FUNC('2021/06/17') TO TEMP_CD_STATS_LOG
SQL Error code = 4944
Error code : InstallErrorCodeList.4008
Error : ALTER TABLE SWITCH statement failed because column 'MEMBER_NAME' has data type nvarchar(255) in source table 'CD_STATS_LOG' which is different from its type varchar(9) in target table 'TEMP_CD_STATS_LOG'.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS9GLA","label":"IBM Control Center"},"ARM Category":[{"code":"a8m0z000000cwVwAAI","label":"DATABASE"}],"ARM Case Number":"TS006302159","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.2.0;and future releases"}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
29 July 2021
UID
ibm16476712