• Replies 4 replies
  • Subscribers 414 subscribers
  • Views 95 views
  • Users 0 members are here
Related

Trying to delete a facility but failing!

Paul White
$organization

Hello.

We're trying to delete a Facility that was set up a while ago however we can't get rid of it.

We've managed to delete most of it, but when we try and remove 'Price Maps'  we get this Impresario Error:

 

"Transaction Description: Deleting price zone map

Transaction Error: SQLSTATE = 23000

Microsoft OLE DB Provider for SQL Server

The DELETE statement conflicted with the REFERENCE constraint "FK_T_WEB_SLI_DETAIL_T_PMAP". The conflict occurred in database "impresario", table "dbo.T_WEB_SLI_DETAIL", column 'pmap_no'.

SQL Statement: DBSPExec: EXECUTE IMMEDIATE :as_ExecStatement;"

 

Is it an actual error or just a roundabout way for Tessitura to say ‘I’m sorry, I can’t do that, Dave’?

Parents
  • $organization

    Hi Paul,

     

    Have you used this facility for ticket sales? Sounds to me like there are sales in the database that have a reference to the price map you are trying to delete. Sorry Dave…

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Paul White
    Sent: 16 August 2011 17:02
    To: Halliday, Gary
    Subject: [Tessitura Ticketing Forum] Trying to delete a facility but failing!

     

    Hello.

    We're trying to delete a Facility that was set up a while ago however we can't get rid of it.

    We've managed to delete most of it, but when we try and remove 'Price Maps'  we get this Impresario Error:

     

    "Transaction Description: Deleting price zone map

    Transaction Error: SQLSTATE = 23000

    Microsoft OLE DB Provider for SQL Server

    The DELETE statement conflicted with the REFERENCE constraint "FK_T_WEB_SLI_DETAIL_T_PMAP". The conflict occurred in database "impresario", table "dbo.T_WEB_SLI_DETAIL", column 'pmap_no'.

    SQL Statement: DBSPExec: EXECUTE IMMEDIATE :as_ExecStatement;"

     

    Is it an actual error or just a roundabout way for Tessitura to say ‘I’m sorry, I can’t do that, Dave’?




    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!


    www.southbankcentre.co.uk

    Ticket Office: 0844 847 9910

    Southbank Centre is a Registered Charity No. 298909

    ______________________________________________________________________

    This message (and files transmitted with it) may contain confidential or copyright information. If you receive it in error, please notify the sender and delete it from your computer.

    _______________________________________________________________________
  • $organization in reply to Gary Halliday

    Hi Gary,

    That's exactly it, yep.  Basically we were under a really tight deadline with a new website, so to save time the decision was made to have the facility for testing set up on Live instead instead of Test (I know!), so that when it was working we didn't have to rebuild it on Live. (This was not my decision BTW!)

    Explains why we've not had that error before though.

    Thanks.

     

Reply
  • $organization in reply to Gary Halliday

    Hi Gary,

    That's exactly it, yep.  Basically we were under a really tight deadline with a new website, so to save time the decision was made to have the facility for testing set up on Live instead instead of Test (I know!), so that when it was working we didn't have to rebuild it on Live. (This was not my decision BTW!)

    Explains why we've not had that error before though.

    Thanks.

     

Children
No Data