cancel
Showing results for 
Search instead for 
Did you mean: 

Restore failed with error - No object matched the specified predicate..

Wilhelm
Level 3

Good day

I successfully perform an SAP ASE database backup to Netbackup.  when I execute the restore command:

load database SA2 from "sybackup::SYBASE.SA2.T.0.15948.30-04-2015.10:22:13 -SERV MASTER_SERVER"

I receive the following:

Backup Server session id is: 21. 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::SYBASE.SA2.T.0.15948.30-04-2015.10:22:13 -SERV MASTER_SERVER::000'
Backup Server: 4.124.2.1: Archive API error for
device='sybackup::SYBASE.SA2.T.0.15948.30-04-2015.10:22:13 -SERV
03RNB-PRD-BCK01::000': Vendor application name='Veritas NetBackup for SYBASE,
Library version=760000, 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 'SA2', Line 1:
Error encountered by Backup Server.  Please refer to Backup Server messages for
details.

 

I have no idea what is causing this.  Any help would be appreciated.

 

Thanks

Wilhelm

 

1 ACCEPTED SOLUTION

Accepted Solutions

Nicolai
Moderator
Moderator
Partner    VIP   

Me neither - so I will rely on my Netbackup knowledge

ERR - BSAQueryObject() failed with error - No object matched the specified predicate

I think this mean Netbackup can't find the backup to restore.

For enhanced debugging create directory sybackup in /usr/openv/netbackup/logs. Ensure the directory has 777 permissions. Re-run operation and attach output from the debugging to a post as a file - do not bulk post debug data as it will be marked as spam.

There is help to find in Netbackup Sybase admin guide chapter 5 

http://www.symantec.com/docs/DOC6483

try a bplist run as root - you should see file being returned:

bplist -B -C host_name -t 7 -l -R  -s 01/01/2015  /

Make sure the client name is correct according to Netbackup - e.g.  srv1.acme.com and srv1 is two different server is in Netbackups mind.

 

View solution in original post

3 REPLIES 3

Nicolai
Moderator
Moderator
Partner    VIP   

Me neither - so I will rely on my Netbackup knowledge

ERR - BSAQueryObject() failed with error - No object matched the specified predicate

I think this mean Netbackup can't find the backup to restore.

For enhanced debugging create directory sybackup in /usr/openv/netbackup/logs. Ensure the directory has 777 permissions. Re-run operation and attach output from the debugging to a post as a file - do not bulk post debug data as it will be marked as spam.

There is help to find in Netbackup Sybase admin guide chapter 5 

http://www.symantec.com/docs/DOC6483

try a bplist run as root - you should see file being returned:

bplist -B -C host_name -t 7 -l -R  -s 01/01/2015  /

Make sure the client name is correct according to Netbackup - e.g.  srv1.acme.com and srv1 is two different server is in Netbackups mind.

 

View solution in original post

Dyneshia
Level 6
Employee

Also check to see if dbbackex.exe is crashing and confirm all capatilization matches in the batch file.  I have seen a case where the NBIMAGE entry was incorrect and did not match.

 

Example:

NBIMAGE "PXXSQL4V6.MSSQL7.PXXSQL4V61\VENDER.db.Core_MSCM.~.7.001of001.20130216231..C"

to

NBIMAGE "PXXSQL4V6.MSSQL7.PXXSQL4V6\vender.db.Core_MSCM.~.7.001of001.20130216231..C"

To confrim:

bplist -C PXXSQL4V6 -t 15 -R /

 

Nicolai
Moderator
Moderator
Partner    VIP   

-t 15 is for MS-SQL - This is Sybase