Closed as program error.
SI 5020401, Oracle 22.214.171.124 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.
STRRTC: 362459 DN/JG Circumvention: None
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
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: 126.96.36.199 and 5020500
Reported component name
STR FILE GATEWA
Reported component ID
Last modified date
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fixed component name
STR FILE GATEWA
Fixed component ID
Applicable component levels