JR60598: NETEZZA CONNECTOR USING EXISTING TWT REPORTS ERROR: EXTERNAL TABLE: COUNT OF BAD INPUT ROWS REACHED MAXERRORS LIMIT

Download the mod pack for IBM InfoSphere Information Server 11.7.1.0 In-Place Upgrade

APAR status

• Closed as program error.

Error description

• DataStage job with Netezza connector configured to use existing
  TWT aborts with error:
  ERROR: External Table : count of bad input rows reached
  maxerrors limit (CC_NZCommon::checkThreadStatusThrow, file
  CC_NZCommon.cpp, line 382)
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Netezza connector users attempting to use TWT functionality with
  predefined temporary table.
  ****************************************************************
  PROBLEM DESCRIPTION:
  Netezza connector is vulnerable to varying order of columns in
  predefined temporary working table.
  ****************************************************************
  RECOMMENDATION:
  Install APAR JR60598 patch.
  ****************************************************************
  

Problem conclusion

• Netezza connector is invulnerable to the order of columns in
  predefined temporary working table.
  

Temporary fix

Comments

APAR Information

• 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

• R910 PSY

     UP

• R912 PSY

     UP

• RB50 PSY

     UP

• RB70 PSY

     UP