Skip to main content
Question

FME Server parent workspace with SQL Server problem

  • July 11, 2016
  • 1 reply
  • 13 views
K

Hello,

I am running a parent workspace on FME Server which calls child workspaces with the FMEServerJobSubmitter transformer. From the log, the translation has errors when trying to connect to a SQL Server Non-Spatial reader in one of the child workspaces. When I run this child workspace individually from the desktop or FME Server, it works fine (no errors). The only problem is when I run it from within the parent workspace on the Server. The parent workspace also ran fine on the desktop. What could be causing this problem? I have seen that this is a common error message (https://knowledge.safe.com/articles/281/failed-to-connect-using-sql-server-2012-native-cli.html), but my connection to SQL Server is fine when I run the child workspace individually.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, 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

erik_jan
Contributor
Forum|alt.badge.img+26
  • erik_janContributor
  • Contributor
  • July 11, 2016

Could it be the MS SQL Server connection is a published parameter that is receiving no value or a different value from the FMEServerJobSubmitter. If so, un-publishing the connection parameter and setting the parameter in the child workspace might solve the issue.

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.