BUG REPORT: SQL Agent backups using keyword "BATCHSIZE" fail to connect with SQL Server.

BUG REPORT: SQL Agent backups using keyword "BATCHSIZE" fail to connect with SQL Server.

Article: 100017053
Modified: 2013-10-23
Ratings: 0 0
Product(s): NetBackup

Problem

BUG REPORT: SQL Agent backups using keyword "BATCHSIZE" fail to connect with SQL Server.

Solution

Bug ID: ET176788

Symptom: SQL backupjobs using the batch file keyword "BATCHSIZE" do not connect to the SQL server,and the backups fail.  

Client Log Files:  The dbclient log file reports one of the following errormessages:

2:53:45 [2276,2476] <16>CODBCaccess::LogODBCerr: DBMS MSG - ODBC message. ODBC return code <-1>,SQL State <IM002>, Message Text <[Microsoft][ODBC Driver Manager] Datasource name not found and no default driverspecified>
12:53:45 [2276,2476]<16> Dbbackrec::PerformNBOperation: USER - Unable to login into ODBC DSN<NBMSSQL_2276_2100> as user<sa>

or

12:54:00[2276,2404] <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC message. ODBCreturn code <-1>, SQL State <08001>, Message Text<[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist oraccess denied.>
12:54:00[2276,2404] <16> CODBCaccess::LogODBCerr: DBMS MSG - <[Microsoft][ODBCSQL Server Driver][DBNETLIB]ConnectionOpen(Connect()).>
12:54:00 [2276,2404]<16> CDBbackcat::LoginODBC: USER - Unable to login into ODBC DSN<NBMSSQL_2276_2100> as user<sa>

Definition:
BATCHSIZE (Integer) - Batchfile parameter. Number of operations to start up simultaneously. Applies to allof the operations in the batch file. Must appear before the end of the firstoperation. Range is 1-10.

Example:
BATCHSIZE 2
OPERATIONBACKUP
DATABASE BUSINESS
SQLHOST "BOB"
NBSERVER "FRED"
ENDOPERTRUE

Workaround:
Decrease the value of the "BATCHSIZE" keyworduntil the problem no longer exists, or remove it completely from the batchfile

Additionally, use of the $ALL value in the batch file hassometimes assisted in resolving this issue.  

Fix:
This issue isresolved in VERITAS NetBackup Maintenance Pack (MP)/ Feature Pack (FP7.) Todownload this feature pack, refer to the TechFiles in the Related Documentssection below



Was this content helpful?