Price Templates not working for a specific Zone Map?

Hello all,

I suspect this will require a TASK ticket, but has anyone gotten an error when trying to browse Price Templates on a specific Zone Map? The error is below, and only happens to a relatively new Zone Map.

Cheers,

Nicholas

controller_pricing_grid.gettemplateprices.10: TemplatePriceCacheEntity did not contain a perfPrice with a zone id of:4121

Parents
  • Hi Joshua,

    I submitted a ticket recently about the same issue.  I had copied a zone map and was able to add a template, but once I saved and tried to reopen that specific template, Tessitura would crash.   So, here’s the response I received from Tessitura:

    This looks like it may be caused by a previously reported defect. Specifically, we've seen errors like this one pop up when a zone had been deleted or added from a facility that was used for a Price Template. Meaning, making changes to a price zone from Facility Manager, or copying a zone from Facility Manager, then making changes from that copied zone and building a Price Template using that 'new' zone. Could that be what is happening here? If so, the fix for this is to delete the template via SQL and start again.

    If you can delete the price templates, Tessitura should stop crashing on you.  The frustrating part is that you’ll have to rebuild your zone maps and price templates.

     

    Good luck!

     

    Janelle Cabrera Torres

    Database Support Technician

    135 North Grand Ave, Los Angeles, CA 90012

    T: 213 972 7203 | F: 213 972 8001 | E: jtorres@laopera.org

     

    LAO-Sig-2015


    This email and any attachments may contain privileged or confidential material and is solely for the use of the intended recipient(s). If you have received this email in error, please notify the sender immediately, delete this email, and do not use, retain or disclose any information contained in this email. Any views or opinions are solely those of the sender and do not necessarily represent those of LA Opera.  LA Opera does not guarantee that this email or any attachments are free from viruses or 100% secure.  Unless expressly stated in the body of the text of the email, this email is not intended to form a binding contract.

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Joshua Forward
    Sent: Tuesday, January 05, 2016 3:49 PM
    To: Janelle Torres <jtorres@laopera.org>
    Subject: Re: [Tessitura Ticketing Forum] Price Templates not working for a specific Zone Map?

     

    Hi Nicholas,

    Before I lodge my own ticket, can you let me know if there's a quick fix or something stupid I'm not doing?

    Keeps crashing my Tess too when I get the same error message.

    thanks,

    Josh

    From: Nicholas Hudson-Ellis <bounce-nicholashudsonellis2615@tessituranetwork.com>
    Sent: 8/5/2014 2:19:59 AM

    Hello all,

    I suspect this will require a TASK ticket, but has anyone gotten an error when trying to browse Price Templates on a specific Zone Map? The error is below, and only happens to a relatively new Zone Map.

    Cheers,

    Nicholas

    controller_pricing_grid.gettemplateprices.10: TemplatePriceCacheEntity did not contain a perfPrice with a zone id of:4121




    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
  • Hi Joshua,

    I submitted a ticket recently about the same issue.  I had copied a zone map and was able to add a template, but once I saved and tried to reopen that specific template, Tessitura would crash.   So, here’s the response I received from Tessitura:

    This looks like it may be caused by a previously reported defect. Specifically, we've seen errors like this one pop up when a zone had been deleted or added from a facility that was used for a Price Template. Meaning, making changes to a price zone from Facility Manager, or copying a zone from Facility Manager, then making changes from that copied zone and building a Price Template using that 'new' zone. Could that be what is happening here? If so, the fix for this is to delete the template via SQL and start again.

    If you can delete the price templates, Tessitura should stop crashing on you.  The frustrating part is that you’ll have to rebuild your zone maps and price templates.

     

    Good luck!

     

    Janelle Cabrera Torres

    Database Support Technician

    135 North Grand Ave, Los Angeles, CA 90012

    T: 213 972 7203 | F: 213 972 8001 | E: jtorres@laopera.org

     

    LAO-Sig-2015


    This email and any attachments may contain privileged or confidential material and is solely for the use of the intended recipient(s). If you have received this email in error, please notify the sender immediately, delete this email, and do not use, retain or disclose any information contained in this email. Any views or opinions are solely those of the sender and do not necessarily represent those of LA Opera.  LA Opera does not guarantee that this email or any attachments are free from viruses or 100% secure.  Unless expressly stated in the body of the text of the email, this email is not intended to form a binding contract.

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Joshua Forward
    Sent: Tuesday, January 05, 2016 3:49 PM
    To: Janelle Torres <jtorres@laopera.org>
    Subject: Re: [Tessitura Ticketing Forum] Price Templates not working for a specific Zone Map?

     

    Hi Nicholas,

    Before I lodge my own ticket, can you let me know if there's a quick fix or something stupid I'm not doing?

    Keeps crashing my Tess too when I get the same error message.

    thanks,

    Josh

    From: Nicholas Hudson-Ellis <bounce-nicholashudsonellis2615@tessituranetwork.com>
    Sent: 8/5/2014 2:19:59 AM

    Hello all,

    I suspect this will require a TASK ticket, but has anyone gotten an error when trying to browse Price Templates on a specific Zone Map? The error is below, and only happens to a relatively new Zone Map.

    Cheers,

    Nicholas

    controller_pricing_grid.gettemplateprices.10: TemplatePriceCacheEntity did not contain a perfPrice with a zone id of:4121




    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