cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Got the following reply from db-kernel: SQL-Code :-903

Go to solution
Former Member

on ‎04-11-2011 12:40 PM

0 Kudos

Dear Experts,

I am having a problem running MaxDB Data backup on Netbackup.... Please se log below and suggest.

2011-04-11 13:30:38

Using environment variable 'TEMP' with value 'C:\Windows\TEMP' as directory for temporary files and pipes.

Using connection to Backint for MaxDB Interface.

2011-04-11 13:30:39

Checking existence and configuration of Backint for MaxDB.

Using configuration variable 'BSI_ENV' = 'C:\Netbackup_Script\bsi_backint_daily.env' as path of the configuration file of Backint for MaxDB.

Setting environment variable 'BSI_ENV' for the path of the configuration file of Backint for MaxDB to configuration value 'C:\Netbackup_Script\bsi_backint_daily.env'.

Reading the Backint for MaxDB configuration file 'C:\Netbackup_Script\bsi_backint_daily.env'.

Found keyword 'BACKINT' with value 'D:\sapdb\KGP\db\bin\backint.exe'.

Found keyword 'INPUT' with value 'E:\sapdb\data\wrk\KGP\backint.input'.

Found keyword 'OUTPUT' with value 'E:\sapdb\data\wrk\KGP\backint.output'.

Found keyword 'ERROROUTPUT' with value 'E:\sapdb\data\wrk\KGP\backint.error'.

Found keyword 'PARAMETERFILE' with value 'C:\Netbackup_Script\backint_parameter_daily.txt'.

Finished reading of the Backint for MaxDB configuration file.

Using 'D:\sapdb\KGP\db\bin\backint.exe' as Backint for MaxDB program.

Using 'E:\sapdb\data\wrk\KGP\backint.input' as input file for Backint for MaxDB.

Using 'E:\sapdb\data\wrk\KGP\backint.output' as output file for Backint for MaxDB.

Using 'E:\sapdb\data\wrk\KGP\backint.error' as error output file for Backint for MaxDB.

Using 'C:\Netbackup_Script\backint_parameter_daily.txt' as parameter file for Backint for MaxDB.

Using '300' seconds as timeout for Backint for MaxDB in the case of success.

Using '300' seconds as timeout for Backint for MaxDB in the case of failure.

Using 'E:\sapdb\data\wrk\KGP\dbm.knl' as backup history of a database to migrate.

Using 'E:\sapdb\data\wrk\KGP\dbm.ebf' as external backup history of a database to migrate.

Checking availability of backups using backint's inquire function.

Check passed successful.

2011-04-11 13:30:39

Checking medium.

Check passed successfully.

2011-04-11 13:30:39

Preparing backup.

The environment variable 'BSI_ENV' has already the value 'C:\Netbackup_Script\bsi_backint_daily.env'.

Setting environment variable 'BI_CALLER' to value 'DBMSRV'.

Setting environment variable 'BI_REQUEST' to value 'NEW'.

Setting environment variable 'BI_BACKUP' to value 'FULL'.

Constructed Backint for MaxDB call 'D:\sapdb\KGP\db\bin\backint.exe -u KGP -f backup -t file -p C:\Netbackup_Script\backint_parameter_daily.txt -i E:\sapdb\data\wrk\KGP\backint.input -c'.

Created temporary file 'E:\sapdb\data\wrk\KGP\backint.output' as output for Backint for MaxDB.

Created temporary file 'E:\sapdb\data\wrk\KGP\backint.error' as error output for Backint for MaxDB.

Writing 'D:\sapdb\pipe2 #PIPE' to the input file.

Prepare passed successfully.

2011-04-11 13:30:39

Starting database action for the backup.

Requesting 'SAVE DATA QUICK TO 'D:\sapdb\pipe2' PIPE BLOCKSIZE 8 NO CHECKPOINT MEDIANAME 'BACKDBFULL'' from db-kernel.The database is working on the request.

2011-04-11 13:30:39

Waiting until database has prepared the backup.

Asking for state of database.

2011-04-11 13:30:39 Database is still preparing the backup.

Waiting 1 second ... Done.

Asking for state of database.

2011-04-11 13:30:41 Database has finished preparation of the backup.

The database has prepared the backup successfully.

2011-04-11 13:30:41

Starting Backint for MaxDB.

Starting Backint for MaxDB process 'D:\sapdb\KGP\db\bin\backint.exe -u KGP -f backup -t file -p C:\Netbackup_Script\backint_parameter_daily.txt -i E:\sapdb\data\wrk\KGP\backint.input -c >>E:\sapdb\data\wrk\KGP\backint.output 2>>E:\sapdb\data\wrk\KGP\backint.error'.

Process was started successfully.

Backint for MaxDB has been started successfully.

2011-04-11 13:30:41

Waiting for end of the backup operation.

2011-04-11 13:30:41 The backup tool is running.

2011-04-11 13:30:41 The database is working on the request.

2011-04-11 13:30:43 The database has finished work on the request.

Receiving a reply from the database kernel.

Got the following reply from db-kernel:

SQL-Code :-903

2011-04-11 13:30:43 The backup tool is running.

2011-04-11 13:30:44 The backup tool process has finished work with return code 2.

The backup operation has ended.

2011-04-11 13:30:44

Filling reply buffer.

Have encountered error -24920:

The backup tool failed with 2 as sum of exit codes. The database request failed with error -903.

Constructed the following reply:

ERR

-24920,ERR_BACKUPOP: backup operation was unsuccessful

The backup tool failed with 2 as sum of exit codes. The database request failed with error -903.

Reply buffer filled.

2011-04-11 13:30:44

Cleaning up.

Copying output of Backint for MaxDB to this file.

-

Begin of output of Backint for MaxDB (E:\sapdb\data\wrk\KGP\backint.output)----

Reading parameter file C:\Netbackup_Script\backint_parameter_daily.txt.

Using D:\sapdb\KGP\db\bin\backint.exe as Backint for Oracle.

Using C:\Netbackup_Script\nt_initKGPdaily.utl as parameterfile of Backint for Oracle.

Using E:\sapdb\data\wrk\KGP\backinthistory.log as history file.

Using E:\sapdb\data\wrk\KGP\backintoracle.in as input of Backint for Oracle.

Using E:\sapdb\data\wrk\KGP\backintoracle.out as output of Backint for Oracle.

Using E:\sapdb\data\wrk\KGP\backintoracle.err as error output of Backint for Oracle.

Using staging area D:\sapdb\Stage1 with a size of 2147483648 bytes.

Reading input file E:\sapdb\data\wrk\KGP\backint.input.

Backing up pipe D:\sapdb\pipe2.

Found 1 entry in the input file.

Starting the backup.

Starting pipe2file program(s).

Waiting for creation of temporary files.

1 temporary file is available for backup.

Calling Backint for Oracle at 2011-04-11 13:30:43.

Calling 'D:\sapdb\KGP\db\bin\backint.exe -u KGP -f backup -t file -p C:\Netbackup_Script\nt_initKGPdaily.utl -i E:\sapdb\data\wrk\KGP\backintoracle.in -c' .

Backint for Oracle ended at 2011-04-11 13:30:43 with return code 2.

Backint for Oracle output: Reading parameter file C:\Netbackup_Script\nt_initKGPdaily.utl.

Backint for Oracle output: Using E:\sapdb\data\wrk\KGP\backint4oracle.in as input of Backint for Oracle.

Backint for Oracle output: Using E:\sapdb\data\wrk\KGP\backint4oracle.out as output of Backint for Oracle.

Backint for Oracle output: Using E:\sapdb\data\wrk\KGP\backint4oracle.err as error output of Backint for Oracle.

Backint for Oracle output: Using staging area D:\sapdb\Stage1 with a size of 2147483648 bytes.

Backint for Oracle output: Using E:\sapdb\data\wrk\KGP\backinthistory.log as history file.

Backint for Oracle output: Using D:\sapdb\KGP\db\bin\backint.exe as Backint for Oracle.

Backint for Oracle output:

Backint for Oracle output: Reading input file E:\sapdb\data\wrk\KGP\backintoracle.in.

Backint for Oracle output: Backing up file D:\sapdb\Stage1.0.

Backint for Oracle output: Found 1 entry in the input file.

Backint for Oracle output:

Backint for Oracle output: Starting the backup.

Backint for Oracle output: Starting pipe2file program(s).

Backint for Oracle output:

Backint for Oracle output: Calling Backint for Oracle at 2011-04-11 13:30:43.

Backint for Oracle output: Calling 'D:\sapdb\KGP\db\bin\backint.exe -u KGP -f backup -t file -i E:\sapdb\data\wrk\KGP\backint4oracle.in -c' .

Backint for Oracle output: Backint for Oracle ended at 2011-04-11 13:30:43 with return code 2.

Backint for Oracle output: Backint for Oracle output: Reading parameter file .

Backint for Oracle output: Backint for Oracle output:

Backint for Oracle output: Backint for Oracle output:

Backint for Oracle output: Backint for Oracle error output: No staging area is defined in the parameter file.

Backint for Oracle output: Backint for Oracle error output: The path of Backint for Oracle is not defined in the parameter file.

Backint for Oracle output: Backint for Oracle error output: The name of the history file is not defined in the parameter file.

Backint for Oracle output: Backint for Oracle error output: The name of the input file of Backint for Oracle is not defined in the parameter file.

Backint for Oracle output: Backint for Oracle error output: The name of the output file of Backint for Oracle is not defined in the parameter file.

Backint for Oracle output: Backint for Oracle error output: The name of the error output file of Backint for Oracle is not defined in the parameter file.

Backint for Oracle output: Backint for Oracle error output:

Backint for Oracle output:

Backint for Oracle output: Finished the backup unsuccessfully.

Backint for Oracle output:

Backint for Oracle output: #ERROR D:\sapdb\Stage1.0

Backint for Oracle output:

Backint for Oracle error output: Backint for Oracle was unsuccessful.

Backint for Oracle error output:

Finished the backup unsuccessfully.

#ERROR D:\sapdb\pipe2

-

End of output of Backint for MaxDB (E:\sapdb\data\wrk\KGP\backint.output)----

Removed Backint for MaxDB's temporary output file 'E:\sapdb\data\wrk\KGP\backint.output'.

Copying error output of Backint for MaxDB to this file.

-

Begin of error output of Backint for MaxDB (E:\sapdb\data\wrk\KGP\backint.error)----

Backint for Oracle was unsuccessful.

-

End of error output of Backint for MaxDB (E:\sapdb\data\wrk\KGP\backint.error)----

Removed Backint for MaxDB's temporary error output file 'E:\sapdb\data\wrk\KGP\backint.error'.

Removed the Backint for MaxDB input file 'E:\sapdb\data\wrk\KGP\backint.input'.

Have finished clean up successfully.

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

markus_doehr2
Active Contributor
‎04-12-2011 12:02 AM
0 Kudos

> Requesting 'SAVE DATA QUICK TO 'D:\sapdb\pipe2' PIPE BLOCKSIZE 8 NO CHECKPOINT MEDIANAME 'BACKDBFULL'' from db-kernel.The database is working on the request.

This seems to be your problem, the pipe is wrongly defined. On Windows it looks like

\\.\pipe1

see

http://msdn.microsoft.com/en-us/library/aa365783.aspx

Markus

Show replies
Show replies
Former Member
‎04-12-2011 11:16 AM
0 Kudos

Thanks for your assistance... Seems like I missed that point... defined
.\pipe\pipe2... Problem solved

Answers (1)

Answers (1)

markus_doehr2
Active Contributor
‎04-11-2011 2:09 PM
0 Kudos

> Got the following reply from db-kernel:

> SQL-Code :-903

Please check knldiag/KnlMsg of the database.

Markus

Show replies
Show replies
Former Member
‎04-11-2011 11:49 PM
0 Kudos

this is the info in KnlMsg

#$BACKUP_MEDIA_NO$ ($BACKUP_MEDIUM_NAME$) $ERRORTEXT$">

<MSG_ARGS

_FILE="vkb38.cpp"

_LINE="293"

_TIME="2011-04-12 00:14:50.038"

_MESSAGEVERSION="1"

BACKUP_MEDIA_NO="1"

BACKUP_MEDIUM_NAME="D:\sapdb\pipe2"

ERRORTEXT="mismatch: checked and expected type"

/>

</MSG>

<MSG _NO="6" _ID="6" _COMP="KernelCommon" TEXT="$TITLE$, Error code $BASISERROR$ &quot;$ERRORTEXT$&quot;">

<MSG_ARGS

FILE="KernelTrace.cpp"

_LINE="219"

_TIME="2011-04-12 00:14:50.038"

_MESSAGEVERSION="1"

TITLE="Backup error occured"

BASIS_ERROR="3700"

ERRORTEXT="hostfile_error"

/>

Ask a Question