Thought I’d check in here first before creating an Epicor ticket to see if anyone has had this issue in the past. It’s not very urgent because the issue that caused me to need to use this tool don’t happen very often, and I am not the only one who can fix it. My user seems to have broken as far as locking and unlocking ECO Groups. Other users can interact with the group fine. Using a client on a different machine does not fix the issue.
Discovery: An absent person had an ECO Group locked. We have an “unjammer” query I was unaware of, so I did it the old fashioned way, reset password of user, went in and checked it in the part, closed the workbench, and notified user they will need to come to me for a password reset on Monday. I then went on my user to test that it was in fact unlocked, and I was able to open it up fine. After closing it, it would not release it from being locked by me. I tried all sorts of actions to get it to resolve, including checking an entire part out and back in to see if it needed something to tie to it. I don’t need to use this screen often, as things tend to work pretty smoothly for the users.
I was then informed about our unjammer tool, which uses EngWorkBench.UpdateExt as the update processing method in query designer. Using this tool in either the deployed dashboard or the query designer freezes the entire client and no changes occur. It is supposed to simply uncheck the locked, switch the lockedby (which I think mimics the behavior of checking it out, from the user updating the record as they would by opening it), then it allows us to go into Engineering Workbench with the group switched over to us and unlock it properly by closing the workbench as normal. I should note there are no applicable BPMs on the Update method, and no bpms at all on specifically the UpdateExt method.
This process is freezing on my user alone. I have full rights and groups on my account, and another user was able to use this tool without problem.
Having an eco group get stuck on my name only occurred the once, on that group in question. I have been able to lock to other groups and unlock again upon close.
Our tool for unjamming however, is not allowing me to take over any groups and freezing. It also will not let me unlock any groups.
Good idea about trying DMT although it would be inconvenient if I always had to use it, however it surprisingly also sits running but never completes or errors on the record.
It’s not related to the Guid error, that one we know well here (markb_wi is from the same business unit). We have developed a few screens for removing bad records from specific groups’ eco tables, but this seems to occur with any group I attempt to unlock.
Likewise, I do not believe the table cleanup would help this because of a few factors;
It seems like an issue isolated to my user. If I use a different user, or someone else unlocks it, it works fine.
This is specific to the ecogroup table but any group, parts are able to be checked out and in on the groups fine, and it isn’t replicated across the other users like you’d expect if the record was slow to reference or something. And it seems to be specific to locking / unlocking. Doing other activities such as changing the ECO Rev table, etc seem to not be affected.
I could try cleaning the tables relating to the current record I’m trying to unlock, maybe the EngineeringWorkbench BO is getting hung up on something from a different table. Just don’t know why it would seem indifferent to what record I was trying to change.
