IC89520: MYFILEGATEWAY EVENT DETAILS DOES NOT DISPLAY.

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • SI 5020401, Oracle 11.2.0.2
    
    All non-admin SI users cannot view Event Details in
    myFilegateway when using the Arrived File to display the "Event
    name" and "Value" pair columns. The window only shows "Loading
    data..." and does not actually display the values.
    
    We are missing a keyword 'ON' for the query,
    fetchOrgKeysForAFEvent: SELECT A.PROD_ORG_KEY, R.CONS_ORG_KEY
    FROM
    FG_ARRIVEDFILE A JOIN FG_ROUTE R JOIN FG_EVENT E ON
    E.ARRIVEDFILE_KEY =
    A.ARRIVEDFILE_KEY  AND A.ARRIVEDFILE_KEY = R.ARRIVEDFILE_KEY
    WHERE E.
    EVENT_KEY = ? AND E.ENTITY_TYPE = 'ARRIVED_FILE'
    
    Also need to trim the value of a fixed length column
    PROD_ORG_KEY.
    

Local fix

  • STRRTC: 362459
    DN/JG
    
    Circumvention: None
    

Problem summary

  • Users Affected:
    Users of Filegateway that make myFilegateway available to
    partners, and using the oracle 11g database.
    
    Problem Description:
    Ordinary partners with access to myFilegateway can not view
    details about their routing events.  When they attempt to view
    the event details, the popup indicates that it is loading
    details - and never does anything after that.
    
    Platforms Affected:
    All using Oracle database
    

Problem conclusion

  • Resolution Summary:
    Changed SQL query that was technically incorrect (though it did
    work on other db platforms).  Also needed to make sure to trim
    spaces from values returned by the above query.
    
    Delivered In:
    5.2.4.3
    

Temporary fix

  • APARNOPUB
    

Comments

APAR Information

  • APAR number

    IC89520

  • Reported component name

    STR FILE GATEWA

  • Reported component ID

    5725D0700

  • Reported release

    224

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-01-14

  • Closed date

    2013-01-18

  • Last modified date

    2013-01-18

  • 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

    STR FILE GATEWA

  • Fixed component ID

    5725D0700

Applicable component levels

  • R224 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

Sterling File Gateway

Software version:

2.2

Reference #:

IC89520

Modified date:

2013-01-18

Translate my page

Machine Translation

Content navigation