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 ID:100017053
  • Last Published:
  • Product(s):NetBackup

Problem

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

Solution

Bug ID: ET176788

Symptom: SQL backup jobs 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 error messages:

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] Data source name not found and no default driver specified>
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. ODBC return code <-1>, SQL State <08001>, Message Text <[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.>
12:54:00 [2276,2404] <16> CODBCaccess::LogODBCerr: DBMS MSG - <[Microsoft][ODBC SQL 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) - Batch file parameter. Number of operations to start up simultaneously. Applies to all of the operations in the batch file. Must appear before the end of the first operation. Range is 1-10.

Example:
BATCHSIZE 2
OPERATION BACKUP
DATABASE BUSINESS
SQLHOST "BOB"
NBSERVER "FRED"
ENDOPER TRUE

Workaround:
Decrease the value of the "BATCHSIZE" keyword until the problem no longer exists, or remove it completely from the batch file

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

Fix:
This issue is resolved in VERITAS NetBackup Maintenance Pack (MP)/ Feature Pack (FP7.) To download this feature pack, refer to the TechFiles in the Related Documents section below



Was this content helpful?