So we are creating a second plant and I have already transfered my warehouses to the new plant but when I try to transfer the resources I get an error that it is assigned to an Opersation /Job Operation.
Is there way around this?? How do I move these resources to the new plant?
We’re having a similar issue. In E9 when we split one of our “Warehouses” into its own Site, we successfully transferred Resources to new Groups in the new Site. However in E10, we’re trying to move some Resources to a different Site since those production lines have moved and are running into a similar error you got, even though all existing jobs have been closed.
I have a support ticket open (CS0001638321), and the support rep is researching this with Development to see if this behavior changed between E9 and E10.2.300.15 (our current version). I’m thinking the logic changed from “Are any jobs open that use this Resource/Resource Group?” to “Are there any jobs at all that use this Resource/Resource Group?”. I’m hoping it’s a bug and we’ll still be able to transfer the Resources.
Is the resource in the resourcetimeused table? If so that is the job/operation assignment you will need to clear.
yes we do have open jobs.
I am going to open a ticket too and see what they say. I mean these jobs need to be transferred too so I would think there would be an easier way to move them too.
How do I clear that? What will that break?
If you unschedule the jobs they should remove the resources from resourcetimeused and then you should hopefully be able to move the resources if that is the problem.
The other thing that should work is changing the resources on the job to something else, transfer the resources and then change them back
You will need to change the resources on ALL jobs (including closed jobs) to move the resources. My case from 2019 was CS0001638321 and the feedback from development was that this was an intended change to block moving a resource to another site after it’s been used in any of these tables:
• ShopLoad
• ResourceTimeUsed (Resource was scheduled)
• JobOpDtl (Scheduled resource of job operation in Job Entry)
• OpMasDtl (Scheduled resource of operation in Operation Entry)
@tsmith @jkane Thanks. I thought deleting my post would not show that I had revived this. I did find a post on EpicWeb that outlines the tables you show and I have an existing change resource group routine for jobs that I used to move the jobs that updates JobOpDtl and ResourceTimeUsed. I have another dashboard to move resources to another resource group so I can run ShopCaps and it clears them all out.
I did two in test last night and I think I have a way to move all twelve RGs and 500 jobs in one pass which I will need when I do this in live.
Loads more for me to learn about multi plant, so I can teach them how this will all work in a couple of months.
