-
Failed to Execute - Domo Workbench
Hi All, I'm getting this error when trying to execute workbench job. "Position is not in format ColumnNameRowName." Any help appreciated. Thanks!
-
Domo workbench - "attempting to open data source"
When a workbench job is executing, does anyone know what is happening when the preview window execution step says "attempting to open data source"? We will have a job that gets stuck on this step for several hours and it is unable to get past this step, then the query times out. The workbench job is executing a stored…
-
Has anyone gotten replacement variables to work with the ODBC connector on a consistent basis
I am trying to utilize replacement variables on ODBC connector queries to move towards incremental APPEND queries instead of REPLACE queries. However, it is taking multiple attempts to get the workbench to save the replacement variable. Without saving it, I keep getting "Replacement parameter does not exist for column XXX"…
-
Is it possible for two people to have admin access to the Domo Workbench?
-
Domo Workbench Error
I have an Excel file that gets picked up using Domo Workbench once per week. Workbench is showing an error, "Cannot read that as a ZipFile." The file is not configured as a zip file. It's a local Excel file. And it's configured to load as an Excel file (Excel: On-Premise). I opened after seeing the error and it opens in…
-
Workbench error for SQL
We get errors - Coould not reload job from Server, see log file for more details error and Response status code does not indicate success: 400 (bad request). This was working just fine till today.
-
Workbench 5 error message when uploading local Excel file...
Attempting to create a job uploading a local excel file using Workbench 5. Getting the error message depicted below… File looks clean to me. There are several formulas in the sheet returning #N/A errors. I've set the below error handling for this. Any ideas what is wrong with the excel file? (I've also tried to upload the…
-
Workbench Notifications
Hello all, I am here to ask if there is something in place that can be setup as far as notifications go when a workbench job has not completed (regardless of failure or succeeding). I know you can the notification on success or on failure but is there anything like "send email when job taking longer than 1 hour to run" or…
-
workbench job - syntax auto fill
Hello In our workbench jobs, we often alias columns and tables with A., B., C., etc. When I type "A." and it autofills to the ADD function, and C. to CASCADE, etc. Does anyone know how to/if you can turn this off?
-
Can you bulk change time zone in Workbench?
I see steps to change time zone transform settings in individual Workbench jobs here: https://community-forums.domo.com/main/discussion/16845/how-do-i-change-the-timezone-in-workbench But is there a way to do this in bulk or at an account level? One of my customers has hundreds of Workbench jobs that need to be updated.
-
Time change
Hello, currently I am pulling data via an ODBC Connector and pulling through Workbench. What I am finding is, when I query the data locally on the server I am seeing the correct dates, however, when I am pulling it through Domo the datetime is 4 hours behind. How do I correct this? Currently I am in EST time.
-
Incremental refreshes using Domo Workbench
Hi everyone, is it possible to do incremental refreshes using Domo Workbench? I have several datasets with more than 15 or 20 million rows and I'm trying to find a way to only load new data using the Domo Workbench instead of full replace, which is time and resource consuming. I'm using ODBC Connection provider.
-
Add CSV filename as column
I am running a few workbench jobs, and I need to able to add the file name from each CSV in the folder I'm loading. When you create a workbench job using an xlsx file, you have the option to check a box to add the file name. But for CSV there is no option I can see. Is there a way through calculated columns or any other…
-
Problems with Workbench, ODBC, MySQL and the data specialist exam
Hi I have a problem with taking this exam: https://learndomo.domo.com/learn/course/383/play/1608/data-specialist-practical-test-2h The task wants you to use Workbench 5 to set up a MySQL job and then import the data from Workbench to Domo. The connection to Domo from Workbench works fine. When I use the parameters for the…
-
Amazon Connector Error
I'm having trouble updating my dataset using amazon selling partner API. The error is: The report being downloaded was not processed as it returned a status of FATAL so cannot proceed. Here is the configurations of my connector. Any help is appreciated!!!
-
for loop in Large amount of Data in Workbench.
Hello all, I'm tiring to pull large amount of data via Workbench, previously this was done with SSIS for loop container pulling only fraction of the time frame data at a time, and appending the results. is there way to achieve this in workbench as I'm not able to find the proper documentation.
-
DOMO Workbench Error: Failed to get a response from the Domo server
I am running a workbench job that is failing with the error message: Failed to get a response from the Domo server. Other jobs on my Workbench are running as normal. I tried to re-run the job, and rebooting my machine. Is there any way to remedy.
-
User not a member of the 'Domo Workbench User' - But only when using impersonation
I am currently transferring my workbench jobs to a new computer on a new network system. I keep getting "User not a member of the 'Domo Workbench User' group" when setting up impersonation on network file jobs. My username, which I use for impersonation, is already part of the 'Domo Workbench User' group. I can run jobs…
-
User is not member of 'Domo Workbench Users' group
We're getting this error User is not member of 'Domo Workbench Users' group Is this something new with workbench? How can we fix this? We're trying to import a backup file. Thank you
-
Workbench Schedule Jobs are not working .
Hello Experts , Our workbench scheduled jobs were working fine but all of a sudden they are not running on schedules. We did change it to Manual and then changed it to Schedules ,still didn't work . Reached out to Domo Support but nothing helped as of now . Please help us experts !!
-
Could not authorize user
We are facing an issue .We authorize user 'A' to authorize but somehow password got change so we had to re-authorize it . We have two accounts added to our workbench and both uses user 'A' to authorize .Unfortunately one account is failing to authorize plus the jobs keep spinning ,no new jobs can be created . We have a…
-
Workbench jobs retrieval
Hi I'm trying to retrieve all the codes that I've created for my dataset jobs. This was removed when I changed password. However, as I checked the datasets in Domo browser and it is still running in the background and updating the datasets.
-
I lost connction to DOMO. get "Could not authenticate user"
When I open workbench, I saw an error ""Could not authenticate user" and lost all dataset jobs. does anyone know what cause the problem and how to fix this? Thank you very much
-
Workbench SFTP Filename Changes
I need to schedule workbench to download a file from an SFTP site. The name file I am downloading will change. It has a date and time embedded, and a randomized string. It looks something like this {yyyymmdd_hhmmss_Product Report_V2_{some string}.xlsx. Can I tell workbench to bring whatever it sees containing "Product…
-
Using Workbench Writeback to MS SQL Server
We're trying to writeback data to our MS SQL Server using workbench. We follow the instructions provided here: but we consistently get the same error. [09.29.23 6:45:49 PM] Determining execution parameters [09.29.23 6:45:58 PM] Starting execution of job sql3 WBK | Macola | CICIMPY to Domo DataSet [09.29.23 6:45:58 PM]…
-
i have added my Non-Admin user to the "Domo Workbench Users"
hi, i have added my Non-Admin user to the "Domo Workbench Users" Local group that is created while installing workbench its working fine for sometime when i shutdown and restart my system its again asking me admin username and password to get access to workbench and also my username is deleted from the admin group. why is…
-
Workbench with impersonation configuration
I'm setting up an ODBC SQL Server connection with Windows Authentication but it's not working. I am included in the Domo Workbench User group Am I missing any configuration?
-
Hyperlink in an alert message
Is it possible to add a hyperlink in an alert message. I am having this alert hit slack and would like the ability to include a card hyperlink.
-
Date change in workbench
Hi, I am using Domo workbench. When i run a data feed with a query the time seems to change when I see the data on the webpage. So for example, when I run a query and put it in workbench it is saying July 01st 00:00, however, when I look at the data on the data page it says June 31st 08:00. There is a 5 hour difference. I…
-
How to prevent WB from disabling jobs if source file is not found
How can I prevent WB from disabling jobs if source file is not found. Most of my files are located in a server. If for whatever reason the WB PC loses connection to the server and it attempts to run a job using a file that it cannot temporarily access, the job gets disabled. Generally, soon after connection is gained again…