PI74124: ESTABLISH PSB FOR RUN UNIT POSTPROCESSING QUERY RETURNS MULTIPLE ROWS WHEN ONLY 1 ROW WAS EXPECTED

RAAz-6.1.0.13-Install-IMRepository
RAAz-6.1.0.13-Install
RAA-6.1.0.13-Install-IMRepository
RAA-6.1.0.13-Install
Rational Asset Analyzer Fix Pack 13 (6.1.0.13) for 6.1
Rational Asset Analyzer for System z Fix Pack 13 (6.1.0.13) for 6.1
Rational Asset Analyzer Fix Pack 14 (6.1.0.14) for 6.1
Rational Asset Analyzer for System z Fix Pack 14 (6.1.0.14) for 6.1
Rational Asset Analyzer Fix Pack 15 (6.1.0.15) for 6.1
Rational Asset Analyzer for System z Fix Pack 15 (6.1.0.15) for 6.1
Rational Asset Analyzer Fix Pack 16 (6.1.0.16) for 6.1
Rational Asset Analyzer for System z Fix Pack 16 (6.1.0.16) for 6.1
Rational Asset Analyzer for System z Fix Pack 17 (6.1.0.17) for 6.1
Rational Asset Analyzer Fix Pack 17 (6.1.0.17) for 6.1
Rational Asset Analyzer Fix Pack 18 (6.1.0.18) for 6.1
Rational Asset Analyzer for System z Fix Pack 18 (6.1.0.18) for 6.1
Rational Asset Analyzer Fix Pack 19 (6.1.0.19) for 6.1
Rational Asset Analyzer for System z Fix Pack 19 (6.1.0.19) for 6.1
Rational Asset Analyzer Fix Pack 20 (6.1.0.20) for 6.1
Rational Asset Analyzer for System z Fix Pack 20 (6.1.0.20) for 6.1
Rational Asset Analyzer for System z Fix Pack 21 (6.1.0.21) for 6.1
Rational Asset Analyzer Fix Pack 21 (6.1.0.21) for 6.1
Rational Asset Analyzer Fix Pack 22 (6.1.0.22) for 6.1
Rational Asset Analyzer for System z Fix Pack 22 (6.1.0.22) for 6.1
Rational Asset Analyzer for System z Fix Pack 23 (6.1.0.23) for 6.1
Rational Asset Analyzer Fix Pack 23 (6.1.0.23) for 6.1

APAR status

• Closed as program error.

Error description

• During queue type 15 (Establish PSB for run unit)
  postprocessing, messages similar to the following may appear:
  
  
  PostProcessor SEVERE: Query [SELECT
  run_unit_id FROM $(SCHEMA).dmh_run_unit_cntnt WHERE
  caller_cu_id = 0
  AND target_cu_id = ? (params=[1234567890])]
     was supposed to return 1 row, but returned [12] rows
  
  com.ibm.dmh.db.SQLRuntimeException:
          at
  com.ibm.dmh.db.DbResultSet.toSingleInt(DbResultSet.java:178)
          at
  com.ibm.dmh.model.DmhMetaComponentRunUnitCntnt.selectRunUnit
  (DmhMetaComponentRunUnitCntnt.java:66)
          at com.ibm.dmh.aqp.task.TaskAnalyzeControlTransfers_IMS.
  determinePSB(TaskAnalyzeControlTransfers_IMS.java:2537)
  

Local fix

• none known.
  

Problem summary

• During the IMS control transfer processing a
  SQLRuntimeException is thrown indicating that one row was
  expected, but multiple rows were returned.
  

Problem conclusion

• The IMS control transfer processing architecture assumed each
  IMS program would be used in one, and only one, run unit.  This
  is not true for sub-routines.  The architecture was modified to
  accommodate a program being used in more than one run unit.
  

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

• pp
  

Fix information

• Fixed component name

  RATL ASSET ANAL

• Fixed component ID

  5724V2700

Applicable component levels

• R610 PSY

     UP