-
Jobs are running constantly and ignoring their schedule on workbench
Hi Dojo Community, I have come across this issue were handful of jobs were running constantly and ignoring their schedule on workbench. Restarted the services but that had no effect, ended up changing the scheduler for each job from manual and back to its schedule run time and that worked. That tells me that most likely…
-
Max Column Width?
We have a vendor that is sending us data where one of the columns has HUGE strings, but they are all being cut off at 1024 characters. We can't figure out if workbench is cutting it at 1024 characters or if it is on their side. Does anybody know offhand if this is a workbench limitation? Thanks
-
Quickbooks On Workbench - Sequence contains no matching element
Unable to load quickbooks on premise data through workbench. QB file located on local computer(Accessing the remote computer that's always logged in through anydesk. Report selected, authorized workbench to access quickbooks. Error : Job requires interactive session, but no interactive session available. WorkItem…
-
Setting up Workbench on new server - "Key not valid for use..." Error occurring
I have set up Workbench on a new server and I have imported and updated a job that was previously running on another machine. On my first and all subsequent attempts at running the job on the new server, I receive the following two notifications: [02.05.20 5:02:50 PM] Determining execution parameters [02.05.20 5:02:50 PM]…
-
What is the main purpose of workbench?
My company has been using domo for years, yet I don't know what are workbench for because we are not using it. What is the main purpose of workbench anyway?
-
How to check workbench job status from comand line
I need to check 1000 workbench jobs status, is there any way I can automate this ?
-
Workbench Error on last run: The directory is not empty.
I'm not sure what this error indicates, looking at the log it's not really clear what to do to resolve the issue any one had this and resolved it? The message I'm getting is "The directory is not empty." And here's the log info: [ERROR] [16416:25] 2019-12-26 11:05:29,954 - Error executing DataSet Job System.IO.IOException:…
-
lastvalue replace variables workbench 5
I am trying to get our table to append new info everyday instead of replacing our tables every day. when I try to use the lastvalue in workbench 5 I am getting the same error: [11.14.19 2:12:27 PM] One or more errors occurred. ERROR [HY000] [Oracle][ODBC][Ora]ORA-01858: a non-numeric character was found where a numeric was…
-
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…
-
MongoDB Connection to WB (local)
Hello, Experts, I am trying to connect MongoDB living on a host machine on our network with WorkBench. I went through the steps advised by the MongoDB doc site saying I need to install a MongoDB ODBC driver (v1.2). Installed that and got it configured. I have installed MongoDB Compass (client tool) and have successfully…
-
Workbench - ODBC - Global Replacement Variables - Main use of and how to use them?
I cannot find any example, post, or video that clearly shows what Global Replacement Variables are best used for and how to use them (ideally in the query unless they aren't meant to be used here)? I think a solid definition of what the difference is between a 'Replacement Variable' and a 'Global Replacement Variable'…
-
Workbench 5 Supported Windows OS
Hi, We are looking to migrate off Windows Server 2012R2 to either Windows Server 2019 or 2016. I see workbench 5 is supported on Windows Server 2016, is there a plan to certify on Windows Server 2019?
-
SFTP Error
I'm trying to load a set of historical data that is batched out monthly in an SFTP server via CSV files. I can do some of the files but there are a handful of them that provide me some sort of the same error. "The CSV appears to be corrupt near record '683741' field '11 at position '2779.' Current raw data:" Different CSVs…
-
Copying or "save as" a workbench job
Curious if anyone knows if you can copy of "save as" a workbench job. If not, which I think is the case, any tricks that you have used to mirror them? Also, I am doing some transforms and column name changes in workbench so this is why copying in workbench would be a huge help. Not sure if the DOMO ETL is faster and maybe…
-
Workbench Filter Dataset on a Year of a Date
Hi, I am trying to bring in some ODBC datasets, but only want workbench to pull in anything that is for the current year. I have invoice date in my dataset as a column that I want to use the following transformation to isolate only invoices for this year. See screenshot below. I know that I can use redshift/SQL/Magic to do…
-
Folder Permissions
I'm trying to connect to an excel file via Workbench 5 to a folder in my company's share drive and right now I have Read Access granted for that specific path. I'm getting a response of No Source File. If I move that file to a different location I am able to bring it in no problem. What level of folder permission do I need…
-
Workbench Transforms - replacing found substrings by an empty string
Hi there, I am trying to delete some substrings using "Search/Replace" transform. I am able to find the substring i try to delete, but cannot find what to put in "Replace with" value. Using ^$ just replaces the substring with this two parameters, and if i try to leave this box empty, i get an error "Value cannot be null.…
-
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…