JR35094: NETEZZA STAGE ABORTS WITH SOME ERROR MESSAGES.

APAR status

• Closed as program error.

Error description

• A job has Netezza stages aborts with various error messages.
  
  ERROR from Exec Direct: ERROR:  Cannot insert a duplicate key
  into unique index _I_OBJECT_NAME
  ERROR from ExecDirect: ERROR:  8 : Character width exceeded
  ERROR from ExecDirect: ERROR:   Relation
  'NZORCH_20091208192824168_0' already exists
  ERROR from ExecDirect: ERROR:   8 : Character width exceeded
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  IS 81 Netezza Stage
  ****************************************************************
  PROBLEM DESCRIPTION:
  NETEZZA STAGE ABORTS WITH SOME ERROR MESSAGES.
  ****************************************************************
  RECOMMENDATION:
  Patch delivered to the customer
  patch_JR35094_server_windows_8100.zip
  ****************************************************************
  

Problem conclusion

• ERROR from Exec Direct: ERROR: Cannot insert a duplicate key
  into unique index _I_OBJECT_NAME
  ERROR from ExecDirect: ERROR:  8 : Character width exceeded
  ERROR from ExecDirect: ERROR: Relation
  'NZORCH_20091208192824168_0' already exists
  
  when looked into the error (did not have necessary logs required
  to find out the exact root cause), it could be due not a very
  unique ET being created. So External Table name has been changed
  to append the whole PID with an underscore, so that its unique.
  

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

• R810 PSY

     UP