-
Export and Import of a job is creating a new dataset instead of modifying the existing one
Hello I exported a job to file on one computer and then imported it into a different computer (same registered user on the source and target machine). The dataset ID was on the file and it matched the browser. I ran the job and, rather than updating the dataset with the ID in the json, it created a brand new dataset. This…
-
Replacement Variable
I'm using workbench 5 and my current query looks like SELECT Unique_ID, Incident_Date, Incident_Time, Incident_Description FROM Incidents WHERE Unique_ID > !{lastvalue:Unique_ID}! ORDER BY Unique_ID In my replacement variables, I have the column set as "Unique_ID" and the value as "!{lastvalue:Unique_ID}! I've run this…
-
Execution has not been started - DOMO workbench error
HI, I had these datasets in domo workbench which were working fine. I am suddently getting this error - Execution has not been started. Any help would be appreciated. Manreet
-
Scheduling a Workbench Job which is event driven
Hi, I am a begginer when it comes to DOMO. I have a problem for which I want your ideas/solution. I want schedule workbench job to run on the basis of an SQL Query result, is there any way by which I can handle the particular use case in the Workbench. Currently I see that we can schedule a workbench job manually or in a…
-
Scheduled Workbench jobs no longer running
Hello, I have a number of Workbench jobs that run daily and up until a couple of weeks ago, they had been running as scheduled. Suddenly, however, they no longer run on the schedule and I've had to manually start the jobs. I have tried the following simple remedies: * Restarting the Domo Service on Windows * Restarting the…
-
I lost my workbench jobs
I've been using workbench version 4 for 10 months without a problem. All of a sudden, my jobs are gone. We thought it was a problem with expired token, but given a new token, jobs were still missing. Any thoughts or ideas how to resurface these jobs?
-
Workbench Job Schema
Hello, Here is the situation: I have scheduled Workbench job whose source is a DB view. There is a column in view's underlying table called 'Sales ' of datatype float. Till date the data in it was integer numbers. The Workbench Job was executing fine. when i added a decimal value into the Sales field, the scheduled Job…
-
Can a workbench connection delete a file after it has been imported?
I have a workbench (WB) job that connects to a file on a sharefile ftp server (ftps://xxxx.sharefileftp.com) and I can get the data from the shared file. However I would like to then delete said file on sharefile (after a successful import). Is there support for that using Domo Workbench (- or perhaps a plugin)? Thanks in…
-
Error trying to access Domo server in Powerpoint
I have the PowerPoint plugin installed and it is in the list of add-ons in Powerpoint. When I try and connect to the server (using our domain name) I get an error. It will not connect. Others at the company can connect and export cards with no problem. What could be the issues? I am able to accesss DOMO without issue…
-
Workbench Query Parameters
Is it possible to use query parameters in workbench? Can the parameter receive it's value from a query on a domo dataset? Here is what we are trying to do: We have some large tables that we would like to refresh often. Currently they are uploaded using the Replace method. We would like instead to use the Append method and…
-
Workbench 5 TXT File upload
Trying to upload a TXT file to Domo that is 301,321 KB and 1.7M rows, anyone have any tips? I can't seem to make any connectors work. They all give me the same error that a file cannot be larger than 254MB. Also, has anyone tried to use the Access app? IT asks for SFTP Hostname for a Microsoft Access connector and the port…
-
Quick books Workbench Error : Could not find any resources for the specified culture/neutral culture
I am getting an error in workbench for one of my quickbooks job while running it. The error is: Could not find any resources appropriate for the specified culture or the neutral culture. Make sure "DomoDataReaders.QuickBooksDataReader.Controls.QuickBooksNotificationDlg.en-US.resources" was correctly embedded or linked into…
-
Loading huge amount of data to Domo using workbench 5 - Issue
Hi All, I'm new to Domo Administration, I have configured data set connecting to Oracle DB from workbench 5, I have following questions in regards to huge data loading issue. 1. I have two tables in Oracle DB (Table A & B) both these tables have huge amount of data. Table 'A' has 500 millions rows and 20 columns and Table…
-
Domo Workbench error "Response status code does not indicate success: 429 (Too Many Requests)"
I have been receiving a workbench error for two files intermittently over the past couple of days: Response status code does not indicate success: 429 (Too Many Requests) Not sure what this code means and what I need to do resolve it?
-
Workbench Scheduler Not Working after password change
Passwords are required to be changed every 60 days. Once changed, scheduled jobs stop running in WB 5. Yes I have the latest version as I allow updated to be installed automatically. Never a problem in WB4Have a ticket open with support who are totally unresponsive. They just keep asking for more information which I…
-
Workbench 5 Job ID
Using Windows Task Scheduler to run Workbench jobs on a schedule, and I need to convert the jobs to bat files. To do this, I need the Workbench Job ID. Where do you find the Workbench Job ID in Workbench 5? Is there a way to see a list of all the jobs with their Job IDs? Or will I have to go through each one to find the…
-
Downgrading from WB 5 to WB4
Any issues exporting jobs from WB5 instance and importing them to WB4? Have an ongoing issue with WB5 when user password changes. WB4 running fine. Tickets open with support with no response.
-
In Workbench 5, sort the "Filtered Jobs" view
In Workbench 5, it is easy to sort the DataSet Jobs view by Job Name or by Last Run, etc., but then when I click on one of the jobs and it goes to the "Filtered Jobs" view, there is no sort to the jobs. Is there a way to sort it or have the Filtered Jobs view automatically be sorted in the same way as the DataSet Jobs…
-
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.
-
Recover workbench job after owner deleted
The user that owned the workbench jobs was removed from our instance. Thus we lost all the workbench jobs. I found a nice way to recover these: The steps below are the instructions to change the owner of a Workbench Agent to a new owner. Since the user was deleted you will need an administrator to take ownership of the…
-
workbench5のスケジュール時間がずれる
workbench5を使用しています。 15のJOBに対し、同じ時間に実行するスケジュールを設定しています。 ですが実際に実行される時間は2分~5分ほどずつずらして実行されるスケジュールが「Next Run」に勝手に設定され、実際にこの通り実行されているようです。 workbench5でのDataset更新に合わせ、DOMOのスケジュールレポートを組んでいるので、一部のデータが更新されないままレポートが配信されていしまいます。 これでは時間を指定している意味がありません。 手動でJOBを実行すれば同時進行は可能なようですし、「Next Run」にも同じ時間に実行される設定も散見されるので同時実行ができないわけではないようです。…
-
Transform Timezone for Entire Dataset
I've been incorrectly bringing data into a dataset (appending) for months now assuming it was coming in as UTC and then Domo converting it to EST. However apparently the data was in EST the whole time and being incorrectly represented in Domo since it was being converted. I know I can add the transform to the Workbench job…
-
dataset job view - message window won't expand??
Having odd issue with UI - job status message window won't expand so can't view any of the status messages? see image running workbench v4.62.6715.32090 on Windows 10 pro v1809 build 17763.437
-
ERROR [42P01] Workbench
Hi All, One of my dataset got into error and I would like to know the cause of it and how to resolve it. Below is the screenshot of the error in workbench. The error is - ERROR [42P01] ERROR: relation "company_setting" does not exist; Error while executing the query Thank you,
-
How to access Global Replacement Variable in Workbench?
I'm able to filter my query using a Replacement Variable using: school_year > !{lastvalue:school_year}! However I don't see any documentation on how to access the defined Global Replacement Variables. I'm maybe missing something obvious but I've been researching this for a while with no luck. Thanks in advance!
-
Append not finding new rows after initial import
Ok, so I'm using a date field in my replacement variable. I initially set the value equal to a date at the beginning of my range (right before the range starts in the data). I include the date field in my SELECT, WHERE, and ORDER BY. In my WHERE I added another date to be the cap to try and troubleshoot the issue of not…
-
Excel from SFTP workbench error
Trying to upload an excel file with multiple sheets using Workbench from an SFTP server, When I validate the settings I get the error: Path extension '.tmp' is not supported. Use ExcelFile.Load method that accepts LoadOptions paramter to explicitly specify source file format. Parameter name: path The path is in the…
-
Domo Workbench Data Loading Error sending to non-users
We recently removed a user as an Admin from our DOMO site. However, they are still receiving notifications on errors from the workbench. Is there a way to remove them? When we open the workbench job, under Notifications, the user name DOES NOT even appear as an option. Any help would be appreciated.
-
Index was out of range. WB 5 Error
I started getting the following error on one of my jobs: "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index". Any idea about what it means. I beilve it is related to the Lookup transform used in the job I havent run the job nor made chagnes to the data sources for…
-
Limit dataset job view by user
Hello We have a server in which Workbench is installed, but are looking to have multiple user accounts to access it. Is it possible for User A to see only their dataset jobs, User B to see theirs, etc.? It appears that currently the domain drives what is seen and we share that. Hope that makes senese. Thank you! Ron