Re: svn commit: r673262 - in /ofbiz/trunk/applications/workeffort: data/WorkEffortTypeData.xml entitydef/entitymodel.xml

Wed, 02 Jul 2008 02:03:10 -0700
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, <[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"/>



























					Reply via email to