IT33695: MS SQL APPLICATION SERVER TEST IS SUCCESSFUL BUT INVENTORY DISCOVERY FAILS

APAR status

• Closed as program error.

Error description

• The MS SQL Application server can be added and tested
  successfully. When run the inventory discovery, it fails with
  "error [Unknown error]" message.
   
  Corresponding application
  log shows that the discovery failed because of SQL
  Statement;
  
  <Date Time> [0x00003054] DEBUG sqlvdiwrapper - CMD:
  [SELECT name, Groups.group_id, replica_server_name, case
  when(primary_replica  = replica_server_name) then  'PRIMARY'
  else case when (primary_replica is NULL) then 'UNKNOWN'  else
  'SECONDARY' end end as role, Replicas.replica_id FROM
  master.sys.availability_groups Groups INNER JOIN
  master.sys.availability_replicas Replicas ON Groups.group_id =
  Replicas.group_id INNER JOIN
  master.sys.dm_hadr_availability_group_states States ON
  Groups.group_id = States.group_id]
  <Date Time> [0x00003054]
  DEBUG sqlvdiwrapper - ExecSQLStatement: connection handle
  allocated
  <Date Time> [0x00003054]  INFO sqlvdiwrapper -
  getConnectionString: connecting to server (MSSQLSERVER)
  <Date
  Time> [0x00003054] DEBUG sqlvdiwrapper - connectString
  [DRIVER={SQL
  Server};SERVER=MSSQLSERVER;Trusted_Connection=Yes;]
  <Date Time>
  [0x00003054]  INFO sqlvdiwrapper - Fall back to use default SQL
  Server driver
  <Date Time> [0x00003054]  INFO sqlvdiwrapper -
  getConnectionString: connecting to server (MSSQLSERVER)
  <Date
  Time> [0x00003054] ERROR sqlvdiwrapper - ExecSQLStatement:
  SQLDriverConnect to [MSSQLSERVER] failed, error
  [[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does
  not exist or access denied.], return code (0)
  <Date Time>
  [0x00003054] ERROR sqlvdiwrapper - Failed to execute SQL
  command, error [ExecSQLStatement: SQLDriverConnect to
  [MSSQLSERVER] failed, error[[Microsoft][ODBC SQL Server
  Driver][DBNETLIB]SQL Server does not exist or access denied.],
  return code (0)]
  Version affected:10.1.*
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus level 10.1.5 and 10.1.6            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed IBM Spectrum Protect Plus level        *
  * 10.1.7. Note that this is subject to change at the           *
  * discretion of IBM.                                           *
  ****************************************************************
  

Problem conclusion

• Fixed a problem with finding the instance name of an
  availability group.
  

Temporary fix

Comments

APAR Information

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

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

Fix information

• Fixed component name

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels