Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
No replies
pallu2626
pallu2626
1 Post
ACCEPTED ANSWER

Pinned topic WCS7 | Data load utitlity | ID resolve issue for ORDRELEASE table

‏2013-07-12T05:54:15Z |

Hi,

 

I am trying to load data into ORDERS and ORDRELEASE using tableobjectmediator.Since ORDRELEASE is having a composite primary key,the id is not getting resolved for orders_id.Below is the data load configuration xml.

 

  <_config:DataLoader className="com.ibm.commerce.foundation.dataload.BusinessObjectLoader" >

    <_config:DataReader className="com.ibm.commerce.foundation.dataload.datareader.CSVReader" firstLineIsHeader="true" useHeaderAsColumnName="true" >

    </_config:DataReader>

    <_config:BusinessObjectBuilder className="com.ibm.commerce.foundation.dataload.businessobjectbuilder.TableObjectBuilder">

<_config:Table name="ORDERS" excludeUnListedColumns="true">

          <_config:Column name="ORDERS_ID" value="ORDERS_ID" valueFrom="IDResolve">

              <_config:IDResolve tableName="ORDERS" generateNewKey="true" />

          </_config:Column>

          <_config:Column name="TOTALPRODUCT" value="TOTALPRODUCT"/>

          <_config:Column name="TOTALTAX" value="TOTALTAX" />

          <_config:Column name="TOTALSHIPPING" value="TOTALSHIPPING" />

          <_config:Column name="TOTALTAXSHIPPING" value="TOTALTAXSHIPPING" />

          <_config:Column name="STOREENT_ID" value="STOREENT_ID" />

          <_config:Column name="CURRENCY" value="CURRENCY" />

          <_config:Column name="LOCKED" value="1" valueFrom="Fixed"/>

          <_config:Column name="STATUS" value="STATUS"/>

          <_config:Column name="SEQUENCE" value="0" valueFrom="Fixed"/>

          <_config:Column name="MEMBER_ID" value="MEMBER_ID" />

          <_config:Column name="FIELD1" value="FIELD1"/>       

          <_config:Column name="SHIPASCOMPLETE" value="Y" valueFrom="Fixed"/>

          <_config:Column name="TOTALADJUSTMENT" value="TOTALADJUSTMENT"/>

      </_config:Table>

       <_config:Table name="ORDRELEASE" excludeUnListedColumns="true">

          <_config:Column name="ORDRELEASENUM" value="ORDRELEASENUM" valueFrom="IDResolve">

              <_config:IDResolve tableName="ORDRELEASE" generateNewKey="true" >

              </_config:IDResolve>

          </_config:Column>

          <_config:Column name="ORDERS_ID" value="ORDERS_ID" valueFrom="IDResolve"/>

          <_config:Column name="FIELD2" value="CARRIER" />

          <_config:Column name="EXTORDNUM" value="TRACKINGNUM" />

          <_config:Column name="ISEXPEDITED" value="N" valueFrom="Fixed"/>    

          <_config:Column name="SHIPMODE_ID" value="SHIPMODE_ID" />

          <_config:Column name="FFMCENTER_ID" value="10051" valueFrom="Fixed" />

          <_config:Column name="MEMBER_ID" value="MEMBER_ID" />

          <_config:Column name="STOREENT_ID" value="STOREENT_ID" />         

      </_config:Table>

       <_config:BusinessObjectMediator className="com.ibm.commerce.foundation.dataload.businessobjectmediator.TableObjectMediator">

      </_config:BusinessObjectMediator>

    </_config:BusinessObjectBuilder>

  </_config:DataLoader>

</_config:DataloadBusinessObjectConfiguration>

 

 

Below is the exception

An exception was caught: com.ibm.commerce.foundation.dataload.exception.DataLoadConfigException: The primary key column was not provided in the data load configuration.  This information is required for an identifier resolution.  The configuration information provided was: {ORDRELEASENUM=8002, ORDERS_ID=null}.

 

Please let me know if you can suggest a solution to this problem.Please let me know if i need to attach a sample csv since the xml file itself is self explanatory.

 

Thanks

Pallavi