• Replies 2 replies
  • Subscribers 338 subscribers
  • Views 65 views
  • Users 0 members are here
Related

Trouble Scheduling an SSRS Post Report

Ed Denning
$organization

All,

I have 1 SSRS Post report that will not render when I schedule it.  I can run the report on demand and it renders nicely.  When I check under tools>Maintain reports/utility schedules at the appropriate time, the report will indicate that it is "Running Now", but the report never makes it to the report viewer and it never gets emailed.   All other SSRS Post reports that are scheduled and delivered as email .pdf attachments are able to complete and get e-mailed to their recipients.

It is a fairly complex report and it takes some time to render.  Is there a time-out setting or something that I should be looking at?  Also, It seemed to work fine before we upgraded to version 10.

Ed

Parents
  • $organization

    There was a mistake made on the default timeout setting added in v10.0.  Check the SSRS_TIMEOUT setting in T_dEFAULTS.  It’s probably set to 10000, which is in milliseconds, or 10 seconds.  Set it to 600000, and your timeout will now be 10 minutes.

    If you  are still having issues, please open a support ticket and we’d be glad to help you.

     

    -Ryan

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ed Denning
    Sent: Wednesday, February 09, 2011 9:27 AM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] Trouble Scheduling an SSRS Post Report

     

    All,

    I have 1 SSRS Post report that will not render when I schedule it.  I can run the report on demand and it renders nicely.  When I check under tools>Maintain reports/utility schedules at the appropriate time, the report will indicate that it is "Running Now", but the report never makes it to the report viewer and it never gets emailed.   All other SSRS Post reports that are scheduled and delivered as email .pdf attachments are able to complete and get e-mailed to their recipients.

    It is a fairly complex report and it takes some time to render.  Is there a time-out setting or something that I should be looking at?  Also, It seemed to work fine before we upgraded to version 10.

    Ed




    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

    There was a mistake made on the default timeout setting added in v10.0.  Check the SSRS_TIMEOUT setting in T_dEFAULTS.  It’s probably set to 10000, which is in milliseconds, or 10 seconds.  Set it to 600000, and your timeout will now be 10 minutes.

    If you  are still having issues, please open a support ticket and we’d be glad to help you.

     

    -Ryan

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ed Denning
    Sent: Wednesday, February 09, 2011 9:27 AM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] Trouble Scheduling an SSRS Post Report

     

    All,

    I have 1 SSRS Post report that will not render when I schedule it.  I can run the report on demand and it renders nicely.  When I check under tools>Maintain reports/utility schedules at the appropriate time, the report will indicate that it is "Running Now", but the report never makes it to the report viewer and it never gets emailed.   All other SSRS Post reports that are scheduled and delivered as email .pdf attachments are able to complete and get e-mailed to their recipients.

    It is a fairly complex report and it takes some time to render.  Is there a time-out setting or something that I should be looking at?  Also, It seemed to work fine before we upgraded to version 10.

    Ed




    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