• Replies 8 replies
  • Subscribers 336 subscribers
  • Views 103 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.

  • $organization

    Hey Stuart -

    Check out this thread.. I did something similar based on Renville's solution.

    http://www.tessituranetwork.com/Community/forums/t/8210.aspx

    Heather

  • $organization

    Stuart,

    It's hard to generate any reporting because the errors are usually in the logs, either Windows or the text logs for Report Server.

    The best thing you can do is schedule PAH to restart on a daily basis (if it gets that bad) using sc stop and sc start commands in a batch file.  

    I've also got the Report Server running as a service so I can do the same thing for it.  I provided an application to the Sarasota Opera that I wrote in c# that will let people re-start either from the desktop (sorta a user self-service option).

    The only other option you have is to use a log reader to parse the logs and report when a certain phrase is present.  Some log softwares let you do that via a regex or other mapping.

    Hope that helps,

    -Ryan

  • $organization

    Hey, thanks, I’ll look into this for the Report Server alerting.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Heather Kraft
    Sent: Tuesday, September 03, 2013 10:57 AM
    To: Stuart McLeod
    Subject: Re: [Tessitura Technical Forum] PAH and Report Server alerting

     

    Hey Stuart -

    Check out this thread.. I did something similar based on Renville's solution.

    http://www.tessituranetwork.com/Community/forums/t/8210.aspx

    Heather

    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!

  • $organization

    We also periodically run into problems with the PAH service tripping over itself and breaking down. We used to not hear about it for hours (or more) resulting in reprinting headaches, until we created a rule in Outlook to forward e-mails that have the subject "LIVE PAH Exception Notification" from our default CC inbox to two key users.

    PAH still fails more often than it should, but at least we know about it much more promptly these days.

  • $organization

    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



    [edited by: David Frederick at 6:18 PM (GMT -6) on 3 Sep 2013]
  • $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!

  • $organization

    I tested Renville’s solution and it works well for the report server.  Thanks! 

     

    David, I look forward to seeing your proc for PAHT.  I already have an email alert setup for it, but it isn’t working.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Heather Kraft
    Sent: Tuesday, September 03, 2013 10:57 AM
    To: Stuart McLeod
    Subject: Re: [Tessitura Technical Forum] PAH and Report Server alerting

     

    Hey Stuart -

    Check out this thread.. I did something similar based on Renville's solution.

    http://www.tessituranetwork.com/Community/forums/t/8210.aspx

    Heather

    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!

  • $organization in reply to Stuart McLeod

    Hi Stuart,

    I uploaded the stored procedures I use to my files area. Some required setup:

    1. Database Mail is used.
    2. Owner of the SQL job must be in the DatabaseMailUserRole of the msdb database in order for the sp_send_dbmail call to work.
    3. Set parameter defaults to appropriate values or pass in the needed values when calling the procedure.

    Here are links to the files:

    lp_check_paht_status.sql

     

    lp_check_reportserver_status.sql

    Thanks,
    David