imc backup fails

bonu_ray — Thu, 05 Dec 2019 08:02:20 GMT

Hello Guys,

I installed a new Windows 2016 VM and installed a fresh IMC 7.3 E0703 .

It is starting completely correct and i can logon to the Webinterface. But when I try to locally backup the database, no matter if automatically or manual, it just fails instantly. Here is what i found in the log.

2019-12-05 08:53:47 [DEBUG] [WriteFile] Write file C:\Program Files\iMC\dbman\bin\dbop.sql.
2019-12-05 08:53:48 [INFO] [runCommand] runCommand result FAIL. ret=1, errno=0, WIFEXITED(ret)=1, WEXITSTATUS(ret)=1
2019-12-05 08:53:48 [DEBUG] [CDbBase::ExecSql] Exec command: osql -b -S127.0.0.1,1433 -dmaster -U"sa" -P"iMC-Install2008" -n -o"C:\Program Files\iMC\dbman\bin\dbop.sql.log" -i"C:\Program Files\iMC\dbman\bin\dbop.sql"
2019-12-05 08:53:48 [ERROR] [CDbBase::ExecSql] Exec command fail
2019-12-05 08:53:48 [ERROR] [int ReadFile()] Read file C:\Program Files\iMC\dbman\bin\dbop.sql.log fail.
2019-12-05 08:53:48 [DEBUG] [CDbBase::ExecSql] Exec sql log:
2019-12-05 08:53:48 [INFO] [Remove] Fail to remove file: C:\Program Files\iMC\dbman\bin\dbop.sql.log
2019-12-05 08:53:48 [DEBUG] [Remove] Remove file: C:\Program Files\iMC\dbman\bin\dbop.sql
2019-12-05 08:53:48 [ERROR] [CDbBackup::BackupOneLocalDBase] Fail to backup `C:\Backup\127.0.0.1@aclm_db_imc_aclm_db_20191205_085343_full.db'.
2019-12-05 08:53:48 [INFO] [sendTrapAlert] Send trap success

2019-12-05 08:53:48 [WARNING] [CDbBackup::BackupAllDataBase] Backup database: aclm_db failed
2019-12-05 08:53:48 [ERROR] [ManualBackupDase] manual backing fail
2019-12-05 08:53:48 [ERROR] [response_err_code] errCode = -1

Hope you can help me.

Cheers, ray

Re: imc backup fails

_biv_ — Wed, 11 Dec 2019 10:38:39 GMT

Hello Ray,

Can you test the database connectivity from cmd.exe like this:

osql -b -S127.0.0.1,1433 -dmaster -U"sa" -P"iMC-Install2008"

or mybe check what is in C:\Program Files\iMC\dbman\bin\dbop.sql.log that can give you a clue why the login doesn't work.

Cheers,

Borislav

Re: imc backup fails

_biv_ — Mon, 04 May 2020 08:48:18 GMT

The most recent .pdf guide for installing MySQL 5.6 has a typo, it suggest:
Add the mysqldump parameter:
[mysqldump]
Single-transaction

should be with a lower case "s"

topic Re: imc backup fails in IMC

imc backup fails

Re: imc backup fails

Re: imc backup fails