Network Management

 View Only
  • 1.  IMC Upgrade E0506 to E0506P09 Failure

    Posted Apr 18, 2018 06:27 AM

    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



  • 2.  RE: IMC Upgrade E0506 to E0506P09 Failure

    Posted Apr 19, 2018 02:08 AM

    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.


  • 3.  RE: IMC Upgrade E0506 to E0506P09 Failure

    Posted Apr 24, 2018 03:34 PM

    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.