APAR status
Closed as program error.
Error description
When using WebSphere MQ File Transfer Edition v7 to do a fteAnt transfer with preaction or postaction, the database logger is issuing the following error: BFGDB0003E: A problem occurred with the database. The database driver reported the following details: SQL State ■42000, Error Code ■1722, Message ■ORA-01722: invalid number . Without preaction or postaction specified for the transfer the databaselogger does not have a problem. ADDITIONAL KEYWORDS: WMQ FTE fteStartDatabaseLogger pre post transfer_event ID mismatch format numeric hexadecimal stored in a char(48) column SQL query logs
Local fix
Problem summary
When a pre or post transfer call is used with the <call> element in an fteAnt script a hexadecimal transfer ID and a numeric event ID is passed back. The database logger was using the event ID instead of the transfer ID USERS AFFECTED: Those using database logger and pre/post transfer calls PLATFORMS AFFECTED: All supported
Problem conclusion
CONCLUSION: The code was altered to use the hexadecimal transfer ID rather than the numeric event ID. Any messages sent to the reject queue because of this error can now be resubmitted to the database. Instructions on how to do this can be found on the following page in the Information Centre: ttp://publib.boulder.ibm.com/infocenter/wmqfte/v7r0/topic/com.ib m.wmqfte.admin.doc/dl_errors.htm
Temporary fix
An iFix is available on request
Comments
APAR Information
APAR number
IC69465
Reported component name
WMQ FILE TRANSF
Reported component ID
5724R1000
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-06-25
Closed date
2010-07-02
Last modified date
2010-07-02
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
R702 PSY
UP
R700 PSN
UP
R701 PSN
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","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
02 July 2010