IBM Support

IC79652: DATABASE LOGGER LOGS MESSAGE TO REJECT QUEUE AFTER MONITOR DELETION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The IBM WebSphere MQ File Transfer Edition Database Logger logs
    a failure message to its reject queue after a monitor was
    deleted. The failure message takes the form of:
    
      <WMQFTE_ReasonForRejection dt="string">
        BFGDB0003E: A problem occurred with the database. The
    database driver
        reported the following details: SQL State [23502], Error
    Code [-407],
        Message [DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502,
    SQLERRMC=TBSPACEID=2,
        TABLEID=49, COLNO=0, DRIVER=3.62.56]
      </WMQFTE_ReasonForRejection>
    

Local fix

Problem summary

  • After a monitor was deleted, the database logger may queue an
    audit message to the reject queue if it encounters an audit
    message for a directory monitor which has been deleted.
    
    USERS AFFECTED:
    Users of the database logger
    
    PLATFORMS AFFECTED:
    All
    

Problem conclusion

  • The code has been altered to ensure that the database logger can
    correctly process audit messages relating to directory monitors
    which have already been deleted.
    
    The fix for this APAR is currently targeted for inclusion in
    fix pack 7.0.4.1.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC79652

  • Reported component name

    WMQ FILE TRANSF

  • Reported component ID

    5724R1000

  • Reported release

    704

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-11-07

  • Closed date

    2011-12-13

  • Last modified date

    2011-12-13

  • 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

    WMQ FILE TRANSF

  • Fixed component ID

    5724R1000

Applicable component levels

  • R704 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEP7X","label":"WebSphere MQ File Transfer Edition"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0.4","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
13 December 2011