Als ik vanuit het Invantive Query Tool via het SQL Server-protocol TDS verbindt met een Invantive UniversalSQL Server-database met Crisp Chat er in, dan krijg ik bij het uitvoeren van de volgende query:
select distinct TABLE_SCHEMA from INFORMATION_SCHEMA.TABLES order by TABLE_SCHEMA
de volgende foutmelding:
itgenviw001
Parent not set on view INFORMATION_SCHEMA.TABLES.
itgenclr096
An unknown error occurred.
Callstack
Microsoft.Data.SqlClient.SqlException
at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose)
at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at Microsoft.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
at Microsoft.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
at Microsoft.Data.SqlClient.SqlDataReader.Read()
at Invantive.Data.Providers.SqlServer.SqlServerProvider.ReadDataReader(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, SparseArrayPool sparseArrayPool, IConnection connection, ResultSet resultSet, IDataReader dataReader)
at Invantive.Data.AnsiSqlProviderBase.RetrieveSimpleResultSet(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, IConnection pooledConnection, String actionSql, ParameterList parameters, String loggingTableName)
at Invantive.Data.Providers.SqlServer.SqlServerProvider.GetObjectMetadata(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, Connection connection, IEnumerable`1 objectSpecifications, Boolean raiseErrorIfNotFound)
at Invantive.Data.AnsiSqlProviderBase.<>c__DisplayClass428_0.<GetObjectMetadata>b__0(Connection pooledConnection)
at Invantive.Data.AnsiSqlProviderBase.ExecuteWithRetry[T](GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, Connection pooledConnection, ConnectionContext context, Func`2 action, Int32 maxAttempts, Int64 sleepOnRetryMs, String originMethod, Nullable`1 originLineNumber)
at Invantive.Data.AnsiSqlProviderBase.GetObjectMetadata(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, ObjectSpecification objectSpecification, Boolean raiseErrorIfNotFound)
at Invantive.Sql.V1.DataSourceOrFunctionWithRotatorTree.OnExecute(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, SparseArrayPool sparseArrayPool, ParameterList parameters, QueryObject additionalFilters, ExpressionParser expressionParser)
at Invantive.Sql.V1.QueryTree.Execute(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, ParameterList parameters, QueryObject additionalFilters, ExpressionParser expressionParser)
at Invantive.Sql.V1.SelectStatementTree.OnExecute(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, SparseArrayPool sparseArrayPool, ParameterList parameters, QueryObject additionalFilters, ExpressionParser expressionParser)
at Invantive.Sql.V1.QueryTree.Execute(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, ParameterList parameters, QueryObject additionalFilters, ExpressionParser expressionParser)
at Invantive.Sql.V1.QueryPlan.<>c__DisplayClass7_0.<.ctor>b__0()
at System.Lazy`1.CreateValue()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Lazy`1.get_Value()
at Invantive.Sql.V1.QueryPlan.ForcePlan(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep)
at Invantive.Sql.V1.QueryPlan.GetFields(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep)
at Invantive.Sql.V1.QueryPlan.GetFieldCount(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep)
at Invantive.Data.QueryPlanCacheEntry.<>c__DisplayClass12_0.<.ctor>b__0(IQueryPlan )
at System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext()
at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
at Invantive.Data.QueryPlanCacheEntry..ctor(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, String sqlStatement, IQueryPlan[] queryPlans, ParameterList parameters)
at Invantive.Sql.V1.SqlEngine.A(GlobalState , ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, QueryPlan[] , String , ParameterList parameters, ResultSetAuditInformation )
at Invantive.Data.ConnectionManager.ExecuteAndCombineQueryPlansV1(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, QueryPlan[] queryPlans, String sqlStatement, ParameterList parameters)
at Invantive.Data.ConnectionManager.ExecuteProviderPassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters, SqlExecutionStep sqlExecutionStep, String callSafeNameOverrule)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Invantive.Data.ConnectionManager.ExecuteProviderPassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters, SqlExecutionStep sqlExecutionStep, String callSafeNameOverrule)
at Invantive.Data.ConnectionManager.b(GlobalState owner, ExecutionOptions , SqlExecutionStep , String actionSql, ParameterList , String )
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Invantive.Data.ConnectionManager.b(GlobalState owner, ExecutionOptions , SqlExecutionStep , String actionSql, ParameterList , String )
at Invantive.Producer.Windows.Forms.QueryToolResults.A(GlobalState owner, ExecutionOptions , IProgressNotifier , String , ParameterList bindVariables, Boolean , Boolean , Boolean , Boolean )
at Invantive.Producer.Windows.Forms.QueryToolResults.A(GlobalState , ExecutionOptions executionOptions, String , ParameterList )
Ik zou hetzij uitvoer verwachten hetzij een begrijpelijke foutmelding.