Hi Henrik,
I have solved the issue to create object structure to LOCHIERARCHY table and then run "Delete" to all locations that you want to delete (sort locations according to children, the lowest level should be deleted first, children=0)
When all systems have been deleted then normally delete locations by MXLoader.
BR,
Ari
------------------------------
Ari Saaranluoma
Fortum
------------------------------
Original Message:
Sent: 05-11-2024 09:41
From: HENRIK SÖDER
Subject: Can I delete locations added in multiple systems/hierarchys?
I need to delete approx 1300 locations!
It's not possible to run delete in MxLoader (Error 400: BMXAA2719E - Locations belonging to more than one system cannot be deleted)
Can I use MxLoader to delete connection to one (or both) of the system/hierarchy and then run delete as usual?
I do not have access to db otherwise I just run an sql script to delete the connection to one of the sustems in locancestor and lochierarchy tables.
I don't want to go in on every single location and delete the system that would take days.
------------------------------
HENRIK SÖDER
Quale Consulting AB
------------------------------