JR60235: Buildindex failed on SQLException: Invalid column type

APAR status

• Closed as program error.

Error description

• Full buildindex failed on SQLException: Invalid column type:
  
  1)
  The error is:
  com.ibm.commerce.foundation.internal.common.exception.Foundation
  ApplicationException: An error has occurred. If this problem
  persists, contact product support.
  com.ibm.commerce.foundation.dataimport.commands.DataImportCmdImp
  l.handleCatalogEntryIndex(DataImportCmdImpl.java:650)\n\tat
  .
  .
  .
  Caused by: java.sql.SQLException: Invalid column type\n\tat
  oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(Ora
  clePreparedStatement.java:8488)\n\tat
  oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(Ora
  clePreparedStatement.java:7995)\n\tat
  oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(Ora
  clePreparedStatement.java:8735)\n\tat
  oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePrepa
  redStatement.java:8714)\n\tat
  oracle.jdbc.driver.OraclePreparedStatementWrapper.setObject(Orac
  lePreparedStatementWrapper.java:219)\n\tat
  com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.setObject(WSJd
  bcPreparedStatement.java:2568)\n\tat
  com.ibm.commerce.foundation.dataimport.preprocess.CatalogHierarc
  hyDataPreProcessor.handleInsert(CatalogHierarchyDataPreProcessor
  .java:1554)\n\tat
  
  2) "Invalid column type" is generic , doesn't point out which
  column has problem
  

Local fix

Problem summary

• USERS AFFECTED:
  8.0.4.18, 9.0.0.6, 9.0.0.7, 9.0.0.8, 9.0.0.9, 9.0.1.0
  
  PROBLEM ABSTRACT:
  Buildindex failed on SQLException: Invalid column type
  
  BUSINESS IMPACT:
  Customers on V8 DB2 10.5 and lower, Oracle. V9 on Oracle
  couldn't build index successfully.
  
  RECOMMENDATION:
  

Problem conclusion

• 1. Avoid using setObject() and setString() JDBC calls on the
  same column in one session.
  2. Using String instead of StringBuffer at the 2nd parameter of
  setObject() call.
  3. Copy executeBatch() code fragment from V9 to V8
  

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

  WC BUS EDITION

• Fixed component ID

  5724I3800

Applicable component levels

• R900 PSY

     UP