I can't remember all the details off hand, but in general you shouldn't load data with keys higher than 9999. If you search nabble there was a similar discussion about a year ago.
Regards Scott On 30/06/07, Art Hughes <[EMAIL PROTECTED]> wrote:
Hi, I'm having trouble with the inventoryItemId sequence seed not being set to point to the next entry when I import data from InventoryItem.xml. E.g. I setup a new system, install ofbiz, load the seed data, bring up the system, use webtools to load my test data. When the system starts, the inventoryItemId sequence seed is "10000" with no Inventory Items, if I receive an item, the inventoryItemId="10000" for that entry. After I import new data, the last inventoryItemId="10078" in the table. If I try to receive another item, a duplicate key value error occurs and the inventoryItemId="10002" is in the data to be written. Where is this seed data stored within the system and can it be accessed to change. Thanks, Art
