IBM Support

PI53490: DMH0731 FAILS ON INSERT INTO DMH_ACTUAL_PARM TABLE

Fixes are available

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

Subscribe

You can track all active APARs for this component.

 

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 number

    PI53490

  • Reported component name

    RAA FOR SSTEM Z

  • Reported component ID

    5655W5700

  • Reported release

    610

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-12-02

  • Closed date

    2016-01-12

  • Last modified date

    2016-02-11

  • 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

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SS3JHP","label":"Rational Asset Analyzer"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.1","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
14 October 2021