Skip to content
+1-888-319-3663

COMMUNITY FORUM

Schedule will not run

Christine Sherman asked 8 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
Lorren replied 8 years ago

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

Answers
Best Answer
Christine Sherman answered 8 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 7 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 7 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


If you would like to submit an answer or comment, please sign in to the eOne portal.