You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Daniel Kunkel <Da...@BioWaves.com> on 2007/02/23 09:04:34 UTC
Re: Entity issue: ??? exists in the database but has no
corresponding entity
Hi
Those log warnings are saying elements in the database that used to be
required are no longer needed. It's not a critical error, but just a
few extra unnecessary fields.
But, back to the issue at hand. What database are you using?
If you're using the default derby database, the clean-all should delete
all of the data (stored in the framework/data directory)
If you're using some other database, I don't believe the clear-all
deletes all the data from the database. (I could be wrong on this, but
the behavior your seeing suggests this might to be the case.)
Daniel
On Thu, 2007-02-22 at 18:51 -0800, Sotomayor, Luis wrote:
> Hi,
>
>
>
> We've been using OFBiz for a few months now and just noticed the
> following warnings in the log file:
>
>
>
> 2007-02-22 18:35:43,228 (main) [ DatabaseUtil.java:372:WARN ]
> Table named [OFBIZ.ACCTG_TRANS] exists in the database but has no
> corresponding entity
>
> 2007-02-22 18:35:43,228 (main) [ DatabaseUtil.java:372:WARN ]
> Table named [OFBIZ.ACCTG_TRANS_ATTRIBUTE] exists in the database but has
> no corresponding entity
>
> 2007-02-22 18:35:43,228 (main) [ DatabaseUtil.java:372:WARN ]
> Table named [OFBIZ.ACCTG_TRANS_ENTRY] exists in the database but has no
> corresponding entity
>
> 2007-02-22 18:35:43,244 (main) [ DatabaseUtil.java:372:WARN ]
> Table named [OFBIZ.ACCTG_TRANS_ENTRY_TYPE] exists in the database but
> has no corresponding entity
>
> 2007-02-22 18:35:43,244 (main) [ DatabaseUtil.java:372:WARN ]
> Table named [OFBIZ.ACCTG_TRANS_TYPE] exists in the database but has no
> corresponding entity
>
> 2007-02-22 18:35:43,244 (main) [ DatabaseUtil.java:372:WARN ]
> Table named [OFBIZ.ACCTG_TRANS_TYPE_ATTR] exists in the database but has
> no corresponding entity
>
> ...
>
>
>
> This is exactly what I did:
>
>
>
> 1) ant clean-all
>
> 2) ant run-install
>
> 3) ant run-tests
>
>
>
> I was using the Derby database. We did create a component in the
> hot-deploy folder, but that component seems to be working as expected.
>
>
>
> Does anyone have any insight into the cause of this problem? Everything
> seems to be working - the unit tests run, the web application runs,
> entities can be created and updated - but the warning is still present.
>
>
>
> Thanks in advance.
>
>
>
> Luis
>
--
Daniel
*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-
Have a GREAT Day!
Daniel Kunkel DanielKunkel@BioWaves.com
BioWaves, LLC http://www.BioWaves.com
14150 NE 20th St. Suite F1
Bellevue, WA 98007
800-734-3588 425-895-0050
http://www.Apartment-Pets.com http://www.Illusion-Optical.com
http://www.Card-Offer.com http://www.RackWine.com
http://www.JokesBlonde.com http://www.Brain-Fun.com
*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-
Re: Entity issue: ??? exists in the database but has nocorresponding
entity
Posted by Jacques Le Roux <ja...@les7arts.com>.
> Hi
>
> Those log warnings are saying elements in the database that used to be
> required are no longer needed. It's not a critical error, but just a
> few extra unnecessary fields.
>
> But, back to the issue at hand. What database are you using?
>
> If you're using the default derby database, the clean-all should delete
> all of the data (stored in the framework/data directory)
>
> If you're using some other database, I don't believe the clear-all
> deletes all the data from the database. (I could be wrong on this, but
> the behavior your seeing suggests this might to be the case.)
You are right Daniel, clean-all or clean-data (more appropriate, faster) take only care of Derby and HSQL (in HSQL case some scraps
remains). With DB such than PostGres or MySql you should use tools like pgAdminIII or MySql Administrator.
Jacques
> Daniel
>
>
>
> On Thu, 2007-02-22 at 18:51 -0800, Sotomayor, Luis wrote:
> > Hi,
> >
> >
> >
> > We've been using OFBiz for a few months now and just noticed the
> > following warnings in the log file:
> >
> >
> >
> > 2007-02-22 18:35:43,228 (main) [ DatabaseUtil.java:372:WARN ]
> > Table named [OFBIZ.ACCTG_TRANS] exists in the database but has no
> > corresponding entity
> >
> > 2007-02-22 18:35:43,228 (main) [ DatabaseUtil.java:372:WARN ]
> > Table named [OFBIZ.ACCTG_TRANS_ATTRIBUTE] exists in the database but has
> > no corresponding entity
> >
> > 2007-02-22 18:35:43,228 (main) [ DatabaseUtil.java:372:WARN ]
> > Table named [OFBIZ.ACCTG_TRANS_ENTRY] exists in the database but has no
> > corresponding entity
> >
> > 2007-02-22 18:35:43,244 (main) [ DatabaseUtil.java:372:WARN ]
> > Table named [OFBIZ.ACCTG_TRANS_ENTRY_TYPE] exists in the database but
> > has no corresponding entity
> >
> > 2007-02-22 18:35:43,244 (main) [ DatabaseUtil.java:372:WARN ]
> > Table named [OFBIZ.ACCTG_TRANS_TYPE] exists in the database but has no
> > corresponding entity
> >
> > 2007-02-22 18:35:43,244 (main) [ DatabaseUtil.java:372:WARN ]
> > Table named [OFBIZ.ACCTG_TRANS_TYPE_ATTR] exists in the database but has
> > no corresponding entity
> >
> > ...
> >
> >
> >
> > This is exactly what I did:
> >
> >
> >
> > 1) ant clean-all
> >
> > 2) ant run-install
> >
> > 3) ant run-tests
> >
> >
> >
> > I was using the Derby database. We did create a component in the
> > hot-deploy folder, but that component seems to be working as expected.
> >
> >
> >
> > Does anyone have any insight into the cause of this problem? Everything
> > seems to be working - the unit tests run, the web application runs,
> > entities can be created and updated - but the warning is still present.
> >
> >
> >
> > Thanks in advance.
> >
> >
> >
> > Luis
> >
> --
> Daniel
>
> *-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-
> Have a GREAT Day!
>
> Daniel Kunkel DanielKunkel@BioWaves.com
> BioWaves, LLC http://www.BioWaves.com
> 14150 NE 20th St. Suite F1
> Bellevue, WA 98007
> 800-734-3588 425-895-0050
> http://www.Apartment-Pets.com http://www.Illusion-Optical.com
> http://www.Card-Offer.com http://www.RackWine.com
> http://www.JokesBlonde.com http://www.Brain-Fun.com
> *-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-