DataCleaner icon indicating copy to clipboard operation
DataCleaner copied to clipboard

Published 20 hours ago • verified publisher icon datacleaner

Failed SQL Server jobs seems to keep the connection open

Open LosD opened this issue 8 years ago • 4 comments

We seem to have a problem with SQL Server jobs that cannot be run after another (or the same) job has failed. This seems to be a pretty consistent problem, at least for large amounts of data.

LosD avatar Mar 03 '16 14:03 LosD

A hint/idea to check out in this regard would be unclosed (datastore-based) SynonymCatalogConnection or DictionaryConnection objects. I'm adding this hunch because I know that at the customer they use datastore (SQL server) backed reference data, so it might just as well be those connections rather than the source or target datastores.

kaspersorensen avatar Mar 07 '16 11:03 kaspersorensen

@ClaudiaPHI are you still working on this?

LosD avatar Mar 11 '16 09:03 LosD

Nope.

ClaudiaPHI avatar Mar 15 '16 08:03 ClaudiaPHI

I could not reproduce this issue.

ClaudiaPHI avatar Sep 13 '16 11:09 ClaudiaPHI