Direct links to fixes
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 number
JR46050
Reported component name
WC BUS EDITION
Reported component ID
5724I3800
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-03-19
Closed date
2013-04-26
Last modified date
2013-04-26
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSYSYL","label":"WebSphere Commerce Enterprise"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
26 April 2013