APAR status
Closed as program error.
Error description
When a row with a decimal column is rejected during a BULK LOAD operation, the Oracle Connector fails with the error: Fatal Error: APT_Decimal::assignFromString: invalid format for the source string. Expecting decimal separator or digit got ' This APAR is similar to JR53337. However JR53337 was for a basic write reject link whereas this APAR is for BULK LOAD reject links. Both JR53337 and this APAR are regressions from APAR JR50944.
Local fix
Find and eliminate the rejected record.
Problem summary
When a row with a decimal column is rejected during a BULK LOAD operation, the Oracle Connector fails with the error: Fatal Error: APT_Decimal::assignFromString: invalid format for the source string. Expecting decimal separator or digit got ' This APAR is similar to JR53337. However JR53337 was for a basic write reject link whereas this APAR is for BULK LOAD reject links. Both JR53337 and this APAR are regressions from APAR JR50944.
Problem conclusion
In the load reject producer, when one of the columns that's not written is decimal, the value in will not be SQLT_PDN (see ocidfn.h). It'll be zero and requires special handling.
Temporary fix
Use INDATE or UPSERT instead of BULK LOAD.
Comments
APAR Information
APAR number
JR58122
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
B50
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-07-26
Closed date
2017-08-07
Last modified date
2017-08-07
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
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
RB50 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
07 August 2017