Hello Alex,
...
Calling Backint for Oracle at 2004-12-03 09:27:55.
Backint for Oracle has ended at 2004-12-03 09:27:55.
Backint for Oracle output:
Backint for Oracle output: C:\SAPDB\DEPEND>C:\perl\bin\perl.exe
C:\sapdb\indep_data\wrk\TST\backup\backint_OB\wrapper.pl -u TST -f
backup -t file -p
C:\sapdb\indep_data\wrk\TST\backup\backint_SAPDB\backintparam.utl -i
C:\sapdb\indep_data\wrk\TST\backup\backint_OB\backint4Oracle.in -c
Backint for Oracle output:
Backint for Oracle error output:
Finished the backup unsuccessfully.
...
So Backint for SAP DB created the first temporary file and tried to back
it up using Backint for Oracle
(C:\sapdb\indep_data\wrk\TST\backup\backint_OB\backint.cmd). But this
only resulted in a perl-call for a wrapper.pl script. It did especially
not answer in the format of Backint for Oracle ( a line starting with
#SAVED, #ERROR, etc. is missing). Therefore Backint for SAP DB said the
backup is over, the pipe was closed and the database kernel reported an
incomplete backup.
Please test your Backint for Oracle manually. It should be able to
backup a file correctly.
Best regards,
Tilo Heinrich
SAP Labs Berlin
>-----Original Message-----
>From: Rodriguez, Alex (HPS Software - Miami)
>[mailto:[EMAIL PROTECTED]
>Sent: Friday, December 03, 2004 4:10 PM
>To: [EMAIL PROTECTED]
>Subject: RE: SAPDB 7.3 - Backup to Pipe - Error SQL Code -8020.
>
>
>Hi Tilo,
>
>I have included a backup_TST.zip, this zip file contains some
>files that you might want to
>take a look at it.
>
>Thanks,
>
>Alex Rodriguez
>Senior Engineer
>HPS CSC Americas - LAC
>
>________________________________
>
>From: Heinrich, Tilo [mailto:[EMAIL PROTECTED]
>Sent: Fri 12/3/2004 9:59 AM
>To: [EMAIL PROTECTED]
>Cc: Rodriguez, Alex (HPS Software - Miami)
>Subject: RE: SAPDB 7.3 - Backup to Pipe - Error SQL Code -8020.
>
>
>
>Hello Alex,
>
>-8020 during backup just means, that no complete backup was made. The
>reason for this is most probably the failure of Backint for SAP DB with
>exit code 2. Please send the complete dbm.ebp to this mailing list.
>
>Best regards,
>Tilo Heinrich
>SAP Labs Berlin
>
>>-----Original Message-----
>>From: Rodriguez, Alex (HPS Software - Miami)
>>[mailto:[EMAIL PROTECTED]
>>Sent: Friday, December 03, 2004 3:53 PM
>>To: [EMAIL PROTECTED]
>>Subject: SAPDB 7.3 - Backup to Pipe - Error SQL Code -8020.
>>
>>
>>Hello There,
>>
>>We are trying to configure a test environment here at then HP
>>Response Center for the
>>Americas using SAPDB 7.3.0 - Windows 2000/SP4 and HP OpenView
>>Data Protector 5.10.
>>
>>After we have completed with all the configuration steps,
>>created files (bsi.env, backint.cmd,
>>SecondConf.txt, wrappel.pl), registred the bsi.env file, etc.,
>>we tried to run a backup from the
>>dbmcli and we got the following error :
>>
>>dbmcli on TST>backup_start BACK_TST_SAPDB_TST
>>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.
>>
>>Part of the dbm.ebp file shows :
>>
>>=========
>>
>>2004-12-03 09:27:54
>>Starting Backint for SAP DB.
>> Starting Backint for SAP DB process
>>'C:\sapdb\depend\bin\backint.exe -u TST -f backup -t file -p
>>C:\sapdb\indep_data\wrk\TST\backup\backint_OB\SecondConf.txt
>>-i
>>C:\sapdb\indep_data\wrk\TST\backup\backint_SAPDB\backint4SAPDB.
>>in -c
>>>>C:\sapdb\indep_data\wrk\TST\backup\backint_SAPDB\backint4SAPD
>>B.out
>>2>>C:\sapdb\indep_data\wrk\TST\backup\backint_SAPDB\backint4SA
>PDB.err'.
>> Process was started successfully.
>>Backint for SAP DB has been started successfully.
>>2004-12-03 09:27:54
>>Waiting for end of the backup operation.
>> 2004-12-03 09:27:54 The backup tool is running.
>> 2004-12-03 09:27:54 The database is working on the request.
>> 2004-12-03 09:27:55 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 :20041203
>> Time :00092752
>> Database :TST
>> Server :rodriguezalej2.ssr.hp.com
>> KernelVersion :Kernel 7.3.0 Build
>048-100-066-583
>> PagesTransfered :16
>> PagesLeft :259
>> MediaName :BACK_TST_SAPDB_TST
>> Location :\\.\pipe\TST
>> Errortext :end of file [109]
>> Label :DAT_00003
>> IsConsistent :true
>> FirstLogPageNo :499
>> DBStamp1Date :20041203
>> DBStamp1Time :00092752
>> BDPageCount :251
>> DevicesUsed :1
>> DatabaseID
>>:rodriguezalej2.ssr.hp.com:TST_20041203_085614
>> Max Used Data Page :266
>> 2004-12-03 09:27:56 The backup tool process has finished
>>work with return code 2.
>> 2004-12-03 09:27:56 The backup tool is not running.
>>The backup operation has ended.
>>
>>======
>>
>>I have done lots of research on this error -8020 at the
>>sapdb.org site,
>>not even the message 7.2 / 7.3 doc has this error.
>>
>>http://www.sapdb.org/pdf/messages_72_73eng.pdf
>>
>>-8018: Index name must be unique
>>
>>-8021: Column must have DEFAULT specification
>>
>>Nothing between -8018 and -8021, so I don't really know if this is due
>>to my configuration or a problem with the SAPDB itself.
>>
>>
>>Could anyone out there point us to the right direction?
>>
>>I have created to different databases(instances), INST1 and
>>the default one TST,
>>nothing still getting the same error.
>>
>>Would you like to see the configuration files?
>>
>>Thanks,
>>
>>Alex Rodriguez
>>Senior Engineer
>>HPS CSC Americas - LAC
>>
>>
>>
>>--
>>MaxDB Discussion Mailing List
>>For list archives: http://lists.mysql.com/maxdb
>>To unsubscribe:
>>http://lists.mysql.com/[EMAIL PROTECTED]
>>
>>
>
>
>
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
