Om de code uit te voeren klik ik “Execute All”. Hierna krijg ik de onderstaande foutmelding:
itgengpr015: Statement #3 ‘create or rep…cremental@eol;’ starting on line 5 caused an error.
Unknown table ‘ACCOUNTSINCREMENTAL’. Possible valid alternatives: AccountsIncremental, ExactOnlineREST.Incremental.GLAccountsIncremental, ExactOnlineREST.Incremental.AccountsIncremental.
Message ID: 0842a935-83f5-4cce-9684-77a4d55d0697
Occurred (UTC): 23/10/2023 12:14:03
create or replace table NtntAccountsIncremental@sql
as
select *
from AccountsIncremental@eol;
ValidationException
ValidationException
at Invantive.Basics.ValidationException…ctor(GlobalState owner, ExecutionOptions executionOptions, String messageCode, String errorMessage, String kindRequest, String localStackTrace, String nk, Exception innerException, Boolean inheritMessageCodeWhenPresent, Nullable1 uid, Boolean isRecoverable, String poolIdentityId, String url, Nullable
1 partyUid)
at Invantive.Data.DataContainerMetadata.ThrowErrorForUnknownTable(GlobalState owner, ExecutionOptions executionOptions, IProviderManager manager, String fullyQualifiedName)
at Invantive.Data.Providers.ExactOnline.ExactOnlineProvider.ThrowErrorForUnknownTable(GlobalState owner, ExecutionOptions executionOptions, String fullyQualifiedName)
at Invantive.Sql.V1.DataSourceOrFunctionWithRotatorTree.OnExecute(GlobalState owner, ExecutionOptions executionOptions, ParameterList parameters, QueryObject additionalFilters, ExpressionParser expressionParser)
at Invantive.Sql.V1.QueryTree.Execute(GlobalState owner, ExecutionOptions executionOptions, ParameterList parameters, QueryObject additionalFilters, ExpressionParser expressionParser)
at Invantive.Sql.V1.SelectStatementTree.OnExecute(GlobalState owner, ExecutionOptions executionOptions, ParameterList parameters, QueryObject additionalFilters, ExpressionParser expressionParser)
at Invantive.Sql.V1.QueryTree.Execute(GlobalState owner, ExecutionOptions executionOptions, ParameterList parameters, QueryObject additionalFilters, ExpressionParser expressionParser)
at Invantive.Sql.V1.DdlStatementTree.OnExecute(GlobalState owner, ExecutionOptions executionOptions, ParameterList parameters, QueryObject additionalFilters, ExpressionParser expressionParser)
at Invantive.Sql.V1.QueryTree.Execute(GlobalState owner, ExecutionOptions executionOptions, ParameterList parameters, QueryObject additionalFilters, ExpressionParser expressionParser)
at Invantive.Sql.V1.QueryPlan.ForcePlan(GlobalState owner, ExecutionOptions executionOptions)
at Invantive.Sql.V1.QueryPlan.Fetch(GlobalState owner, ExecutionOptions executionOptions, String sqlStatement)
at Invantive.Data.ConnectionManager.QJ.N(QueryPlan )
at System.Linq.Enumerable.WhereSelectArrayIterator2.MoveNext() at System.Linq.Buffer
1…ctor(IEnumerable1 source) at System.Linq.Enumerable.ToArray[TSource](IEnumerable
1 source)
at Invantive.Data.ConnectionManager.ExecuteAndCombineQueryPlansV1(GlobalState owner, ExecutionOptions executionOptions, QueryPlan queryPlans, String sqlStatement, ParameterList parameters)
at Invantive.Data.ConnectionManager.ExecuteProviderPassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters, String callSafeNameOverrule)
at Invantive.Data.ConnectionManager.PassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters, String callSafeNameOverrule)
at Invantive.Data.ActionProceduresBase.PassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters)
at Invantive.Producer.Windows.Forms.QueryToolResults.DFR(GlobalState , ExecutionOptions , IProgressNotifier , String , ParameterList , Boolean , Boolean , Boolean , Boolean )
at Invantive.Producer.Windows.Forms.QueryToolResults.CFR(GlobalState , ExecutionOptions , String , String , Boolean )
at Invantive.Producer.Windows.Forms.QueryToolResults.ExecuteStatements(GlobalState owner, ExecutionOptions executionOptions)
at Invantive.Producer.Windows.Forms.QueryToolDocumentViewModel.JV.DV.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Invantive.Producer.Windows.Forms.QueryToolDocumentViewModel.JV.P()
at System.Threading.Tasks.Task1.InnerInvoke() at System.Threading.Tasks.Task.Execute() at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot) at System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution) at System.Threading.ThreadPoolWorkQueue.Dispatch() at Invantive.Data.DataContainerMetadata.ThrowErrorForUnknownTable(GlobalState owner, ExecutionOptions executionOptions, IProviderManager manager, String fullyQualifiedName) at Invantive.Data.Providers.ExactOnline.ExactOnlineProvider.ThrowErrorForUnknownTable(GlobalState owner, ExecutionOptions executionOptions, String fullyQualifiedName) at Invantive.Sql.V1.DataSourceOrFunctionWithRotatorTree.OnExecute(GlobalState owner, ExecutionOptions executionOptions, ParameterList parameters, QueryObject additionalFilters, ExpressionParser expressionParser) at Invantive.Sql.V1.QueryTree.Execute(GlobalState owner, ExecutionOptions executionOptions, ParameterList parameters, QueryObject additionalFilters, ExpressionParser expressionParser) at Invantive.Sql.V1.SelectStatementTree.OnExecute(GlobalState owner, ExecutionOptions executionOptions, ParameterList parameters, QueryObject additionalFilters, ExpressionParser expressionParser) at Invantive.Sql.V1.QueryTree.Execute(GlobalState owner, ExecutionOptions executionOptions, ParameterList parameters, QueryObject additionalFilters, ExpressionParser expressionParser) at Invantive.Sql.V1.DdlStatementTree.OnExecute(GlobalState owner, ExecutionOptions executionOptions, ParameterList parameters, QueryObject additionalFilters, ExpressionParser expressionParser) at Invantive.Sql.V1.QueryTree.Execute(GlobalState owner, ExecutionOptions executionOptions, ParameterList parameters, QueryObject additionalFilters, ExpressionParser expressionParser) at Invantive.Sql.V1.QueryPlan.ForcePlan(GlobalState owner, ExecutionOptions executionOptions) at Invantive.Sql.V1.QueryPlan.Fetch(GlobalState owner, ExecutionOptions executionOptions, String sqlStatement) at Invantive.Data.ConnectionManager.QJ.N(QueryPlan ) at System.Linq.Enumerable.WhereSelectArrayIterator
2.MoveNext()
at System.Linq.Buffer1..ctor(IEnumerable
1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
at Invantive.Data.ConnectionManager.ExecuteAndCombineQueryPlansV1(GlobalState owner, ExecutionOptions executionOptions, QueryPlan queryPlans, String sqlStatement, ParameterList parameters)
at Invantive.Data.ConnectionManager.ExecuteProviderPassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters, 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, String callSafeNameOverrule)
at Invantive.Data.ConnectionManager.PassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters, String callSafeNameOverrule)
— End of stack trace from previous location where exception was thrown —
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Invantive.Data.ConnectionManager.PassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters, String callSafeNameOverrule)
at Invantive.Data.ActionProceduresBase.PassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters)
at Invantive.Producer.Windows.Forms.QueryToolResults.DFR(GlobalState , ExecutionOptions , IProgressNotifier , String , ParameterList , Boolean , Boolean , Boolean , Boolean )
at Invantive.Producer.Windows.Forms.QueryToolResults.CFR(GlobalState , ExecutionOptions , String , String , Boolean )