LiveCache DB backup failure due to error code "903".

[Former Member]

LC DB BACKUP was failed due to backup devices issue '903'. When I did the

BACKUP to FILE instead of PIPE, it worked well. Pls suggest. Thanks.

Base on the configuration 'dbm.mmm'. Here is the definition for PIPE

'BACKTSM', which is the current BACKUP device.

[BACKTSM]

LOCATION=/sapdb/backup/dummy

TYPE=PIPE

SAVETYPE=DATA

SIZE=0

BLOCKSIZE=8

OVERWRITE=NO

AUTOLOADER=NO

OSCOMMAND=

BACKUPTOOL=BACK

CREATED=20061101171214

MODIFIED=20061101171214

[janlars_goedtke]

Hi,

is it still a problem?

Are you doing a backup to a TSM Server?

Regards

Jan

[former_member229109]

Hello Steve Yang,

1. It will be helpful if you will update the thread with additional information:

• What is the version of the liveCache instance?

• What is the version of the external backup tool you are using?

• Did you check the errors in knldiag < or KnlMsg > and dbm.ebp files?

• Did you check the documents at

http://maxdb.sap.com/doc/7_7/default.htm

-> Database Administration -> Backing Up Databases -> Using Third-Party Backup Tools

< Pay attention to u201CMore informationu201D links for u201CInstallation Manualsu201D >?

2. Did you create the SAP message on this issue?

Thank you and best regards, Natalia Khlopina

[Former Member]

OSS message is 1062604 / 2010. However, no response so far.

Here is the info from the log file 'knldiag.err'.

2010-12-28 13:47:18 56387 ERR 11000 d0_aopen filetype found file, required pipe

2010-12-28 13:47:18 34953 ERR 52012 SAVE error occured, basis_err 3700

2010-12-28 13:47:18 34953 ERR 3 Backup Data backup failed

2010-12-28 13:47:18 34953 ERR 1 Backup + Backupmedium #1 (/sapdb/backup/demo) Wrong file type

2010-12-28 13:47:18 34953 ERR 6 KernelCo + Backup error occured, Error code 3700 "hostfile_error"

2010-12-28 13:47:18 34953 ERR 17 SrvTasks + Servertask Info: because Error in backup task occured

2010-12-28 13:47:18 34953 ERR 10 SrvTasks + Job 1 (Backup / Restore Medium Task) [executing] WaitingT115 Result=3700

2010-12-28 13:47:18 34953 ERR 6 KernelCo + Error in backup task occured, Error code 3700 "hostfile_error"

However, i am not quite sure how to find out what's the third party tools the BAKCUP is using. The only thing I find is the configration 'dbm.mm'. The data carrier is 'BACKTSM', and the backtool is set 'BACK'. Any suggestions? The LC version is 'BUILD = DBMServer 7.6.06 Build 009-123-225-492'.

[BACKTSM]

LOCATION=/sapdb/backup/dummy

TYPE=PIPE

SAVETYPE=DATA

SIZE=0

BLOCKSIZE=8

OVERWRITE=NO

AUTOLOADER=NO

OSCOMMAND=

BACKUPTOOL=BACK

CREATED=20061101171214

MODIFIED=20061101171214

Edited by: Steve Yang on Dec 30, 2010 6:15 AM

[Former Member]

Attach dem.ebp for reference. Is it possible that the tools '/sapdb/LCT/db/bin/backint' have problems?

2010-12-30 10:35:13

Using environment variable 'TEMP' with value '' as directory for temporary files and pipes.

Using environment variable 'TMP' with value '/var/tmp' as directory for temporary files and pipes.

Using connection to Backint for MaxDB Interface.

2010-12-30 10:35:13

Checking existence and configuration of Backint for MaxDB.

Using configuration variable 'BSI_ENV' = '/home/lctadm/bsi.env' as path of the configuration file of Backi

nt for MaxDB.

Reading the Backint for MaxDB configuration file '/home/lctadm/bsi.env'.

Found keyword 'BACKINT' with value '/sapdb/LCT/db/bin/backint'.

The following line of the Backint for MaxDB configuration file does not start with a proper keyword an

d is ignored:

Found keyword 'INPUT' with value '/home/lctadm/dba/backint4SAPDB.in'.

Found keyword 'OUTPUT' with value '/home/lctadm/dba/backint4SAPDB.out'.

Found keyword 'ERROROUTPUT' with value '/home/lctadm/dba/backint4SAPDB.err'.

The following line of the Backint for MaxDB configuration file does not start with a proper keyword an

d is ignored:

Found keyword 'PARAMETERFILE' with value '/home/lctadm/backint.par'.

The following line of the Backint for MaxDB configuration file does not start with a proper keyword an

d is ignored:

Found keyword 'TIMEOUT_SUCCESS' with value '600'.

Found keyword 'TIMEOUT_FAILURE' with value '300'.

Finished reading of the Backint for MaxDB configuration file.

Using '/sapdb/LCT/db/bin/backint' as Backint for MaxDB program.

Using '/home/lctadm/dba/backint4SAPDB.in' as input file for Backint for MaxDB.

Using '/home/lctadm/dba/backint4SAPDB.out' as output file for Backint for MaxDB.

Using '/home/lctadm/dba/backint4SAPDB.err' as error output file for Backint for MaxDB.

Using '/home/lctadm/backint.par' as parameter file for Backint for MaxDB.

Using '600' 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 '/sapdb/data/wrk/LCT/dbm.knl' as backup history of a database to migrate.

Using '/sapdb/data/wrk/LCT/dbm.ebf' as external backup history of a database to migrate.

Checking availability of backups using backint's inquire function.

Check passed successful.

2010-12-30 10:35:13

Checking medium.

Check passed successfully.

2010-12-30 10:35:13

Preparing backup.

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 '/sapdb/LCT/db/bin/backint -u LCT -f backup -t file -p /home/lctadm/bac

kint.par -i /home/lctadm/dba/backint4SAPDB.in -c'.

Created temporary file '/home/lctadm/dba/backint4SAPDB.out' as output for Backint for MaxDB.

Created temporary file '/home/lctadm/dba/backint4SAPDB.err' as error output for Backint for MaxDB.

Writing '/sapdb/backup/dummy #PIPE' to the input file.

Prepare passed successfully.

2010-12-30 10:35:13

Creating pipes for data transfer.

Creating pipe '/sapdb/backup/dummy' ... Done.

All data transfer pipes have been created.

2010-12-30 10:35:13

Starting database action for the backup.

Requesting 'SAVE DATA QUICK TO '/sapdb/backup/dummy' PIPE BLOCKSIZE 8 NO CHECKPOINT MEDIANAME 'BACKTSM'' f

rom db-kernel.

The database is working on the request.

2010-12-30 10:35:13

Waiting until database has prepared the backup.

Asking for state of database.

2010-12-30 10:35:13 Database is still preparing the backup.

Waiting 1 second ... Done.

Asking for state of database.

2010-12-30 10:35:14 Database has finished preparation of the backup.

The database has prepared the backup successfully.

2010-12-30 10:35:14

Starting Backint for MaxDB.

Starting Backint for MaxDB process '/sapdb/LCT/db/bin/backint -u LCT -f backup -t file -p /home/lctadm/bac

kint.par -i /home/lctadm/dba/backint4SAPDB.in -c >>/home/lctadm/dba/backint4SAPDB.out 2>>/home/lctadm/dba/back

int4SAPDB.err'.

Process was started successfully.

Backint for MaxDB has been started successfully.

2010-12-30 10:35:14

Waiting for end of the backup operation.

2010-12-30 10:35:14 The backup tool is running.

2010-12-30 10:35:14 The database is working on the request.

2010-12-30 10:35:19 The backup tool is running.

2010-12-30 10:35:19 The database is working on the request.

2010-12-30 10:35:21 The backup tool process has finished work with return code 2.

2010-12-30 10:35:21 The database has finished work on the request.

Receiving a reply from the database kernel.

Got the following reply from db-kernel:

SQL-Code :-8020

Date :20101230

Time :00103514

Database :LCT

Server :mdt2ds41

KernelVersion :Kernel 7.6.06 Build 009-123-225-492

PagesTransfered :131072

PagesLeft :25509

MediaName :BACKTSM

Location :/sapdb/backup/dummy

Errortext :end of file

Label :DAT_000000970

IsConsistent :true

FirstLogPageNo :2676033

DBStamp1Date :20101230

DBStamp1Time :00081359

BDPageCount :156557

DevicesUsed :1

DatabaseID :mdt2ds09:LCD_20070908_000004

Max Used Data Page

Converter Page Count :99

The backup operation has ended.

2010-12-30 10:35:21

Filling reply buffer.

Have encountered error -24920:

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

Constructed the following reply:

ERR

Date :20101230

Time :00103514

Database :LCT

Server :mdt2ds41

KernelVersion :Kernel 7.6.06 Build 009-123-225-492

PagesTransfered :131072

PagesLeft :25509

MediaName :BACKTSM

Location :/sapdb/backup/dummy

Errortext :end of file

Label :DAT_000000970

IsConsistent :true

FirstLogPageNo :2676033

DBStamp1Date :20101230

DBStamp1Time :00081359

BDPageCount :156557

DevicesUsed :1

DatabaseID :mdt2ds09:LCD_20070908_000004

Max Used Data Page

Converter Page Count :99

The backup operation has ended.

2010-12-30 10:35:21

Filling reply buffer.

Have encountered error -24920:

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

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 -8020.

Reply buffer filled.

2010-12-30 10:35:21

Cleaning up.

Removing data transfer pipes.

Removing data transfer pipe /sapdb/backup/dummy ... Done.

Removed data transfer pipes successfully.

Copying output of Backint for MaxDB to this file.

-

---

Begin of output of Backint for MaxDB (/home/lctadm/dba/backint4SAPDB.out)----

---

Have encountered error -24919:

The file '/home/lctadm/dba/backint4SAPDB.out' does not exists.

-

---

End of output of Backint for MaxDB (/home/lctadm/dba/backint4SAPDB.out)----

---

Have encountered error -24919:

Could not move output of tool from file /home/lctadm/dba/backint4SAPDB.out to protocol file.

Not removing Backint for MaxDB's temporary output file (/home/lctadm/dba/backint4SAPDB.out).

Copying error output of Backint for MaxDB to this file.

-

---

Begin of error output of Backint for MaxDB (/home/lctadm/dba/backint4SAPDB.err)----

---

Have encountered error -24919:

The file '/home/lctadm/dba/backint4SAPDB.err' does not exists.

-

---

End of error output of Backint for MaxDB (/home/lctadm/dba/backint4SAPDB.err)----

---

Have encountered error -24919:

Could not move output of tool from file /home/lctadm/dba/backint4SAPDB.err to protocol file.

Not removing Backint for MaxDB's temporary error output file (/home/lctadm/dba/backint4SAPDB.err).

Could not clean up all correctly.