dotnet / dotnet/machinelearning-modelbuilder
SQL connection is not valid when modifying Command Timeout
- Dominant language
- Dockerfile
- Stars
- 285
- Forks
- 66
- PR merge metrics
- No merged PRs in 30d
Description
- Model Builder Version (available in Manage Extensions dialog):
- 17.16.0.23.26802
- Visual Studio Version
Microsoft Visual Studio Community 2022 (64-bit) - Version 17.6.0
**Describe the bug**
Unable to load data from a MSSQL View after changing Command Timeout on the database connection.
Receiving error: SQL connection is not valid.
Error appears as soon as I click OK
Works fine if this setting is not modified and I use a query that is less complex.
**To Reproduce**
Steps to reproduce the behavior:
1. Connect to a database
2. Select Server/DB
3. Click on Advanced
4. Change Command Timeout
5. Click OK on Advanced
6. Click OK on Connection Properties
7. Receive Error

**Expected behavior**
Use the modified (extended timeout) so my complex view can be loaded
2023-05-23 05:24:36.6997 DEBUG SQL connection is not valid. If reloading Model Builder, please re-open the SQL Source dialog to reauthenticate.
at Microsoft.ML.ModelBuilder.DataProviders.SQLDataProvider.GetSQLConnectionString(TabularSqlDataSource sqlData)
at Microsoft.ML.ModelBuilder.ToolWindows.DataTextViewModel.d__137.MoveNext() (Microsoft.ML.ModelBuilder.Utils.Logger.Debug)
at Microsoft.ML.ModelBuilder.DataProviders.SQLDataProvider.GetSQLConnectionString(TabularSqlDataSource sqlData)
at Microsoft.ML.ModelBuilder.ToolWindows.DataTextViewModel.d__137.MoveNext()

Full Log file:
2023-05-23 05:24:04.8010 DEBUG update ModelBuilderDataContext_287.TrainDataContext (Microsoft.ML.ModelBuilder.Utils.Logger.Debug)
2023-05-23 05:24:04.8010 DEBUG update DataTextViewModel_297.TextColumn (Microsoft.ML.ModelBuilder.Utils.Logger.Debug)
2023-05-23 05:24:04.8010 DEBUG update ModelBuilderDataContext_287.GetCompletedTabAsync (Microsoft.ML.ModelBuilder.Utils.Logger.Debug)
2023-05-23 05:24:04.8010 DEBUG update DataTextViewModel_297.IsCompleted (Microsoft.ML.ModelBuilder.Utils.Logger.Debug)
2023-05-23 05:24:04.8010 DEBUG update DataTabDataContext_296.IsCompleted (Microsoft.ML.ModelBuilder.Utils.Logger.Debug)
2023-05-23 05:24:04.8010 DEBUG update DataTextViewModel_297.PossibleTextColumnList (Microsoft.ML.ModelBuilder.Utils.Logger.Debug)
2023-05-23 05:24:04.8010 DEBUG update ModelBuilderDataContext_287.CreateEvaluateTabViewModelAsync (Microsoft.ML.ModelBuilder.Utils.Logger.Debug)
2023-05-23 05:24:04.8010 DEBUG update ModelBuilderDataContext_287.CreateConsumeTabViewModelAsync (Microsoft.ML.ModelBuilder.Utils.Logger.Debug)
2023-05-23 05:24:04.8010 DEBUG update ModelBuilderDataContext_287.GetCompletedTabAsync (Microsoft.ML.ModelBuilder.Utils.Logger.Debug)
2023-05-23 05:24:04.8010 DEBUG update DataTextViewModel_297.SelectedTextColumn (Microsoft.ML.ModelBuilder.Utils.Logger.Debug)
2023-05-23 05:24:04.8010 DEBUG update ModelBuilderDataContext_287.CreateTrainTabViewModelAsync (Microsoft.ML.ModelBuilder.Utils.Logger.Debug)
2023-05-23 05:24:04.8010 DEBUG update ModelBuilderDataContext_287.CreateEvaluateTabViewModelAsync (Microsoft.ML.ModelBuilder.Utils.Logger.Debug)
2023-05-23 05:24:04.8010 DEBUG update DataTextViewModel_297.ShowTextColumnSearchBox (Microsoft.ML.ModelBuilder.Utils.Logger.Debug)
2023-05-23 05:24:04.8010 DEBUG update ModelBuilderDataContext_287.TrainDataContext (Microsoft.ML.ModelBuilder.Utils.Logger.Debug)
2023-05-23 05:24:04.8010 DEBUG update ModelBuilderDataContext_287.GetCompletedTabAsync (Microsoft.ML.ModelBuilder.Utils.Logger.Debug)
2023-05-23 05:24:04.8010 DEBUG update ModelBuilderDataContext_287.CreateEvaluateTabViewModelAsync (Microsoft.ML.ModelBuilder.Utils.Logger.Debug)
2023-05-23 05:24:04.8010 DEBUG update ModelBuilderDataContext_287.CreateConsumeTabViewModelAsync (Microsoft.ML.ModelBuilder.Utils.Logger.Debug)
2023-05-23 05:24:36.6997 DEBUG SQL connection is not valid. If reloading Model Builder, please re-open the SQL Source dialog to reauthenticate.
at Microsoft.ML.ModelBuilder.DataProviders.SQLDataProvider.GetSQLConnectionString(TabularSqlDataSource sqlData)
at Microsoft.ML.ModelBuilder.ToolWindows.DataTextViewModel.d__137.MoveNext() (Microsoft.ML.ModelBuilder.Utils.Logger.Debug)
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.