IBM Maximo: Integrity Check Tool
Maximo has an internal tool called Integrity Checker for data integrity and it is also a recommended tool to confirm whether some upgrade process for example was successful.
You can use it for non-upgrade purposes too, specially if you suspect your Maximo data could be corrupted, since the tool reports data integrity issues to be fixed.
Below i show some messages and how to solve
Solutions
BMXAA0443E -- Erro - BMXAA0443E -- Error - Sequence MAXVARSSEQ not setup correctly
Solution find the highest value for sequence and update sequence:
Drop Sequence LOGINTRACKINGUSEQ ; Create Sequence LOGINTRACKINGUSEQ Start With 3756493 Increment By 1 Nocache Nocycle ; Update maxsequence Set maxreserved=3756493 Where sequencename='LOGINTRACKINGUSEQ';