Schedule will not run
Christine Sherman asked 9 years ago
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
Answers
Best Answer
Christine Sherman answered 9 years ago
Christine replied 9 years ago
Chris replied 9 years ago
Christine Sherman answered 9 years ago
Lorren
Thanks for the update. This issue did resolve. Changing some of the run times on the schedules seemed to fix it.
Christine replied 9 years ago 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.
Chris replied 9 years ago 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.
H
Christine,
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?
Lorren