IT18284: UNABLE TO DELETE STORAGE RESOURCE AGENT FROM WEB UI DUE TO MULTIPLE NETAPP ENTRIES IN DATABASE.

IBM Spectrum Control V5.2.13 (March 2017)
IBM Spectrum Control V5.2.14 (May 2017)
IBM Spectrum Control V5.2.15 (August 2017)
IBM Spectrum Control V5.2.15.2 (November 2017)
IBM Spectrum Control V5.2.16 (March 2018)
IBM Spectrum Control V5.2.17 (May 2018)

APAR status

• Closed as program error.

Error description

• Two entries in the T_RES_DEVICE_PERSONALITY for the same NetApp
  system.
  The NetApp system was originally managed by the SRA that cannot
  be deleted from the target_host_dns.
  After the upgrade the same NetApp system was added as a block
  device using a CIM agent.
  Consequently two entries in the T_RES_DEVICE_PERSONALITY table.
  The Storage Resource Agent delete code fails whe trying to
  update the T_RES_DEVICE_PERSONALITY table
  because the update to disassociate the SRA with the NetApp would
  create a database integrity issue.
  
  server_0000xx.log
  
  2016-11-21 14:17:57.829-0500 NAD0056E: Error uninstalling agent
  at target_host_dns:install_location.
  
  serviceTrace.log
  
  Caused by:
  com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException:
  DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505,
  SQLERRMC=2;TPC.T_RES_DEVICE_PERSONALITY, DRIVER=3.65.77
  
  
  RECREATE STEPS:  Attempt to remove Storage Resource Agent from
  IBM Spectrum Control WEB UI
  
  ________________________________________________________________
  The defect is against component:  Storage Resource Agent
  SC Server/Manager build/release:  5.2.12
  SC Server OS:   Windows
  ________________________________________________________________
  Problem as described by customer: Storage Resource Agent fails
  to deletion from Spectrum Control WEB UI
  Initial customer impact (low/med/high):  low
  

Local fix

• Contact Support
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Control 5.2.8, 52.9, 5.2.10, 5.2.11 and 5.2.12  *
  * users upgrading a pre-5.2.8 installation with NetApp devices *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Unable to delete a storrage resource agent that was          *
  * previously the data source for a NetApp device               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fix maintenance when available                         *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is targeted for the following maintenance
  package:
  
  | refresh pack | 5.2-TIV-TPC-RP0013 - target March 2017
  
  Fixed in IBM Spectrum Control 5.2.13
  
  http://www.ibm.com/support/docview.wss?&uid=swg21320822
  
  The target dates for future refresh packs do not represent a
  formal commitment by IBM. The dates are subject to change
  without notice.
  

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:

Modules/Macros

• Data
  

Fix information

• Fixed component name

  TPC ADVANCED

• Fixed component ID

  5608TPCA0

Applicable component levels