• Replies 8 replies
  • Subscribers 417 subscribers
  • Views 552 views
  • Users 0 members are here
Related

Seat locked in online order

Maurice Nounou
$organization

Hey,

Has anyone using TNEW experienced a seat being locked into an online order (purple) that doesn't time out after the specified time allotted? If so, does anyone know of a way to force it to be released? I can't access the order, and no patron information shows.

Thanks,

Maurice

  • $organization

    Good morning Maurice,

    We have encountered this issue on a number of occasions and I believe that there are some shared reports available through TASK that can be run to unlock the seats.

    CD Web Current Seat Locks (Report #171)
    - This report identifies the locked seats by Season

    Cleanup Connection (Report #170)
    - This utility unlocks seats by the Locked by Number


    Hope that helps!
    Short 



    [edited by: Christopher Short at 12:32 PM (GMT -6) on 17 Jul 2014] Corrected (swapped) Report #'s based on Nick Reilingh's comments.
  • $organization

    Once you know the performance and seat_no you can use TP_NEW_RELEASE_LOCKED_SEATS, from TX_Perf_Seat.

     

  • $organization

    Hi Maurice,

    I'm not on TNEW but we've had to do the same thing here from time to time. If you are in the seat map you can right click on the seat and select Database Seat No from the menu. There you should see a Locked By = #### number. You can then run TP_CLEANUP_CONNECTION with that number as the parameter in SQL Server Management Studio.

    Hope that helps!

  • $organization in reply to Christopher Short

    Chris,

    Just went looking for these reports and it looks like your report solution numbers are switched -- might want to edit that for future reference?

    Thanks though; Cleanup connection (170) was exactly what I was looking for.

  • $organization in reply to Nick Reilingh

    Thanks, Nick!  I've edited the post accordingly.

    Glad this solution worked.

  • $organization

    The #170 one, will that work with our Web since it is different?  Just thinking out or rather “writing” out loud!!!

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Nick Reilingh
    Sent: Thursday, July 17, 2014 1:15 PM
    To: Vantine, Anne M
    Subject: Re: [Tessitura Ticketing Forum] Seat locked in online order

     

    Chris,

    Just went looking for these reports and it looks like your report solution numbers are switched -- might want to edit that for future reference?

    Thanks though; Cleanup connection (170) was exactly what I was looking for.

    From: Christopher Short <bounce-christophershort8349@tessituranetwork.com>
    Sent: 5/7/2014 11:43:44 AM

    Good morning Maurice,

    We have encountered this issue on a number of occasions and I believe that there are some shared reports available through TASK that can be run to unlock the seats.

    CD Web Current Seat Locks (Report #170)
    - This report identifies the locked seats by Season

    Cleanup Connection (Report #171)
    - This utility unlocks seats by the Locked by Number


    Hope that helps!
    Short 




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!



    This e-mail message is intended only for the recipient(s) named above. This message may contain trade secrets, attorney-client communication, or other privileged and confidential information. Any review, re-transmission, dissemination, reproduction or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the Sender and delete the material from any computer.
  • $organization in reply to Deborah Glover

    You know, I'm not sure.  I have a feeling it will because we were using this custom report before we were TNEW users but it might be worth a TASK ticket to get Support's take on this.