Sef
VIP Member
Here's one for the nuts and bolts experts......
Depending on where the Business Function B9800100, Get Audit Info, is called from it returns either the Enterprise server name or the web server name. When called from an interactive application the enterprise server name is returned, however when called from within a business function the web server name is returned.
This normally does not cause a problem, however we have noticed in Ship confirmation (with transaction processing) there is an issue.
Due to transaction processing, records are inserted into F41021WF based on (amongst others) Jobnumber and workstation ID. The ‘insert’ and subsequent ‘select’ and ‘update’ SQLs all use the webserver name as part of the key.
At the end of the ship confirmation within the ER on P4205 another cache check is made in F41021WF. However since this is called from within an application and since it passes the workstation ID which is now the enterprise server, the cache call fails and a new record is inserted into F41021WF. At the very end of the process this record is correctly deleted, however the original entry (with the webserver name as part of its key) remains in the file.
• Has somebody seen this issue (maybe in a different application with transaction processing)?
• Is my initial statement wrt B9800100 correct?
• Is it possible ‘to force’ B9800100 to always return the webserver name?
• Has somebody encountered a SAR/ESU for this issue (our communication with Oracle on this issue has been difficult and the issue could not be reproduced!?).
We are currently on 8.11, Oracle 10g, Websphere 5.0.2, Tools release 8.95 H1. We have taken pretty much every ESU until the end of last year, but very few ESUs since.
Depending on where the Business Function B9800100, Get Audit Info, is called from it returns either the Enterprise server name or the web server name. When called from an interactive application the enterprise server name is returned, however when called from within a business function the web server name is returned.
This normally does not cause a problem, however we have noticed in Ship confirmation (with transaction processing) there is an issue.
Due to transaction processing, records are inserted into F41021WF based on (amongst others) Jobnumber and workstation ID. The ‘insert’ and subsequent ‘select’ and ‘update’ SQLs all use the webserver name as part of the key.
At the end of the ship confirmation within the ER on P4205 another cache check is made in F41021WF. However since this is called from within an application and since it passes the workstation ID which is now the enterprise server, the cache call fails and a new record is inserted into F41021WF. At the very end of the process this record is correctly deleted, however the original entry (with the webserver name as part of its key) remains in the file.
• Has somebody seen this issue (maybe in a different application with transaction processing)?
• Is my initial statement wrt B9800100 correct?
• Is it possible ‘to force’ B9800100 to always return the webserver name?
• Has somebody encountered a SAR/ESU for this issue (our communication with Oracle on this issue has been difficult and the issue could not be reproduced!?).
We are currently on 8.11, Oracle 10g, Websphere 5.0.2, Tools release 8.95 H1. We have taken pretty much every ESU until the end of last year, but very few ESUs since.
