Hello,
I am running the Generate option on the egdbSQL Add on, I keep getting the following error:
There is already an open DataReader associated with this Command which must be closed first.
TraceLog Error: -2146233079 : 11/24/2021 9:24:27 AM: STACK TRACE: at System.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command)
at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at sqlfetch.sqlfetch.FetchToDataTable(String sql) in C:\Projects\Danny\Tools\vs\SM3Extension\sqlfetch\sqlfetch.cs:line 1263
at sm3egdb.ssPerfQueryGenerator.makeSQL(sqlfetch sf, ssLayerInfo layerInfo, ssQueryParams queryInfo) in C:\Projects\Danny\Tools\vs\SM3Extension\sm3egdb\ssPerfQueryGenerator.cs:line 474
at sm3egdb.ssPerfQueryGenerator.generateArbitrarily_ODBC(sqlfetch sf, String subdir) in C:\Projects\Danny\Tools\vs\SM3Extension\sm3egdb\ssPerfQueryGenerator.cs:line 1315
at sm3egdb.ssPerfQueryGenerator.GenerateQueries(String directory, String connString, ConnectionType connType, Int32 connectionHash) in C:\Projects\Danny\Tools\vs\SM3Extension\sm3egdb\ssPerfQueryGenerator.cs:line 1687
at sm3egdb.Program.doGenerate(String connString) in C:\Projects\Danny\Tools\vs\SM3Extension\sm3egdb\Program.cs:line 82
at sm3egdb.Program.Main(String[] args) in C:\Projects\Danny\Tools\vs\SM3Extension\sm3egdb\Program.cs:line 709
This is Monitor 10.8 DB Version Info:
SDE 10.6.1 | MSSQL 13.0.5101.9 |
Thanks for any advice and assistance on how to resolve this issue.
Solved! Go to Solution.
Checking the troubleshooting section of the read me, adding Type System Version=SQL Server 2012 solved the issue.
Checking the troubleshooting section of the read me, adding Type System Version=SQL Server 2012 solved the issue.
Tried adding the System Version argument and still receiving the ERROR: There is already an open DataReader associated with this Command which must be closed first. Tried"Latest" as well as "SQL Server 2012" despite running SQL Server 2017. When I used "SQL Server 2017" it did not run at all.