MS SQL Server Connector Error

We have a job that extracts data from SQL through the SQL Server connector. It has been running successfully for a long time but it started failing yesterday. I tried recreating the data connection and let the query only pull data for a few days. It ran successfully. However, after I update the query to pull more data (e.g. 150k), it no longer works. We have contacted Support but wonder if anyone had similar issues before who can point us to the right direction. This is a critical dataset and we are looking to resolve it today. Please see below for the error message. Appreciate your inputs!
|
---|
Best Answer
-
Hopefully you've been able to resolve this by now. Looks like the connector was updated on 11/1 so Domo support will be your best option for debugging this issue if you're still experiencing it. In the meantime, make sure the configuration options on your server haven't changed.
Worst case scenario you can pull the data in through the SQL partition connector, workbench, or the CLI tool.1
Answers
-
Hopefully you've been able to resolve this by now. Looks like the connector was updated on 11/1 so Domo support will be your best option for debugging this issue if you're still experiencing it. In the meantime, make sure the configuration options on your server haven't changed.
Worst case scenario you can pull the data in through the SQL partition connector, workbench, or the CLI tool.1 -
Thank you. Unfortunately this has not yet been resolved. We are still working with support but we did have some success with the SQL partition however it runs 10 times slower.
0
Categories
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 437 Beast Mode
- 23 Variables
- 513 Automate
- 115 Apps
- 390 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive