Network Management

last person joined: yesterday 

Keep an informative eye on your network with IMC and AirWave network management solutions.

IMC 7.3 E0706 DBMAN Backup

This thread has been viewed 11 times
  • 1.  IMC 7.3 E0706 DBMAN Backup

    Posted Sep 15, 2021 10:33 AM
    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.db
    2021-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