• Replies 8 replies
  • Subscribers 336 subscribers
  • Views 105 views
  • Users 0 members are here
Related

PAH and Report Server alerting

Stuart McLeod
$organization

Hello out there,

Does anyone have any alerting on either Print at Home Tickets or the Report Server to email them when either goes down. Maybe once a month Print at Home Services will stop working (although the service is still running) and we won't hear about it for a day or two until someone tells us it's not working.  Same for the Report Server.  The Report Server app will not be running (I think because the server reboots instelf after an update) and we don't hear about it until a couple days later when users say they aren't getting their reports.

Parents
  • $organization

    Yes, I’d love to see them David, thank you.

     

    Stuart.Mcleod@seattleopera.org

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of David Frederick
    Sent: Tuesday, September 03, 2013 4:20 PM
    To: Stuart McLeod
    Subject: Re: [Tessitura Technical Forum] PAH and Report Server alerting

     

    Hi Stuart,

    For Report Server, I have a job that checks for scheduled reports that are scheduled in the past, but haven't been executed yet. If there are any signs of that, the job emails an administrator so that the Report Server can be checked. I provided some info on this in the same post that Heather linked to (http://www.tessituranetwork.com/Community/forums/t/8210.aspx). Both options can work, but I prefer this as even if the Report Server has a connection to the Tessitura database, that does not mean it is working properly.

    I am taking a similar approach for PAHT - i.e. running a job that will look for PAHT that are overdue. I built a stored procedure adapted from WP_GET_ORDERS_FOR_DELIVERY to find orders with pending PAHT. If the order's sub-line items were created over 30 minutes ago and still have no ticket printed, that triggers an email alert (using sp_send_dbmail). The only downside is that the code will need to be audited periodically to ensure it is still selecting pending PAHT properly.

    Both solutions are very basic, but help in identifying problems relatively quickly. I'd be happy to post them if that would help.

    Thanks,
    David

    From: Stuart McLeod <bounce-stuartmcleod2704@tessituranetwork.com>
    Sent: 9/3/2013 11:40:37 AM

    Hello out there,

    Does anyone have any alerting on either Print at Home Tickets or the Report Server to email them when either goes down. Maybe once a month Print at Home Services will stop working (although the service is still running) and we won't hear about it for a day or two until someone tells us it's not working.  Same for the Report Server.  The Report Server app will not be running (I think because the server reboots instelf after an update) and we don't hear about it until a couple days later when users say they aren't getting their reports.




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

    Yes, I’d love to see them David, thank you.

     

    Stuart.Mcleod@seattleopera.org

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of David Frederick
    Sent: Tuesday, September 03, 2013 4:20 PM
    To: Stuart McLeod
    Subject: Re: [Tessitura Technical Forum] PAH and Report Server alerting

     

    Hi Stuart,

    For Report Server, I have a job that checks for scheduled reports that are scheduled in the past, but haven't been executed yet. If there are any signs of that, the job emails an administrator so that the Report Server can be checked. I provided some info on this in the same post that Heather linked to (http://www.tessituranetwork.com/Community/forums/t/8210.aspx). Both options can work, but I prefer this as even if the Report Server has a connection to the Tessitura database, that does not mean it is working properly.

    I am taking a similar approach for PAHT - i.e. running a job that will look for PAHT that are overdue. I built a stored procedure adapted from WP_GET_ORDERS_FOR_DELIVERY to find orders with pending PAHT. If the order's sub-line items were created over 30 minutes ago and still have no ticket printed, that triggers an email alert (using sp_send_dbmail). The only downside is that the code will need to be audited periodically to ensure it is still selecting pending PAHT properly.

    Both solutions are very basic, but help in identifying problems relatively quickly. I'd be happy to post them if that would help.

    Thanks,
    David

    From: Stuart McLeod <bounce-stuartmcleod2704@tessituranetwork.com>
    Sent: 9/3/2013 11:40:37 AM

    Hello out there,

    Does anyone have any alerting on either Print at Home Tickets or the Report Server to email them when either goes down. Maybe once a month Print at Home Services will stop working (although the service is still running) and we won't hear about it for a day or two until someone tells us it's not working.  Same for the Report Server.  The Report Server app will not be running (I think because the server reboots instelf after an update) and we don't hear about it until a couple days later when users say they aren't getting their reports.




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