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: https://domo-support.domo.com/s/article/000005234?language=en_US 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

  • GrantSmith
    GrantSmith Coach
    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!**

Answers

  • GrantSmith
    GrantSmith Coach
    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!**