› Forums › MxLoader › Creating new locations (missing lochhierarchy ond locancestor records ) This topic has 4 replies, 2 voices, and was last updated 8 months, 1 week ago by DVaucher. Viewing 5 posts - 1 through 5 (of 5 total) Author Posts 2020-06-23 at 23:20 #19984 DVaucherParticipant When we create new location via MxLOADER there are no lochierarchy or locancestor records created. Unable to change the parent location as it throws up error. We have currently over 8000 records with no lochierarchy or locancestor records. Any Ideas how do I resolve this issue? 2020-06-23 at 23:31 #19985 janseParticipant But my suggestion to try is: – Create a Excel with data retrieve from location with parent and create sql statement llike this: insert into locancestor ( location, ancestor, systemid, siteid, orgid, locancestorid) values (‘MECSCTR’, ‘MEC’, ‘PRIMARY’, ‘MANKATO’, ‘SWG’, 7 ) insert into LOCHIERARCHY (LOCATION,PARENT,SYSTEMID,CHILDREN,SITEID,ORGID, lochierarchyid) values (‘MECSCTR’, ‘MEC’, ‘PRIMARY’, 0 , ‘MANKATO’, ‘SWG’, 17 ) First you need to understand how ancestor and lochierachy works… need to insert many record to create hierachy relationship. This is more hardcode way… you can also try to create a Objectstructure to work with this kind of relationship. This is more complicated i think. 2020-06-23 at 23:42 #19986 DVaucherParticipant Thanks Janse, I will forward this on to our Database Admin. Is there a fix or setting to apply to Maximo when creating a location via MxlOADER that it will create the records in the LOCANCESTOR and LOCHIERARCHY tables? 2020-06-24 at 00:17 #19987 janseParticipant Each project and data has its particular needs, but in my vanilla implementation I did like this and LocHierachy works very well. The end user was capable to nav throught the tree without problems. 2020-06-24 at 01:23 #19988 DVaucherParticipant Found the issue, the MxLOADER sheet had LOCHIERARCHY.PARENT LOCHIERARCHY.SYSTEMID should be PARENT SYSTEMID Author Posts Viewing 5 posts - 1 through 5 (of 5 total) You must be logged in to reply to this topic. Log In Username: Password: Keep me signed in Login with FacebookLogin with GoogleLogin with Twitter Log In You must be logged in to reply to this topic.