IC83857: SQL ERROR SQL0811N WHEN USING TPC VIEW TPC_GROUP2ENTITY.

Fix Pack 5.1.1.0 (December 2012) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.2 (September 2013) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.5 (July 2014) for Tivoli Storage Productivity Center
4.2.2 Fix Pack 7 (July 2014) for Tivoli Storage Productivity Center
4.2.2 Interim Fix 2 (December 2012) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.6 (March 2015) for Tivoli Storage Productivity Center
4.2.2 Fix Pack 8 (March 2015) for Tivoli Storage Productivity Center
4.2.2 Fix Pack 9 (May 2015) for Tivoli Storage Productivity Center
4.2.2 Fix Pack 10 (August 2015) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.9 (October 2015) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.12 (October 2016) for Tivoli Storage Productivity Center
4.2.2 Fix Pack 3 (October 2012) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.13 (February 2017) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.14 (June 2017) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.15 (Sept 2017) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.8 (July 2015) for Tivoli Storage Productivity Center

APAR status

• Closed as program error.

Error description

• Using the TPC Exposed Views TPC_GROUP2ENTITY results in this SQL
  error:
  SQL0811N  The result of a scalar fullselect, SELECT INTO
  statement, or VALUES INTO statement is more than one row.
  SQLSTATE=21000
  
  RECREATE STEPS:
  Use the TPC_GROUP2ENTITY view in an SQL statement.
  Difficult to recreate,  does not happen in all environments.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: TPC 4.2.x users using the exposed views.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: See ERROR DESCRIPTION.                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  -
  

Problem conclusion

• Corrected the query for the TPCREPORT.GET_ENTITY_NAME
  function.  The fix for this APAR is targeted for the following
  maintenance package:
  
  | fix pack | 4.2.2-TIV-TPC-FP0003 - target October 2012
  
  http://www-01.ibm.com/support/docview.wss?&uid=swg21320822
  
  The target dates for future fix 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:

Fix information

• Fixed component name

  TPC FOR DATA

• Fixed component ID

  5608TC300

Applicable component levels

• R42A PSY

     UP

• R42L PSY

     UP

• R42W PSY

     UP