Hi,
pasting first few lines of log --
It is giving Cannot insert duplicate key row in object , i wonder how it
is getting duplicate data when i am using fresh DB.
Entity: InventoryItemDetail
2009-08-07 12:06:24,187 (main) [ EntityEcaRule.java:117:INFO ] Running
Entity ECA Service:
this error looks like you need to clean your DB.
duplicate key row in object 'dbo.INVENTORY_ITEM' with unique index
'INVITEM_SOFID'.)). Rolling back transaction.
Abhijeet Pandey sent the following on 8/7/2009 2:07 AM:
Hi,
pasting first few lines of log --
It is giving Cannot insert
you have run this more than once I assume
check the db to see if it has data in the table dbo.INVENTORY_ITEM
if so you need to do a clean.
or you can just let it complete and see if you have demo data.
BJ Freeman sent the following on 8/7/2009 2:32 AM:
this error looks like you need to clean
what i did that i deleted the ofbiz database and then also it is throwing
this error.
after deletion i did ant clean-all , then i created ofbiz db again and then
i did ant run-install .
what i am missing here ? it is working fine when connected to default db,
also it is connecting with mssql ,
ant clean-all only cleans the Derby DB
it does not clean any external DB like MS-SQL.
you have to use MS-SQL tools to do this.
the fact it is inserting duplicate says it is already in the MS-SQL db
so let it run then check a page
Abhijeet Pandey sent the following on 8/7/2009 2:54 AM:
what i