IBM Support

JR43353: NETEZZA ENTERPRISE STAGE ABORTS WITH NZLOAD METHOD WHEN TABLE NAME CONTAINS ERROR WORD

Subscribe

You can track all active APARs for this component.

 

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