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
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 656 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 811 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 80 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive