Schedule will not run
I have 8 maps scheduled to run and they will not run. On the first schedule got the following error: Error [HYTOO](Microsoft)(SQL Server Native Client 10.0) Query timeout expired Collection was modified; enumeration operation may not execute. I am on version 20.13.89
Lorren Thanks for the update. This issue did resolve. Changing some of the run times on the schedules seemed to fix it.
This is happening again. Schedules ran fine and then on Sunday got the following error again:
Collection was modified, enumeration operation may not execute.
There are 8 maps schedules independently which are set to run from 12:00 am to 5:30 am
12:00, 12:05, 12:30, 1:00, 3:00, 4:00, 4:30 and 5:30
These are the only scheduled maps. You suggested changing the query timeout setting in sql server. How do you do this?
Do you have any other suggestions.
What are the data sources for the maps – are they SQL? It would help to know since then we would know if the error is coming from the data source or if that error is coming from when it is trying to pull something internal for the map from sql.
If you would like to submit an answer or comment, please sign in to the eOne portal.
Is it one map that is scheduled to run and it executes the other maps as tasks from that one or are their 8 separate maps scheduled independently?
How long does your Query run from SQL Management Studio? You can change the query timeout setting in SQL Server to allow for a longer running query.
Are the other scheduled maps running SQL Queries as well?