Dear fellow easymorph (em) users,
We have an em package, scheduled as task from the server, running every 15 mins,
The reason I reach out to you is…, sometimes we have a strange error.
The step that fails is the ‘import from database’, the database is actually an Azure SQL Database.
The import is just a simple table, around 50k rows.
We did some logging on the database and the load is around 1-4% and there are no heavy queries running at the time our em package fails.
The error produced is:
"
Invalid operation. The connection is closed.
Location: action “Import from database”, module “FinYears”,
"
(We use the default logging from the scheduler.)
This happens only ad random. Mostly in the evening.
Furthermore, at first sight, we can not spot any rarities in the network at the time of the error.
Someone has an idea what can be the problem OR how we can troubleshoot this better ?
Many thanks in advance