Helpfu Tip & Trick when experiencing person record issues with the PERSONANCHESTOR Maximo table

Body

Hello,

For those that do not know me, my name is Edgar Mengelberg and I have been working with the Maximo and TPAE product suite in various Support roles for over 15 years.

Recently I had a tricky issue to deal with whereby existing old data was causing problems with person records , in my case with Supervisors not being able to be added to Maximo records.

The following steps and script is a great tip and trick on how to tackle any issues around person records (in this case with supervisors) :

1. Create a backup copy of PERSONANCESTOR table.
2. Delete all records from PERSONANCESTOR table.
3. Open a command prompt, and navigate to
%MAXIMO_ROOT%\tools\maximo\internal.
Execute the "runscriptfile that recreates the PERSONANCESTOR ,so for example for Maximo 7509 ,it is the script -fV7501_37
Make sure you check for any incorrect data in the person table as well.
4. Verify that a supervisor can be added and removed from previously existing PERSON records, and check the PERSONANCESTOR table for a specific
PERSONID before adding a supervisor, after adding a supervisor, and after removing a supervisor.
Hierarchylevels 0 should be present in all three tests.

I hope this has been informative to you,if so, kindly click the Like button.

 
For further upcoming blogs on a variety of topics , be sure to follow me on DeveloperWorks  ---------> Follow me on DevWorks here!

-Edgar