Skip to main content
Best Answer

Why do my FME jobs fail when scheduled in Windows Task Scheduler with 'Run whether user is logged on or not'?

  • October 13, 2016
  • 2 replies
  • 88 views
fmelizard
Safer
Forum|alt.badge.img+21

I have created schedules / tasks in Windows Task Scheduler and specified for them to 'Run whether user is logged on or not'. They run without issue in FME Workbench, or if I set the schedule / task to 'Run only when user is logged on'. What's going on here?

I looked at the workspace log and it contains errors connecting to the database similar to below, but I have verified that my credentials are correct:

38. 2016-10-05 10:00:58| 1.8| 0.0|INFORM|Microsoft SQL Server Non-Spatial Reader: Read 1 DEF line(s). Found 0 attribute(s)

 

39. 2016-10-05 10:00:58| 1.8| 0.0|INFORM|Microsoft SQL Server Non-Spatial Reader: Opening `TABLE' for read operation

 

40. 2016-10-05 10:00:58| 1.8| 0.0|INFORM|Microsoft SQL Server Non-Spatial Reader: Trying to connect using SQL Server 2012 Native Client...

 

41. 2016-10-05 10:00:58| 1.9| 0.1|ERROR |Microsoft SQL Server Non-Spatial Reader: Failed to connect using SQL Server 2012 Native Client. Provider error '(-2147217843) Invalid authorization specification'. Connection string 'Provider=DB;DataTypeCompatibility=80;Data Source=;Initial Catalog=TABLE;User ID=;Password=********'

 

42. 2016-10-05 10:00:58| 1.9| 0.0|INFORM|Microsoft SQL Server Non-Spatial Reader: Trying to connect using SQL Server 2008 Native Client...

 

43. 2016-10-05 10:00:58| 1.9| 0.0|ERROR |Microsoft SQL Server Non-Spatial Reader: Failed to connect using SQL Server 2008 Native Client. Provider error '(-2146824582) Provider cannot be found. It may not be properly installed.'. Connection string 'Provider=DB;DataTypeCompatibility=80;Data Source=;Initial Catalog=TABLE;User ID=;Password=********'

 

44. 2016-10-05 10:00:58| 1.9| 0.0|ERROR |Failed to open reader

 

45. 2016-10-05 10:00:58| 1.9| 0.0|INFORM|FME Session Duration: 1.8 seconds. (CPU: 0.6s user, 0.2s system)

 

46. 2016-10-05 10:00:58| 1.9| 0.0|INFORM|END - ProcessID: 9440, peak process memory usage: 272396 kB, current process memory usage: 272396 kB

Best answer by rylanatsafe

If you are using a Database Connection in your FME workspace, you might need to make the connection 'public'. Please see the Knowledge Center article "Making Database and Web Connections Public".

If following the steps in the article does not resolve this issue for you, please add a comment here or contact .

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.

2 replies

rylanatsafe
Safer
Forum|alt.badge.img+14
  • rylanatsafeSafer
  • Safer
  • Best Answer
  • October 13, 2016

If you are using a Database Connection in your FME workspace, you might need to make the connection 'public'. Please see the Knowledge Center article "Making Database and Web Connections Public".

If following the steps in the article does not resolve this issue for you, please add a comment here or contact .

tim_wood
Contributor
Forum|alt.badge.img+8
  • tim_woodContributor
  • Contributor
  • October 12, 2018

If you are using a Database Connection in your FME workspace, you might need to make the connection 'public'. Please see the Knowledge Center article "Making Database and Web Connections Public".

If following the steps in the article does not resolve this issue for you, please add a comment here or contact .

Hi. I started a separate topic:

 

https://knowledge.safe.com/questions/62568/connecting-to-sql-server-when-runnning-as-a-schedu.html

 

Community Stats

32,182
Posts
122,179
Replies
39,856
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.