JR61812: CREATING A CDC NETEZZA INSTANCE USING AN ADMIN SCHEMA RETURNS ERROR NULL POINTER EXCEPTION (NPE)

APAR status

• Closed as program error.

Error description

• If you attempt to create a CDC instance in a Netezza database
  with an ADMIN schema, you will get a Null Pointer Exception
  (NPE). The stack trace of the NPE is:
  
  com.datamirror.ts.jdbcage
  nt.messagehandler.generated.MsgTsjavaToolsHandler
  handleMessage() ?java.lang.NullPointerException | at com.datamir
  ror.ts.metadata.MetadataManager.tableExists(MetadataManager.java
  :2150)| at com.datamirror.ts.metadata.MetadataManager.validateNe
  tezzaMetadataSchema(MetadataManager.java:4536)| at com.datamirro
  r.ts.metadata.MetadataManager.setNewCustomerDatabase(MetadataMan
  ager.java:2605)| at com.datamirror.ts.jdbcagent.message.custom.M
  sgSetConfigInfo$Handler.setNewCustomerDatabase(MsgSetConfigInfo.
  java:1392)| at com.datamirror.ts.jdbcagent.message.custom.MsgSet
  ConfigInfo$Handler.handleRequest(MsgSetConfigInfo.java:782)| at
  com.datamirror.ts.jdbcagent.messagehandler.generated.MsgTsjavaTo
  olsHandler.handleMessage(MsgTsjavaToolsHandler.java:83)| at com.
  datamirror.ts.jdbcagent.main.MessageReader.runThread(MessageRead
  er.java:140)| at
  com.datamirror.ts.util.TsThread.run(TsThread.java:130)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue affects clients using IDR 11.4.0.1-5123 through   *
  * 11.4.0.2-5512 for Netezza.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * If you attempt to create a CDC instance in a Netezza         *
  * database with an ADMIN schema, you will get a Null Pointer   *
  * Exception (NPE).                                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDR LUW 11.4.0.2-5521 or newer for Netezza.       *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR LUW 11.4.0.2-5521 or newer for Netezza resolves
  the issue.
  

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

  IS CDC JAVA ENG

• Fixed component ID

  5725E30JE

Applicable component levels

• RB40 PSY

     UP