PI14797: ORA-01400: CANNOT INSERT NULL ERROR MAY OCCUR WITH ODBC OR ORACLE ADAPTER WHEN USING CUSTOM PARTITIONED TYPE TREE

APAR status

• Closed as program error.

Error description

• An ORA-1400 error is generated when trying to insert data into a
  Oracle database table when using a custom partitioned type tree.
  
  The error message is:
  
  <14296-10988-02/28/14 11:18:47>:    Error in SQLExecute
  Message: [Oracle][ODBC][Ora]ORA-01400: cannot insert NULL into
  ("DBNAME"."TABLENAME"."FIELDNAME")
  
  SQL State: S1000
  

Local fix

• WTXCQ - WTX00044528
  PVB / PVB
  Circumvention: Use non-partitioned type tree
  

Problem summary

• Users Affected:
  WebSphere Transformation Extender DB Adapter users that are
  employing custom type trees that define different row type
  definitions under a partitioned type.
  
  Problem Description:
  The WTX DB adapter could not properly handle input type trees
  that included a partitioned type.
  
  Platforms Affected:
  Win32
  

Problem conclusion

• During the compilation of a partitioned input type tree, the
  metadata for the infix delimiter is retrieved from the first
  sub-component of the partitioned type.  Before this fix, the
  row's infix delimiter was never initialized because it was
  pointing to a partitioned type that does no define an infix
  delimiter.
  
  Applies to:
  8.3.0.6, 8.4.0.4, 8.4.1.1
  
  Fixed in the next service packs and releases.
  
  To obtain the fix for this APAR:
  
  To see if the next service pack or product release is available,
  check the WebSphere Transformation Extender Downloads page:
  http://www.ibm.com/support/entry/portal/product/other_software/t
  ransformation_extender
  
  If the service pack or product release is available, download it
  from PassportAdvantage:
  http://www.ibm.com/software/howtobuy/passportadvantage/pao_custo
  mers.htm
  
  If the service pack or product release is not available and you
  require the APAR fix immediately, request a Limited Availability
  Interim Fix (LAIF) by opening a PMR:
  https://www.ibm.com/support/servicerequest/Home.action
  

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

  WEBSPHERE LAUNC

• Fixed component ID

  5724M4003

Applicable component levels

• R830 PSY

     UP

• R840 PSY

     UP

• R841 PSY

     UP