Loading...

Backup Troubleshooting - SAP MaxDB iDataAgent

On Windows clients, backup operation fails

On Windows clients, backup operation fails with the following error message:

-24920, ERR_TOOLCHK: External backup tool not found
The file C:\PROGRA~1\COMMVA~1\SIMPAN~1\Base\backint.exe is not executable

Issue

Windows does not allow short paths in the backint.conf file, so the backup operation fails.

Resolution

In the backint.conf file, provide full path to backint.exe as follows:

BACKINT C:\cvbackuptools\backint.exe
INPUT C:\cvbackuptools\in
OUTPUT C:\cvbackuptools\out
ERROROUTPUT C:\cvbackuptools\err
PARAMETERFILE C:\cvbackuptools\param
TIMEOUT_SUCCESS 300
TIMEOUT_FAILURE 300

Create the backint.conf file in the C:\cvbackuptools directory and copy the parameters file to the same directory.

On Windows clients, backup operation fails

On Windows clients, backup operation fails with the following error message:

-24920, ERR_BACKUPOP: Backup failed
The backup tool failed with 2 as sum of exit codes. The database request was canceled and ended with error -903.

Issue

Windows does not allow short paths in the backint.conf file, so the backup operation fails.

Resolution

In the backint.conf file, provide full path to backint.exe, and backint input, output, and error files, as follows:

BACKINT C:\cvbackuptools\backint.exe
INPUT C:\cvbackuptools\in
OUTPUT C:\cvbackuptools\out
ERROROUTPUT C:\cvbackuptools\err
PARAMETERFILE C:\cvbackuptools\param
TIMEOUT_SUCCESS 300
TIMEOUT_FAILURE 300

Create the backint.conf file in the C:\cvbackuptools directory and copy the parameters file to the same directory.

Scheduled log backup operation fails when log size is too small (or negligible)

Scheduled log backup operation fails with the following error message:

-24920,ERR_BACKUPOP: backup operation was unsuccessful
The database was unable to fulfill a request (-123, No more log to save)

Issue

When a log backup is scheduled using a script and if the log size is very small (or negligible), then the log backup operation fails.

Resolution

Use the following command to check the log size on each log backup in script. If the log size is too small, then skip the log backup.

dbmcli -d <SID> -u '<LOGIN>,<PWD>' -c info log

SAP MaxDB command line operations do not invoke the backint program in a Windows environment

Issue

The SAP MaxDB and SAP on Oracle command line backup and restore operations do not invoke the backint program for the Commvault software in a Windows environment.

Resolution

  1. Verify that the Commvault software installation path includes "Base" in the path. On the command line, type the following command:

    C:\Users\admin>echo %PATH%
    %JRE_HOME%\bin;C:\Program Files\Java\jreXX.xx\bin;C:\Program Files\CommVault\ContentStore\Base

    where XX.xx is the Java version.

  2. Verify that the backint program is searchable from ENV. On the command line, type the following command:

    C:\Users\admin>where backint
    C:\Program Files\CommVault\ContentStore\Base\backint.exe

  3. Verify that you can invoke the backint program and the output is similar to the following.

    C:\Users\admin>backint
    backint -u <SID> [-f <backup | restore | inquire | delete>] [-t <file | file_online>] [-p <par_file>] [-i <in_file>] [-o <out_file>] [-c] [-v]
    Default: -f backup, -t file
    backint -u <SID> <-f summary> -p <par_file> [-i <in_file>] [-o <out_file>] [-v]
    backint <-f createsldxml> <short_client_name> <oracle|maxdb>

  4. We recommend that you do not install multiple vendor backup software on the same machine that has the backint program.

A Command Line Backup Job Fails After the Data Phase Completes

Issue

A command line backup job fails after the data phase completes with the following error message in the dbm.ebl file.

2017-03-06 20:42:15 The database is working on the request.
2017-03-06 20:42:45 Canceling Utility-task after a timeout of 300 seconds elapsed ... OK.
2017-03-06 20:42:46 The database is working on the request

Resolution

Set the DBM_KTO_SUCCESS and DBM_KTO_FAILURE variables. For information, go to the SAP help site, Setting DBM_KTO_SUCCESS and DBM_KTO_FAILURE.

Example

The database SID name is maxdb.

bash-4.2# dbmcli -d maxdb -u dbadmin,dbadmin dbm_configset DBM_KTO_SUCCESS 600
OK
bash-4.2# dbmcli -d maxdb -u dbadmin,dbadmin
dbmcli on maxdb>dbm_configget DBM_KTO_SUCCESS = 600

Backup Failure

Improper group association is specified during installation

The SAP for MAXDB user (sdb) should belong to the same group as entered during the installation. Otherwise, SAP for MAXDB will not be able to record the transactions in backint_maxdb.log and will not be able to access the registry. For example; /etc/<>Registry. As a result, the backups will fail. Sometimes, the backup fails due to incorrect group permissions.

The following message would be logged in the <instanceName>/wrk/dbm.ebl file:

Instance [<instanceName>] Machine [<machName>] does not exist.

Select 'sys' group (sdb) do not belong to this group and as a result the backup fails during the Backup. Please follow the proper installation instructions to create < >group and reinstall all the < >packages on the client. Use group dba during the installation.

Also, make sure to add sdb/sdba to group dba in the file /etc/group.

If you need to change the < > Group as part of security administrations. Then follow the procedure given below:

  • edit < >_GROUP variable in < >/Base/pkginfo file
  • do a "chgrp –R < >", "chmod o-w" on all < >files
  • Restart the services.

Failure of Backups and Restores performed from a remote desktop on Windows

Currently, backups and restores cannot be performed from a remote desktop on Windows.

Use any one of the following solutions that suits your setup:

  • Login to remote desktop using the following command:

    mstsc /v:winclient /console

    • Use netmeeting
    • Use telnet
    • Use the clients console

External Backup Tool Errors

The file '/opt/< >/SapMaxDbAgent/in' already exists.

Execute the following commands:

<instance># ./dbmcli -d TEST2 -u dbm,dbm -uUTL -c backup_start BackLog
ERR
-24927,ERR_TOOLCHK: external backup tool not found
The file '/opt/galaxy/SapMaxDbAgent/in' already exists.
<instance># rm /opt/galaxy/SapMaxDbAgent/in <instance># ./dbmcli -d TEST2 -u dbm,dbm -uUTL -c backup_start BackLog
ERR
-24927,ERR_TOOLCHK: external backup tool not found
The file '/opt/galaxy/SapMaxDbAgent/out' already exists.
<instance># rm /opt/galaxy/SapMaxDbAgent/out
<instance># ./dbmcli -d TEST2 -u dbm,dbm -uUTL -c backup_start BackLog
ERR
-24927,ERR_TOOLCHK: external backup tool not found
The file '/opt/galaxy/SapMaxDbAgent/err' already exists.
<instance># rm /opt/galaxy/SapMaxDbAgent/err
<instance># ./dbmcli -d TEST2 -u dbm,dbm -uUTL -c backup_start BackLog

The file /Base/backint.exe is not executable.

In this situation, the configuration of BACKINT interface is incorrect. Configure the following parameter files to the exact location of the backint.exe.

D:\program files\sdb\programs\pgm>cat D:\MaxDB\sdb\config\backint.conf
BACKINT "D:\< >\< >\Base\backint.exe"
INPUT "D:\MaxDB\sdb\config\in"
OUTPUT "D:\MaxDB\sdb\config\out"
ERROROUTPUT "D:\MaxDB\sdb\config\err"
PARAMETERFILE "D:\MaxDB\sdb\config\param"
TIMEOUT_SUCCESS 300
TIMEOUT_FAILURE 300
D:\program files\sdb\programs\pgm>

The file /SapMaxDbAgent/backint.conf is missing or unreadable.

Execute the following commands:

magnum-as-root> ./dbmcli -d TEST1 -u dbm,dbm -uUTL
./dbmcli on TEST1>dbm_configset -raw BSI_ENV/oracle/galaxy/SapMaxDbAgent/backint.conf OK
---
./dbmcli on TEST1>dbm_configset -raw set_variable_0 LD_LIBRARY_PATH=/oracle/galaxy/Base
OK
---
./dbmcli on TEST1>dbm_configset -raw set_variable_1 SHLIB_PATH=/oracle/galaxy/Base
OK
---
./dbmcli on TEST1>quit
OK
---
magnum-as-root> pwd
/oracle/sdb/programs/bin
magnum-as-root>

Last modified: 1/4/2018 12:59:57 PM