Skip to main content
Solved

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


fmelizard
Contributor
Forum|alt.badge.img+17

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 .

View original
Did this help you find an answer to your question?

2 replies

rylanatsafe
Safer
Forum|alt.badge.img+13
  • 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
  • Contributor
  • October 12, 2018
rylanatsafe wrote:

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

 


Reply


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