PI53490: DMH0731 FAILS ON INSERT INTO DMH_ACTUAL_PARM TABLE

Rational Asset Analyzer Fix Pack 9 (6.1.0.9) for 6.1
Rational Asset Analyzer Fix Pack 10 (6.1.0.10) for 6.1
Rational Asset Analyzer for System z Fix Pack 10 (6.1.0.10) for 6.1
Rational Asset Analyzer Fix Pack 11 (6.1.0.11) for 6.1
Rational Asset Analyzer for System z Fix Pack 11 (6.1.0.11) for 6.1
Rational Asset Analyzer Fix Pack 12 (6.1.0.12) for 6.1
Rational Asset Analyzer for System z Fix Pack 12 (6.1.0.12) for 6.1
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

• An error similar to the following may occur when postprocessing
  PL/I code:
  
  PostProcessor SEVERE: SQL exception on prepared statement
  [INSERT INTO $(SCHEMA).DMH_ACTUAL_PARM (comp_unit_id, xfer_id,
  xfer_seq, sequence, cmpnt_type_id, related_id) VALUES (?, ?, ?,
  ?, ?, ?)]/[INSERT INTO DMH1.DMH_ACTUAL_PARM (comp_unit_id,
  xfer_id, xfer_seq, sequence, cmpnt_type_id, related_id) VALUES
  (?, ?, ?, ?, ?, ?)], sqlTypes=[0,0,0,0,0,0],
  columnSizes=[0,0,0,0,0,0]
  Caused by: [jcc][t4][102][10040][4.18.74] Batch failure.  The
  batch was submitted, but at least one exception occurred on an
  individual member of the batch.
  Use getNextException() to retrieve the exceptions for specific
  batched elements. ERRORCODE=-4229, SQLSTATE=null
  Caused by: A NON-ATOMIC INSERT STATEMENT SUCCESSFULLY COMPLETED
  FOR SOME OF THE REQUESTED ROWS, POSSIBLY WITH WARNINGS, AND ONE
  OR MORE ERRORS
  

Local fix

• none known
  

Problem summary

• During import file processing, if 2 different call target have
  IDs with the same target name, when the output file is created
  they will be identical. Thus the import will fail because of
  duplication.
  

Problem conclusion

• Code was changed to differentiate between multiple similar
  calls.
  

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

• import
  

Fix information

• Fixed component name

  RAA FOR SSTEM Z

• Fixed component ID

  5655W5700

Applicable component levels

• R610 PSY

     UP