IMC backup failing

[DPS_IT]

Hello There,

We recently seeing some issues with IMC where the backups are failing and we see alerts that the backup's are "Part Succeeded".

The IMC software has been recently upgraded to version below:

iMC PLAT 7.3 (E0705P07)

Any help greatly appreciated.

Thanks,

Pavan

[Nitish_N]

Hi Pavan,

Please let us know if you're talking about iMC monitored device configuration backup or iMC database backup. If its device backup, then we have to check the cfgbck folder and also auto-backup setting as sometimes i have seen where there will be default setting of limited device configuration backup file threshold limit which needs to be changed. If it's iMC database backup then we have to check if after the iMC upgrade dbman folder was copied to remote DB server(if using remote db) and also we can check dmalog under folder c:/program file/imc/dbman/.

-N

[DPS_IT]

Hello Nitish,

Thank you for your email.

It will be iMC monitored device configuration backup. Seems like the backups are not completed successfully and we get alerts saying that is it "Part Succeded".

Please let me know the next course of action. happy to share logs if needed be.

Thanks,

Pavan

[Nitish_N]

Hi,

Please share the screenshot of "Max backup configuration file" which will be found under Service Tab >> Configuration Center >> Option's. Below is the screenshot of same. If you see any value like 50 or any number, please change the value to "0" and then try backing up the configuration of the device and check if the issue still persist or not.

-N

[DPS_IT]

Hello Nitish,

Thank you for your email.

We did look at this and changed the vlaue from 50 to 0 and still seeing backups failing.

Please advise next course of action.

Thanks,

Pavan

[Nitish_N]

Hi, 

Thanks for the update. To check further logs needs to be checked so for that i will request if you can log case with HPE support to check further on the issue.

-N

[DPS_IT]

Hello Nitish,

Thank you for your email. We are seeing the below errors on the log file.

2020-12-07 00:00:02.021 [ERROR (3119)] [THREAD(8384)] [CQvDBConnADP::executeSQL] Execute "insert into tbl_cfgbak_history(history_id,plan_id,history_name,history_desc,backup_type,backup_time,backup_result) values (809,601,'NZ Daily Firewall Backup','',2,'2020-12-07 00:00:02',0)" failed, errorMsg:Violation of PRIMARY KEY constraint 'PK__tbl_cfgb__096AA2E9173876EA'. Cannot insert duplicate key in object 'imc_icc.tbl_cfgbak_history'. The duplicate key value is (809).
2020-12-07 00:00:03.053 [ERROR (-1)] [THREAD(8384)] [CCfgFileDataMgr::writePlanBackupHistory()] Fail to execute sql: insert into tbl_cfgbak_history(history_id,plan_id,history_name,history_desc,backup_type,backup_time,backup_result) values (809,601,'NZ Daily Firewall Backup','',2,'2020-12-07 00:00:02',0)
2020-12-07 00:00:03.056 [ERROR (3119)] [THREAD(8400)] [CQvDBConnADP::executeSQL] Execute "insert into tbl_cfgbak_history(history_id,plan_id,history_name,history_desc,backup_type,backup_time,backup_result) values (809,601,'NZ Daily Firewall Backup','',2,'2020-12-07 00:00:03',0)" failed, errorMsg:Violation of PRIMARY KEY constraint 'PK__tbl_cfgb__096AA2E9173876EA'. Cannot insert duplicate key in object 'imc_icc.tbl_cfgbak_history'. The duplicate key value is (809).
2020-12-07 00:00:03.056 [ERROR (-1)] [THREAD(8400)] [CCfgFileDataMgr::writePlanBackupHistory()] Fail to execute sql: insert into tbl_cfgbak_history(history_id,plan_id,history_name,history_desc,backup_type,backup_time,backup_result) values (809,601,'NZ Daily Firewall Backup','',2,'2020-12-07 00:00:03',0)

2020-12-07 00:00:05.043 [ERROR (18)] [THREAD(8372)] [CComponentAdapter::getDevAdapterName()] fail to call discoverDeviceAdapter()
2020-12-07 00:00:05.043 [ERROR (18)] [THREAD(8372)] [CComponentAdapter::isDevSupportServiceAction()] fail to call getDevAdapterName().DevID=157,ServiceName = ConfigBackup

Thanks,

Pavan

[Nitish_N]

Hi,

From the logs it looks like some issue with database which may have occurred after iMC upgrade. As if i'm not wrong the issue started after upgrade only right? I will request to open a case with HPE support or possible to rollback previous VM snapshot if taken before upgrade. Also please let me know if you faced any issues during iMC upgrade.

-N

[DPS_IT]

Hello Nitish,

I believe we had issues before upgrading the iMC.

The reason it was upgraded was to check if the issue resolves after upgrading.

Any further help on this greatly apprecviated.

Thanks,

Pavan

[DPS_IT]

Hello Nitish,,

Just want to check if you have any update on this please?

Thanks,

Pavan