Import Sales detail from CSV - problem

Import Sales detail from CSV - problem

I can import only one product for account,
for second product i see stack trace and log:

[12:52:52:082]|[12-24-2008]|[com.adventnet.persistence.Row]|[WARNING]|[23]|: WARNING::The column SALESID in Sales_Fields is given a value that is instance
of java.lang.String that contradicts with BIGINT specified in data-dictionary. |
[12:52:52:082]|[12-24-2008]|[com.adventnet.persistence.Row]|[WARNING]|[23]|: The column SALESID in Sales_Fields is given a value that is instance of java.
lang.String that contradicts with BIGINT specified in the data-dictionary|
[12:52:52:082]|[12-24-2008]|[com.adventnet.persistence.DataAccess]|[WARNING]|[23]|: Exception occured while inserting into table [Sales_Fields] in the dat
aObject :: <WritableDataObject>
<Tables>
[Customer_Product, Sales_Fields] </Tables>
<JoinsInDO>
</JoinsInDO>
<Operations>
<INSERT><Customer_Product_PK CUSTOMER_PRODUCT_ID="148"/></INSERT>
<INSERT><Sales_Fields_PK SALESID="68"/></INSERT>
</Operations>
<Rows>
<Customer_Product CUSTOMER_PRODUCT_ID="148" CUSTOMER_ID="527" PRODUCT_ID="2" SOLD_DATE="1153857600000" WARRANTY_PERIOD="0" NO_OF_UNITS="null" UNIT_PRICE
="null" TAX_RATE="null" DISCOUNT="null" NET_SP="null" COMMENTS="None" LICENSETYPE="null" />
<Sales_Fields SALESID="68" UDF_LONG1="null" UDF_LONG2="null" UDF_CHAR1="GigabitEthernet0/1.601-802.1Q vLAN subif .... c2-mwf" UDF_CHAR2="RCN-MSPD-?" UDF
_CHAR3="........ .............. GigabitEthernet0/1.601-802.1Q vLAN subif .... c2-mwf; ....................: ............; ..... ........................;
... 34; 1-.... ......; ............ 8." UDF_CHAR4="null" UDF_CHAR5="null" UDF_CHAR6="null" UDF_DATE1="null" UDF_DATE2="null" UDF_LONG3="null" UDF_LONG4="n
ull" UDF_CHAR7="null" UDF_CHAR8="null" UDF_CHAR9="null" UDF_CHAR10="null" UDF_CHAR11="null" UDF_CHAR12="null" UDF_DATE3="null" UDF_DATE4="null" />
</Rows>
</WritableDataObject>
|
[12:52:52:082]|[12-24-2008]|[SYSOUT]|[INFO]|[23]|: [JBOSS] RequestProcessor: Unhandled Exception thrown: class com.adventnet.persistence.DataAccessExcepti
on|
[12:52:52:082]|[12-24-2008]|[SYSOUT]|[INFO]|[23]|: [JBOSS] Engine: StandardWrapperValve[action]: Servlet.service() for servlet action threw exceptioncom.a
dventnet.persistence.DataAccessException: [Sales_Fields] Exception occured while inserting rows
at com.adventnet.persistence.DataAccess.createDataAccessException(DataAccess.java:2574)
at com.adventnet.persistence.DataAccess.insertRows(DataAccess.java:2218)
at com.adventnet.persistence.DataAccess.add(DataAccess.java:294)
at com.adventnet.persistence.DataAccess.add(DataAccess.java:250)
.....


org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcp|
[12:52:52:083]|[12-24-2008]|[SYSOUT]|[INFO]|[23]|: Endpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: null, message from server: "Duplicate entry '68' for key 1"
at com.adventnet.db.api.RelationalAPI.handleException(RelationalAPI.java:690)
at com.adventnet.db.api.RelationalAPI.executeBatch(RelationalAPI.java:665)
at com.adventnet.persistence.DataAccess.insertRows(DataAccess.java:2184)
... 93 more
Caused by: java.sql.BatchUpdateException: null, message from server: "Duplicate entry '68' for key 1"
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1401)
at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:750)
at com.adventnet.db.api.RelationalAPI.executeBatch(RelationalAPI.java:661)
... 94 more





















































                  New to ADSelfService Plus?