The logging indicated on itgenboe378 message that the Free Plan limits are exceeded.
The total processing time 3833 seconds with approximately 1 million rows internally processed. This exceeds the limits on rows processed and duration.
Sample Query 1
The following query retrieves timesheets for four years, download approximately 240K rows from Autotask:
select t.[id], t.[createDateTime], t.[dateWorked], t.[hoursWorked], t.[internalBillingCodeID], t.[internalNotes], t.[isNonBillable], t.[resourceID], t.[roleID], t.[ticketID], t.[timeEntryType]
from Autotask.TimeEntries.TimeEntries@at t
where (([createDateTime] >= :w1) and ([createDateTime] < :w2))
Sample Query 2
The following query retrieves some columns on service level agreement results (131,416 rows):
select t.[id], t.[firstResponseElapsedHours], t.[firstResponseResourceID], t.[resolutionElapsedHours], t.[resolutionPlanElapsedHours], t.[resolutionPlanResourceID], t.[resolutionResourceID], t.[ticketID]
from Autotask.ServiceLevelAgreementResults.ServiceLevelAgreementResults@at t
There are several other heavy queries, which can be found in the Monitoring section.
It is recommended to either optimize the queries to reduce data volume and especially run time by better filters or caching.
More details can be found by consulting: