I can't figure out where the amHistory.lhistoryid comes from.
I read on this forum that the "AM" sequence is used for all primary key generation. I read elsewhere on this forum that the "lastid" table is used.
The highest lhistoryid value in our amHistory table is 771636110.
No sequence in our database has a value that high, nor does the "lastid" table. So I am completely at a loss as to where these values are generated.
We are using HP Asset Manager 9.62, if that helps.