Getting following error while uploading data :
[java] 2008-07-02 13:56:09,272 (main) [
GenericDelegator.java:1240:ERROR]
[java] ---- exception report
----------------------------------------------------------
[java] Failure in store operation for entity [StatusType]:
org.ofbiz.entity.GenericEntityException: Error while updating:
[GenericEntity:StatusType][description,Project(java.lang.String)][lastUpdatedStamp,2008-07-02
13:56:09.249(java.sql.Timestamp)][lastUpdatedTxStamp,2008-07-02
13:56:09.146(java.sql.Timestamp)][parentTypeId,PROJECT_STATUS(java.lang.String)][statusTypeId,WORK_EFF_ASSET_STTS(java.lang.String)]
(SQL Exception while executing the following:UPDATE public.STATUS_TYPE SET
PARENT_TYPE_ID=?, DESCRIPTION=?, LAST_UPDATED_TX_STAMP=?,
LAST_UPDATED_STAMP=? WHERE STATUS_TYPE_ID=? (ERROR: insert or update on
table "status_type" violates foreign key constraint "status_type_parent"
[java] Detail: Key (parent_type_id)=(PROJECT_STATUS) is not present
in table "status_type".)). Rolling back transaction.
[java
Thank You,
Ratnesh
On Wed, Jul 2, 2008 at 8:03 AM, <[EMAIL PROTECTED]> wrote:
> Author: jonesde
> Date: Tue Jul 1 19:33:00 2008
> New Revision: 673262
>
> URL: http://svn.apache.org/viewvc?rev=673262&view=rev
> Log:
> Added delegateReasonEnumId to WorkEffortPartyAssignment to keep track of
> why a task was assigned to another person or group
>
> Modified:
> ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml
> ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml
>
> Modified: ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml
> URL:
> http://svn.apache.org/viewvc/ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml?rev=673262&r1=673261&r2=673262&view=diff
>
> ==============================================================================
> --- ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml
> (original)
> +++ ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml Tue Jul
> 1 19:33:00 2008
> @@ -28,13 +28,18 @@
> <EnumerationType description="Parent Type for all Work Effort enum
> types" enumTypeId="WORK_EFFORT" hasTable="N" parentTypeId=""/>
> <EnumerationType description="Parent Type for all Workflow enum types"
> enumTypeId="WORKFLOW" hasTable="N" parentTypeId=""/>
>
> - <EnumerationType description="Work Effort Expectations"
> enumTypeId="WORK_EFF_EXPECT" hasTable="N" parentTypeId="WORK_EFFORT"/>
> + <EnumerationType description="Work Effort Expectation"
> enumTypeId="WORK_EFF_EXPECT" hasTable="N" parentTypeId="WORK_EFFORT"/>
> <Enumeration description="For Your Information" enumCode="FYI"
> enumId="WEE_FYI" sequenceId="01" enumTypeId="WORK_EFF_EXPECT"/>
> <Enumeration description="Involvement Required" enumCode="REQUIRE"
> enumId="WEE_REQUIRE" sequenceId="02" enumTypeId="WORK_EFF_EXPECT"/>
> <Enumeration description="Involvement Requested" enumCode="REQUEST"
> enumId="WEE_REQUEST" sequenceId="03" enumTypeId="WORK_EFF_EXPECT"/>
> <Enumeration description="Immediate Response Requested"
> enumCode="IMMEDIATE" enumId="WEE_IMMEDIATE" sequenceId="04"
> enumTypeId="WORK_EFF_EXPECT"/>
>
> - <EnumerationType description="Work Effort Scope Classifications"
> enumTypeId="WORK_EFF_SCOPE" hasTable="N" parentTypeId="WORK_EFFORT"/>
> + <EnumerationType description="Work Effort Delegate Reason"
> enumTypeId="WORK_EFF_DEL_REAS" hasTable="N" parentTypeId="WORK_EFFORT"/>
> + <Enumeration description="Need Support or Help" enumCode="NEED_HELP"
> enumId="WEDR_NEED_HELP" sequenceId="01" enumTypeId="WORK_EFF_DEL_REAS"/>
> + <Enumeration description="My Part Finished" enumCode="PART_FINISHED"
> enumId="WEDR_PART_FINISHED" sequenceId="02" enumTypeId="WORK_EFF_DEL_REAS"/>
> + <Enumeration description="Completely Finished"
> enumCode="WHOLE_FINISHED" enumId="WEDR_WHOLE_FINISHED" sequenceId="03"
> enumTypeId="WORK_EFF_DEL_REAS"/>
> +
> + <EnumerationType description="Work Effort Scope Classification"
> enumTypeId="WORK_EFF_SCOPE" hasTable="N" parentTypeId="WORK_EFFORT"/>
> <Enumeration description="General, public access" enumCode="PUBLIC"
> enumId="WES_PUBLIC" sequenceId="01" enumTypeId="WORK_EFF_SCOPE"/>
> <Enumeration description="Restricted, private access"
> enumCode="PRIVATE" enumId="WES_PRIVATE" sequenceId="02"
> enumTypeId="WORK_EFF_SCOPE"/>
> <Enumeration description="Very restricted, confidential access"
> enumCode="CONFIDENTIAL" enumId="WES_CONFIDENTIAL" sequenceId="03"
> enumTypeId="WORK_EFF_SCOPE"/>
> @@ -80,13 +85,26 @@
> <StatusValidChange condition="" statusId="CAL_TENTATIVE"
> statusIdTo="CAL_CANCELLED" transitionName="Cancel"/>
> <StatusValidChange condition="" statusId="CAL_TENTATIVE"
> statusIdTo="CAL_CONFIRMED" transitionName="Confirm"/>
> <StatusValidChange condition="" statusId="CAL_CONFIRMED"
> statusIdTo="CAL_COMPLETED" transitionName="Complete"/>
> -
> +
> + <!-- Project Statuses -->
> + <StatusType description="Project" hasTable="N"
> parentTypeId="PROJECT_STATUS" statusTypeId="WORK_EFF_ASSET_STTS"/>
> + <StatusItem description="Planning" sequenceId="01"
> statusCode="PLANNING" statusId="WEPR_PLANNING" statusTypeId="EVENT_STATUS"/>
> + <StatusItem description="In Progress" sequenceId="02"
> statusCode="IN_PROGRESS" statusId="WEPR_IN_PROGRESS"
> statusTypeId="EVENT_STATUS"/>
> + <StatusItem description="Complete" sequenceId="05"
> statusCode="COMPLETE" statusId="WEPR_COMPLETE" statusTypeId="EVENT_STATUS"/>
> + <StatusItem description="On Hold" sequenceId="98" statusCode="ON_HOLD"
> statusId="WEPR_ON_HOLD" statusTypeId="EVENT_STATUS"/>
> + <StatusItem description="Cancelled" sequenceId="99"
> statusCode="CANCELLED" statusId="WEPR_CANCELLED"
> statusTypeId="EVENT_STATUS"/>
> + <StatusValidChange condition="" statusId="WEPR_PLANNING"
> statusIdTo="WEPR_IN_PROGRESS" transitionName="Begin Project"/>
> + <StatusValidChange condition="" statusId="WEPR_IN_PROGRESS"
> statusIdTo="WEPR_ON_HOLD" transitionName="Begin Project"/>
> + <StatusValidChange condition="" statusId="WEPR_ON_HOLD"
> statusIdTo="WEPR_IN_PROGRESS" transitionName="Resume Project"/>
> + <StatusValidChange condition="" statusId="WEPR_IN_PROGRESS"
> statusIdTo="WEPR_CANCELLED" transitionName="Cancel"/>
> + <StatusValidChange condition="" statusId="WEPR_ON_HOLD"
> statusIdTo="WEPR_CANCELLED" transitionName="Cancel"/>
> +
> <!-- Status items for WorkEffortPartyAssignment.availabilityStatusId
> -->
> <StatusType description="Work Effort Party Availability" hasTable="N"
> parentTypeId="" statusTypeId="WEPA_AVAILABILITY"/>
> <StatusItem description="Available" sequenceId="01"
> statusCode="AVAILABLE" statusId="WEPA_AV_AVAILABLE"
> statusTypeId="WEPA_AVAILABILITY"/>
> <StatusItem description="Busy" sequenceId="02" statusCode="BUSY"
> statusId="WEPA_AV_BUSY" statusTypeId="WEPA_AVAILABILITY"/>
> <StatusItem description="Away" sequenceId="03" statusCode="AWAY"
> statusId="WEPA_AV_AWAY" statusTypeId="WEPA_AVAILABILITY"/>
> -
> +
> <WorkEffortAssocType description="Breakdown/Detail" hasTable="N"
> parentTypeId="" workEffortAssocTypeId="WORK_EFF_BREAKDOWN"/>
> <WorkEffortAssocType description="Dependency" hasTable="N"
> parentTypeId="" workEffortAssocTypeId="WORK_EFF_DEPENDENCY"/>
> <WorkEffortAssocType description="Concurrency" hasTable="N"
> parentTypeId="WORK_EFF_DEPENDENCY"
> workEffortAssocTypeId="WORK_EFF_CONCURRENCY"/>
>
> Modified: ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml
> URL:
> http://svn.apache.org/viewvc/ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml?rev=673262&r1=673261&r2=673262&view=diff
>
> ==============================================================================
> --- ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml
> (original)
> +++ ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml Tue Jul
> 1 19:33:00 2008
> @@ -668,9 +668,7 @@
> <key-map field-name="noteId"/>
> </relation>
> </entity>
> - <entity entity-name="WorkEffortPartyAssignment"
> - package-name="org.ofbiz.workeffort.workeffort"
> - title="Work Effort Party Assignment Entity">
> + <entity entity-name="WorkEffortPartyAssignment"
> package-name="org.ofbiz.workeffort.workeffort" title="Work Effort Party
> Assignment Entity">
> <field name="workEffortId" type="id-ne"></field>
> <field name="partyId" type="id-ne"></field>
> <field name="roleTypeId" type="id-ne"></field>
> @@ -678,7 +676,8 @@
> <field name="thruDate" type="date-time"></field>
> <field name="statusId" type="id"></field>
> <field name="statusDateTime" type="date-time"></field>
> - <field name="expectationEnumId" type="id"></field>
> + <field name="expectationEnumId" type="id"><description>Point to
> Enumeration value with enumTypeId="WORK_EFF_EXPECT"</description></field>
> + <field name="delegateReasonEnumId" type="id"><description>Point to
> Enumeration value with enumTypeId="WORK_EFF_DEL_REAS"</description></field>
> <field name="facilityId" type="id"></field>
> <field name="comments" type="comment"></field>
> <field name="mustRsvp" type="indicator"></field>
> @@ -712,14 +711,15 @@
> <relation type="one" fk-name="WKEFF_PA_EXP_ENUM" title="Expectation"
> rel-entity-name="Enumeration">
> <key-map field-name="expectationEnumId" rel-field-name="enumId"/>
> </relation>
> + <relation type="one" fk-name="WKEFF_PA_DELR_ENM"
> title="DelegateReason" rel-entity-name="Enumeration">
> + <key-map field-name="delegateReasonEnumId"
> rel-field-name="enumId"/>
> + </relation>
> <relation type="one" fk-name="WKEFF_PA_AVSTTS" title="Availability"
> rel-entity-name="StatusItem">
> <key-map field-name="availabilityStatusId"
> rel-field-name="statusId"/>
> </relation>
> </entity>
> - <entity entity-name="WorkEffortPurposeType"
> - package-name="org.ofbiz.workeffort.workeffort"
> - title="Work Effort Purpose Type Entity"
> - default-resource-name="WorkEffortEntityLabels">
> + <entity entity-name="WorkEffortPurposeType"
> package-name="org.ofbiz.workeffort.workeffort" title="Work Effort Purpose
> Type Entity"
> + default-resource-name="WorkEffortEntityLabels">
> <field name="workEffortPurposeTypeId" type="id-ne"></field>
> <field name="description" type="description"></field>
> <prim-key field="workEffortPurposeTypeId"/>
>
>
>
