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?
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 HilgersSent: Wednesday, July 06, 2011 11:42 AMTo: Gloria OrmsbySubject: [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!
That’s what I thought but no one has it open.
MH
matt_hilgers@milwaukeeartspartners.org
IM: matt_hilgers
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Gloria OrmsbySent: Wednesday, July 06, 2011 10:47 AMTo: Matt HilgersSubject: 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 HilgersSent: Wednesday, July 06, 2011 11:52 AMTo: Robert BellSubject: 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?
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Bob BellSent: Wednesday, July 06, 2011 11:07 AMTo: Matt HilgersSubject: RE: [Tessitura Technical Forum] locked in batch -1
There should be nothing to fix. The mir_lock will remain at -1 until the order is opened again and saved either online or in the client. Once the time specified by the ORDER LOCK TIMEOUT setting has elapsed, the order can be opened, and once it is opened and saved, the mir_lock will be reset appropriately.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matt HilgersSent: Wednesday, July 06, 2011 12:17 PMTo: Robert BellSubject: RE: [Tessitura Technical Forum] locked in batch -1
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
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
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
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
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