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] Saving the Workbench DataSet Job to Domo.
[09.29.23 6:45:58 PM] Updating Agent Job '831' configuration on the Domo server.
[09.29.23 6:45:58 PM] Requesting CSV source file from the Write Back Provider
[09.29.23 6:45:58 PM] Querying dataset facf965f-3b31-49aa-9d09-75c368cb0ab2
[09.29.23 6:45:58 PM] Dataset query: SELECT
[ID]
,[cmp_wwn]
,[cmp_code]
,[cnt_id]
,[cmp_parent]
,[cmp_name]
,[cmp_fadd1]
,[cmp_fadd2]
,[cmp_fadd3]
,[cmp_fpc]
,[cmp_fcity]
,[cmp_fcounty]
,[StateCode]
,[cmp_fctry]
,[cmp_e_mail]
,[cmp_web]
,[cmp_fax]
,[cmp_tel]
,[sct_code]
,[SubSector]
,[siz_code]
,[cmp_date_cust]
,[cmp_note]
,[cmp_acc_man]
,[cmp_reseller]
,[Administration]
,[cmp_type]
,[cmp_status]
,[DivisionDebtorID]
,[DivisionCreditorID]
,[datefield1]
,[datefield2]
,[datefield3]
,[datefield4]
,[datefield5]
,[numberfield1]
,[numberfield2]
,[numberfield3]
,[numberfield4]
,[numberfield5]
,[YesNofield1]
,[YesNofield2]
,[YesNofield3]
,[YesNofield4]
,[YesNofield5]
,[textfield1]
,[textfield2]
...
[09.29.23 6:45:58 PM] Saving Workbench DataSet Job changes to Domo.
[09.29.23 6:45:58 PM] Updating Agent Job '831' configuration on the Domo server.
[09.29.23 6:45:59 PM] Reporting DataSet Job execution failure to Domo.
[09.29.23 6:45:59 PM] Reporting Agent '9' execution status.
[09.29.23 6:45:59 PM] Recording local stat data
[09.29.23 6:45:59 PM] The remote server returned an error: (400) Bad Request.
I think it has to do with the dataset name not being a log DOMO creates but we're not sure how to force that to happen
Any help would be greatly appreciated
Best Answer
-
This sounds like a bug as per the documentation:
Workbench creates a log table with the same name as the DataSet name mentioned in the Overview tab.
I'd recommend logging a ticket with Domo Support to have them help diagnose your issue.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers
-
This sounds like a bug as per the documentation:
Workbench creates a log table with the same name as the DataSet name mentioned in the Overview tab.
I'd recommend logging a ticket with Domo Support to have them help diagnose your issue.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive