Users - Error Importing ProductFeatureAppl

[Fred Forester-2]

Hi all,

Trying to import our data into ofbiz. getting the following error.


305752 (main) [  ServiceDispatcher.java:447:DEBUG] [[Sync service
finished- total:0.134,since last(Begin):0.134]] - 'entity-default / indexPr
oductKeywords'
305756 (main) [      EntityEcaRule.java:122:INFO ] Running Entity ECA
Service: indexProductKeywords, triggered by rule on Entity: ProductFeat
ureAppl
305958 (main) [   GenericDelegator.java:588:ERROR]
---- exception report
----------------------------------------------------------
Failure in create operation for entity [ProductKeyword]:
org.ofbiz.entity.GenericEntityException: Exception while inserting the
following ent
ity: [GenericEntity:ProductKeyword][createdStamp,2006-02-24
16:41:39.7(java.sql.Timestamp)][createdTxStamp,2006-02-24
16:37:02.529(java.sql.T
imestamp)][keyword,cotton(java.lang.String)][lastUpdatedStamp,2006-02-24
16:41:39.7(java.sql.Timestamp)][lastUpdatedTxStamp,2006-02-24 16:37:
02.529(java.sql.Timestamp)][productId,V1710XXL(java.lang.String)][relevancyWeight,1(java.lang.Long)]
(while inserting: [GenericEntity:Product
Keyword][createdStamp,2006-02-24
16:41:39.7(java.sql.Timestamp)][createdTxStamp,2006-02-24
16:37:02.529(java.sql.Timestamp)][keyword,cotton(j
ava.lang.String)][lastUpdatedStamp,2006-02-24
16:41:39.7(java.sql.Timestamp)][lastUpdatedTxStamp,2006-02-24
16:37:02.529(java.sql.Timestamp)]
[productId,V1710XXL(java.lang.String)][relevancyWeight,1(java.lang.Long)]
(SQL Exception while executing the following:INSERT INTO OFBIZ.PROD
UCT_KEYWORD (PRODUCT_ID, KEYWORD, RELEVANCY_WEIGHT, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?,
 ?, ?, ?, ?, ?) (The statement was aborted because it would have caused
a duplicate key value in a unique or primary key constraint or unique
 index identified by 'SQL060223053828620' defined on
'PRODUCT_KEYWORD'.))). Rolling back transaction.
Exception: org.ofbiz.entity.GenericEntityException
Message: Exception while inserting the following entity:
[GenericEntity:ProductKeyword][createdStamp,2006-02-24
16:41:39.7(java.sql.Timestamp
)][createdTxStamp,2006-02-24
16:37:02.529(java.sql.Timestamp)][keyword,cotton(java.lang.String)][lastUpdatedStamp,2006-02-24
16:41:39.7(java.
sql.Timestamp)][lastUpdatedTxStamp,2006-02-24
16:37:02.529(java.sql.Timestamp)][productId,V1710XXL(java.lang.String)][relevancyWeight,1(java.
lang.Long)] (while inserting:
[GenericEntity:ProductKeyword][createdStamp,2006-02-24
16:41:39.7(java.sql.Timestamp)][createdTxStamp,2006-02-2
4
16:37:02.529(java.sql.Timestamp)][keyword,cotton(java.lang.String)][lastUpdatedStamp,2006-02-24
16:41:39.7(java.sql.Timestamp)][lastUpdated
TxStamp,2006-02-24
16:37:02.529(java.sql.Timestamp)][productId,V1710XXL(java.lang.String)][relevancyWeight,1(java.lang.Long)]
(SQL Exception
while executing the following:INSERT INTO OFBIZ.PRODUCT_KEYWORD
(PRODUCT_ID, KEYWORD, RELEVANCY_WEIGHT, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_S
TAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?) (The
statement was aborted because it would have caused a duplicate key v
alue in a unique or primary key constraint or unique index identified by
'SQL060223053828620' defined on 'PRODUCT_KEYWORD'.)))
---- stack trace
---------------------------------------------------------------
org.ofbiz.entity.GenericEntityException: Exception while inserting the
following entity: [GenericEntity:ProductKeyword][createdStamp,2006-02-
24 16:41:39.7(java.sql.Timestamp)][createdTxStamp,2006-02-24
16:37:02.529(java.sql.Timestamp)][keyword,cotton(java.lang.String)][lastUpdatedS
tamp,2006-02-24
16:41:39.7(java.sql.Timestamp)][lastUpdatedTxStamp,2006-02-24
16:37:02.529(java.sql.Timestamp)][productId,V1710XXL(java.lang.
String)][relevancyWeight,1(java.lang.Long)] (while inserting:
[GenericEntity:ProductKeyword][createdStamp,2006-02-24
16:41:39.7(java.sql.Time
stamp)][createdTxStamp,2006-02-24
16:37:02.529(java.sql.Timestamp)][keyword,cotton(java.lang.String)][lastUpdatedStamp,2006-02-24
16:41:39.7(
java.sql.Timestamp)][lastUpdatedTxStamp,2006-02-24
16:37:02.529(java.sql.Timestamp)][productId,V1710XXL(java.lang.String)][relevancyWeight,1(
java.lang.Long)] (SQL Exception while executing the following:INSERT
INTO OFBIZ.PRODUCT_KEYWORD (PRODUCT_ID, KEYWORD, RELEVANCY_WEIGHT, LAST_
UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it wou
ld have caused a duplicate key value in a unique or primary key
constraint or unique index identified by 'SQL060223053828620' defined on
'PRO
DUCT_KEYWORD'.)))
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:140)

Thanx.
Fred

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users