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 >
