IBM Maximo: Integrity Check Tool: Difference between revisions
(Criou a página com "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....") |
|||
| Line 5: | Line 5: | ||
Below i show some messages and how to solve | Below i show some messages and how to solve | ||
= Solutions = | = 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'; | |||
* [[IBM Maximo: Java code to check and update sequence]] | |||
* [https://www.ibm.com/support/pages/integrity-checker-sequence-not-setup-correctly Integrity Checker - Sequence not setup correctly] | |||
== BMXAA6292E Records exist in the Wogen table which need be deleted. == | == BMXAA6292E Records exist in the Wogen table which need be deleted. == | ||
| Line 11: | Line 23: | ||
* [https://www.ibm.com/support/pages/wogen-table-data-growing-exponentially WOGEN table data growing exponentially] | * [https://www.ibm.com/support/pages/wogen-table-data-growing-exponentially WOGEN table data growing exponentially] | ||
= Ver também = | = Ver também = | ||
Latest revision as of 18:47, 6 July 2023
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';