JR58442: Cannot sync expected inventory from external system after applying JR57166

APAR status

• Closed as program error.

Error description

• Expected inventory is not synchronized with external system and
  you might encounter the following error:
  
  CommerceSrvr  E com.ibm.commerce.command.ECCommandTarget
  executeCommand CMN0420E: The following command exception has
  occurred
  during processing: "java.lang.ClassCastException:
  java.math.BigDecimal incompatible with java.lang.Integer".
  java.lang.ClassCastException: java.math.BigDecimal incompatible
  with java.lang.Integer
      at
  com.ibm.commerce.inventory.commands.MakeReceiptAvailableCmdImpl.
  performExecute(MakeReceiptAvailableCmdImpl.java:363)
  
  JR57166 introduced a new logic where queries to the rcptavail
  table were changed from
  'SELECT MAX(precedence), MIN(precedence) FROM rcptavail'
  to
  'SELECT MAX(precedence), MIN(precedence) FROM rcptavail WHERE
  distarrang_id = ?'
  
  
  This causes an error on Oracle databases because when using
  Oracle scripts to create the table, the id is defined as INTEGER
   but the query is expecting BigDecimal.
  

Local fix

Problem summary

• USERS AFFECTED:
  WebSphere Commerce Version 7 and Version 8.
  
  PROBLEM ABSTRACT:
  Cannot sync expected inventory from external system after
  applying JR57166
  
  BUSINESS IMPACT:
  Fails to sync expected inventory from external system.
  
  RECOMMENDATION:
  

Problem conclusion

• Handle the Oracle query result as BigDecimal instead of Integer.
  

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

• R700 PSY

     UP