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.
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 194 Visualize
- 253 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive