Sybase restore fails with: ERR - BSAQueryObject() failed with error - No object matched the specified predicate

Article:TECH160256

Created: 2011-05-18

Updated: 2011-07-27

Article URL http://www.symantec.com/docs/TECH160256

Article Type
Technical Solution

Product(s)

Show all

Languages

Show all

Problem

When attempting to restore a Sybase database backup with the NetBackup agent for Sybase, the following
error is received: - BSAQueryObject() failed with error - No object matched the specified predicate

Error

$ /usr/openv/netbackup/ext/db_ext/sybase/scripts/sybase_mydb_restore

/sybase15/bin/isql -Uxxxxxxxx -Pxxxxxxxx -I/sybase15/interfaces -SSYB123ABC
       < /usr/openv/netbackup/ext/db_ext/sybase/scripts/sybase_mydb_load
Backup Server session id is: 103. Use this value when executing the 'sp_volchanged'
   system stored procedure after fulfilling any volume change request from the Backup Server.
Backup Server: 4.132.1.1: Attempting to open byte stream device:
   'sybackup::SYB123ABC.datafilesXY.D.0.385132.13-03-2010.14:15:47::00'
Backup Server: 4.124.2.1: Archive API error for device=
   'sybackup::SYB123ABC.datafilesXY.D.0.385132.13-03-2010.14:15:47::00':
Vendor application name='Veritas NetBackup for SYBASE, Library version=700000,
API routine=syb_open(), Message= Restore failed - syb_open:
ERR - BSAQueryObject() failed with error - No object matched the specified predicate..
Please refer to sybackup log for more info.
Msg 8009, Level 16, State 1:
Server 'SYB123ABC', Line 1:
Error encountered by Backup Server. Please refer to Backup Server messages for details.
Database 'datafilesXY' is now online.
Finished Sat Mar 13 15:25:04 CST 2010
exit 0

Environment

NetBackup 7
Sybase 15

Cause

The time differential between the NetBackup Master server and the target Sybase client must
be no more than +/- 24 hours.

Solution

Correct the date and time on the target Sybase client.