I know I'm supposed to know this but I'm not remembering today - when an order is locked in batch # -1 what does that mean exactly?
Matt,
I go in and manually update the column in t_order to unlock the order.
Update t_order
Set mir_lock = 0
Where order_no = xxxxxx
Teresa
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matt Hilgers Sent: Wednesday, July 06, 2011 11:17 AM To: Teresa Dean Subject: RE: [Tessitura Technical Forum] locked in batch -1
It does have the mir_lock of -1 but it’s been this way since at least yesterday. That’s kind of why I’m drawing a blank on fixing it, but maybe I never saw it before and that’s why I don’t remember. Will the tp_cleanup_connection root that out or do I have to use some other means?
MH
matt_hilgers@milwaukeeartspartners.org
IM: matt_hilgers
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Bob Bell Sent: Wednesday, July 06, 2011 11:07 AM To: Matt Hilgers Subject: RE: [Tessitura Technical Forum] locked in batch -1
Matt, is it that the mir_lock column for this order set to -1? If so, it means that the order was opened on the Web but the customer abandoned the order without saving it after they opened it. In this situation, the mir_lock on the order gets set to -1 and the order cannot be opened online or in the client until the time specified by the ORDER LOCK TIMEOUT T_DEFAULTS setting has elapsed. The -1 mir_lock will not automatically be reset when the ORDER LOCK TIMEOUT has passed but the order can be opened again online or in the client after the appropriate time has elapsed.
Bob
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matt Hilgers Sent: Wednesday, July 06, 2011 11:52 AM To: Robert Bell Subject: RE: [Tessitura Technical Forum] locked in batch -1
That’s what I thought but no one has it open.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Gloria Ormsby Sent: Wednesday, July 06, 2011 10:47 AM To: Matt Hilgers Subject: RE: [Tessitura Technical Forum] locked in batch -1
Usually means that someone has the same batch open on another workstation.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matt Hilgers Sent: Wednesday, July 06, 2011 11:42 AM To: Gloria Ormsby Subject: [Tessitura Technical Forum] locked in batch -1
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!