Reservation Entry Table Entry no. exceeded

SaravananA

HI all,

Our reservation entry no exceeds the integer value range(ie. -2147483647
to +2147483647). So, we are not able to process any thing line Purchase order, Transfer order, Sales order etc. Any solution for this kindly help us.

With regards,
Saravanan

kine

Hmmm... interesting...

I see two ways: changing from Integer to BigInteger datatype with all side effects (like need to change all variables working with this field)
or making some batch which will "compress" the entries to begin from number 1 (move all existing entries to beginning, renumbering all possible relations to this no. if any). I think there is no much table relations to Entry No. on Reservation entry in the system...

garak

is there some customized code where you set maybe a wrong "Entry No."? Or is there no customized code?
How many reservations do you have? Are there some old reservation, that are not needed?

So, if there is no source, you had 2 option. As i can see, Kamil has discribed both :-)
There are 3 Table Realtions to this table:

337 Reservation Entry (the table self)
99000849 Action Message Entry
99008533 BizTalk Reservation Entry