Workbench Job Schedule with QuickBooks

user02364

Hi Everyone,

There is an issue we are having in our account with scheduling a Workbench job with uploading QuickBooks data.

I have set up everything within the data set to upload the Quickbooks company file data, and it runs just fine, manually running the job. However, after I setup the schedule to run daily in the evening, it doesn't run. Below is the log info:

 

...
[INFO] [3296:71] 2017-03-08 18:52:45,123 - subdomain.domo.com: Total DataSet Jobs found for this agent: 2
[INFO] [3296:71] 2017-03-08 18:52:45,154 - subdomain.domo.com: Adjusting next DataSet Job check to 2017-03-08 19:00:00 Local
[INFO] [3296:71] 2017-03-08 19:00:00,658 - subdomain.domo.com: Total DataSet Jobs found for this agent: 2
[INFO] [3296:71] 2017-03-08 19:00:01,377 - subdomain.domo.com: DataSet Job Id 2 - next run date of 2017-03-08 19:00:00 Local is past due. Queued for execution.
[INFO] [3296:71] 2017-03-08 19:00:01,392 - subdomain.domo.com: Adjusting next DataSet Job check to 2017-03-08 19:15:00 Local
[INFO] [3296:17] 2017-03-08 19:00:01,408 - Job requires interactive session, but no interactive session available
[ERROR] [3296:17] 2017-03-08 19:00:01,408 - WorkItem processing error
System.InvalidOperationException: Sequence contains no matching element
   at System.Linq.Enumerable.First[TSource](IEnumerable`1 source, Func`2 predicate)
   at Workbench.Service.WorkItems.DomoJobWorkItem.CreateDataCollectorProcess(Win32Process& process, EventWaitHandle& cancelProcessEvent) in c:\jenkins\workspace\Workbench\WorkbenchBuild\Workbench.Service\WorkItems\DomoJobWorkItem.cs:line 241
   at Workbench.Service.WorkItems.DomoJobWorkItem.WorkRoutine(CancellationToken cancellationToken) in c:\jenkins\workspace\Workbench\WorkbenchBuild\Workbench.Service\WorkItems\DomoJobWorkItem.cs:line 84
   at Workbench.Service.Scheduler.WorkItem.Start() in c:\jenkins\workspace\Workbench\WorkbenchBuild\Workbench.Service\Scheduler\WorkItem.cs:line 61

 

From what I gathered, it appears that, for the job to run, a local admin user needs to be logged in into windows for the job to run. On a side note, when I login to the local admin account the following morning after the job is queued, it runs instantly after logon.

Is there a way for it to run without requiring an active user being logged into the machine? On a side note, the 'Domo Workbench' service currently logs in as the 'Local System' account.

Any direction on solving this issue is appreciated.

Cody

Hi @user02364,

I'm sorry you're having issues with QuickBooks jobs in Workbench. Thank you for providing a copy of the logs as well. The error: "Job requires interactive session, but no interactive session available" is observed when there is no Windows "interactive session". An interactive session is referring to somebody being logged in on the PC. While Workbench will continue to function as an unattended service, the QuickBooks services require a user to remain logged in. I see this often on remote Windows PCs. Users will log off instead of just disconnected the remote desktop session.

 

Please ensure someone is logged in with an active Windows session at all times and this error should go away.