Quickbooks job taking way too long
Hello,
I have just recently gotten Workbench connected to our Quickbooks server on premise. Last night I attempted a test run using the General Details - General Ledger report with the date range from 3/13 o 3/20. The run started at 10pm PST. I checked on it at 12PM and say that it was in the same state as when it started:
[INFO] [4832:8] 2017-03-27 21:57:18,496 - [domain:marketingevolution.domo.com][job:5] Loading QuickBooks company file: C:\path\to\file.QBW
I checked it again this morning at 7AM (kept the user logged in via remote desktop the entire time) and saw that it was still at the same state. I had to cancel the run so I wouldn't get in the way of our financial team. Here is the full log:
[INFO] [4832:1] 2017-03-27 21:57:15,418 - Starting Workbench.DataCollector v4.5.6176.30185
[INFO] [4832:1] 2017-03-27 21:57:18,044 - [domain:marketingevolution.domo.com][job:5] Saving the Workbench DataSet Job to Domo.
[INFO] [4832:1] 2017-03-27 21:57:18,064 - [domain:marketingevolution.domo.com][job:5] Updating Agent Job '5' configuration on the Domo server.
[INFO] [4832:8] 2017-03-27 21:57:18,491 - [domain:marketingevolution.domo.com][job:5] Loading local file provider properties
[INFO] [4832:8] 2017-03-27 21:57:18,496 - [domain:marketingevolution.domo.com][job:5] Loading QuickBooks company file: C:\path\to\file.QBW
[ERROR] [4832:1] 2017-03-28 07:11:35,461 - The operation was canceled.
System.OperationCanceledException: The operation was canceled.
at System.Threading.CancellationToken.ThrowOperationCanceledException()
at System.Threading.ManualResetEventSlim.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
at System.Threading.Tasks.Task.SpinThenBlockingWait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
at System.Threading.Tasks.Task.InternalWait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
at System.Threading.Tasks.Task.Wait(CancellationToken cancellationToken)
at Workbench.DataCollector.Program.Main(String[] args) in c:\jenkins\workspace\Workbench\WorkbenchBuild\Workbench.DataCollector\Program.cs:line 97
Any ideas on why this would be taking so long and how to fix it? I'm not sure if this would have any affect, but the filename itself does have a period in it.
Thanks,
Curtis
Comments
-
Hey Curtis,
How large is your QB file? I've seen that large files can cause long runtimes.
Another avenue you could pursue is to talk to Domo support or your Consulting team (if applicable), they can better help you troubleshoot the issues you're having.
Best of luck!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0 -
Was this a QB account hosted on a VM / remote server?
Can you please tell us how you created the process and got Domo workbench installed therein?
Let us know please!
0
Categories
- 10.5K All Categories
- 6 Connect
- 916 Connectors
- 250 Workbench
- 463 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 189 Visualize
- 252 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
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 172 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive