-
SQL partition password reset
Hi - I put in a help ticket without success so far. We are using a SQL partitions connector to bring in accounting data. Following an apparent password reset on database access, some of the datasets continued to work while some larger datasets stopped working but continued to bring in blank lines of data. I reset my…
-
Domo Workbench 5: Unable to Query Provider Types
Hello folks, We use Quickbooks Desktop 22 (queue eye roll) and use Domo WB to connect to the network files and send data over to Domo. I have been seeing this error alot lately. Has anyone ever specifically ran into this type of error and if so what did you do to resolve it? [INFO] [3532:12] 2023-05-18 00:03:30,774 -…
-
Partition By not working to show correct SM% when I change parameters view options
Deal All, I have prepared a P&L summary with below aspect When I change the filter in the "Geography/Product View" and for example I switch from "P&L" to "Geography", I am not able tom show the proper SM% by Geography, I see the same % for the different countries in the same quarter, see below As Column I am showing the…
-
For those using Domo Workbench with Quickbooks Enterprise, how do you deal with modal dialog boxes?
Intuit login, errors pertaining to the qbsdklog.txt file, etc…we are getting multiple errors every single day which hang up all of our Workbench jobs. How does everyone else deal with these? We have implemented a Power Automate script on our servers housing our Workbench jobs, but some of the dialog boxes, particularly the…
-
Kill/revert Workbench Job
Hi , Can you please let me know if I can kill any existing jobs running .I made changes to query and I am not able to revert back or kill the existing running session .
-
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"…
-
Workbench Job changing Date values
I have a Job that is publishing a Date/Time format. When I run Preview, the Date is 04/28/2023 00:00:00. But when I execute the Job, Domo is converting the Date to 4/27/2023 08:00:00. I'm guessing the 00:00:00 is a potential problem—but why not error versus changing value? This was working appropriately and just recently…
-
Using partitioning in ETL or Workbench
Good afternoon. Typically, to not do full replaces of data pulls into Domo from our databases, we have used recursive dataflows with ETL. I am trying to think of a way of accomplishing this using the partitioning features in ETL and/or workbench to avoid the ETL still having to process the whole set of updated+historical.…
-
Removing Java components
Does Workbench installation rely on Java to function? I ask becuase my company is requesting to remove any and al Java components from our VMs where we are hosting our Workbench application. Would getting rid of Java screw up Workbench?
-
Are there any workbench reports available to show configurations for all jobs?
Is it possible to get a list of all directories and files used by Work Bench without having to go through each job one by one? My colleagues and I are working to clean up our workbench instance. One of the issues we've run into is that the jobs are pulling from personal folders that we don't always have the permissions to…
-
Transaction Deadlock workbench error
Good morning. I am curious if anyone has had this error before. One of our workbench jobs has been getting it more and more. I don't know if it is a domo workbench issue, or if it is an issue on the database side where we query the workbench job from Error 40001 Microsoft ODBC SQL Server Driver SQL Server Transaction was…
-
Doubt about updating tables and credits consumption
Hi everyone, I've got a question about Domo's Workbench Process, if 10 tables are used in order to generate 3 tables done processes in Workbench, how much credits will it be needed?
-
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…
-
Scheduled job fails to run when DOMO dataset is deleted
I've set up a job in DOMO workbench to pull data from SQL Server and upload it to DOMO instance. Below are the details: Job Details Transport Type: MS SQL ODBC Data Provider Reader Type: Database Query DOMO Details Dataset Name: test_schedule Dataset Type: Workbench ODBC I'm just using a normal select * from <table> as…
-
Large dataset import in Domo Workbench
Hi everyone, I have a very large dataset (18M rows) that I want to import and it takes too long. The query is already a grouped query so there is no unique ID. I am just trying to figure out if there is a way to import possibly a one time chunk (the data is for 2 years) and then maybe append the data after that. So maybe…
-
Workbench Weird Issues
Hello community, Has anyone encountered the inability to restart/stop the Domo workbench service? Even via command line as administrator on a Windows 2019 Server? Everytime I run the command or try to stop/restart via the GUI in task bar I get a message saying I cannot do it. I checked the workbench logs today and saw…
-
Workbench - SharePoint Plugin
Hi there - Where do I find the sharepoint plugin for workbench? As referenced in the below documentations:
-
What is the best password policy for Encryption on Workbench
We have a requirement to encrypt a few fields while uploading via workbench. What will be a good encryption password policy? Let's say we have ten fields that need to be encrypted, and 30 users need access to them that they can decrypt with a password. do you create 30 different encryption passwords how do you manage these…
-
Workbench dataset stuck in "preparing" Status
Rarely, we will see that there is a scheduled run from the Domo Workbench that is stuck in a "preparing" status on the dataset. In the event that this does occur, there are a few steps to perform that may help with resolving this issue. 1) If the job is still showing a 'Running' Status on Workbench, stop the job from the…
-
Job Ends in Cache Warning
Hi Everyone, I have a job that always ends with a warning. WARNING - Could not clear cache, this will be cleaned the next time the service starts. Does anyone know how to clear out this warning? This particular data set is also duplicating records in the target table. I want to rule out that caching is not causing the…
-
is there a way to run domo workbench 5 on local machine without admin privileges
hi, is there a way to run domo workbench 5 on local machine without admin privileges if there is a way please tell and one more question even after i enter admin password and all when searching for a local files in workbench from my user account i am only seeing admin files but not my excel sheets and all which are present…
-
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…
-
Domo Workbench executing jobs on a Group Schedule multiple times
Hello everyone, I have multiple Workbench jobs that run on a 4 hour schedule. What I have noticed is that when the jobs run, they run 4 times one after the other like they are trying to catch up to the fact that they did not run in the past 4 hours and now running 4 times they look like they they caught up for an hourly…
-
Remove column from existing schema
Hello! Is it possible to remove a column from an existing dataset using the Domo CLI? In otherwords, can I change the schema? My existing schema has 25 columns. But I only have 23 columns in a data file that I want to upload. This causes an issue when uploading the file using the Domo CLI. So, the last two columns of my…
-
DATETIME field with NULL value
I am running into an issue where when I load up some data via workbench there is a table that has a DATETIME field where the default value is NULL. When workbench is querying that, it absolutely does not like that there is a NULL value in that field. It takes about 20+ hours to run the entire process. I removed the column…
-
How can I fix a workbench job where the Schema is locked and doesn't match the dataset?
Hi, everyone! I'm running into an issue with the workbench and can't seem to find a solution. One of my jobs has the work bench schema messed up and is pulling nonexistent headers. I'm not sure if it is getting this information from a previous upload but it doesn't even match the column names or number of columns. I…
-
Workbench - Source File Does Not Exist
Has anyone found a solution for the "Source File Does Not Exist" error? I am using the 'Excel: On-Premise' processing method and using a network drive for storage. Even when I reconfigure and reselect the file it does not resolve and I get the above reference error. Any ideas? Thanks all!
-
Unable to Schedule Jobs
Hi everyone, I can manually run a job which works, however when I schedule a job, it says that it executes however the job does not run and I don't see it in the UI. When I look at the viewer, I see the following error: 'Could not fix consecutive blocks of CRON schedule' Does anyone know how to resolve?
-
Workbench installation failed
I am trying to modify/repair installation of workbench and receiving "Domo Workbench failed to install, see log for more details. Any thoughts and/ or guidance would be appreciated.
-
How to properly partition in Workbench while allowing older data to come in?
I have a SQL Server dataset of 50M rows. Workbench runs the APPEND Update Method HOURLY. I use the table ID as the UPSERT key and the processing query checks the past 7 days ("Insertion Date") for new records. This updates older data unnecessarily with the same data, but protects against issues with the job not running for…