Network Management

 View Only
  • 1.  HPE IMC with dedicated MS-SQL Database: Manual Database Backup fail

    Posted May 16, 2025 08:34 AM

    Hi,

    We have a distributed IMC Environment: One HPE IMC Application Server and database on dedicated MS-SQL Server

    When trying to make a backup via Deployment Monitoring Agent or manually with dbman, the backup fails.

    The first file is beinig created on the dedicated MS-SQL Database Server, but seems not to be copied and then the process fail completly.

    Maybe its a transaction problem cause of a wrong IP address.
    I cannot see the MS-SQL Database Server IP Address (v-it052 172.19.0.37) in the dbman_debug.log in the HPE IMC Server, only the localhost 127.0.0.1 and a "wrong" IP 172.18.8.4.
    The 172.18.8.4 is only a secondary IP on the HPE IMC Server to directly connect to the switch management network, there is no default gateway and therefore no connection to the MS-SQL Database Server possible. The connection between IMC and Database should use the IP Address 172.19.2.130 on the IMC side to communicate with the database server with the IP Address 172.19.0.37.

    So I'm wondering about:
    2025-05-16 14:15:47 [THREAD(17164)] [INFO] [Client::connect_to_server] Starting connect to 172.18.8.4: 2810
    2025-05-16 14:15:47 [THREAD(17164)] [INFO] [Client::connect_to_server] Established connection to 172.18.8.4: 2810
    2025-05-16 14:15:47 [THREAD(8100)] [DEBUG] [My_Accept_Handler::handle_input] Connection established 172.18.8.4

    But oddly I even cannot see any traffic between 172.19.0.37 and 172.18.8.4, but database is working as traffic (tcp/1433) from 172.19.2.130 to 172.19.0.37 can be seen.

    Heres some more output from the debug log on IMC side. The debug log on database server is more or less empty, without the latest events as seen on the HPE IMC sides log.

    2025-05-16 14:15:39 [THREAD(8100)] [DEBUG] [My_Accept_Handler::handle_input] Connection established 127.0.0.1
    2025-05-16 14:15:39 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive encode length: 24
    2025-05-16 14:15:39 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive encode : gZGihypEytvj5nuMQOLWtw==
    2025-05-16 14:15:39 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive command code: 10000
    2025-05-16 14:15:39 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] Succeed to create SendBakConfigFileReq thread
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 32
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 32
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 32
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 32
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 32
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 32
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 32
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 32
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 32
    2025-05-16 14:15:39 [THREAD(17444)] [DEBUG] [CConfigT::decodePasswordInConf] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(17444)] [INFO] [SendBakConfigFileReq] Reload config from file: C:\Program Files\iMC\dbman\bin\..\etc\dbman.conf
    2025-05-16 14:15:39 [THREAD(17444)] [INFO] [SendBakConfigFileReq] Reload config from file: C:\Program Files\iMC\dbman\bin\..\etc\DBEtcInfo.conf
    2025-05-16 14:15:39 [THREAD(17444)] [INFO] [Client::connect_to_server] Starting connect to 127.0.0.1: 2810
    2025-05-16 14:15:39 [THREAD(17444)] [INFO] [Client::connect_to_server] Established connection to 127.0.0.1: 2810
    2025-05-16 14:15:39 [THREAD(8100)] [DEBUG] [My_Accept_Handler::handle_input] Connection established 127.0.0.1
    2025-05-16 14:15:39 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive encode length: 24
    2025-05-16 14:15:39 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive encode : Dk3E0f4CsnrVBvFc09sQtg==
    2025-05-16 14:15:39 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive command code: 10020
    2025-05-16 14:15:39 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] Success to create directory: C:\dbmanbak
    2025-05-16 14:15:39 [THREAD(17444)] [INFO] [Client::connect_to_server] Starting connect to 127.0.0.1: 2810
    2025-05-16 14:15:39 [THREAD(17444)] [INFO] [Client::connect_to_server] Established connection to 127.0.0.1: 2810
    2025-05-16 14:15:39 [THREAD(8100)] [DEBUG] [My_Accept_Handler::handle_input] Connection established 127.0.0.1
    2025-05-16 14:15:39 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive encode length: 24
    2025-05-16 14:15:39 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive encode : Dk3E0f4CsnrVBvFc09sQtg==
    2025-05-16 14:15:39 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] After debase64 length: 16
    2025-05-16 14:15:39 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive command code: 10020
    2025-05-16 14:15:39 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] Success to create directory: C:\dbmanrestore
    2025-05-16 14:15:47 [THREAD(8100)] [DEBUG] [My_Accept_Handler::handle_input] Connection established 127.0.0.1
    2025-05-16 14:15:47 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive encode length: 24
    2025-05-16 14:15:47 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive encode : Qp3HmHN+PqaKXJY7t3DD0Q==
    2025-05-16 14:15:47 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] After debase64 length: 16
    2025-05-16 14:15:47 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive command code: 10002
    2025-05-16 14:15:47 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] Succeed to create ManualBackupDBase thread .
    2025-05-16 14:15:47 [THREAD(9512)] [DEBUG] [getAllServerState] Send echo message to 
    2025-05-16 14:15:47 [THREAD(9512)] [INFO] [Client::connect_to_server] Starting connect to 172.18.8.4: 2810
    2025-05-16 14:15:47 [THREAD(9512)] [INFO] [Client::connect_to_server] Established connection to 172.18.8.4: 2810
    2025-05-16 14:15:47 [THREAD(8100)] [DEBUG] [My_Accept_Handler::handle_input] Connection established 172.18.8.4
    2025-05-16 14:15:47 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive encode length: 24
    2025-05-16 14:15:47 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive encode : xfA8jZ2+bK3Z2dEwvrJQaA==
    2025-05-16 14:15:47 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] After debase64 length: 16
    2025-05-16 14:15:47 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive command code: 10009
    2025-05-16 14:15:47 [THREAD(8100)] [ERROR] [CDataConnStreamQueueT::deal_msg] Receive echo message from 172.18.8.4
    2025-05-16 14:15:47 [THREAD(9512)] [INFO] [ManualBackupDase] All server echo ok
    2025-05-16 14:15:47 [THREAD(9512)] [INFO] [ManualBackupDase] begin to check file dir.
    
    2025-05-16 14:15:47 [THREAD(9512)] [DEBUG] [checkBackupFileDir] strLowerRoot:c:\program files\imc
    2025-05-16 14:15:47 [THREAD(9512)] [DEBUG] [Remove] Remove file: C:\Program Files\iMC\server\bin\..\..\dbman\etc\LastOperationResult.conf
    2025-05-16 14:15:47 [THREAD(9512)] [DEBUG] [CLorOper::modifyLor] Write file LastOperationResult.conf: Result=Backup in progress.
    ErrorReport=You cannot perform backup when another backup operation is in progress.
    Tips=If you cannot obtain the failure reason from the ErrorReport, view the dbman/log/dbman.log and dbman_debug.log files.
    2025-05-16 14:15:47 [THREAD(9512)] [DEBUG] [WriteFile] Write file C:\Program Files\iMC\server\bin\..\..\dbman\etc\LastOperationResult.conf.
    2025-05-16 14:15:47 [THREAD(9512)] [INFO] [CDbBackup::BackupAllDataBase] Begin to manual backup all databases. Backup directory: C:\tools\Backup_20250512
    2025-05-16 14:15:47 [THREAD(9512)] [INFO] [CDbBackup::BackupAllDataBase] ServerCount = 1
    2025-05-16 14:15:47 [THREAD(9512)] [INFO] [CDbBackup::BackupAllDataBase] Path: v-it052@aclm_db_imc_aclm_db_20250516_141547_full.db
    2025-05-16 14:15:47 [THREAD(9512)] [INFO] [Client::connect_to_server] Starting connect to 172.18.8.4: 2810
    2025-05-16 14:15:47 [THREAD(9512)] [INFO] [Client::connect_to_server] Established connection to 172.18.8.4: 2810
    2025-05-16 14:15:47 [THREAD(8100)] [DEBUG] [My_Accept_Handler::handle_input] Connection established 172.18.8.4
    2025-05-16 14:15:47 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive encode length: 24
    2025-05-16 14:15:47 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive encode : 0vSTRtaVhpzh/V1d1TFCSQ==
    2025-05-16 14:15:47 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] After debase64 length: 16
    2025-05-16 14:15:47 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive command code: 10005
    2025-05-16 14:15:47 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive iMSG_V001_REMOTE_BACKUP_ONEDBFILE_REQ data_len = 256
    2025-05-16 14:15:47 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] Succeed to create BackupDBase thread
    2025-05-16 14:15:47 [THREAD(17164)] [INFO] [CDbBackup::BackupOneLocalDBase] Ready to backup 'C:/Program Files/iMC/dbman\bak\v-it052@aclm_db_imc_aclm_db_20250516_141547_full.db'
    2025-05-16 14:15:47 [THREAD(17164)] [DEBUG] [CDbBase::ExecSql] Input sql: BACKUP DATABASE aclm_db
    TO DISK = 'C:/Program Files/iMC/dbman\bak\v-it052@aclm_db_imc_aclm_db_20250516_141547_full.db'
    WITH INIT
    GO
    
    2025-05-16 14:15:47 [THREAD(17164)] [DEBUG] [WriteFile] Write file C:\Program Files\iMC\dbman\bin\dbop.sql.
    2025-05-16 14:15:47 [THREAD(17164)] [INFO] [runCommand] runCommand result OK. ret=0, WIFEXITED(ret)=1, WEXITSTATUS(ret)=0
    2025-05-16 14:15:47 [THREAD(17164)] [ERROR] [CDbBase::ExecSql] ---------------------------Exec command VOER.---------------------------
    2025-05-16 14:15:47 [THREAD(17164)] [DEBUG] [CDbBase::ExecSql] Exec sql log: 296 Seiten wurden fr die aclm_db-Datenbank, Datei "PRMDATA01" fr
    
    Datei 1, verarbeitet.
    
    96 Seiten wurden fr die aclm_db-Datenbank, Datei "PRMDATA02" fr
    
    Datei 1, verarbeitet.
    
    104 Seiten wurden fr die aclm_db-Datenbank, Datei "PRMDATA03" fr
    
    Datei 1, verarbeitet.
    
    1 Seiten wurden fr die aclm_db-Datenbank, Datei "LOG01" fr Datei 1,
    
    verarbeitet.
    
    BACKUP DATABASE hat erfolgreich 497 Seiten in 0.085 Sekunden
    
    verarbeitet (45.605 MB/s).
    
    
    2025-05-16 14:15:47 [THREAD(17164)] [DEBUG] [Remove] Remove file: C:\Program Files\iMC\dbman\bin\dbop.sql.log
    2025-05-16 14:15:47 [THREAD(17164)] [DEBUG] [Remove] Remove file: C:\Program Files\iMC\dbman\bin\dbop.sql
    2025-05-16 14:15:47 [THREAD(17164)] [INFO] [CDbBackup::BackupOneLocalDBase] Success to backup 'C:/Program Files/iMC/dbman\bak\v-it052@aclm_db_imc_aclm_db_20250516_141547_full.db'
    2025-05-16 14:15:47 [THREAD(17164)] [ERROR] [GetFileSize] -1 == res : Fail to open file: C:/Program Files/iMC/dbman\bak\v-it052@aclm_db_imc_aclm_db_20250516_141547_full.db, errno: 2
    2025-05-16 14:15:47 [THREAD(17164)] [INFO] [CDbBackup::BackupOneLocalDBase] ifAuto: 0;ifTrans: 0;bakDbIp: ,bakDBReceivePath: 
    2025-05-16 14:15:47 [THREAD(17164)] [INFO] [Client::connect_to_server] Starting connect to 172.18.8.4: 2810
    2025-05-16 14:15:47 [THREAD(17164)] [INFO] [Client::connect_to_server] Established connection to 172.18.8.4: 2810
    2025-05-16 14:15:47 [THREAD(8100)] [DEBUG] [My_Accept_Handler::handle_input] Connection established 172.18.8.4
    2025-05-16 14:15:47 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive encode length: 24
    2025-05-16 14:15:47 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive encode : L5nvi/boOTmcOOGQ+cDp5A==
    2025-05-16 14:15:47 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] After debase64 length: 16
    2025-05-16 14:15:47 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive command code: 10010
    2025-05-16 14:15:47 [THREAD(8100)] [DEBUG] [CDataConnStreamQueueT::deal_msg] Succeed to create FileTrans thread
    2025-05-16 14:15:47 [THREAD(8508)] [INFO] [FileTrans] Dbman space is enough, trans files is safety.
    2025-05-16 14:15:47 [THREAD(17164)] [INFO] [Client::send_filetrans_msg] Dbman space check ok, preparing to transfer files(C:/Program Files/iMC/dbman\bak\v-it052@aclm_db_imc_aclm_db_20250516_141547_full.db 0Bytes).
    2025-05-16 14:15:47 [THREAD(17164)] [ERROR] [Client::send_filetrans_msg] (errno is 2) Open file fail: C:/Program Files/iMC/dbman\bak\v-it052@aclm_db_imc_aclm_db_20250516_141547_full.db
    2025-05-16 14:15:47 [THREAD(17164)] [INFO] [CDbBackup::BackupOneLocalDBase] file trans failed
    2025-05-16 14:15:47 [THREAD(8508)] [INFO] [FileTrans] Ready to receive file(C:\tools\Backup_20250512\v-it052@aclm_db_imc_aclm_db_20250516_141547_full.db 0Bytes)
    2025-05-16 14:15:47 [THREAD(17164)] [INFO] [sendTrapAlert] Send trap success 
    
    2025-05-16 14:15:47 [THREAD(17164)] [ERROR] [response_err_code] errCode = -8
    2025-05-16 14:15:47 [THREAD(9512)] [ERROR] [Client::send_backupdbase_msg] Remote return error: Database backup failed when backup
    2025-05-16 14:15:47 [THREAD(9512)] [WARNING] [CDbBackup::BackupAllDataBase] Backup database: aclm_db failed
    2025-05-16 14:15:47 [THREAD(9512)] [ERROR] [ManualBackupDase] manual backing fail
    2025-05-16 14:15:47 [THREAD(9512)] [DEBUG] [Remove] Remove file: C:\Program Files\iMC\server\bin\..\..\dbman\etc\LastOperationResult.conf
    2025-05-16 14:15:47 [THREAD(9512)] [DEBUG] [CLorOper::modifyLor] Write file LastOperationResult.conf: Result=Backup failed.
    ErrorReport=Database backup or bulk operation failed.
    Tips=If you cannot obtain the failure reason from the ErrorReport, view the dbman/log/dbman.log and dbman_debug.log files.
    2025-05-16 14:15:47 [THREAD(9512)] [DEBUG] [WriteFile] Write file C:\Program Files\iMC\server\bin\..\..\dbman\etc\LastOperationResult.conf.
    2025-05-16 14:15:47 [THREAD(9512)] [ERROR] [response_err_code] errCode = -1
    

    Maybe someone can help, whats the problem is and how to get the dbman file transfer possible, and how to define the IP Address that should be used for this purpose.

    Thanks and kind regards

    Robert



  • 2.  RE: HPE IMC with dedicated MS-SQL Database: Manual Database Backup fail

    Posted May 19, 2025 03:52 AM

    Hello,

    the configuration files responsible for the correct IP addresses binding on both servers (iMC and remote database) are called server-addr.xml, you can find them under \iMC\common\conf on both servers. under "local-address" you should see the correct IP address of the server where you check the file. The "db-config address" should be the IP address of the remote database server. On the below screenshot (the file is on the iMC server) .52 is the IP address of the iMC server and .53 is the remote database:

    On the iMC server there is additional file that also needs to be checked. It is called again server-addr.xml, but the location is different - \iMC\euplat\common\conf.

    Please check if you have the correct IP addresses there and change them if they are wrong.

    Thank you,

    Best Regards,

    Ivaylo Velikov




  • 3.  RE: HPE IMC with dedicated MS-SQL Database: Manual Database Backup fail

    Posted May 19, 2025 06:15 AM
    Edited by r.grossmann May 19, 2025 07:17 AM

    Hello Ivaylo,

    thanks for your response.

    I checked the files and the local address is correct on both sides in the imc\common\conf

    IMC:
    local-address: 172.19.2.130 (correct)
    components address: 127.0.0.1
    db-config address: v-it052 (correct, dns without domain, dns-suffix is our domain)

    Database Server:
    local-address: 172.19.0.37 (correct)
    components address: 172.19.2.130 (correct, see above)
    db-config address: v-it052 (not sure if correct or should be localhost 127.0.0.1)

    There is no directory \IMC\euplat\common\conf on my HPE IMC or database server (generally no \IMC\euplat\)

    I do have another server-addr.xml in the directory \IMC\deploy\conf
    Both files on IMC server are identical and both filse on Database server are identical.

    And IMC with external database is working. Only the "integrated" database backup with dbman (still) does not work.


    dbman.conf on IMC:

    # DBMAN Configurations
    
    Language = en
    # Common Configurations
    EnableDbman = 0
    BackHoseIp = 
    PrimaryHost = 0
    MaxLogSize = 10485760
    FileReserveTime = 7
    CommandPort = 2810
    SessionTimeout = 300
    
    FaultIp = 127.0.0.1
    IfTransToHost  = 0
    
    # Primary Common Configurations
    BackupAtOnce = 0
    BackupTime = 4
    BackupTimeMinute = 0
    AfterFTPSave = 2
    # iMC server Configurations
    ServerCount = 1
    
    iMCIP1 = 127.0.0.1
    DBaseIP1 = v-it052
    DBType1 = 1
    DBInstance1 = N/A
    PrimaryDbSaUserName1 = imc-db-sa
    PrimaryDbSaPassword1 = HASH
    PrimaryDbPort1 = 1433
    DBCount1 = 10
    
    # Primary 1 Configurations 
    BackupPath1_127.0.0.1 = C:\dbmanbak
    BackupPath1_v-it052 = C:\dbmanbak
    
    PrimaryDbInst1_1 = v-it052@aclm_db
    PrimaryDbUser1_1 = imc_aclm
    PrimaryDbPassword1_1 = HASH
    PrimaryDbInst1_1_iMC-ACLM = 7.3.E0710P06
    ifbackup1_1 = 1
    iftrans1_1 = 0
    ........

    I dont know whar BackHoseIp is for, but I tried "BackHoseIp = 172.19.2.130", but without change in behaviour
    What is it for? And what are the others variables are for? Maybe I could change something there, to get file transfer working with the correct IP addresses (if that is really the problem)?


    dbman.conf on Database server v-it052:

    # DBMAN Configurations
    
    # Common Configurations
    EnableDbman = 0
    PrimaryHost = 1
    MaxLogSize = 10485760
    FileReserveTime = 7
    CommandPort = 2810
    SessionTimeout = 300
    
    # Primary Host Configurations
    BackupTime = 04
    BackupTimeMinute = 00
    BackupAtOnce = 0
    BackupPath = 
    
    PrimaryDbSaPassword = HASH
    DBCount = 4
    
    PrimaryDbInst1 = 127.0.0.1@aclm_db
    PrimaryDbUser1 = imc_aclm
    PrimaryDbPassword1 = HASH
    ......


    Any other idea? How does dbman transfer the files from the Databse Server to the IMC Server to the desired directory? I can see a running tftp server on the databse server as on the IMC Server. But trying with a tftp client I am not able to put a file. Wireshark says: "Error Code, Code Access violation, Message: Access voilation." But the dbman directory also has a pscp.exe in it...

    Thanks and kind regards

    Robert




  • 4.  RE: HPE IMC with dedicated MS-SQL Database: Manual Database Backup fail
    Best Answer

    Posted May 19, 2025 11:10 AM

    Hello Robert,

    the configuration looks correct but there is something that bothers me, this is the FQDN name that you use for the database server in iMC. Although it should work seamless it isn't in some cases. I would suggest opening a case at the HPE TAC to check the issue (this will be possible if you have active contract for iMC). If you don't have a contract, you can replace the FQDN names of the database server in all server-addr.xml files with its IP address (on both servers), restart the machines and see if this can help solving the issue. 

    Before doing any change on the servers, please take a snapshot and backup the original files in another directory (not the original installation directory) so you can easily have the previous state in case of problems after the change has happened.

    Thank you,

    Best Regards,

    Ivaylo




  • 5.  RE: HPE IMC with dedicated MS-SQL Database: Manual Database Backup fail

    Posted May 21, 2025 03:28 AM

    Hello Ivaylo,

    I changed all DNS Entries v-it052 to the appropriate IP address, in all server-addr-xml files on both servers AND in dbman.conf on IMC server side.

    Now the database backup works. Thank you!

    Kind Regards

    Robert




  • 6.  RE: HPE IMC with dedicated MS-SQL Database: Manual Database Backup fail

    Posted May 21, 2025 03:48 AM
    Edited by IvoVelikov May 21, 2025 03:48 AM

    Hello Robert,

    now you need to change the instinfo.txt file in iMC (this is a configuration file that is important during upgrades and re-installations or migrations to another machines), you should define there that the database address will be an IP address and not an alias, like my example below:

    Then restart iMC.

    Thank you,

    Best Regards,

    Ivaylo