OFBiz › OFBiz - User

Entity issue: ??? exists in the database but has no corresponding entity

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

3 messages Options

Sotomayor, Luis

Entity issue: ??? exists in the database but has no corresponding entity

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 Kunkel

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 [hidden email]
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
*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-

Jacques Le Roux

Re: Entity issue: ??? exists in the database but has nocorresponding entity

Administrator

> 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 [hidden email]
> 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
> *-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-