Jacques , I just found out a problem with this particular commit, so I reported here. BTW i know about the user mailing list ;)
Thanks ! -Ratnesh On Wed, Jul 2, 2008 at 3:18 PM, Jacques Le Roux < [EMAIL PROTECTED]> wrote: > Any problems with revision (last) 673329 here > > Please use rather user ML for such questions : > > http://docs.ofbiz.org/display/OFBADMIN/Mailing+Lists#MailingLists-DeveloperList:[email protected] > > Thanks > > Jacques > > From: "Ratnesh Upadhyay" <[EMAIL PROTECTED]> > > 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"/> >>> >>> >>> >>> >> >
