• Replies 2 replies
  • Subscribers 962 subscribers
  • Views 63 views
  • Users 0 members are here
Related

Report works in Tess, but not Tessitura OnTheGo

Jessie Forrester
$organization

I'm relatively new to Tessitura. I have created a custom SSRS report that works in Tessitura beautifully. No errors returned, everything looks nice, data is returned.

For some reason the same report will not run in Tess OnTheGo. I get back "An error occurred while processing your request". I've run similar reports in OnTheGo without issue. 

Any idea what might cause this? Is there some exec rights I need to grant for OnTheGo reports to run? 

  • $organization

    Sounds like the path of where the report lives.  

     

    From: Tessitura Shared Reports Forum [mailto:forums-shared.reports@tessituranetwork.com] On Behalf Of Jessie Forrester
    Sent: Monday, August 24, 2015 9:29 AM
    To: Robert Martin <rmartin@waltonartscenter.org>
    Subject: [Tessitura Shared Reports Forum] Report works in Tess, but not Tessitura OnTheGo

     

    I'm relatively new to Tessitura. I have created a custom SSRS report that works in Tessitura beautifully. No errors returned, everything looks nice, data is returned.

    For some reason the same report will not run in Tess OnTheGo. I get back "An error occurred while processing your request". I've run similar reports in OnTheGo without issue. 

    Any idea what might cause this? Is there some exec rights I need to grant for OnTheGo reports to run? 




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

    Hi Jessie,

    I would first check the TessituraWeb service logs for more detailed errors.  You may want to find the NLog.config file that's located in the folder where that service is installed, and up the logging level on the default logger "*" to "Trace".  Save the file and the service will automatically start logging at the more verbose level - no restart needed.

    I wonder if perhaps you have parameters set up for the user to select directly on the report?  You should be passing all the required parameters through the Tessitura Report Setup application, using the SSRS Name column on each parameter.  The parameters on the SSRS report itself should all be hidden.

    If I'm way off base with that suggestion, I'd invite you to open a help ticket.  Normally we don't get too deep in to troubleshooting custom reports, but we can help you make sure your report setup configuration is correct.