how to fix a Stuck WORK (one line is CLOSED and one OPEN) with no access to SQL

(0) Share

Report

Posted on by Abdo Khoury

14,855

Dear

i have a work that is stuck , one line is CLOSED and the other is OPEN, the location is missing and the user on the device is missing (see attached screen shot) , as a result the QTY 4 on this item is stuck on this user location AA,

is there any way i can cancel this or make it complete ,

note that the system doesn't let me complete it manually because location and user ID are missing

and we are on the production environment so there is no SQL

any idea how i can fix this situation

I have the same question (0)

All responses (5)

Answers (0)

Zain Mehmood 4,173 Most Valuable Professional on at

Like (0)

Report

RE: how to fix a Stuck WORK (one line is CLOSED and one OPEN) with no access to SQL

Hi Angelo Russo,

Didn't you turn on the parameter for location directives in case if the location isn't found system should thrown an error.

Regards,

Zain

Was this reply helpful? Yes No
Guy Terry 28,886 Moderator on at

Like (2)

Report

RE: how to fix a Stuck WORK (one line is CLOSED and one OPEN) with no access to SQL

Create a mobile device menu item with Mode = Work and Use existing work = Yes. Set Directed by to User directed, and do not add any Work classes to the menu item.

Sign on to a mobile device as worker aa, and select the new mobile device menu item. Enter the Work Id. The mobile device will ask for a Put location, which you must provide.

Was this reply helpful? Yes No
Ivan (Vanya) Kashperuk on at

Like (0)

Report

RE: how to fix a Stuck WORK (one line is CLOSED and one OPEN) with no access to SQL

Agree with Guy, this is not actually "Stuck", just a normal work that someone picked up, and never put down.

Find that user and ask him to "put it down", using the menu item as Guy suggests.

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

RE: how to fix a Stuck WORK (one line is CLOSED and one OPEN) with no access to SQL

additionally in PU31, new feature in work management is expected to stop/close centrally

Was this reply helpful? Yes No
Ivan (Vanya) Kashperuk on at

Like (0)

Report

RE: how to fix a Stuck WORK (one line is CLOSED and one OPEN) with no access to SQL

what feature is that?

Was this reply helpful? Yes No