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 <[EMAIL PROTECTED]> 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, <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] __________________________________ Office : 509.855.4113 Mobile : +919425926892
