• Replies 31 replies
  • Subscribers 361 subscribers
  • Views 184 views
  • Users 0 members are here
Related

What's your Migration Date?

David Vivino (Past Member)
$organization

For those migrating soon, what’s your migration date?

We are T-minus 17 days – Sunday October 7

 

Gonna start working on my migration-day procedure sheet!!

 

Dave Vivino

Cleveland Orchestra

Parents
  • $organization

    Quick question.  If the tessitura SSRS_SNAPPATH in t_defaults says /TessituraScheduledReports then it would be in the root of C:  or under impresario client?

     

    From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of Chris Jensen
    Sent: Wednesday, December 12, 2012 9:51 AM
    To: John Brandt
    Subject: RE: [Tessitura Next Generation Forum] What's your Migration Date?

     

    Beth Gilliland:

    SSRS Reports were scheduled, and would "run", but not get "saved" to the folder for emailing, so it appeared as though they didn't run at all.

    An almost exact description of our situation, i.e. "error creating snapshot" in the Report Server log, the snapshot actually gets created in Report Manager and can be seen and opened there, but nothing is e-mailed. We've gone around and around with permissions settings on the EMAIL REPORT PATH, but our support ticket remains open (since September).

    Beth Gilliland:

    [...] if we kept the snapshot folder on the SQL
    database server, adding the app services *machine* rights were not enough to make
    this work. It seems we specifically needed the *app pool* rights, and the
    only way to do that was to have the folder on the same server as the app
    services.

    I'd love to give this a try immediately, but moving our SSRS server to our Services server would not be trivial.

    I wonder if the snapshot folder (same as the SSRS_SNAPPATH from t_defaults, yes?) needs to live on the same server as the rest of SSRS? Hmm....

    From: Beth Gilliland <bounce-bethgilliland6030@tessituranetwork.com>
    Sent: 12/12/2012 9:58:43 AM

    I am realizing reading through several posts that this seems similar to a problem we wrestled with for a few months post-conversion to v11. We opened a ticket, but eventually resolved it on our own. Infomaker reports were scheduled and ran just fine. SSRS Reports were scheduled, and would "run", but not get "saved" to the folder for emailing, so it appeared as though they didn't run at all. A bevy of errors in the Tessitura Report Server Application Log pointed us in the right direction. Here is a brief description of what we discovered:

    ----------

    We did indeed finally get a working solution, and it came down
    to permissions on the folder that temporarily stores the files prior to
    emailing.

    1) we had to move to using a snapshot folder on the app services machine (which
    is also our Report Server) instead of on our SQL database machine
    2) we shared the snapshot folder (particularly to the user running SQL services and
    the Report Server)
    3) we gave full read/write permissions to the 'IIS AppPool\Tessitura_Svcs'
    application pool

    It was #3 that was really the sticking point - if we kept the snapshot folder on the SQL
    database server, adding the app services *machine* rights were not enough to make
    this work. It seems we specifically needed the *app pool* rights, and the
    only way to do that was to have the folder on the same server as the app
    services. Not sure if that is the intended setup, but at least we have it
    working again. On pg 12 of the Report Setup/Admin document, it is not very
    clear as to the best location of the folder, nor does it specify the app
    pool permissions we found to work in our situation.

    Our patch upgrade to 11.0.4 last week seems to have also cleared up a few
    other small issues as well.

    ----------

    Group policy may indeed be the culprit, depending on how you have permissions setup. If anyone needs more details, let me know - I can try and dig up more info.

    Beth Gilliland

    UMS Tessitura System Administrator 




    You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!

  • $organization in reply to John Brandt

    Unknown said:
    Quick question.  If the tessitura SSRS_SNAPPATH in t_defaults says /TessituraScheduledReports then it would be in the root of C:  or under impresario client?
     

    That's a folder within SSRS, i.e. it can be seen via the Report Manager site. On our server it lives at this URL:

    http://actdata/Reports/Pages/Folder.aspx?ItemPath=%2fTessituraScheduledReports&ViewMode=List

Reply
  • $organization in reply to John Brandt

    Unknown said:
    Quick question.  If the tessitura SSRS_SNAPPATH in t_defaults says /TessituraScheduledReports then it would be in the root of C:  or under impresario client?
     

    That's a folder within SSRS, i.e. it can be seen via the Report Manager site. On our server it lives at this URL:

    http://actdata/Reports/Pages/Folder.aspx?ItemPath=%2fTessituraScheduledReports&ViewMode=List

Children
No Data