Workbench Job Schedule with QuickBooks
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.
Comments
-
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.
0
Categories
- 10.7K All Categories
- 1 APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 252 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 101 Apps
- 705 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 23 お知らせ
- 63 Kowaza
- 297 仲間に相談
- 649 ひらめき共有