STATUS CODE: 12 "file open failed" occurs during a MS SQL or Oracle database agent backup.

STATUS CODE: 12 "file open failed" occurs during a MS SQL or Oracle database agent backup.

Article: 100016812
Last Published: 2013-10-24
Ratings: 2 2
Product(s): NetBackup

Problem

STATUS CODE: 12 "file open failed" occurs during a MS SQL or Oracle database agent backup.

Error Message

bpcd_remote_write: couldn't open remote file /usr/openv/netbackup/logs/mssql_backup_failures/012405.rpt on client , error = 2

Solution

Overview:  
This error is reported during adatabase agent backup failures on MS SQL or Oracle databases. The server couldnot write the backup failure report because the mssql_backup_failuresfolder is not available or not created in the master server or client underthe following path (UNIX): /usr/openv/netbackup/logs or(WINDOWS): <install_path>\netbackup\logs.

Troubleshooting:
Enablethe bprd log file on the master and the dbclient log on the clientsystem.

Log Files:
The bprd log on the master serverwill show:
<2> bpcd_remote_write: couldn'topen remote file /usr/openv/netbackup/logs/mssql_backup_failures/012405.rpt onclient <master_server_name>, error =2
<2> bpcd_remote_write: INF -bpcd_remote_write status =12
<2> process_request:bpcd_remote_write failed - status = file open failed (12)

The Progress log on the client willshow:
Batch = C:\ProgramFiles\VERITAS\NetBackup\DbExt\MsSql\SQL.bch, Op# =8.
INF - Using backup image'sql01.MSSQL7.SQL01.db.Test.~.7.001of001.20050119224654..C'.
INF- backup database "Test" to VIRTUAL_DEVICE='VNBU0-3184-3436' with blocksize =65536, maxtransfersize = 65536, buffercount =1
INF - #Stripes: 1, #Bufs per stripe1, To: NetBackup on GRSF2K16
INF -Created VDI object for SQL Server instance <*DEFAULT*>. Connection timeoutis <300> seconds.
22:46:59.779[3184.2896] <4> : 22:46:56 INF - Server status =12
ERR - <VxBSACreateObject>failed with error <3>. The textfollows:
   CONTINUATION:- System detected error, operation aborted.

The dbclientlog on the client will show:
<4>serverResponse: 22:46:56 INF - Server status =12
<16> serverResponse: ERR -server exited with status 12: file openfailed

Resolution:
Make sure that the folder mssql_backup_failures exists in the master server and client in thefollowing path:
Windows: <install_path>\netbackup\logs\mssql_backup_failures
UNIX: /usr/openv/netbackup/logs/mssql_backup_failures
Once this directory hasbeen created, run the database backup again.

Was this content helpful?