Random question here - TX_PERF_SEAT.locked_by - what is that? I always figured that was a batch number, but only just looked at the numbers. Clearly not batch numbers.
Random answer – I think it’s the Seat server session id for the session that has its claws in the seat, from memory.
________________________________Ken McSwain
Systems and Technology Manager
Australian Chamber Orchestra
ken.mcswain@aco.com.au
Ph +61 2 8274 3833 :: Mob +61 418 659 360 :: Fax +61 2 8274 3801
PO Box R21, Royal Exchange NSW 1225
2 East Circular Quay, Sydney NSW 2000
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Brian GrahamSent: Tuesday, 13 December 2011 15:23To: Ken McSwainSubject: [Tessitura Technical Forum] locked_by
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!
When you look at the seat map and see a locked seat, you right click and select Database Seat Number, if it is locked at the end of this screen will be a “locked_by” number. That is what you use to unlock a seat with the TP_CLEANUP_CONNECTION procedure.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ken McSwain Sent: Monday, December 12, 2011 11:53 PM To: Gloria Ormsby Subject: RE: [Tessitura Technical Forum] locked_by
________________________________ Ken McSwain
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Brian Graham Sent: Tuesday, 13 December 2011 15:23 To: Ken McSwain Subject: [Tessitura Technical Forum] locked_by
Explore the 2012 season at aco.com.au/season2012 This email is confidential. If you are not the intended recipient you must not disclose or use the information contained in it. If you have received this email in error please notify us immediately by return email and delete the document. The ACO is not responsible for any changes made to a document other than those made by the ACO or for the effect of the changes on the document's meaning. The ACO accepts no liability for any damage caused by this email or its attachments due to viruses interference, interception, corruption or unauthorised access.
Our IT dept wrote a report for the Ticketing Managers to put in the locked_by # to unlock seats. It sure beats calling up IT on their days off!