OFBiz › OFBiz - User

Getting error in Data load

‹ Previous Topic Next Topic ›
 
classic Classic list List threaded Threaded
♦
♦
 2 messages Options
Rohit Jain-2
Reply | Threaded
Open this post in threaded view
♦
♦
|

Getting error in Data load

Rohit Jain-2
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
Deepak Dixit-2
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Getting error in Data load

Deepak Dixit-2
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
>
>  

Free forum by Nabble Edit this page