Unable to import DataSet Jobs successfully
I am unable to import DataSet files and then succesfully uploading to our domo server.
As a way to duplicate DataSet Jobs, in order to save time redoing schemas and transfroms I tested exporting a working DataSet job and then importing it back, changing the DataSet name when asked by workbench.
when I then try to run the Job it fails and says: Response status code does not indicate success: 500 (Server Error).
I cna then find an instance of said job in our server but every time the Job rusn again it creates a extra instance of the DataSet instead of replaing it. Making any reruns of the Job useless.
I tried importing a DataSet that I know worked before exporting/exporting, deleting the old DataSet Job and running the Job without modifying the Job or Name (any many combinations of those) but i always get the same outcome.
I am worried also that when I change the computer used to run workbench I will have the same issue and have to redo all DataSet Jobs again.
Best Answer
-
The issue was resolved by reinstalling the workbench. Now I can export and import the same job as it should
1
Answers
-
@rado98 I think your suggestion here is to create an option to duplicate DataSet jobs in Workbench so that you don't have to go through the workaround you described above, is that fair?
For some context, how many WB jobs do you have to create? Are they all roughly the same (same type, DNS, source)?
I'll look into the error you are having in the short term, but long term we will look at adding a duplicate job feature so you are not having to export and import jobs in an attempt to duplicate.
Alex Peay
Product Manager
Domo3 -
A duplicate function would be ideal.
I have probably 10 or so WB job that would benefit from a duplication function.
I am setting up DataSets from Excel spreadsheets so I find myself changing to the same schema and transforms over and over again just because similar data is set up across different tabs. Although I have found some work around for some things a batch data type changing funtion would also be apreciated.
Is the issue simply that I am importing data generated on the same PC? Should I expect similar issues when importing to different PCs?
Thanks for the quick follow up.
RA
0 -
Are your schemas the same or are you having to pull them into a common schema for the transforms? Would there be a reasonable expectation on my part that the transforms would have the same columns to use?
I would suspect your issue is that it is the same machine with the same Agent ID.
Alex Peay
Product Manager
Domo2 -
A duplicate function would be great. Or, the ability to create a job via command line. We currently have 75 jobs and I have been asked to bring in two other SQL databases that have over 100 tables each.
0 -
The issue was resolved by reinstalling the workbench. Now I can export and import the same job as it should
1 -
@COWsupport have you looked at the Domo Public APIs? This may be a better option for your importing data needs:
Alex Peay
Product Manager
Domo0 -
You can also do some work on the CLI, follow the link here to the Domo help center to learn about running jobs from the command line:
Alex Peay
Product Manager
Domo0 -
It would be great if you could create a dataset via command line. We have our partner looking into the API for us. Thanks.
2
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 688 Automate
- 177 Apps
- 453 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive