Re: svn commit: r673262 - in /ofbiz/trunk/applications/work
Locked
Re: svn commit: r673262 - in /ofbiz/trunk/applications/work
 
|
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, <[hidden email]> 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"/> > > > |
Re: svn commit: r673262 - in /ofbiz/trunk/applications/work
|
|
Thanks for letting me know. I hadn't finished the statusTypeIds when I committed that. They're finished now and in with a few other changes in SVN rev 673324. I also did a fresh db load test with the latest and got no errors. -David On Jul 2, 2008, at 2:46 AM, Ratnesh Upadhyay wrote: > 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, <[hidden email]> 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"/> >> >> >> |
Re: svn commit: r673262 - in /ofbiz/trunk/applications/work
Administrator
|
In reply to this post by Ratnesh Upadhyay
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:dev@... Thanks Jacques From: "Ratnesh Upadhyay" <[hidden email]> > 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, <[hidden email]> 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"/> >> >> >> > |
Re: svn commit: r673262 - in /ofbiz/trunk/applications/work
|
|
In reply to this post by David E Jones
Thank you so much David.
- Ratnesh On Wed, Jul 2, 2008 at 2:32 PM, David E Jones <[hidden email]> wrote: > > Thanks for letting me know. I hadn't finished the statusTypeIds when I > committed that. They're finished now and in with a few other changes in SVN > rev 673324. > > I also did a fresh db load test with the latest and got no errors. > > -David > > > > On Jul 2, 2008, at 2:46 AM, Ratnesh Upadhyay wrote: > > 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, <[hidden email]> 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"/> >>> >>> >>> >>> > |
Re: svn commit: r673262 - in /ofbiz/trunk/applications/work
|
|
In reply to this post by Jacques Le Roux
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 < [hidden email]> 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:dev@... > > Thanks > > Jacques > > From: "Ratnesh Upadhyay" <[hidden email]> > > 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, <[hidden email]> 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"/> >>> >>> >>> >>> >> > |
Re: svn commit: r673262 - in /ofbiz/trunk/applications/work
|
|
In reply to this post by Jacques Le Roux
Wait a minute... why would the user mailing list be used for this? It's definitely discussion around development of OFBiz itself.... -David On Jul 2, 2008, at 3:48 AM, Jacques Le Roux 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 > :[hidden email] > > Thanks > > Jacques > > From: "Ratnesh Upadhyay" <[hidden email]> >> 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, <[hidden email]> 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"/> >>> >>> >>> > |
Re: svn commit: r673262 - in /ofbiz/trunk/applications/work
|
Administrator
|
David, Ratnesh,
Yes sorry, I was too fast on this one, kind of Pavlov's reflex. At large, my aim si to cut ASAP messages not well directed Jacques From: "David E Jones" <[hidden email]> > > Wait a minute... why would the user mailing list be used for this? It's definitely discussion around development of OFBiz > itself.... > > -David > > > On Jul 2, 2008, at 3:48 AM, Jacques Le Roux 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 :[hidden email] >> >> Thanks >> >> Jacques >> >> From: "Ratnesh Upadhyay" <[hidden email]> >>> 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, <[hidden email]> 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"/> >>>> >>>> >>>> >> > |
«
Return to OFBiz - Dev
|
1 view|%1 views
| Free forum by Nabble | Edit this page |