Technical Blog Post
Abstract
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
UID
ibm11130955