Forum Discussion

Mike_Mellis's avatar
Mike_Mellis
Frequent Visitor
5 years ago
Solved

Scheduled Refresh error "There is no data in the database for @CatalogItemId"

Hi, I've got a dozen reports scheduled to update every 30-60 minutes.  They all hit the same three data sources (DB2 database, AzureDevops WorkItem query using OData, and an on-prem SharePoint list ...
Scheduled data refresh
  • Mike_Mellis's avatar
    Mike_Mellis
    5 years ago

    So far, no errors.. which is unusual.  I usually have a half dozen a day.  I offset the schedule for each report by 1 minute or so.  Some run at 1 min after the hour, some 1 minute prior.. or 2 minutes after, etc.  This is promising.  I'll update in a couple of days to see if any errors pop back up.

     

    EDIT 11/23/2020 - No errors since I made the scheduling change.  Looks like off setting the schedules so they don't run at the same time worked to resolve the error.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

Does that maybe coincide with the time when you write to your data source?

Mike_Mellis's avatar
Mike_Mellis
Frequent Visitor
5 years ago

I don't think so.  I got the same error on a report this morning that is only making a single query to a local DB2 database and I can confirm all records in that database are complete and there are no errors or null values.  I thought it had to do with the OData query to AzureDev Ops, but doesn't seem to be isolated to it.