dotnet / dotnet/machinelearning-modelbuilder

SQL connection is not valid when modifying Command Timeout

Open
#2,646 5 comments 0 reactions 1 assignee Claimed by @zewditu View on GitHub
Stale
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
![image](https://github.com/dotnet/machinelearning-modelbuilder/assets/1238851/a5d04635-0332-4702-99cd-11912a87a7d8)

**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()

![image](https://github.com/dotnet/machinelearning-modelbuilder/assets/1238851/bd3983ef-bc66-43a4-8ad7-931fecadae3c)

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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.