1748030 Members
5436 Online
108757 Solutions
New Discussion

Failed to Backup or Restor IMC's databases

 
lcieplak
Occasional Advisor

Failed to Backup or Restor IMC's databases

Hello,

Cause of a migration of my software and services on another server, i had to reinstall IMC.

So i backuped databases of the old version in order to do a restore on the new installation.

The backup is OK but i can't restore the new one :

restore.PNG

 

There are the logs about this : 

Spoiler

2019-07-18 10:08:04 [DEBUG] [My_Accept_Handler::handle_input] Connection established 127.0.0.1
2019-07-18 10:08:04 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive encode length: 24
2019-07-18 10:08:04 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive encode : zAkLvgKeyuJAftyoU4fh8Q==
2019-07-18 10:08:04 [DEBUG] [CDataConnStreamQueueT::deal_msg] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive command code: 10000
2019-07-18 10:08:04 [DEBUG] [CDataConnStreamQueueT::deal_msg] Succeed to create SendBakConfigFileReq thread
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 32
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 32
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 32
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 32
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 32
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 32
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 32
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 32
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 32
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
2019-07-18 10:08:04 [INFO] [SendBakConfigFileReq] Reload config from file: C:\Program Files\iMC\dbman\bin\..\etc\dbman.conf
2019-07-18 10:08:04 [INFO] [Client::connect_to_server] Starting connect to 127.0.0.1: 2810
2019-07-18 10:08:04 [INFO] [Client::connect_to_server] Established connection to 127.0.0.1: 2810
2019-07-18 10:08:04 [DEBUG] [My_Accept_Handler::handle_input] Connection established 127.0.0.1
2019-07-18 10:08:04 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive encode length: 24
2019-07-18 10:08:04 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive encode : FIYRVcy5FLXIIxVwEyHJJg==
2019-07-18 10:08:04 [DEBUG] [CDataConnStreamQueueT::deal_msg] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive command code: 10020
2019-07-18 10:08:04 [DEBUG] [CDataConnStreamQueueT::deal_msg] Success to create directory: C:\dbmanbak
2019-07-18 10:08:04 [INFO] [Client::connect_to_server] Starting connect to 127.0.0.1: 2810
2019-07-18 10:08:04 [INFO] [Client::connect_to_server] Established connection to 127.0.0.1: 2810
2019-07-18 10:08:04 [DEBUG] [My_Accept_Handler::handle_input] Connection established 127.0.0.1
2019-07-18 10:08:04 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive encode length: 24
2019-07-18 10:08:04 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive encode : FIYRVcy5FLXIIxVwEyHJJg==
2019-07-18 10:08:04 [DEBUG] [CDataConnStreamQueueT::deal_msg] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive command code: 10020
2019-07-18 10:08:04 [DEBUG] [CDataConnStreamQueueT::deal_msg] Success to create directory: C:\Temp\HPE IMC\BackUp\New
2019-07-18 10:08:04 [INFO] [Client::connect_to_server] Starting connect to 127.0.0.1: 2810
2019-07-18 10:08:04 [INFO] [Client::connect_to_server] Established connection to 127.0.0.1: 2810
2019-07-18 10:08:04 [DEBUG] [My_Accept_Handler::handle_input] Connection established 127.0.0.1
2019-07-18 10:08:04 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive encode length: 24
2019-07-18 10:08:04 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive encode : FIYRVcy5FLXIIxVwEyHJJg==
2019-07-18 10:08:04 [DEBUG] [CDataConnStreamQueueT::deal_msg] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive command code: 10020
2019-07-18 10:08:04 [DEBUG] [CDataConnStreamQueueT::deal_msg] Success to create directory: C:\dbmanbak
2019-07-18 10:08:04 [INFO] [Client::connect_to_server] Starting connect to 127.0.0.1: 2810
2019-07-18 10:08:04 [INFO] [Client::connect_to_server] Established connection to 127.0.0.1: 2810
2019-07-18 10:08:04 [DEBUG] [My_Accept_Handler::handle_input] Connection established 127.0.0.1
2019-07-18 10:08:04 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive encode length: 24
2019-07-18 10:08:04 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive encode : FIYRVcy5FLXIIxVwEyHJJg==
2019-07-18 10:08:04 [DEBUG] [CDataConnStreamQueueT::deal_msg] After debase64 length: 16
2019-07-18 10:08:04 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive command code: 10020
2019-07-18 10:08:04 [DEBUG] [CDataConnStreamQueueT::deal_msg] Success to create directory: C:\Temp\HPE IMC\BackUp\New
2019-07-18 10:08:28 [DEBUG] [My_Accept_Handler::handle_input] Connection established 127.0.0.1
2019-07-18 10:08:28 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive encode length: 24
2019-07-18 10:08:28 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive encode : tIqZNUJINsrFAjqeoYB5hQ==
2019-07-18 10:08:28 [DEBUG] [CDataConnStreamQueueT::deal_msg] After debase64 length: 16
2019-07-18 10:08:28 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive command code: 10003
2019-07-18 10:08:28 [DEBUG] [CDataConnStreamQueueT::deal_msg] Succeed to create ManualRestoreBase thread
2019-07-18 10:08:28 [INFO] [ManualRestoreBase] All server echo ok
2019-07-18 10:08:28 [DEBUG] [ManualRestoreBase] Manual restore type: 0
2019-07-18 10:08:28 [DEBUG] [ManualRestoreBase] IfRestart imc 1
2019-07-18 10:08:28 [INFO] [ManualRestoreBase] Restore file list: C:\Temp\HPE IMC\BackUp\New\127.0.0.1@aclm_db_imc_aclm_db_20190712_130509_full.db
2019-07-18 10:08:28 [INFO] [ManualRestoreBase] FileDir: C:\Temp\HPE IMC\BackUp\New; StrfileName: 127.0.0.1@aclm_db_imc_aclm_db_20190712_130509_full.db; FileLen: 1860096
2019-07-18 10:08:28 [ERROR] [checkDBFiles] Restore all database failed: Components is not match
2019-07-18 10:08:28 [ERROR] [checkDBFiles] Database: 127.0.0.1@aclm_db. Components: iMC-ACLM=7.3.E0605
2019-07-18 10:08:28 [ERROR] [checkDBFiles] DbFileConf: 127.0.0.1@aclm_db_imc_aclm_db_20190712_130509_full.db. Components: iMC-ACLM=7.3.E0703
2019-07-18 10:08:28 [INFO] [sendTrapAlert] Send trap success

2019-07-18 10:08:28 [ERROR] [ManualRestoreBase] Fail to check DB file.
2019-07-18 10:08:28 [ERROR] [response_err_code] errCode = -1

After this i wanted to backup the new install to see if i can but i can't backup too.

Maybe is it a problem of connexion with the databases ? Any ideas ?

3 REPLIES 3
jguse
HPE Pro

Re: Failed to Backup or Restor IMC's databases

Hello,

Restoring a DB from E0605 to E0703 will definitely break the IMC installation, and your DB Backup and the system to be restored must match in terms of components deployed, and their exact version (eg. E0703).

2019-07-18 10:08:28 [ERROR] [checkDBFiles] Restore all database failed: Components is not match
2019-07-18 10:08:28 [ERROR] [checkDBFiles] Database: 127.0.0.1@aclm_db. Components: iMC-ACLM=7.3.E0605
2019-07-18 10:08:28 [ERROR] [checkDBFiles] DbFileConf: 127.0.0.1@aclm_db_imc_aclm_db_20190712_130509_full.db. Components: iMC-ACLM=7.3.E0703

There we can see the version of Database: and Components: (installed).

To get this working, install E0605 on your new system instead, with the same components/modules as your old system, and then restore the DB. Keep in mind the file numbers in the backup will also need to be changed before it works.

See IMC Windows Migration Guide, "Restore the Database" section:

https://support.hpe.com/hpsc/doc/public/display?docLocale=en_US&docId=emr_na-a00075552en_us&withFrame

E0605 is available here:

https://h10145.www1.hpe.com/downloads/SoftwareReleases.aspx?ProductNumber=JG747AAE (link for standard edition)

Best regards,
Justin

Working @ HPE
Accept or Kudo
lcieplak
Occasional Advisor

Re: Failed to Backup or Restor IMC's databases

Hello,

Okay i'll try this option but can i upgrade my version to E703 after the migration ?

jguse
HPE Pro

Re: Failed to Backup or Restor IMC's databases

Hello,

Sure thing, E0605 can be upgraded directly to E0703.

Best regards,
Justin

Working @ HPE
Accept or Kudo