JR46050: CMVC 227967 - RESOLVE THE DATALOAD ATP INVENTORY DATA NOT POPULATING THE ITEMFFMCTR TABLE.

7.0.0-WS-WCServer-FP009
WebSphere Commerce Version 7.0.0.8 Fix Pack
WebSphere Commerce Version 7.0.0.9 Fix Pack

APAR status

• Closed as program error.

Error description

• The ITEMFFMCTR table is not populated during the ATP inventory
  dataloading. Looking at the wc-data-load.log, the following
  lines will be seen:
  
  Mar 11, 2013 4:54:53 AM
  com.ibm.commerce.foundation.dataload.database.DBPreparedStatemen
  t logQuery
  FINE: Execute statement : select ITEMSPC_ID, STORE_ID,
  FFMCENTER_ID from ITEMFFMCTR where ITEMSPC_ID=? and STORE_ID=?
  and FFMCENTER_ID=?[10257701,10151,11052]
  Mar 11, 2013 4:54:53 AM
  com.ibm.commerce.foundation.dataload.idresolve.IDResolverForOneT
  able checkIdFromDB
  FINER: RETURN
  Mar 11, 2013 4:54:53 AM
  com.ibm.commerce.foundation.dataload.idresolve.IDResolverForOneT
  able addToPrimaryKeyMap
  FINER: ENTRY 10257701|10151|11052
  Mar 11, 2013 4:54:53 AM
  com.ibm.commerce.foundation.dataload.idresolve.IDResolverForOneT
  able addToPrimaryKeyMap
  FINER: RETURN [Ljava.lang.Object;@78387838
  Mar 11, 2013 4:54:53 AM
  com.ibm.commerce.foundation.dataload.idresolve.IDResolverForOneT
  able checkId
  FINER: RETURN false
  Mar 11, 2013 4:54:53 AM
  com.ibm.commerce.foundation.dataload.businessobjectmediator.Abst
  ractBusinessObjectMediator checkId
  FINER: RETURN false
  Mar 11, 2013 4:54:53 AM
  com.ibm.commerce.foundation.dataload.businessobjectmediator.Abst
  ractBusinessObjectMediator createTableDataObjectWithPrimary
  FINER: ENTRY ITEMFFMCTR {FFMCENTER_ID=11052, STORE_ID=10151,
  ITEMSPC_ID=10257701}
  Mar 11, 2013 4:54:53 AM
  com.ibm.commerce.foundation.dataload.businessobjectmediator.Abst
  ractBusinessObjectMediator createTableDataObject
  FINER: ENTRY ITEMFFMCTR
  Mar 11, 2013 4:54:53 AM
  com.ibm.commerce.foundation.dataload.businessobjectmediator.Abst
  ractBusinessObjectMediator createTableDataObject
  FINER: The physical table object for table ITEMFFMCTR was added
  to the list of physical objects.
  Mar 11, 2013 4:54:53 AM
  com.ibm.commerce.foundation.dataload.businessobjectmediator.Abst
  ractBusinessObjectMediator createTableDataObject
  FINER: RETURN ITEMFFMCTR, null,Operation mode:  .
  Mar 11, 2013 4:54:53 AM
  com.ibm.commerce.foundation.dataload.object.TableDataObject
  addMultipleColumnData
  FINER: ENTRY {FFMCENTER_ID=11052, STORE_ID=10151,
  ITEMSPC_ID=10257701}
  Mar 11, 2013 4:54:53 AM
  com.ibm.commerce.foundation.dataload.object.TableDataObject
  addMultipleColumnData
  FINER: RETURN {FFMCENTER_ID=11052, STORE_ID=10151,
  ITEMSPC_ID=10257701}
  Mar 11, 2013 4:54:53 AM
  com.ibm.commerce.foundation.dataload.businessobjectmediator.Abst
  ractBusinessObjectMediator checkId
  FINER: ENTRY ITEMFFMCTR {FFMCENTER_ID=11052, STORE_ID=10151,
  ITEMSPC_ID=10257701}
  Mar 11, 2013 4:54:53 AM
  com.ibm.commerce.foundation.dataload.database.DBMetaDataManager
  getTableMetaData
  FINER: ENTRY ITEMFFMCTR
  Mar 11, 2013 4:54:53 AM
  com.ibm.commerce.foundation.dataload.database.DBMetaDataManager
  getTableMetaData
  FINER: RETURN
  com.ibm.commerce.foundation.dataload.database.TableMetaData@1d0c
  1d0c
  Mar 11, 2013 4:54:53 AM
  com.ibm.commerce.foundation.dataload.businessobjectmediator.Abst
  ractBusinessObjectMediator checkId
  FINER: Retrieved table meta data:
  com.ibm.commerce.foundation.dataload.database.TableMetaData@1d0c
  1d0c for table: ITEMFFMCTR
  Mar 11, 2013 4:54:53 AM
  com.ibm.commerce.foundation.dataload.businessobjectmediator.Abst
  ractBusinessObjectMediator checkId
  FINER: Table primary or unique-index keys: [ITEMSPC_ID,
  STORE_ID, FFMCENTER_ID] for table: ITEMFFMCTR
  Mar 11, 2013 4:54:53 AM
  com.ibm.commerce.foundation.dataload.idresolve.IDResolverForOneT
  able checkId
  FINER: ENTRY
  Mar 11, 2013 4:54:53 AM
  com.ibm.commerce.foundation.dataload.idresolve.IDResolverForOneT
  able tryToLoadPrimaryKeyMap
  FINER: ENTRY
  Mar 11, 2013 4:54:53 AM
  com.ibm.commerce.foundation.dataload.idresolve.IDResolverForOneT
  able tryToLoadPrimaryKeyMap
  FINER: RETURN 2
  Mar 11, 2013 4:54:53 AM
  com.ibm.commerce.foundation.dataload.idresolve.IDResolverForOneT
  able checkId
  FINER: RETURN true
  Mar 11, 2013 4:54:53 AM
  com.ibm.commerce.foundation.dataload.businessobjectmediator.Abst
  ractBusinessObjectMediator checkId
  FINER: RETURN true
  Mar 11, 2013 4:54:53 AM
  com.ibm.commerce.foundation.dataload.businessobjectmediator.Abst
  ractBusinessObjectMediator createTableDataObjectWithPrimary
  FINER: RETURN ITEMFFMCTR, ITEMSPC_ID=10257701 FFMCENTER_ID=11052
  STORE_ID=10151 ,Operation mode: U.
  
  The operation mode is "U" even if there is no record found in
  the database (the checkId returns false), so the record won't be
  inserted.
  

Local fix

Problem summary

• USERS AFFECTED:
  WebSphere Commerce users on v7.0 who use dataload utility to
  load ATP inventory data.
  
  PROBLEM ABSTRACT:
  Dataload ATP inventory data not populating the ITEMFFMCTR table.
  
  BUSINESS IMPACT:
  The related products won't be able to be added to shopping cart
  and check out.
  
  RECOMMENDATION:
  

Problem conclusion

• The code change is made to ensure the operation mode is "I" when
  there is no record found in the database, so that the ITEMFFMCTR
  table could be populated properly.
  
  -------------------------------------------------------------
  The latest available maintenance information can be obtained
  from the Recommended Fixes for WebSphere Commerce technote:
  http://www.ibm.com/support/docview.wss?rs=3046&uid=swg21261296
  

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