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
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive