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

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

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

Sotomayor, Luis
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

Reply | Threaded
Open this post in threaded view
|

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

Daniel Kunkel
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 
*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-

Reply | Threaded
Open this post in threaded view
|

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

Jacques Le Roux
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
> *-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-