• State Not Answered
  • Replies 9 replies
  • Subscribers 1383 subscribers
  • Views 273 views
  • Users 0 members are here
Options
Related

Report Requests not Running - Stalled on QueueStatus "s"

Seth Mize
$organization

We've been working on integrating with the Reporting features on the Tessitura API for one of our clients lately, and we've recently ran into some issues. When I first started working on this (around 5/12/21), we were able to generate Report Schedules and direct Report Request calls that would successfully execute on the Test server (it never worked on the Prod server). Around 5/28/21, the reports requests stopped executing on the Test server as well, and are now stalled in queue with a QueueStatus of "s". We've been trying to debug this without much success, so we have a few questions to try and debug it.

What User, User Group, Resource, and Security permissions are required to generate a functioning Report Schedule as well as do direct Report Requests calls? We want to ensure that our users are configured correctly. Currently, we're attempting to generate them using both an Admin and Non-Admin account.

Parents
  • 0 $organization
    Hi, Tom,
     
    While we haven’t gone deep enough under the hood to diagnose symptoms at the level you have, we have been having what I assume is a similar problem pretty much since we went live on AWS.
     
    We have had a ticket open for over a month on this with very little progress, and it is causing major operational issues for us. Scheduled reports simply fail to show up sometimes, and on-demand reports intermittently don’t work. We were initially told it had something to do with the barcode font we were using in our primary ticketing report, so we reworked the report to remove the barcode (really annoying the people who relied on that to quickly tally program attendance), and while this reduced the problem a little for that report (presumably by reducing the rendering time overall), the underlying issue is still there for all reports. We are dealing with some pretty negative perceptions about the reliability of the system because of this. The most recent update we got from support was that “the system admin team is still investigating this” on July 8.
     
    I think we were early on the AWS migration path – we went live in mid-May.
     
    -David
     
     
    ____
     
    David Dwiggins, Chief Information Officer
    Historic New England
    (he/him/his)
    Eustis Estate
    1424 Canton Ave
    Milton, MA 02186-2418
    617-994-5948 (office)
     
     
  • 0 $organization in reply to David Dwiggins

    ,

    It's good to know that I'm not alone.  We were compelled to move to AWS mid-June 2021.  We have had a support ticket open for about a week now.

    I'm wondering if anyone else out there is having the same problems.

    I'm also wondering what might be similar between your organization and mine.

  • 0 $organization in reply to Tom Brown (Past Member)

    Hi Tom and David,

    Boann here with the Support Escalation Team. I have reviewed your open support tickets on this issue and based on what we are seeing in our troubleshooting thus far, it does not seem like the issues are related. We are continuing to investigate both issues, and understand how frustrating it can be to have a report run slowly or not complete. We will continue to keep you updated on our progress within each support ticket.

    Thank you,

    Boann Petersen

    Support Escalation Manager

Reply
  • 0 $organization in reply to Tom Brown (Past Member)

    Hi Tom and David,

    Boann here with the Support Escalation Team. I have reviewed your open support tickets on this issue and based on what we are seeing in our troubleshooting thus far, it does not seem like the issues are related. We are continuing to investigate both issues, and understand how frustrating it can be to have a report run slowly or not complete. We will continue to keep you updated on our progress within each support ticket.

    Thank you,

    Boann Petersen

    Support Escalation Manager

Children
No Data