Have you experienced some issue scenario where after spending some time investigating, the only option left is to consider that the maximo tables data integrity is likely incorrect ? If so, do you know how you can do that ?
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.
Please follow the instructions below for info and steps on how to run Maximo Integrity Checker. (Below are instructions for running it for version 7.6, but it also applies to 7.5)
Before proceeding further with the Maximo Asset Management 7.6 upgrade process, you need to run the Maximo Asset Management 7.6 Integrity Checker utility to confirm the integrity of the Maximo Asset Management 7.6 database after the upgrade steps have been completed.
When run in Report mode, the integrity checker utility checks the current database and reports on common errors.
If the Integrity Checker reports an error, you must resolve it by running the Integrity Checker in Repair mode.
NOTE : You must have a database backup before running the Integrity Checker tool.
1- Stop the application server. For example, MXServer.
2- From the administrative workstation of the existing deployment, open a command prompt and change directory to the maximo tools directory. For example, c:\ibm\SMP\maximo\tools\maximo
3- Start the Integrity Checker tool: integrityui.bat
4- Select the Check Integrity tab
5- Run the Integrity Checker in Report mode (Ensure that the Repair Mode? check box is cleared, and then click Run Integrity Checker).
6- When the report dialog box appears, click OK.
Results are found in the install dir\maximo\tools\maximo\log directory in the file defined in the Log File Name field of the Check Integrity panel.
Optional: If any errors are reported, run the Integrity Checker in Repair mode.
A- Select the Repair Mode? check box, and then click Run Integrity Checker.
B- When the report dialog box appears, click OK.
Optional: If Integrity Checker was run in Repair mode, check the log file to ensure all reported items have been repaired.
If further manual intervention is required, you must resolve the errors and then rerun the Integrity Checker in Report mode.
Repeat the process until no more errors are reported.
While the Integrity Checker can repair many issues, you might have to resolve some errors manually by consulting the log files.