Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Authoring
  • Why do my FME jobs fail when scheduled in Windows Task Scheduler with 'Run whether user is logged on or not'?

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

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 .

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


Community Stats

30,159
Posts
114,480
Replies
37,807
Members
Terms & ConditionsCookie 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.