Community
IMC
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Re: IMC Upgrade E0506 to E0506P09 Failure

 
SKB-IT
Occasional Visitor

‎04-18-2018 03:26 AM

‎04-18-2018 03:26 AM

IMC Upgrade E0506 to E0506P09 Failure

Dear Community,

we were about updating our IMC Services but the Deployment fails every time with the following errorlog:

 

2018-04-18 12:24:22 [INFO ] [SwingWorker-pool-2-thread-2] [com.h3c.imc.deploy.install.MyURLClassLoaderManager::loadPlugin(91)] ---------------
2018-04-18 12:24:28 [INFO ] [AWT-EventQueue-0] [com.h3c.imc.deploy.dma.ComponentDeployInfo::isComponentsConformable(513)] Components conformable check failed: invalid state - updating
2018-04-18 12:24:44 [INFO ] [SwingWorker-pool-2-thread-2] [com.h3c.imc.deploy.dma.SlaveUpdateWorker::doWork(155)] Start update component: iMC-PLAT [iMC PLAT 7.3 (E0506P09)]
2018-04-18 12:24:44 [INFO ] [SwingWorker-pool-2-thread-2] [com.h3c.imc.deploy.dma.SlaveUpdateWorker::doWork(167)] Replacement Variables: {${COUNTRY}=US, ${DATABASE_ADDRESS}=127.0.0.1, ${DATABASE_ADMIN_PASSWORD}={PROTECTED}, ${DATABASE_ADMIN_USERNAME}=hpimc, ${DATABASE_PORT}=1433, ${DATABASE_TYPE}=SQLServer, ${DATAFILE_DIR}=C:\Program Files\iMC\iMCDATA, ${DEPLOY_IP}=127.0.0.1, ${INSTALL_DESTINATION_DIR}=C:\Program Files\iMC, ${INSTANCE_NAME}=, ${LANGUAGE_U}=C, ${LANGUAGE}=en, ${LOCAL_IP_0}=10.160.13.13, ${LOCAL_IP_1}=192.168.200.10, ${LOCAL_IP_2}=fe80:0:0:0:2d4c:dafa:192b:57e%12, ${LOCAL_IP_3}=fe80:0:0:0:0:5efe:aa0:d0d%13, ${LOCAL_IP_4}=fe80:0:0:0:f8e2:3134:d528:8edf%14, ${LOCAL_IP_5}=fe80:0:0:0:0:5efe:c0a8:c80a%15, ${LOCAL_IP_COUNT}=6, ${MASTER_IP}=localhost, ${SERVER_TYPE}=Master, ${SQLSERVER_COLLATE_CS}=, ${SQLSERVER_COLLATE}=, ${iMC-ACLM['DATABASE_ADDRESS']}=SQLCLU04.sanatorium.local, ${iMC-ACLM['DATABASE_INSTANCE']}=SQLCLU04.sanatorium.local\XSC, ${iMC-ACLM['DATABASE_NAME']}=aclm_db, ${iMC-ACLM['DATABASE_PASSWORD']}={PROTECTED}, ${iMC-ACLM['DATABASE_PORT']}=56010, ${iMC-ACLM['DATABASE_TYPE']}=SQLServer, ${iMC-ACLM['DATABASE_USER_NAME']}=imc_aclm, ${iMC-ACLM['DEPLOY_IP']}=ATINNS1003.sanatorium.local, ${iMC-ACLM['INNER_VERSION']}=V700R001B06D018SP05, ${iMC-ACLM['INSTANCE_NAME']}=XSC, ${iMC-ACLM['JDBC_INSTANCE_NAME']}=;instance=XSC, ${iMC-ACLM['SERVER_TYPE']}=Master, ${iMC-ACLM['VERSION']}=7.3-E0506P03, ${iMC-DM['DEPLOY_IP']}=ATINNS1003.sanatorium.local, ${iMC-DM['INNER_VERSION']}=V700R001B06D018SP05, ${iMC-DM['VERSION']}=7.3-E0506P03, ${iMC-EUPLAT['DATABASE_ADDRESS']}=SQLCLU04.sanatorium.local, ${iMC-EUPLAT['DATABASE_INSTANCE']}=SQLCLU04.sanatorium.local\XSC, ${iMC-EUPLAT['DATABASE_NAME']}=config_db, ${iMC-EUPLAT['DATABASE_PASSWORD']}={PROTECTED}, ${iMC-EUPLAT['DATABASE_PORT']}=56010, ${iMC-EUPLAT['DATABASE_TYPE']}=SQLServer, ${iMC-EUPLAT['DATABASE_USER_NAME']}=imc_config, ${iMC-EUPLAT['DEPLOY_IP']}=ATINNS1003.sanatorium.local, ${iMC-EUPLAT['INNER_VERSION']}=V700R001B06D018SP05, ${iMC-EUPLAT['INSTANCE_NAME']}=XSC, ${iMC-EUPLAT['JDBC_INSTANCE_NAME']}=;instance=XSC, ${iMC-EUPLAT['VERSION']}=7.3-E0506P03, ${iMC-GAM['DATABASE_ADDRESS']}=SQLCLU04.sanatorium.local, ${iMC-GAM['DATABASE_INSTANCE']}=SQLCLU04.sanatorium.local\XSC, ${iMC-GAM['DATABASE_NAME']}=config_db, ${iMC-GAM['DATABASE_PASSWORD']}={PROTECTED}, ${iMC-GAM['DATABASE_PORT']}=56010, ${iMC-GAM['DATABASE_TYPE']}=SQLServer, ${iMC-GAM['DATABASE_USER_NAME']}=imc_config, ${iMC-GAM['DEPLOY_IP']}=ATINNS1003.sanatorium.local, ${iMC-GAM['INNER_VERSION']}=V700R001B06D018SP05, ${iMC-GAM['INSTANCE_NAME']}=XSC, ${iMC-GAM['JDBC_INSTANCE_NAME']}=;instance=XSC, ${iMC-GAM['VERSION']}=7.3-E0506P03, ${iMC-ICC['DATABASE_ADDRESS']}=SQLCLU04.sanatorium.local, ${iMC-ICC['DATABASE_INSTANCE']}=SQLCLU04.sanatorium.local\XSC, ${iMC-ICC['DATABASE_NAME']}=icc_db, ${iMC-ICC['DATABASE_PASSWORD']}={PROTECTED}, ${iMC-ICC['DATABASE_PORT']}=56010, ${iMC-ICC['DATABASE_TYPE']}=SQLServer, ${iMC-ICC['DATABASE_USER_NAME']}=imc_icc, ${iMC-ICC['DEPLOY_IP']}=ATINNS1003.sanatorium.local, ${iMC-ICC['INNER_VERSION']}=V700R001B06D018SP05, ${iMC-ICC['INSTANCE_NAME']}=XSC, ${iMC-ICC['JDBC_INSTANCE_NAME']}=;instance=XSC, ${iMC-ICC['SERVER_TYPE']}=Master, ${iMC-ICC['VERSION']}=7.3-E0506P03, ${iMC-NETASSET['DATABASE_ADDRESS']}=SQLCLU04.sanatorium.local, ${iMC-NETASSET['DATABASE_INSTANCE']}=SQLCLU04.sanatorium.local\XSC, ${iMC-NETASSET['DATABASE_NAME']}=invent_db, ${iMC-NETASSET['DATABASE_PASSWORD']}={PROTECTED}, ${iMC-NETASSET['DATABASE_PORT']}=56010, ${iMC-NETASSET['DATABASE_TYPE']}=SQLServer, ${iMC-NETASSET['DATABASE_USER_NAME']}=imc_inventory, ${iMC-NETASSET['DEPLOY_IP']}=ATINNS1003.sanatorium.local, ${iMC-NETASSET['INNER_VERSION']}=V700R001B06D018SP05, ${iMC-NETASSET['INSTANCE_NAME']}=XSC, ${iMC-NETASSET['JDBC_INSTANCE_NAME']}=;instance=XSC, ${iMC-NETASSET['SERVER_TYPE']}=Master, ${iMC-NETASSET['VERSION']}=7.3-E0506P03, ${iMC-NME-FAULT['DATABASE_ADDRESS']}=SQLCLU04.sanatorium.local, ${iMC-NME-FAULT['DATABASE_INSTANCE']}=SQLCLU04.sanatorium.local\XSC, ${iMC-NME-FAULT['DATABASE_NAME']}=monitor_db, ${iMC-NME-FAULT['DATABASE_PASSWORD']}={PROTECTED}, ${iMC-NME-FAULT['DATABASE_PORT']}=56010, ${iMC-NME-FAULT['DATABASE_TYPE']}=SQLServer, ${iMC-NME-FAULT['DATABASE_USER_NAME']}=imc_monitor, ${iMC-NME-FAULT['DEPLOY_IP']}=ATINNS1003.sanatorium.local, ${iMC-NME-FAULT['INNER_VERSION']}=V700R001B06D018SP05, ${iMC-NME-FAULT['INSTANCE_NAME']}=XSC, ${iMC-NME-FAULT['JDBC_INSTANCE_NAME']}=;instance=XSC, ${iMC-NME-FAULT['SERVER_TYPE']}=Master, ${iMC-NME-FAULT['VERSION']}=7.3-E0506P03, ${iMC-NME-PERF['DATABASE_ADDRESS']}=SQLCLU04.sanatorium.local, ${iMC-NME-PERF['DATABASE_INSTANCE']}=SQLCLU04.sanatorium.local\XSC, ${iMC-NME-PERF['DATABASE_NAME']}=perf_db, ${iMC-NME-PERF['DATABASE_PASSWORD']}={PROTECTED}, ${iMC-NME-PERF['DATABASE_PORT']}=56010, ${iMC-NME-PERF['DATABASE_TYPE']}=SQLServer, ${iMC-NME-PERF['DATABASE_USER_NAME']}=imc_perf, ${iMC-NME-PERF['DEPLOY_IP']}=ATINNS1003.sanatorium.local, ${iMC-NME-PERF['INNER_VERSION']}=V700R001B06D018SP05, ${iMC-NME-PERF['INSTANCE_NAME']}=XSC, ${iMC-NME-PERF['JDBC_INSTANCE_NAME']}=;instance=XSC, ${iMC-NME-PERF['SERVER_TYPE']}=Master, ${iMC-NME-PERF['VERSION']}=7.3-E0506P03, ${iMC-PLAT['DATABASE_ADDRESS']}=SQLCLU04.sanatorium.local, ${iMC-PLAT['DATABASE_INSTANCE']}=SQLCLU04.sanatorium.local\XSC, ${iMC-PLAT['DATABASE_NAME']}=config_db, ${iMC-PLAT['DATABASE_PASSWORD']}={PROTECTED}, ${iMC-PLAT['DATABASE_PORT']}=56010, ${iMC-PLAT['DATABASE_TYPE']}=SQLServer, ${iMC-PLAT['DATABASE_USER_NAME']}=imc_config, ${iMC-PLAT['DEPLOY_IP']}=ATINNS1003.sanatorium.local, ${iMC-PLAT['INNER_VERSION']}=V700R001B06D018SP12, ${iMC-PLAT['INSTANCE_NAME']}=XSC, ${iMC-PLAT['JDBC_INSTANCE_NAME']}=;instance=XSC, ${iMC-PLAT['VERSION']}=7.3-E0506P09, ${iMC-REPORT['DATABASE_ADDRESS']}=SQLCLU04.sanatorium.local, ${iMC-REPORT['DATABASE_ADDRESS|1']}=SQLCLU04.sanatorium.local, ${iMC-REPORT['DATABASE_INSTANCE']}=SQLCLU04.sanatorium.local\XSC, ${iMC-REPORT['DATABASE_INSTANCE|1']}=SQLCLU04.sanatorium.local\XSC, ${iMC-REPORT['DATABASE_NAME']}=reportplat_db, ${iMC-REPORT['DATABASE_NAME|1']}=report_db, ${iMC-REPORT['DATABASE_PASSWORD']}={PROTECTED}, ${iMC-REPORT['DATABASE_PASSWORD|1']}={PROTECTED}, ${iMC-REPORT['DATABASE_PORT']}=56010, ${iMC-REPORT['DATABASE_PORT|1']}=56010, ${iMC-REPORT['DATABASE_TYPE']}=SQLServer, ${iMC-REPORT['DATABASE_TYPE|1']}=SQLServer, ${iMC-REPORT['DATABASE_USER_NAME']}=reportplat, ${iMC-REPORT['DATABASE_USER_NAME|1']}=report, ${iMC-REPORT['DEPLOY_IP']}=ATINNS1003.sanatorium.local, ${iMC-REPORT['INNER_VERSION']}=V700R001B06D018SP05, ${iMC-REPORT['INSTANCE_NAME']}=XSC, ${iMC-REPORT['INSTANCE_NAME|1']}=XSC, ${iMC-REPORT['JDBC_INSTANCE_NAME']}=;instance=XSC, ${iMC-REPORT['JDBC_INSTANCE_NAME|1']}=;instance=XSC, ${iMC-REPORT['REPORT_ENGINE_TYPE']}=JRC, ${iMC-REPORT['VERSION']}=7.3-E0506P03, ${iMC-SCC['DEPLOY_IP']}=ATINNS1003.sanatorium.local, ${iMC-SCC['INNER_VERSION']}=V700R001B06D018SP05, ${iMC-SCC['VERSION']}=7.3-E0506P03, ${iMC-SEPLAT['DEPLOY_IP']}=ATINNS1003.sanatorium.local, ${iMC-SEPLAT['INNER_VERSION']}=V700R001B06D018SP05, ${iMC-SEPLAT['VERSION']}=7.3-E0506P03, ${iMC-SYSLOG['DATABASE_ADDRESS']}=SQLCLU04.sanatorium.local, ${iMC-SYSLOG['DATABASE_INSTANCE']}=SQLCLU04.sanatorium.local\XSC, ${iMC-SYSLOG['DATABASE_NAME']}=syslog_db, ${iMC-SYSLOG['DATABASE_PASSWORD']}={PROTECTED}, ${iMC-SYSLOG['DATABASE_PORT']}=56010, ${iMC-SYSLOG['DATABASE_TYPE']}=SQLServer, ${iMC-SYSLOG['DATABASE_USER_NAME']}=imc_syslog, ${iMC-SYSLOG['DEPLOY_IP']}=ATINNS1003.sanatorium.local, ${iMC-SYSLOG['INNER_VERSION']}=V700R001B06D018SP05, ${iMC-SYSLOG['INSTANCE_NAME']}=XSC, ${iMC-SYSLOG['JDBC_INSTANCE_NAME']}=;instance=XSC, ${iMC-SYSLOG['VERSION']}=7.3-E0506P03, ${iMC-VLAN['DATABASE_ADDRESS']}=SQLCLU04.sanatorium.local, ${iMC-VLAN['DATABASE_INSTANCE']}=SQLCLU04.sanatorium.local\XSC, ${iMC-VLAN['DATABASE_NAME']}=vlanm_db, ${iMC-VLAN['DATABASE_PASSWORD']}={PROTECTED}, ${iMC-VLAN['DATABASE_PORT']}=56010, ${iMC-VLAN['DATABASE_TYPE']}=SQLServer, ${iMC-VLAN['DATABASE_USER_NAME']}=vlan, ${iMC-VLAN['DEPLOY_IP']}=ATINNS1003.sanatorium.local, ${iMC-VLAN['INNER_VERSION']}=V700R001B06D018SP05, ${iMC-VLAN['INSTANCE_NAME']}=XSC, ${iMC-VLAN['JDBC_INSTANCE_NAME']}=;instance=XSC, ${iMC-VLAN['SERVER_TYPE']}=Master, ${iMC-VLAN['VERSION']}=7.3-E0506P03, ${iMC-VNM['DATABASE_ADDRESS']}=SQLCLU04.sanatorium.local, ${iMC-VNM['DATABASE_INSTANCE']}=SQLCLU04.sanatorium.local\XSC, ${iMC-VNM['DATABASE_NAME']}=vnm_db, ${iMC-VNM['DATABASE_PASSWORD']}={PROTECTED}, ${iMC-VNM['DATABASE_PORT']}=56010, ${iMC-VNM['DATABASE_TYPE']}=SQLServer, ${iMC-VNM['DATABASE_USER_NAME']}=imc_vnm, ${iMC-VNM['DEPLOY_IP']}=ATINNS1003.sanatorium.local, ${iMC-VNM['INNER_VERSION']}=V700R001B06D018SP05, ${iMC-VNM['INSTANCE_NAME']}=XSC, ${iMC-VNM['JDBC_INSTANCE_NAME']}=;instance=XSC, ${iMC-VNM['VERSION']}=7.3-E0506P03}
2018-04-18 12:24:44 [INFO ] [SwingWorker-pool-2-thread-2] [com.h3c.imc.deploy.dma.IPConfigFileManager::a(168)] Start loading server-addr.xml configuration file
2018-04-18 12:24:44 [INFO ] [SwingWorker-pool-2-thread-2] [com.h3c.imc.deploy.dma.IPConfigFileManager::a(232)] Load server-addr.xml configuration file succeeded
2018-04-18 12:24:44 [INFO ] [SwingWorker-pool-2-thread-2] [com.h3c.imc.deploy.dma.IPConfigFileManager::saveAllConfigs(353)] Save server address config OK

any suggestions or help?

Best regards

0 Kudos
Reply
2 REPLIES 2
SKB-IT
Occasional Visitor

‎04-18-2018 11:08 PM - edited ‎04-18-2018 11:08 PM

‎04-18-2018 11:08 PM - edited ‎04-18-2018 11:08 PM

Re: IMC Upgrade E0506 to E0506P09 Failure

Additional Errors from SQL:

Begin to install database and data...
    Begin to install config_db data...
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 1
Violation of PRIMARY KEY constraint 'PK__tbl_dev___59EA507641440816'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_series'. The
duplicate key value is (2407).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 2
Violation of PRIMARY KEY constraint 'PK__tbl_dev___59EA507641440816'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_series'. The
duplicate key value is (2408).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 3
Violation of PRIMARY KEY constraint 'PK__tbl_dev___59EA507641440816'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_series'. The
duplicate key value is (2409).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 4
Violation of PRIMARY KEY constraint 'PK__tbl_dev___59EA507641440816'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_series'. The
duplicate key value is (2410).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 5
Violation of PRIMARY KEY constraint 'PK__tbl_dev___59EA507641440816'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_series'. The
duplicate key value is (2411).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 6
Violation of PRIMARY KEY constraint 'PK__tbl_dev___59EA507641440816'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_series'. The
duplicate key value is (2412).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 7
Violation of PRIMARY KEY constraint 'PK__tbl_dev___59EA507641440816'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_series'. The
duplicate key value is (2413).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 8
Violation of PRIMARY KEY constraint 'PK__tbl_dev___59EA507641440816'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_series'. The
duplicate key value is (2414).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 9
Violation of PRIMARY KEY constraint 'PK__tbl_dev___59EA507641440816'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_series'. The
duplicate key value is (2415).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 10
Violation of PRIMARY KEY constraint 'PK__tbl_dev___59EA507641440816'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_series'. The
duplicate key value is (2416).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 11
Violation of PRIMARY KEY constraint 'PK__tbl_dev___59EA507641440816'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_series'. The
duplicate key value is (2417).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 12
Violation of PRIMARY KEY constraint 'PK__tbl_dev___59EA507641440816'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_series'. The
duplicate key value is (2418).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 13
Violation of PRIMARY KEY constraint 'PK__tbl_dev___59EA507641440816'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_series'. The
duplicate key value is (2419).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 14
Violation of PRIMARY KEY constraint 'PK__tbl_dev___59EA507641440816'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_series'. The
duplicate key value is (2420).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 15
Violation of PRIMARY KEY constraint 'PK__tbl_dev___59EA507641440816'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_series'. The
duplicate key value is (2421).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 16
Violation of PRIMARY KEY constraint 'PK__tbl_dev___59EA507641440816'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_series'. The
duplicate key value is (2422).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 20
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80457).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 21
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80458).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 22
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80459).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 23
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80460).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 24
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80461).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 25
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80462).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 26
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80463).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 27
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80464).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 28
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80465).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 29
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80466).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 30
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80467).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 31
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80468).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 32
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80469).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 33
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80470).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 34
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80471).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 35
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80472).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 36
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80473).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 37
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80474).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 38
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80475).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 39
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80476).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 40
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80477).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 41
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80478).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 42
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80479).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 43
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80480).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 44
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80481).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 45
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80482).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 46
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80483).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 47
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80484).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 48
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80485).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 50
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80486).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 51
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80487).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 52
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80488).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 53
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80489).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 54
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80490).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 55
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80491).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 56
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80492).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 57
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80493).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 58
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80494).
The statement has been terminated.
Msg 2627, Level 14, State 1, Server SQLCLU04\XSC, Line 59
Violation of PRIMARY KEY constraint 'PK__tbl_dev___F8646478A0978855'.
Cannot insert duplicate key in object 'imc_config.tbl_dev_type'. The duplicate
key value is (80495).
The statement has been terminated.
0 Kudos
Reply
NeilR
Esteemed Contributor

‎04-24-2018 12:34 PM

‎04-24-2018 12:34 PM

Re: IMC Upgrade E0506 to E0506P09 Failure

I've seen log entires like this when objects that were added as custom under previous versions got ids assigned  that are now being used as part of the standard items in the update - the key value reffered to in the log.

So when the update script tries to insert the new items into the table it fails as they already exist.

The only way i was able to "fix" this was to go into the db, find the items the keys were pointing to, and then delete them from IMC before running the update. This is not always a simple task, as you will need to find the table, look up what the key refers to and then trace it back to an entry in the gui.

Sometimes deleting the item in the GUI does not always clear related items in the tables.

So if you are planning to try this, make sure you have a backup of the DB. You may be better off working directly with HP support.

0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.