primary key field sequence generator seed

[Art Hughes <ar...@vibralung.com>]

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

Re: primary key field sequence generator seed

[David E Jones <jo...@hotwaxmedia.com>]

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 <ar...@vibralung.com> 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
>>
>>
>>
>>
> 

Re: primary key field sequence generator seed

[Scott Gray <le...@gmail.com>]

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 <ar...@vibralung.com> 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
>
>
>
>