Re: Getting error in Data load

[Deepak Dixit]

Hello Rohit,

This error coming due to Hans commit (#814287). In this commit statusId 
used in PartyHelpData.xml , and statusId's   define in 
ContentTypeData.xml in content component,and content  component is 
loaded after party component. There for  statusId generate error.

Thanks & Regards
-----
Deepak Dixit

Rohit Jain wrote:
Hello All,

My local ofbiz at revision no 814471
I have tried to load data by using command "ant clean-all;ant run-install",
and getting following error in loading Data file.


     [java] 2009-09-14 10:03:57,265 (main) [
EntitySaxReader.java:257:INFO ] Transaction Timeout set to 2 hours (7200
seconds)
     [java] 2009-09-14 10:03:57,366 (main) [
GenericDelegator.java:843:ERROR]
     [java] ---- exception report
----------------------------------------------------------
     [java] Failure in create operation for entity [DataResource]:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:DataResource][createdStamp,2009-09-14
10:03:57.337(java.sql.Timestamp)][createdTxStamp,2009-09-14
10:03:57.264(java.sql.Timestamp)][dataResourceId,HELP_PARTY(java.lang.String)][dataResourceName,Party
Overview(java.lang.String)][dataResourceTypeId,OFBIZ_FILE(java.lang.String)][dataTemplateTypeId,NONE(java.lang.String)][isPublic,Y(java.lang.String)][lastUpdatedStamp,2009-09-14
10:03:57.337(java.sql.Timestamp)][lastUpdatedTxStamp,2009-09-14
10:03:57.264(java.sql.Timestamp)][localeString,en(java.lang.String)][mimeTypeId,text/xml(java.lang.String)][objectInfo,applications/party/data/helpdata/HELP_PARTY.xml(java.lang.String)][statusId,CTNT_IN_PROGRESS(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO OFBIZ.DATA_RESOURCE
(DATA_RESOURCE_ID, DATA_RESOURCE_TYPE_ID, DATA_TEMPLATE_TYPE_ID,
DATA_CATEGORY_ID, DATA_SOURCE_ID, STATUS_ID, DATA_RESOURCE_NAME,
LOCALE_STRING, MIME_TYPE_ID, CHARACTER_SET_ID, OBJECT_INFO, SURVEY_ID,
SURVEY_RESPONSE_ID, RELATED_DETAIL_ID, IS_PUBLIC, CREATED_DATE,
CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
(INSERT on table 'DATA_RESOURCE' caused a violation of foreign key
constraint 'DTRSRC_STATUS' for key (CTNT_IN_PROGRESS).  The statement has
been rolled back.)). Rolling back transaction.
     [java] Exception: org.ofbiz.entity.GenericEntityException
     [java] Message: Error while inserting:
[GenericEntity:DataResource][createdStamp,2009-09-14
10:03:57.337(java.sql.Timestamp)][createdTxStamp,2009-09-14
10:03:57.264(java.sql.Timestamp)][dataResourceId,HELP_PARTY(java.lang.String)][dataResourceName,Party
Overview(java.lang.String)][dataResourceTypeId,OFBIZ_FILE(java.lang.String)][dataTemplateTypeId,NONE(java.lang.String)][isPublic,Y(java.lang.String)][lastUpdatedStamp,2009-09-14
10:03:57.337(java.sql.Timestamp)][lastUpdatedTxStamp,2009-09-14
10:03:57.264(java.sql.Timestamp)][localeString,en(java.lang.String)][mimeTypeId,text/xml(java.lang.String)][objectInfo,applications/party/data/helpdata/HELP_PARTY.xml(java.lang.String)][statusId,CTNT_IN_PROGRESS(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO OFBIZ.DATA_RESOURCE
(DATA_RESOURCE_ID, DATA_RESOURCE_TYPE_ID, DATA_TEMPLATE_TYPE_ID,
DATA_CATEGORY_ID, DATA_SOURCE_ID, STATUS_ID, DATA_RESOURCE_NAME,
LOCALE_STRING, MIME_TYPE_ID, CHARACTER_SET_ID, OBJECT_INFO, SURVEY_ID,
SURVEY_RESPONSE_ID, RELATED_DETAIL_ID, IS_PUBLIC, CREATED_DATE,
CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
(INSERT on table 'DATA_RESOURCE' caused a violation of foreign key
constraint 'DTRSRC_STATUS' for key (CTNT_IN_PROGRESS).  The statement has
been rolled back.))


Is there any one who facing same problem.

Thanks and regards
----
Rohit Jain