Maximo

 View Only

 Database Error Number 1 BMXAA4211E (SEQUENCE)

Jabree Clark's profile image
Jabree Clark posted 08/04/26 02:53 PM

I'm receiving this error when trying to save a record "BMXAA4211E - Database error number 1 has occurred when operating on INGRANTVIEW : Contract=21193 Revision=0 Organization=USCG. Report the error to the owner of the deployment."

So I read that I had to get the sequence synced up since the MAX_ID was 37540 and the SEQUENCE_VAL was 3263. I was able to reset the sequence and got the MAXRESERVED set to 37541, but somehow still getting the error.

Julio Perera's profile image
Julio Perera IBM Champions posted 08/17/26 03:54 PM

Hi Jabree:

If this is Oracle (which looks like due to your error 1), Maximo actually uses a database sequence (that will need to be updated with ALTER SEQUENCE). And you should still update MAXSEQUENCE as per above.

Also, I see it is named like a View, so it may be that the combinations of fields there already exist (CONTRACTNUM, REVISIONNUM, ORGID, etc.), check the Unique Indexes on the base table to get an idea as it may not be necessarily the surrogate key (but according to what you did above, it probably is as it was out of sync with the data).

Thanks

Related Content