• Replies 9 replies
  • Subscribers 963 subscribers
  • Views 272 views
  • Users 0 members are here
Related

Recently upgraded to 15.1.5 and some of our scheduled reports have stopped sending

Nathaniel Baker
$organization

Hello All,

Recently upgraded code levels and now some of our scheduled reports (both custom and standard) are showing in error for some of our Box Office Managers and Development personnel. They're having to go in and manually run the reports as the scheduled reports have stopped working. We have had our email server cycled and have had a ticket opened around the issue with Tessitura.

Has anyone else seen this with recent upgrades?

Thanks,

Nathaniel 

Parents
  • $organization

    Hi Nathaniel,

    We also had something similar when we updated to 15.14
    In v. 15.14 a "bug" has been corrected, so now scheduled reports will fail if the owner of the schedule is not an active tessitura user in the security module. The thing is that if you have one report that fails for this reason, a lot of other reports will subsequently fail as well

    Could this be the issue. 

    One more thing. A new column "as_of_datetime" has been added to the table "GOOESOFT_REPORT_SCHEDULE". The column doesn't allow null, and doesn't have a default value. If you have schefules that is automaticelly scheduled from a stored procedure or other code, this will fail on insert.

Reply
  • $organization

    Hi Nathaniel,

    We also had something similar when we updated to 15.14
    In v. 15.14 a "bug" has been corrected, so now scheduled reports will fail if the owner of the schedule is not an active tessitura user in the security module. The thing is that if you have one report that fails for this reason, a lot of other reports will subsequently fail as well

    Could this be the issue. 

    One more thing. A new column "as_of_datetime" has been added to the table "GOOESOFT_REPORT_SCHEDULE". The column doesn't allow null, and doesn't have a default value. If you have schefules that is automaticelly scheduled from a stored procedure or other code, this will fail on insert.

Children
No Data