Hi all,
I am planning to migrate the Database from a MS-SQL2014 to MS-SQL2019 but I get an error while using dbman to do a database backup on the SQL2014.
IMC is deployed on WinSrv2012R2 also the SQL2014. DBMAN is deploy over Deployment Manager as slave. The file on the DB-server will be create but it cannot be transfered to the IMC-server.
Here the debug log of dbman:
2021-09-15 13:43:49 [DEBUG] [Remove] Remove file: C:\Program Files\iMC\dbman\bin\dbop.sql.log
2021-09-15 13:43:49 [INFO] [Client::connect_to_server] Starting connect to
2021-09-15 13:43:49 [INFO] [Client::connect_to_server] Established connection to
2021-09-15 13:43:49 [DEBUG] [My_Accept_Handler::handle_input] Connection established
2021-09-15 13:43:49 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive encode length: 24
2021-09-15 13:43:49 [DEBUG] [CDataConnStreamQueueT::deal_msg] After debase64 length: 16
2021-09-15 13:43:49 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive command code: 10005
2021-09-15 13:43:49 [ERROR] [CDataConnStreamQueueT::deal_msg] Receive iMSG_V001_REMOTE_BACKUP_ONEDBFILE_REQ data_len = 256
2021-09-15 13:43:49 [DEBUG] [CDataConnStreamQueueT::deal_msg] Succeed to create BackupDBase thread
2021-09-15 13:43:49 [INFO] [CDbBackup::BackupOneLocalDBase] Ready to backup 'C:/Program Files/iMC/dbman\bak\
Hostname@icc_db_imc_icc_db_20210915_134215_full.db'
2021-09-15 13:43:49 [DEBUG] [CDbBase::ExecSql] Input sql: BACKUP DATABASE icc_db
TO DISK = 'C:/Program Files/iMC/dbman\bak\
Hostname@icc_db_imc_icc_db_20210915_134215_full.db'
WITH INIT
GO
2021-09-15 13:43:49 [DEBUG] [WriteFile] Write file C:\Program Files\iMC\dbman\bin\dbop.sql.
2021-09-15 13:43:49 [INFO] [runCommand] runCommand result OK. ret=0, WIFEXITED(ret)=1, WEXITSTATUS(ret)=0
2021-09-15 13:43:49 [ERROR] [CDbBase::ExecSql] ---------------------------Exec command VOER.---------------------------
2021-09-15 13:43:49 [DEBUG] [CDbBase::ExecSql] Exec sql log: Processed 608 pages for database 'icc_db', file 'PRMDATA01' on file 1.
Processed 120 pages for database 'icc_db', file 'PRMDATA02' on file 1.
Processed 152 pages for database 'icc_db', file 'PRMDATA03' on file 1.
Processed 2 pages for database 'icc_db', file 'LOG01' on file 1.
BACKUP DATABASE successfully processed 882 pages in 0.045 seconds
(152.962 MB/sec).
2021-09-15 13:43:49 [DEBUG] [Remove] Remove file: C:\Program Files\iMC\dbman\bin\dbop.sql.log
2021-09-15 13:43:49 [DEBUG] [Remove] Remove file: C:\Program Files\iMC\dbman\bin\dbop.sql
2021-09-15 13:43:49 [INFO] [CDbBackup::BackupOneLocalDBase] Success to backup 'C:/Program Files/iMC/dbman\bak\
Hostname@icc_db_imc_icc_db_20210915_134215_full.db'
2021-09-15 13:43:49 [ERROR] [GetFileSize] -1 == res : Fail to open file: C:/Program Files/iMC/dbman\bak\
Hostname@icc_db_imc_icc_db_20210915_134215_full.db, errno: 2
2021-09-15 13:43:49 [INFO] [CDbBackup::BackupOneLocalDBase] ifAuto: 0;ifTrans: 0;bakDbIp: ,bakDBReceivePath:
2021-09-15 13:43:49 [INFO] [Client::connect_to_server] Starting connect to
2021-09-15 13:43:49 [INFO] [Client::connect_to_server] Established connection to
2021-09-15 13:43:49 [DEBUG] [My_Accept_Handler::handle_input] Connection established
2021-09-15 13:43:49 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive encode length: 24
2021-09-15 13:43:49 [DEBUG] [CDataConnStreamQueueT::deal_msg] After debase64 length: 16
2021-09-15 13:43:49 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive command code: 10010
2021-09-15 13:43:49 [DEBUG] [CDataConnStreamQueueT::deal_msg] Succeed to create FileTrans thread
2021-09-15 13:43:49 [INFO] [FileTrans] Dbman space is enough, trans files is safety.
2021-09-15 13:43:49 [INFO] [Client::send_filetrans_msg] Dbman space check ok, preparing to transfer files(C:/Program Files/iMC/dbman\bak\
Hostname@icc_db_imc_icc_db_20210915_134215_full.db).
2021-09-15 13:43:49 [ERROR] [Client::send_filetrans_msg] (errno is 2) Open file fail: C:/Program Files/iMC/dbman\bak\
Hostname@icc_db_imc_icc_db_20210915_134215_full.db2021-09-15 13:43:49 [INFO] [CDbBackup::BackupOneLocalDBase] file trans failed
2021-09-15 13:43:49 [ERROR] [FileTrans] Failed to write file:C:\Users\Username\Documents\
Hostname@icc_db_imc_icc_db_20210915_134215_full.db. File size error. Size:0, just size: -1
2021-09-15 13:43:49 [ERROR] [response_err_code] errCode = -1
2021-09-15 13:43:49 [INFO] [sendTrapAlert] Send trap success
2021-09-15 13:43:49 [ERROR] [response_err_code] errCode = -8
2021-09-15 13:43:49 [ERROR] [Client::send_backupdbase_msg] Remote return error: Database backup failed when backup
2021-09-15 13:43:49 [WARNING] [CDbBackup::BackupAllDataBase] Backup database: icc_db failed
2021-09-15 13:43:49 [ERROR] [ManualBackupDase] manual backing fail
2021-09-15 13:43:49 [ERROR] [response_err_code] errCode = -1
Do you have any idea or solution?
Best regards
MrPfiff