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
> 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
>
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
>>
>
>
>