Cannot reconfigure devices. SQL query returned syntax error or access violation

Cannot reconfigure devices. SQL query returned syntax error or access violation

Article: 100026843
Last Published: 2019-04-30
Ratings: 0 1
Product(s): NetBackup

Problem

Trying to reconfigure tape devices through the Device Configuration wizard the following pop-up
error prevents the wizard from progressing:

SQL query returned syntax error or access violation.  The EMM server failed to process the request

Error Message

In addition to the above message, the nbemm log (OID = 111) shows:
   [DbConnection::Fetch] SQL - retval=EMM_ERROR_SQLNoDataFound(2007031) retdal=100 native=<0> sqlerror=<> sqlstate=<>
   [ConnectionManager::ReleaseMSRConnection] LastErrorCode 2007031, bDbUp true

Cause

In this environment, one out of two tape libraries had been consistently providing problems.
At this time one out of the two tape drives in that library was DOWN and disabled.

 

 

Solution

The SAN zoning was altered to exclude the troublesome library unit and the Device Configuration progressed without further issue.

 

Was this content helpful?