Skip to main content
Solved

SQL Connection Problem

  • December 6, 2012
  • 1 reply
  • 17 views
T
I have an automated nightly process that runs and outputs several tables to SQL Server 2008.  This week we have had intermitten issues with connecting to SQL server.  One night it failed and the next it worke and then again it failed.  It is giving me an warning message of:  

 

 

MS SQL Server: Connection not properly cleaned up, please contact support@safe.com. Connection key '1_|_3_|_TABLENAME_|_DATABASENAME_|_<unused>_|

 

 

I am looking for any insight of what might be causing this.  Is it an FME issue or a SQL DB issue.  I am running FME 2012 SP2 Build 12235 WIN32.

 

 

Thanks

 

Travis

Best answer by sigtill

Usually when it says Connect support@safe.com it is a difficult issue and atleast the entire logfile is needed.

 

 

If possible, I would suggest you try the FME2012 SP4 and see if that has the same issue. It seems issues with databases are quite regularly fixed.

 

 

If you cant upload the logfile, then I would suggest to contact Safe directly: http://fmepedia.safe.com/knowledgeSubmitCase?
View original
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

sigtill
Supporter
Forum|alt.badge.img+24
  • sigtillSupporter
  • Supporter
  • Best Answer
  • December 6, 2012
Usually when it says Connect support@safe.com it is a difficult issue and atleast the entire logfile is needed.

 

 

If possible, I would suggest you try the FME2012 SP4 and see if that has the same issue. It seems issues with databases are quite regularly fixed.

 

 

If you cant upload the logfile, then I would suggest to contact Safe directly: http://fmepedia.safe.com/knowledgeSubmitCase?
The real SigTill

Helpful Members This Week

Community Stats

31,341
Posts
118,856
Replies
38,930
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.