IT02488: DP SQL BACKUPS FAILING WITH CSQLAPI::GETSQLDATABASENAMES:8551: 1914 UNABLE TO GET LIST OF DATABASES

Download Information: Version 7.1.2 Tivoli Storage Manager for Databases
Download Information: Version 4.1.2 Tivoli Storage FlashCopy Manager

APAR status

• Closed as suggestion for future release.

Error description

• When using Tivoli Storage Manager for Databases: Data Protection
  for Microsoft SQL Server to perform query or backup operations,
  the operation may fail when attempting to obtain a list of SQL
  databases from the Microsoft SQL Server.
  
  To determine if you are affected by this APAR you can issue:
  
    tdpsqlc query sql * /tracefile=sqltrace.txt
  /traceflags=service
  If databases exist on the Microsoft SQL Server but no databases
  are returned from the query and you see the following in the
  output:
    CSqlApi::GetSqlDatabaseNames:8551:1914 unable to get list of
  databases
  and the service trace shows information similar to the following
  then you may be affected by this APAR:
  11/14/2013 18:13:02.722 [004860] [13812] : SqlApi.cpp
  (1009): SQLAPI-CSqlApi::GetSqlDatabaseNames >>>>> enter 18:13:02
  11/14/2013 18:13:02.771 [004860] [13812] : SqlApi.cpp
  (4357): SQLAPI-CSqlApi::LogonServer >>>>> enter 18:13:02
  11/14/2013 18:13:02.772 [004860] [13812] : SqlApi.cpp
  (4397): SQLAPI-CSqlApi::LogonServer gcnew SmoApplication()
  11/14/2013 18:13:02.801 [004860] [13812] : SqlApi.cpp
  (4410): SQLAPI-CSqlApi::LogonServer
  connectionInfoH->ServerInstance:'SQLDB'
  11/14/2013 18:13:02.801 [004860] [13812] : SqlApi.cpp
  (4451): SQLAPI-CSqlApi::LogonServer
  connectionInfoH->NetworkProtocol:'NetworkProtocol::NotSpecified'
  11/14/2013 18:13:02.801 [004860] [13812] : SqlApi.cpp
  (4458): SQLAPI-CSqlApi::LogonServer
  connectionInfoH->ConnectTimeout:'30'
  11/14/2013 18:13:02.802 [004860] [13812] : SqlApi.cpp
  (4464): SQLAPI-CSqlApi::LogonServer
  connectionInfoH->StatementTimeout = 0
  11/14/2013 18:13:02.802 [004860] [13812] : SqlApi.cpp
  (4476): SQLAPI-CSqlApi::LogonServer
  connectionInfoH->LoginSecure(true)
  11/14/2013 18:13:03.124 [004860] [13812] : SqlApi.cpp
  (4596): SQLAPI-CSqlApi::LogonServer SQL Server version string:
  9.00.5000.00
  11/14/2013 18:13:03.595 [004860] [13812] : SqlApi.cpp
  (4606): SQLAPI-CSqlApi::LogonServer OS version: 6.0 (6002)
  11/14/2013 18:13:04.436 [004860] [13812] : SqlApi.cpp
  (4616): SQLAPI-CSqlApi::LogonServer SQL Server edition:
  Enterprise Edition (64-bit)
  11/14/2013 18:13:04.439 [004860] [13812] : SqlApi.cpp
  (4651): SQLAPI-CSqlApi::LogonServer BEFORE
  upper-casing:szSqlServerName:SQLDB
  11/14/2013 18:13:04.439 [004860] [13812] : SqlApi.cpp
  (4654): SQLAPI-CSqlApi::LogonServer AFTER
  upper-casing:szSqlServerName:SQLDB
  11/14/2013 18:13:04.439 [004860] [13812] : SqlApi.cpp
  (4659): SQLAPI-CSqlApi::LogonServer HostName:SQLDB
  11/14/2013 18:13:04.439 [004860] [13812] : SqlApi.cpp
  (4679): SQLAPI-CSqlApi::LogonServer NetName:SQLDB
  11/14/2013 18:13:04.439 [004860] [13812] : SqlApi.cpp
  (4684): SQLAPI-CSqlApi::LogonServer bSqlIsClustered:false
  11/14/2013 18:13:04.439 [004860] [13812] : SqlApi.cpp
  (4713): SQLAPI-CSqlApi::LogonServer <<<<< exit rc(0):RC_OK
  18:13:04
  11/14/2013 18:13:04.456 [004860] [13812] : SqlApi.cpp
  (5885): SQLAPI-CSqlApi::GetDatabases >>>>> enter 18:13:04
  11/14/2013 18:13:04.456 [004860] [13812] : SqlApi.cpp
  (4357): SQLAPI-CSqlApi::LogonServer >>>>> enter 18:13:04
  11/14/2013 18:13:04.456 [004860] [13812] : SqlApi.cpp
  (4713): SQLAPI-CSqlApi::LogonServer <<<<< exit rc(0):RC_OK
  18:13:04
  11/14/2013 18:13:04.458 [004860] [13812] : SqlApi.cpp
  (6014): SQLAPI-CSqlApi::GetDatabases <<<<< exit rc(1914):( 1900
  + 14 ) 18:13:04
  11/14/2013 18:13:04.458 [004860] [13812] : errormsg.cpp        (
  199): Enter agentRcMessage(),
    agentRc : 1914
  11/14/2013 18:13:04.458 [004860] [13812] : errormsg.cpp        (
  345): Exit agentRcMessage(), msgNum = 5422
  11/14/2013 18:13:04.459 [004860] [13812] : SqlApi.cpp
  (1314): SQLAPI-CSqlApi::GetSqlDatabaseNames ACO5422E Received
  the following from the MS SQL server:
  CSqlApi::GetSqlDatabaseNames:6003:1914 unable to get list of
  databases
  This is an extremely rare situation.  If you believe that you
  are affected please contact service for information on an
  undocumented option that can be used to bypass the issue.
  Initial impact: Low
  Platforms affected: All supported platforms
  

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

• Tivoli Storage Manager for Databases: Data Protection for
  Microsoft SQL Server and Tivoli Storage FlashCopy Manager for
  Microsoft SQL Server are working as designed. This problem can
  not be reproduced and currently appears to affect a single
  customer environment. A workaround has been provided for the
  initial customer. If you encounter this problem, please
  contact IBM Support, and reference this APAR number, for
  additional assistance.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels