Thanks Ashish. Btw I observe a typo in the log message. foregn -->
foreign I hope someone could fix it :) Vikas On Jul 10, 2009, at 1:28 PM, [hidden email] wrote: > Author: ashish > Date: Fri Jul 10 07:58:40 2009 > New Revision: 792826 > > URL: http://svn.apache.org/viewvc?rev=792826&view=rev > Log: >>> [java] 2009-07-10 13:09:23,343 (main) [ GenericDelegator.java: >>> 258:WARN ] [RelFKNameGT18] The foregn key name (length:19) was >>> greater than 18 characters in length for relation >>> InvoiceItemAssocType of entity InvoiceItemAssoc. > > This thing always confuses me. I was in impression that the maximum > length allowed for fk-name is 20 but came to know that it is 18. > Thanks Vikas for report, will remember this in future :-). > > 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=792826&r1=792825&r2=792826&view=diff > = > = > = > = > = > = > = > = > ====================================================================== > --- ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml > (original) > +++ ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml > Fri Jul 10 07:58:40 2009 > @@ -1284,14 +1284,14 @@ > <prim-key field="invoiceItemSeqIdTo"/> > <prim-key field="invoiceItemAssocTypeId"/> > <prim-key field="fromDate"/> > - <relation type="one" fk-name="IN_ITMASC_TYP_IIASC" rel-entity- > name="InvoiceItemAssocType"> > + <relation type="one" fk-name="INITMASCTYP_IIASC" rel-entity- > name="InvoiceItemAssocType"> > <key-map field-name="invoiceItemAssocTypeId"/> > </relation> > - <relation type="one" fk-name="IN_ITMASSC_FIITM" title="From" > rel-entity-name="InvoiceItem"> > + <relation type="one" fk-name="INITMASC_FIITM" title="From" > rel-entity-name="InvoiceItem"> > <key-map field-name="invoiceIdFrom" rel-field- > name="invoiceId"/> > <key-map field-name="invoiceItemSeqIdFrom" rel-field- > name="invoiceItemSeqId"/> > </relation> > - <relation type="one" fk-name="IN_ITMASSC_TIITM" title="To" > rel-entity-name="InvoiceItem"> > + <relation type="one" fk-name="INITMASC_TIITM" title="To" rel- > entity-name="InvoiceItem"> > <key-map field-name="invoiceIdTo" rel-field-name="invoiceId"/> > <key-map field-name="invoiceItemSeqIdTo" rel-field- > name="invoiceItemSeqId"/> > </relation> > @@ -1311,7 +1311,7 @@ > <field name="hasTable" type="indicator"></field> > <field name="description" type="description"></field> > <prim-key field="invoiceItemAssocTypeId"/> > - <relation type="one" fk-name="IN_ITASC_TYP_PARNT" > title="Parent" rel-entity-name="InvoiceItemAssocType"> > + <relation type="one" fk-name="INITMASCTYP_PRNT" > title="Parent" rel-entity-name="InvoiceItemAssocType"> > <key-map field-name="parentTypeId" rel-field- > name="invoiceItemAssocTypeId"/> > </relation> > </entity> > > |
Sorry, If I wasn't clear. I was referring to the following part of the
log that is generated by the system. > [java] 2009-07-10 13:09:23,343 (main) [ GenericDelegator.java: > 258:WARN ] [RelFKNameGT18] The foregn key name (length:19) was > greater than 18 characters in length for relation > InvoiceItemAssocType of entity InvoiceItemAssoc. Vikas On Jul 10, 2009, at 1:56 PM, Vikas Mayur wrote: > Thanks Ashish. Btw I observe a typo in the log message. foregn --> > foreign > > I hope someone could fix it :) > > Vikas > > On Jul 10, 2009, at 1:28 PM, [hidden email] wrote: > >> Author: ashish >> Date: Fri Jul 10 07:58:40 2009 >> New Revision: 792826 >> >> URL: http://svn.apache.org/viewvc?rev=792826&view=rev >> Log: >>>> [java] 2009-07-10 13:09:23,343 (main) [ GenericDelegator.java: >>>> 258:WARN ] [RelFKNameGT18] The foregn key name (length:19) was >>>> greater than 18 characters in length for relation >>>> InvoiceItemAssocType of entity InvoiceItemAssoc. >> >> This thing always confuses me. I was in impression that the maximum >> length allowed for fk-name is 20 but came to know that it is 18. >> Thanks Vikas for report, will remember this in future :-). >> >> 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=792826&r1=792825&r2=792826&view=diff >> = >> = >> = >> = >> = >> = >> = >> = >> = >> ===================================================================== >> --- ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml >> (original) >> +++ ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml >> Fri Jul 10 07:58:40 2009 >> @@ -1284,14 +1284,14 @@ >> <prim-key field="invoiceItemSeqIdTo"/> >> <prim-key field="invoiceItemAssocTypeId"/> >> <prim-key field="fromDate"/> >> - <relation type="one" fk-name="IN_ITMASC_TYP_IIASC" rel- >> entity-name="InvoiceItemAssocType"> >> + <relation type="one" fk-name="INITMASCTYP_IIASC" rel-entity- >> name="InvoiceItemAssocType"> >> <key-map field-name="invoiceItemAssocTypeId"/> >> </relation> >> - <relation type="one" fk-name="IN_ITMASSC_FIITM" title="From" >> rel-entity-name="InvoiceItem"> >> + <relation type="one" fk-name="INITMASC_FIITM" title="From" >> rel-entity-name="InvoiceItem"> >> <key-map field-name="invoiceIdFrom" rel-field- >> name="invoiceId"/> >> <key-map field-name="invoiceItemSeqIdFrom" rel-field- >> name="invoiceItemSeqId"/> >> </relation> >> - <relation type="one" fk-name="IN_ITMASSC_TIITM" title="To" >> rel-entity-name="InvoiceItem"> >> + <relation type="one" fk-name="INITMASC_TIITM" title="To" rel- >> entity-name="InvoiceItem"> >> <key-map field-name="invoiceIdTo" rel-field-name="invoiceId"/> >> <key-map field-name="invoiceItemSeqIdTo" rel-field- >> name="invoiceItemSeqId"/> >> </relation> >> @@ -1311,7 +1311,7 @@ >> <field name="hasTable" type="indicator"></field> >> <field name="description" type="description"></field> >> <prim-key field="invoiceItemAssocTypeId"/> >> - <relation type="one" fk-name="IN_ITASC_TYP_PARNT" >> title="Parent" rel-entity-name="InvoiceItemAssocType"> >> + <relation type="one" fk-name="INITMASCTYP_PRNT" >> title="Parent" rel-entity-name="InvoiceItemAssocType"> >> <key-map field-name="parentTypeId" rel-field- >> name="invoiceItemAssocTypeId"/> >> </relation> >> </entity> >> >> > |
It was crystal clear to me Vikas :-).
Someone having framework access will take care of it soon. -- Ashish On Fri, Jul 10, 2009 at 6:57 PM, Vikas Mayur <[hidden email]>wrote: > Sorry, If I wasn't clear. I was referring to the following part of the log > that is generated by the system. > > [java] 2009-07-10 13:09:23,343 (main) [ GenericDelegator.java:258:WARN ] >> [RelFKNameGT18] The foregn key name (length:19) was greater than 18 >> characters in length for relation InvoiceItemAssocType of entity >> InvoiceItemAssoc. >> > > Vikas > > > On Jul 10, 2009, at 1:56 PM, Vikas Mayur wrote: > > Thanks Ashish. Btw I observe a typo in the log message. foregn --> foreign >> >> I hope someone could fix it :) >> >> Vikas >> >> On Jul 10, 2009, at 1:28 PM, [hidden email] wrote: >> >> Author: ashish >>> Date: Fri Jul 10 07:58:40 2009 >>> New Revision: 792826 >>> >>> URL: http://svn.apache.org/viewvc?rev=792826&view=rev >>> Log: >>> >>>> [java] 2009-07-10 13:09:23,343 (main) [ GenericDelegator.java:258:WARN >>>>> ] [RelFKNameGT18] The foregn key name (length:19) was greater than 18 >>>>> characters in length for relation InvoiceItemAssocType of entity >>>>> InvoiceItemAssoc. >>>>> >>>> >>> This thing always confuses me. I was in impression that the maximum >>> length allowed for fk-name is 20 but came to know that it is 18. >>> Thanks Vikas for report, will remember this in future :-). >>> >>> 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=792826&r1=792825&r2=792826&view=diff >>> >>> ============================================================================== >>> --- ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml >>> (original) >>> +++ ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml Fri Jul >>> 10 07:58:40 2009 >>> @@ -1284,14 +1284,14 @@ >>> <prim-key field="invoiceItemSeqIdTo"/> >>> <prim-key field="invoiceItemAssocTypeId"/> >>> <prim-key field="fromDate"/> >>> - <relation type="one" fk-name="IN_ITMASC_TYP_IIASC" >>> rel-entity-name="InvoiceItemAssocType"> >>> + <relation type="one" fk-name="INITMASCTYP_IIASC" >>> rel-entity-name="InvoiceItemAssocType"> >>> <key-map field-name="invoiceItemAssocTypeId"/> >>> </relation> >>> - <relation type="one" fk-name="IN_ITMASSC_FIITM" title="From" >>> rel-entity-name="InvoiceItem"> >>> + <relation type="one" fk-name="INITMASC_FIITM" title="From" >>> rel-entity-name="InvoiceItem"> >>> <key-map field-name="invoiceIdFrom" rel-field-name="invoiceId"/> >>> <key-map field-name="invoiceItemSeqIdFrom" >>> rel-field-name="invoiceItemSeqId"/> >>> </relation> >>> - <relation type="one" fk-name="IN_ITMASSC_TIITM" title="To" >>> rel-entity-name="InvoiceItem"> >>> + <relation type="one" fk-name="INITMASC_TIITM" title="To" >>> rel-entity-name="InvoiceItem"> >>> <key-map field-name="invoiceIdTo" rel-field-name="invoiceId"/> >>> <key-map field-name="invoiceItemSeqIdTo" >>> rel-field-name="invoiceItemSeqId"/> >>> </relation> >>> @@ -1311,7 +1311,7 @@ >>> <field name="hasTable" type="indicator"></field> >>> <field name="description" type="description"></field> >>> <prim-key field="invoiceItemAssocTypeId"/> >>> - <relation type="one" fk-name="IN_ITASC_TYP_PARNT" title="Parent" >>> rel-entity-name="InvoiceItemAssocType"> >>> + <relation type="one" fk-name="INITMASCTYP_PRNT" title="Parent" >>> rel-entity-name="InvoiceItemAssocType"> >>> <key-map field-name="parentTypeId" >>> rel-field-name="invoiceItemAssocTypeId"/> >>> </relation> >>> </entity> >>> >>> >>> >> > |
Free forum by Nabble | Edit this page |