APAR status
Closed as fixed if next.
Error description
In the case of bad data such as a BIGINT value being loaded into an INT column LOAD is failing with following error An I O error reason BSL-0-5d19ee6f6 Commit failed. No Valid rows loaded Examination of the Map Reduce job log shows a FATAL error, ArrayIndexOutOfBoundsException, instead of logging a rejected record and continuing.
Local fix
Change int field to bigint
Problem summary
Please see problem description.
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH04334
Reported component name
IBM BIG SQL
Reported component ID
5737E7400
Reported release
503
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-10-19
Closed date
2020-09-09
Last modified date
2020-09-09
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
R503 PSY
UP
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCRJT","label":"IBM Big SQL"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"503"}]
Document Information
Modified date:
17 September 2021