Hello there,
I hope you have exactly the same iMC version and patch on old and on new server.
You should have also exactly same components deployed on both server , check also if there is any difference made by .skip files, which causes a db not be backed up.The files could be found under iMC/dbman/etc
Also I would try to restore dbs one by one and see if all dbs are having same issue or some of them are restored successfully..
Lastly I would also check the dbman.debug log from SQL server for errors.
Kind regards,.
------------------------------
Marina Milenkova
------------------------------
Original Message:
Sent: Nov 12, 2021 10:45 AM
From: Archive User
Subject: [IMC] Failed to manual restore databases
Hello, we currently have a remote database server with MSSQL 11.00.6020 and an IMC Server on 7.3 E0506P09. We are trying to duplicate this setup on a PRE PRODUCTION environment but every time we try to restore the database from one IMC server to the other it fails.
The backup operation works well and when trying to restore the new IMC server own database it also works.
The deployed components are the same and i have followed the Windows IMC migration guide. Basically i did a DB backup on the old server, one on the new, transfered the old DB to the new server and renamed the old files with the new names.
We are getting some errors in dbman_debug that i can't find information about.
2021-11-12 12:00:35 [INFO] [Main] Version: 7.3
2021-11-12 12:00:35 [INFO] [Main] Global directory: C:/IMC/dbman
2021-11-12 12:00:35 [INFO] [Main] Listenning on port: 2812
2021-11-12 12:00:35 [DEBUG] [Main] arv count 2
2021-11-12 12:00:35 [DEBUG] [Main] arv 1: dbman
2021-11-12 12:00:35 [DEBUG] [Main] arv 2: -n
2021-11-12 12:00:35 [INFO] [DBMAN] dbman exit
2021-11-12 12:01:41 [DEBUG] [My_Accept_Handler::handle_input] Connection established 127.0.0.1
2021-11-12 12:01:41 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive command code: 10000
2021-11-12 12:01:41 [DEBUG] [CDataConnStreamQueueT::deal_msg] Succeed to create SendBakConfigFileReq thread
2021-11-12 12:01:41 [INFO] [SendBakConfigFileReq] Reload config from file: C:\IMC\dbman\bin\..\etc\dbman.conf
2021-11-12 12:01:41 [INFO] [Client::connect_to_server] Starting connect to 127.0.0.1: 2812
2021-11-12 12:01:41 [INFO] [Client::connect_to_server] Established connection to 127.0.0.1: 2812
2021-11-12 12:01:41 [DEBUG] [My_Accept_Handler::handle_input] Connection established 127.0.0.1
2021-11-12 12:01:41 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive command code: 10020
2021-11-12 12:01:41 [DEBUG] [CDataConnStreamQueueT::deal_msg] Success to create directory: C:\dbmanbak
2021-11-12 12:01:41 [INFO] [Client::connect_to_server] Starting connect to 127.0.0.1: 2812
2021-11-12 12:01:41 [INFO] [Client::connect_to_server] Established connection to 127.0.0.1: 2812
2021-11-12 12:01:41 [DEBUG] [My_Accept_Handler::handle_input] Connection established 127.0.0.1
2021-11-12 12:01:41 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive command code: 10020
2021-11-12 12:01:41 [DEBUG] [CDataConnStreamQueueT::deal_msg] Success to create directory: C:\dbmanrestore
2021-11-12 12:01:41 [INFO] [Client::connect_to_server] Starting connect to 10.5.250.155: 2812
2021-11-12 12:01:41 [INFO] [Client::connect_to_server] Established connection to 10.5.250.155: 2812
2021-11-12 12:01:41 [INFO] [Client::connect_to_server] Starting connect to 10.5.250.155: 2812
2021-11-12 12:01:41 [INFO] [Client::connect_to_server] Established connection to 10.5.250.155: 2812
2021-11-12 12:02:09 [DEBUG] [My_Accept_Handler::handle_input] Connection established 127.0.0.1
2021-11-12 12:02:09 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive command code: 10003
2021-11-12 12:02:09 [DEBUG] [CDataConnStreamQueueT::deal_msg] Succeed to create ManualRestoreBase thread
2021-11-12 12:02:09 [INFO] [Client::connect_to_server] Starting connect to 10.5.250.155: 2812
2021-11-12 12:02:09 [INFO] [Client::connect_to_server] Established connection to 10.5.250.155: 2812
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] All server echo ok
2021-11-12 12:02:09 [DEBUG] [ManualRestoreBase] Manual restore type: 0
2021-11-12 12:02:09 [DEBUG] [ManualRestoreBase] IfRestart imc 1
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] Restore file list: C:\Temp\bdd\10.5.250.155@aclm_db_imc_aclm_db_20211112_111930_full.db
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] FileDir: C:\Temp\bdd; StrfileName: 10.5.250.155@aclm_db_imc_aclm_db_20211112_111930_full.db; FileLen: 496640
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] Restore file list: C:\Temp\bdd\10.5.250.155@config_db_imc_config_db_20211112_111930_full.db
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] FileDir: C:\Temp\bdd; StrfileName: 10.5.250.155@config_db_imc_config_db_20211112_111930_full.db; FileLen: 44698624
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] Restore file list: C:\Temp\bdd\10.5.250.155@icc_db_imc_icc_db_20211112_111930_full.db
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] FileDir: C:\Temp\bdd; StrfileName: 10.5.250.155@icc_db_imc_icc_db_20211112_111930_full.db; FileLen: 9312768
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] Restore file list: C:\Temp\bdd\10.5.250.155@invent_db_imc_inventory_db_20211112_111930_full.db
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] FileDir: C:\Temp\bdd; StrfileName: 10.5.250.155@invent_db_imc_inventory_db_20211112_111930_full.db; FileLen: 8307712
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] Restore file list: C:\Temp\bdd\10.5.250.155@monitor_db_imc_monitor_db_20211112_111930_full.db
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] FileDir: C:\Temp\bdd; StrfileName: 10.5.250.155@monitor_db_imc_monitor_db_20211112_111930_full.db; FileLen: 18228224
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] Restore file list: C:\Temp\bdd\10.5.250.155@perf_db_imc_perf_db_20211112_111930_full.db
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] FileDir: C:\Temp\bdd; StrfileName: 10.5.250.155@perf_db_imc_perf_db_20211112_111930_full.db; FileLen: 63115264
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] Restore file list: C:\Temp\bdd\10.5.250.155@reportplat_db_reportplat_db_20211112_111930_full.db
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] FileDir: C:\Temp\bdd; StrfileName: 10.5.250.155@reportplat_db_reportplat_db_20211112_111930_full.db; FileLen: 476160
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] Restore file list: C:\Temp\bdd\10.5.250.155@syslog_db_imc_syslog_db_20211112_111930_full.db
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] FileDir: C:\Temp\bdd; StrfileName: 10.5.250.155@syslog_db_imc_syslog_db_20211112_111930_full.db; FileLen: 4696064
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] Restore file list: C:\Temp\bdd\10.5.250.155@vlanm_db_vlan_db_20211112_111930_full.db
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] FileDir: C:\Temp\bdd; StrfileName: 10.5.250.155@vlanm_db_vlan_db_20211112_111930_full.db; FileLen: 1005568
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] Restore file list: C:\Temp\bdd\10.5.250.155@vnm_db_imc_vnm_db_20211112_111930_full.db
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] FileDir: C:\Temp\bdd; StrfileName: 10.5.250.155@vnm_db_imc_vnm_db_20211112_111930_full.db; FileLen: 422912
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] Restore file list: C:\Temp\bdd\10.5.250.155@vxlan_db_imc_vxlan_db_20211112_111930_full.db
2021-11-12 12:02:09 [INFO] [ManualRestoreBase] FileDir: C:\Temp\bdd; StrfileName: 10.5.250.155@vxlan_db_imc_vxlan_db_20211112_111930_full.db; FileLen: 648192
2021-11-12 12:02:09 [INFO] [CDbRestore::RestoreDatabaseList] Restore fileDir: C:\Temp\bdd; Filename: 10.5.250.155@aclm_db_imc_aclm_db_20211112_111930_full.db; Size: 496640
2021-11-12 12:02:09 [INFO] [CDbRestore::RestoreDatabaseList] Restore fileDir: C:\Temp\bdd; Filename: 10.5.250.155@config_db_imc_config_db_20211112_111930_full.db; Size: 44698624
2021-11-12 12:02:09 [INFO] [CDbRestore::RestoreDatabaseList] Restore fileDir: C:\Temp\bdd; Filename: 10.5.250.155@icc_db_imc_icc_db_20211112_111930_full.db; Size: 9312768
2021-11-12 12:02:09 [INFO] [CDbRestore::RestoreDatabaseList] Restore fileDir: C:\Temp\bdd; Filename: 10.5.250.155@invent_db_imc_inventory_db_20211112_111930_full.db; Size: 8307712
2021-11-12 12:02:09 [INFO] [CDbRestore::RestoreDatabaseList] Restore fileDir: C:\Temp\bdd; Filename: 10.5.250.155@monitor_db_imc_monitor_db_20211112_111930_full.db; Size: 18228224
2021-11-12 12:02:09 [INFO] [CDbRestore::RestoreDatabaseList] Restore fileDir: C:\Temp\bdd; Filename: 10.5.250.155@perf_db_imc_perf_db_20211112_111930_full.db; Size: 63115264
2021-11-12 12:02:09 [INFO] [CDbRestore::RestoreDatabaseList] Restore fileDir: C:\Temp\bdd; Filename: 10.5.250.155@reportplat_db_reportplat_db_20211112_111930_full.db; Size: 476160
2021-11-12 12:02:09 [INFO] [CDbRestore::RestoreDatabaseList] Restore fileDir: C:\Temp\bdd; Filename: 10.5.250.155@syslog_db_imc_syslog_db_20211112_111930_full.db; Size: 4696064
2021-11-12 12:02:09 [INFO] [CDbRestore::RestoreDatabaseList] Restore fileDir: C:\Temp\bdd; Filename: 10.5.250.155@vlanm_db_vlan_db_20211112_111930_full.db; Size: 1005568
2021-11-12 12:02:09 [INFO] [CDbRestore::RestoreDatabaseList] Restore fileDir: C:\Temp\bdd; Filename: 10.5.250.155@vnm_db_imc_vnm_db_20211112_111930_full.db; Size: 422912
2021-11-12 12:02:09 [INFO] [CDbRestore::RestoreDatabaseList] Restore fileDir: C:\Temp\bdd; Filename: 10.5.250.155@vxlan_db_imc_vxlan_db_20211112_111930_full.db; Size: 648192
2021-11-12 12:02:09 [INFO] [CDbRestore::RestoreDatabaseList] Begin stop service.
2021-11-12 12:02:10 [INFO] [Main] Version: 7.3
2021-11-12 12:02:10 [INFO] [Main] Global directory: C:/IMC/dbman
2021-11-12 12:02:10 [INFO] [Main] Listenning on port: 2812
2021-11-12 12:02:10 [DEBUG] [Main] arv count 2
2021-11-12 12:02:10 [DEBUG] [Main] arv 1: dbman
2021-11-12 12:02:10 [DEBUG] [Main] arv 2: -n
2021-11-12 12:02:10 [INFO] [DBMAN] dbman exit
2021-11-12 12:02:37 [INFO] [CDbRestore::RestoreDatabaseList] End stop service.
2021-11-12 12:02:37 [INFO] [CDbRestore::RestoreDatabaseList] Restart DBIp: 10.5.250.155
2021-11-12 12:02:37 [INFO] [CRestoreConfig::readFrom] Fail to read restore config file: C:/IMC/dbman\/etc/oracleRac.cfg
2021-11-12 12:02:37 [INFO] [Client::connect_to_server] Starting connect to 10.5.250.155: 2812
2021-11-12 12:02:37 [INFO] [Client::connect_to_server] Established connection to 10.5.250.155: 2812
2021-11-12 12:02:37 [ERROR] [deal_err_response] Remote return error code: AsnDbmanDmErrCode::iERR_MSG_DBMAN_RES_ERROR, errorContent: Dbman deal msg error, please to see dbman_debug.log
2021-11-12 12:02:37 [INFO] [DBMAN] Begin to restore file 10.5.250.155@aclm_dbimc_aclm
2021-11-12 12:02:37 [INFO] [Client::connect_to_server] Starting connect to 10.5.250.155: 2812
2021-11-12 12:02:37 [INFO] [Client::connect_to_server] Established connection to 10.5.250.155: 2812
2021-11-12 12:02:37 [ERROR] [Client::send_filetrans_msg] Send file data error expect 1024 bytes infact -1 bytes
2021-11-12 12:02:37 [INFO] [CDbRestore::RestoreOneDBase] File trans failed
2021-11-12 12:02:37 [ERROR] [CDbRestore::RestoreDatabaseList] Fail to restore DB file in RestoreOneDBase Function 10.5.250.155@aclm_db_imc_aclm_db_20211112_111930_full.db
2021-11-12 12:02:37 [INFO] [ManualRestoreBase] req asn msg:{ -- SEQUENCE --
iErrCode 'f6'H --
,
iContent '61636c6d5f64623b31302e352e3235302e313535'H -- "aclm_db;10.5.250.155" --
}
2021-11-12 12:02:37 [INFO] [sendTrapAlert] Send trap success
2021-11-12 12:02:37 [ERROR] [ManualRestoreBase] Failed to manual restore databases. ManualType: 0
2021-11-12 12:02:37 [ERROR] [response_err_code] errCode = -10
2021-11-12 12:02:37 [INFO] [ManualRestoreBase] Begin start service.
2021-11-12 12:03:13 [INFO] [ManualRestoreBase] End start service.
Any help would be much appreciated.
Regards