APAR status
Closed as program error.
Error description
Netezza Enterprise stage job after loading all the rows into the target table, gets aborted when the table name contains the word error in it.
Local fix
Steps to recreate the problem: Create a RowGenerator ---> Netezza EE stage job Use nzload load method Use write/replace mode Provide table name which contains error word in it, example: TESTERROR Execute the job and notice that the data gets loaded and then the job aborts at the end
Problem summary
Netezza Enterprise stage write jobs abort with nzload load method when table name contains the word ERROR in it, even though the data is fully inserted into the target table.
Problem conclusion
Code has been corrected not to throw false error messages and not to abort for the same.
Temporary fix
Create an alias to the problematic table without the word ERROR in it and use it in the load job.
Comments
APAR Information
APAR number
JR43353
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
810
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-07-06
Closed date
2012-07-19
Last modified date
2012-07-19
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
R752 PSY
UP
R753 PSY
UP
R801 PSY
UP
R810 PSY
UP
R850 PSY
UP
R870 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":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
19 July 2012