Deleting Unsold Performances and Price Layers

Deleting Unsold Performances and Price Layers

If tickets have not been sold into a performance, it can be deleted by:
1. Locating the performance in Ticketing Setup>>Production Elements>>Performances
2. Clicking to highlight the performance
3. Clicking the "Delete" button at the bottom of the screen


Similarly, if tickets have not been sold into a performance and one or more pricing layers needs to be deleted, that can be done by:
1. Locating the performance in Ticketing Setup>>Production Elements>>Performances
2. Double-clicking on the performance
3. Clicking on the "Pricing" tab in the performance setup screen
4. Clicking on the price layer tab that needs to be deleted
5. Right-clicking anywhere on the price layer and selecting "Delete Layer" in the window that pops up.



ALERT: Occasionally an error may pop up when attempting either of the above procedures for an unsold performance. The error message will say something similar to:

"Delete performance failed for 86456: The DELETE statement conflicted with the REFERENCE constraint "FK_T_WEB_SLI_DETAIL_T_PERF_PRICE_TYPE". The conflict occurred in database "impresario", table "dbo.T_WEB_SLI_DETAIL", column 'pmap_no'. (Error 547 in TP_DELETE_PERFORMANCE[67], Severity 16, State 0)"

OR

"Database reference constraint check failed. Please check that the referenced table id is correct and the corresponding value exists in the database."

These error messages mean that most likely a temporary order exists somewhere in the database for the performance. These temporary orders are not visible from the application and are often created when someone navigates to the performance online and adds it to their cart (typically during testing). Even if they didn't actually checkout and purchase tickets, the performance is still associated with a temporary order and; therefore, cannot be deleted.

Temporary orders are cleared automatically every two weeks, so in these instances:
1. Locate the performance in Ticketing Setup>>Production Elements>>Performances
2. Double-clicking on the performance
3. Un-check the "On Sale" box to take the performance off sale

4. Wait for two weeks until all temporary orders have cleared and then attempt to delete the price layer and/or performance again.

If an error message still appears, please submit a support ticket so the support team can help troubleshoot.

    • Related Articles

    • Address Verification Service (AVS) Configuration

      The following article outlines the steps necessary to enable Address Verification Services (AVS) on the hosted payment page of your TNEW site as well as in the Tessitura application. AVS is a tool provided by credit card processors and issuing banks ...

    • Education and the Consortium

      The following article includes the resources available to users regarding Education setup and selling in the Consortium. Selling Education Sessions in Tessitura – PRAC In order to setup your Education season in Tessitura, it is highly recommended to ...

    • (New) Bookings for Private Instructions

      The following article outlines customized functionality to use Resource Scheduling and Bookings for Private Instructions. When building a Private Instruction product under Ticketing Setup-->Performances, add the following under the Content Tab: ...