• Replies 2 replies
  • Subscribers 413 subscribers
  • Views 28 views
  • Users 0 members are here
Related

Price zone error

Laura Kirk
$organization

Hello everyone,

We are new to version 12 and were trying to delete a price zone that we are no longer using in one of our maps. There are no seats assigned to it. Has anyone had this problem? Any idea of what's going on?

 

Transaction Description: Deleting zones

Transaction Error: SQLSTATE = 25000

Microsoft OLE DB Provider for SQL Server

Cannot roll back DeleteZone. No transaction or savepoint of that name was found.

SQL Statement: DBSPExec: EXECUTE IMMEDIATE :as_ExecStatement;

 

Thanks,

Laura Kirk

Yale Repertory Theatre

Parents
  • $organization

    Chris,

     

    Thank you for responding. That makes perfect sense. I hadn’t been able to sort it out yet, but I think what you represent is most likely true for our case.

     

    Best,

    Laura

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Christopher Cuhel
    Sent: Thursday, April 24, 2014 1:07 PM
    To: Kirk, Laura
    Subject: Re: [Tessitura Ticketing Forum] Price zone error

     

    Hi Laura,

    We are currently not on V12 but I have been doing some testing for our upcoming transition (May 19). I would imagine that if there are any transactions in that zone (from previous seasons) you would not be able to delete the zone. You can mark it as inactive however. I know that you are in a consortium at Yale and am also wondering if another consortium partner used that zone and map for an event. That's really the only reason I can think of why you wouldn't be able to delete a zone.

    I hope, since this post is from March, that you were able to get the problem solved.

    Best,

    Chris Cuhel

    From: Laura Kirk <bounce-laurakirk5212@tessituranetwork.com>
    Sent: 3/17/2014 9:43:01 AM

    Hello everyone,

    We are new to version 12 and were trying to delete a price zone that we are no longer using in one of our maps. There are no seats assigned to it. Has anyone had this problem? Any idea of what's going on?

     

    Transaction Description: Deleting zones

    Transaction Error: SQLSTATE = 25000

    Microsoft OLE DB Provider for SQL Server

    Cannot roll back DeleteZone. No transaction or savepoint of that name was found.

    SQL Statement: DBSPExec: EXECUTE IMMEDIATE :as_ExecStatement;

     

    Thanks,

    Laura Kirk

    Yale Repertory Theatre




    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!

Reply
  • $organization

    Chris,

     

    Thank you for responding. That makes perfect sense. I hadn’t been able to sort it out yet, but I think what you represent is most likely true for our case.

     

    Best,

    Laura

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Christopher Cuhel
    Sent: Thursday, April 24, 2014 1:07 PM
    To: Kirk, Laura
    Subject: Re: [Tessitura Ticketing Forum] Price zone error

     

    Hi Laura,

    We are currently not on V12 but I have been doing some testing for our upcoming transition (May 19). I would imagine that if there are any transactions in that zone (from previous seasons) you would not be able to delete the zone. You can mark it as inactive however. I know that you are in a consortium at Yale and am also wondering if another consortium partner used that zone and map for an event. That's really the only reason I can think of why you wouldn't be able to delete a zone.

    I hope, since this post is from March, that you were able to get the problem solved.

    Best,

    Chris Cuhel

    From: Laura Kirk <bounce-laurakirk5212@tessituranetwork.com>
    Sent: 3/17/2014 9:43:01 AM

    Hello everyone,

    We are new to version 12 and were trying to delete a price zone that we are no longer using in one of our maps. There are no seats assigned to it. Has anyone had this problem? Any idea of what's going on?

     

    Transaction Description: Deleting zones

    Transaction Error: SQLSTATE = 25000

    Microsoft OLE DB Provider for SQL Server

    Cannot roll back DeleteZone. No transaction or savepoint of that name was found.

    SQL Statement: DBSPExec: EXECUTE IMMEDIATE :as_ExecStatement;

     

    Thanks,

    Laura Kirk

    Yale Repertory Theatre




    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!

Children
No Data