-
Its showing me "Live updates are not available" as the status, how do I solve it?
I uninstalled and installed the domo workbench multiple times to try and solve this problem but it seems i cannot get rid of this. I need some help to know why it is happening and how do I solve it.
-
Workbench Job Hanging, Dataset stuck on 'Preparing'
I have a scheduled Workbench job to update a dataset that typically takes 30ish mins to run. The job started yesterday at 1:37pm and has been stuck on 'Preparing..' in the Result field (on the History tab) since then. I just canceled the workbench job and started a new manual run. It started a new run, but the history tab…
-
Workbench crashes every time - Workbench Service WILL NOT STAY RUNNING
Hello, I created an account on developer.domo.com and started working on a custom workbench plugin. However, there now seems to be a problem tied to my account because anytime I try to pull any data in workbench it crashes. This issue is not tied to my machine. After MANY, MANY uninstalls and reinstalls, I just created a…
-
Scheduled update of an Excel with date in the title possible ?
Hello all, I need to configure a job that has to be updated every day, but the bad thing is that the Excel file source is an extract from a database that is daily generated with the date of the day in the title (then it means a different title then a different file each day). Do you know if it is possible to let Workbench…
-
Daylight Savings messing with Scheduling
How are people handling the effects daylight savings has on scheduling in domo? All of my connectors and everything in workbench is now running an hour later because domo schedules everything based on UTC. From what I've read, the only way to fix this is by going through each individual dataset and scheduling it an hour…
-
Process for using Workbench to read a Sharepoint Excel File
Hi, I'm trying to set up Workbench to read a sharepoint stored excel file. While in sharepoint I am generating a link to the file (which is a web https:// link) but after putting this into Workbench as a "local file" it fails to reach the file. Guidance on what I'm missing in Workbench or Sharepoint to get this working…
-
Import multiple files into single Dataset
Every day a new Excel file is dropped into a shared network folder. Every file is in the same format, and each file contains one day's data. Is there a way, using Workbench or any other method, to transport all Excel files from one local folder into a single Domo DataSet? Since a new file is added every day, every file…
-
Deleting and recreating jobs in Workbench
Hi, Some of the jobs in workbench were not running on schedule and when I checked the log viewer and it says “Local is past due. Queued for execution”. I went ahead and recreated the same job just to check if they run on schedule and they do as expected. My query is if I delete the old jobs(which weren’t running on…
-
Error: No agent found matching computer name, or user does not have access to agent
DOMO workbench 5.0.7228.31236 has been installed on my Laptop and when I add account and authorize my machine, the browser confirms the authorization. However while saving the authorization, I get the following error. No agent found matching computer name, or user does not have access to agent The following troubleshooting…
-
Dataset jobs not running on set schedule
I've been running into issues where Workbench is scheduled to run a job every morning at 6 AM, but when I open Workbench at 9 or 10 AM the job hasn't run and the status under the job name just shows "Next run scheduled for 6:00 AM". Has anyone run into this?
-
Scheduling workbench jobs with a batch file and windows task scheduler
Hi, one of the questions I got yesterday was around scheduling workbench or other jobs using windows scheduler vs. the scheduler built into workbench. * See my reply for the solution.
-
WorkBenchのLock Data Typeが外れる・ロックされない
WorkBench v4.26を利用しています。 自動判別で各項目の型が変換されてしまわないよう、Schemaの設定で Data Typeで型を指定し、Lock Data Typeにチェックを入れています。 この状態でData Typeは変更されない想定なのですが、以下2パータンの状態になってしまします。 ・Lock Data Typeのチェックが外れてしまう。 ・Lock Data Typeのチェックが入っているが、Data Typeが変わってしまう。 同様の事象が起きている方はいらっしゃいますでしょうか？ 解消方法をお持ちの方がいましたらご教授頂けますと助かります。 よろしくお願いします。
-
Filter out junk data
There is a dataset I import using Workbench, then transform using Magic ETL. The data includes values between 1-10, but sometimes will contain a random junk value like 324568. I'd like to filter out all values that don't fall between 1-10, but can't find a way to do this wihtout specifying every possible junk value, ie.…
-
Append data when columns missing from input data
Hello. I have a master dataset in domo which was originally extracted from a legacy system, and has 'timestamp' and 'id' columns which were specific to the legacy data set. New data is identical but with the exception of the fact that it doesn't include those columns. It seems if I try to append the data to the master data…
-
Workbench Scheduler to Batch Run Jobs
First some background...there are 6 Jobs that I need to run in Workbench every day. The source data becomes available at different times and I need to manually format the sorce files for all 6 before upload, so I can't set a daily time schedule to automatically upload. The last of the 6 uploads triggers an ETL to run, so…
-
Workbench 4.5 Error: Object reference not set to an instance of an object
I am running Workbench 4.5 and when I migrated my Workbench 2.0 jobs I noticed that some were left out. When try to import them into Workbench 4.5 one by one I get this error: "Object reference not set to an instance of an object." Has anyone else experienced this error and does anyone know what's causing it?
-
Workbench Error
I began receiving the error over the weekend while trying to execute workbench jobs that have historically ran successfully. The error message "DomoApi.Exceptions.IndexingFailedException" did not help point in a direction for fixing the issue. Have anyone run into this before?
-
Set Workbench Job to Pull in Most Recent File
Is there a way to have a Workbench 'Local File Provider' job look for the most recent version of a file (based on the Date modified) so long as the naming schema for the file is consistent? I have a report that autoexports out of one of our software systems, but the file name when it exports is always…