Re: svn commit: r631785 - /ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml

[pankaj savita]

Si,
Problems have been encountered while loading data due to this code.

(ERROR: insert or update on table "gl_account_type" violates foreign key
constraint "glactty_par"
 Detail: Key (parent_type_id)=(EXPENSE) is not present in table
"gl_account_type".)). Rolling back transaction.

Regards,
Pankaj Savita

On Thu, Feb 28, 2008 at 5:43 AM, <[hidden email]> wrote:

> Author: sichen
> Date: Wed Feb 27 16:12:58 2008
> New Revision: 631785
>
> URL: http://svn.apache.org/viewvc?rev=631785&view=rev
> Log:
> Add relation for GlAccountType's parent/child structure.
>
> Modified:
>    ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml
>
> Modified: ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml
> URL:
> http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml?rev=631785&r1=631784&r2=631785&view=diff
>
> ==============================================================================
> --- ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml
> (original)
> +++ ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml Wed Feb
> 27 16:12:58 2008
> @@ -1885,6 +1885,9 @@
>       <field name="hasTable" type="indicator"></field>
>       <field name="description" type="description"></field>
>       <prim-key field="glAccountTypeId"/>
> +      <relation type="one" fk-name="GLACTTY_PAR" title="Parent"
> rel-entity-name="GlAccountType">
> +        <key-map field-name="parentTypeId"
> rel-field-name="glAccountTypeId"/>
> +      </relation>
>     </entity>
>     <entity entity-name="GlAccountTypeDefault"
>             package-name="org.ofbiz.accounting.ledger"
>
>
>

<http://www.hotwaxmedia.com>

[Christian Geisert]

I think Si isn't subscribed to this mailing list...

Anyway, this change just triggered a problem in the demo data which
I noticed by coincidence yesterday while looking at the
AccountingTypeData.xml ;-)

A fix for this is either to add a GlAccountType "EXPENSE" or remove
the parentTypeId from "PURCHASE_PRICE_VAR"
(For example "OTHER_EXPENSE" has no parent "EXPENSE")

I'm not sure which is better...

Christian

> Si,
> Problems have been encountered while loading data due to this code.
>
> (ERROR: insert or update on table "gl_account_type" violates foreign key
> constraint "glactty_par"
>  Detail: Key (parent_type_id)=(EXPENSE) is not present in table
> "gl_account_type".)). Rolling back transaction.
>
> Regards,
> Pankaj Savita
>
> On Thu, Feb 28, 2008 at 5:43 AM, <[hidden email]> wrote:
>
>> Author: sichen
>> Date: Wed Feb 27 16:12:58 2008
>> New Revision: 631785
>>
>> URL: http://svn.apache.org/viewvc?rev=631785&view=rev
>> Log:
>> Add relation for GlAccountType's parent/child structure.
>>
>> Modified:
>>    ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml
>>
>> Modified: ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml
>> URL:
>> http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml?rev=631785&r1=631784&r2=631785&view=diff
>>
>> ==============================================================================
>> --- ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml
>> (original)
>> +++ ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml Wed Feb
>> 27 16:12:58 2008
>> @@ -1885,6 +1885,9 @@
>>       <field name="hasTable" type="indicator"></field>
>>       <field name="description" type="description"></field>
>>       <prim-key field="glAccountTypeId"/>
>> +      <relation type="one" fk-name="GLACTTY_PAR" title="Parent"
>> rel-entity-name="GlAccountType">
>> +        <key-map field-name="parentTypeId"
>> rel-field-name="glAccountTypeId"/>
>> +      </relation>
>>     </entity>
>>     <entity entity-name="GlAccountTypeDefault"
>>             package-name="org.ofbiz.accounting.ledger"
>>
>>
>>
>
>
>
> <http://www.hotwaxmedia.com>
>

--
Mit freundlichen Grüßen
Christian Geisert

ISU GmbH * Kreisstr. 9 * 76297 Stutensee * Germany
Tel. [phone] * Fax [phone]
www.isu-gmbh.de * [hidden email]

Geschäftsführer: Hartmut Glasenapp
Amtsgericht Mannheim HRB 106505
USt.-Id Nr. DE 158792445
St.-Nr. 34 413 82630

[Mridul Pathak-2]

The error is actually due to the following data record in
AccountingTypeData.xml:
LINE 301: <GlAccountType description="Purchase Price Variance"
glAccountTypeId="PURCHASE_PRICE_VAR" hasTable="N" parentTypeId="EXPENSE"/>

Here glAccoutTypeId="EXPENSE" does not exists so can't be used as a
parentTypeId as it violates FK constraints according to this commit,  I
think we can use parentTypeId="OTHER_EXPENCE".

On Thu, Feb 28, 2008 at 10:26 AM, pankaj savita <[hidden email]>
wrote:

> Si,
> Problems have been encountered while loading data due to this code.
>
> (ERROR: insert or update on table "gl_account_type" violates foreign key
> constraint "glactty_par"
>  Detail: Key (parent_type_id)=(EXPENSE) is not present in table
> "gl_account_type".)). Rolling back transaction.
>
> Regards,
> Pankaj Savita
>
> On Thu, Feb 28, 2008 at 5:43 AM, <[hidden email]> wrote:
>
> > Author: sichen
> > Date: Wed Feb 27 16:12:58 2008
> > New Revision: 631785
> >
> > URL: http://svn.apache.org/viewvc?rev=631785&view=rev
> > Log:
> > Add relation for GlAccountType's parent/child structure.
> >
> > Modified:
> >    ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml
> >
> > Modified: ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml
> > URL:
> >
> http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml?rev=631785&r1=631784&r2=631785&view=diff
> >
> >
> ==============================================================================
> > --- ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml
> > (original)
> > +++ ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml Wed
> Feb
> > 27 16:12:58 2008
> > @@ -1885,6 +1885,9 @@
> >       <field name="hasTable" type="indicator"></field>
> >       <field name="description" type="description"></field>
> >       <prim-key field="glAccountTypeId"/>
> > +      <relation type="one" fk-name="GLACTTY_PAR" title="Parent"
> > rel-entity-name="GlAccountType">
> > +        <key-map field-name="parentTypeId"
> > rel-field-name="glAccountTypeId"/>
> > +      </relation>
> >     </entity>
> >     <entity entity-name="GlAccountTypeDefault"
> >             package-name="org.ofbiz.accounting.ledger"
> >
> >
> >
>
>
>
> <http://www.hotwaxmedia.com>
>

--
Thanks & Regards
Mridul Pathak
Hotwax Media
http://www.hotwaxmedia.com
[hidden email]
__________________________________
Office          :   509.855.4113
Mobile         : [phone]

[Jacopo Cappellato]

Christian Geisert wrote:
> I think Si isn't subscribed to this mailing list...
>

As a committer, Si should really be subscribed to all the OFBiz's public
lists; I would be surprised of the contrary, but I'm copying this
message to Si so that he can subscribe if he is not.

> Anyway, this change just triggered a problem in the demo data which
> I noticed by coincidence yesterday while looking at the
> AccountingTypeData.xml ;-)

The data loading issue should be fixed in rev. 631906

Pankaj, Christian, thanks for your help.

Jacopo


>
> A fix for this is either to add a GlAccountType "EXPENSE" or remove
> the parentTypeId from "PURCHASE_PRICE_VAR"
> (For example "OTHER_EXPENSE" has no parent "EXPENSE")
>
> I'm not sure which is better...
>
> Christian

>
>> Si,
>> Problems have been encountered while loading data due to this code.
>>
>> (ERROR: insert or update on table "gl_account_type" violates foreign key
>> constraint "glactty_par"
>>  Detail: Key (parent_type_id)=(EXPENSE) is not present in table
>> "gl_account_type".)). Rolling back transaction.
>>
>> Regards,
>> Pankaj Savita
>>