OR you can change the relevant entry(ies) in the SequenceValueItem entity's
table. After you know where you want it.
-David
Scott Gray wrote:
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
