Solved

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

  • 14 October 2016
  • 2 replies
  • 12 views

Userlevel 3
Badge +13

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
icon

Best answer by rylanatsafe 14 October 2016, 01:48

View original

2 replies

Badge +11

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 .

Badge +7

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