way to clean the DB

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

way to clean the DB

Patrick-4
I was trying to figure out entity creation and I created some unwanted
constraints for this entity PartyFacility.  Then I added some rows,
then I deleted some constraints, and restarted ofbiz.  But I think
some of the old rows which were created under the other constraints
are causing trouble.  I have a really simple entity now, when I name
it to PartyFacility1 I can do inserts, but if I rename it and restart
ofBiz I can't do inserts even though its the exact same entity and it
is as simple as possible, 1 primary key, two other fields that are not
foreign keys.  So is there a way to clean the DB or something like
that ?  Thanks
Patrick
Reply | Threaded
Open this post in threaded view
|

Re: way to clean the DB

BJ Freeman
https://localhost:8443/webtools/control/view/checkdb
should fit the bill.
then you can remove the records


=========================
BJ Freeman
http://bjfreeman.elance.com
Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=93>
Specialtymarket.com <http://www.specialtymarket.com/>

Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man
Linkedin
<http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro>


Patrick sent the following on 3/26/2010 3:20 PM:

> I was trying to figure out entity creation and I created some unwanted
> constraints for this entity PartyFacility.  Then I added some rows,
> then I deleted some constraints, and restarted ofbiz.  But I think
> some of the old rows which were created under the other constraints
> are causing trouble.  I have a really simple entity now, when I name
> it to PartyFacility1 I can do inserts, but if I rename it and restart
> ofBiz I can't do inserts even though its the exact same entity and it
> is as simple as possible, 1 primary key, two other fields that are not
> foreign keys.  So is there a way to clean the DB or something like
> that ?  Thanks
> Patrick
>


Reply | Threaded
Open this post in threaded view
|

Re: way to clean the DB

Patrick-4
Thanks! :)

On Fri, Mar 26, 2010 at 6:07 PM, BJ Freeman <[hidden email]> wrote:

> https://localhost:8443/webtools/control/view/checkdb
> should fit the bill.
> then you can remove the records
>
>
> =========================
> BJ Freeman
> http://bjfreeman.elance.com
> Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=93>
> Specialtymarket.com <http://www.specialtymarket.com/>
>
> Systems Integrator-- Glad to Assist
>
> Chat  Y! messenger: bjfr33man
> Linkedin
> <http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro>
>
>
> Patrick sent the following on 3/26/2010 3:20 PM:
>> I was trying to figure out entity creation and I created some unwanted
>> constraints for this entity PartyFacility.  Then I added some rows,
>> then I deleted some constraints, and restarted ofbiz.  But I think
>> some of the old rows which were created under the other constraints
>> are causing trouble.  I have a really simple entity now, when I name
>> it to PartyFacility1 I can do inserts, but if I rename it and restart
>> ofBiz I can't do inserts even though its the exact same entity and it
>> is as simple as possible, 1 primary key, two other fields that are not
>> foreign keys.  So is there a way to clean the DB or something like
>> that ?  Thanks
>> Patrick
>>
>
>
>