Exact Online: itgensql035 & Ukendt ID 'CFD.ID'. Overvej følgende: ID, Modified

[tbx8]

Siden 4. august 2026 modtager vi en meddelelse ved hvert opkald via Invantive Bridge Online:

itgensql035
Ukendt ID 'CFD.ID'.
Overvej en af følgende: ID, Modified.
(itgensql035, 2b4cfe89-a973-4292-b0bd-6795a10aea1f)

I overvågningstidslinjen er denne også synlig, men da med meddelelsen:

Ukendt ID ‘CFD.ID’.
Overvej en af følgende: ID, Modified. (CFD.ID).‘

På den anmodende side er der ikke ændret noget, vi anmoder enten om alle data på et endpoint eller ændrede data (på Modified).

Hvad går galt her?

[forums]

Udfyldning af information

Er det muligt at tilføje et (anonymiseret) skærmbillede af forespørgslens detaljer i Invantive Bridge Online Monitoring som beskrevet i Meer inzicht met nieuwe Bridge Online Monitoring?

Detaljerne kan findes ved at klikke på downloadforespørgslen, som repræsenterer emnet for dette emne.

Downloadforespørgslen har normalt en SQL-erklæring, hvor tabelnavnet er synligt.

Vær venlig at lade mindst følgende data være synlige fra begge kolonner:

• titellinjen med forespørgsels-ID,
• statuskode, netværksstørrelse, sti og tidspunkter i venstre kolonne,
• fejlkode og fejlmeddelelse helt nederst i venstre kolonne,
• hele højre kolonne inklusiv SQL-erklæring, tabelnavn og parameter værdier.

For eksempel:

Kontroller korrekt server og bruger

Kontroller omhyggeligt, at du logger ind på det Bridge Online-websted, der også bruges fra Power BI, og med det samme brugernavn. Du kan kun se anmodningerne fra den Invantive Cloud-bruger, som du logger ind med på webstedet.

Der er fire servere i brug:

• bridge-online.cloud
• app-online.cloud
• bridge-online.invantive.com
• app-online.invantive.com

Den server, der bruges, findes i dit script eller kildekode til rapportering.

Kontroller korrekt forespørgsel og detaljer

Sørg for, at du først vælger forespørgslen for at se detaljerne. Der bør kun være en forespørgsel synlig på skærmbilledet.

Kontroller også omhyggeligt, om forespørgslen har en sti med odata4 eller apps. Forespørgsler med andre stier er generelt ikke relevante for dette formål.

Fejlmeddelelse og tips pr. e-mail

Desuden vil den Invantive Cloud-bruger, der har fejlmeddelelsen på sin e-mailadresse, ofte modtage en e-mail med en fejlmeddelelse og tips, hvis der er tale om en fejlmeddelelse i Power BI, Power Query, Azure Data Factory, Qlik eller Tableau.

Rådet er at kontrollere den pågældende brugers spam for sådanne e-mails sendt fra support@invantive.com.

[tbx8]

Hermed er der vedhæftet et skærmbillede af systemmeddelelsernes download ved denne fejl..

Endnu en gang: denne fejl opstår siden sidste tirsdag, før det var ikke sket og der har ikke været ændringer i hverken Invantive- eller opkaldssiden (Fabric) i forhold til legitimationsoplysninger, opkaldsmetoder osv.

I Invantive-databasen er der dog en view, hvor vi læser Exact Online-tilpassede felter (baseret på de instruktioner, der er delt på forummet, og knyttet til database-opstarten) deri blev view alias CFD som nævnt i fejlen. Denne view har været der i flere måneder.

Efter at have fjernet denne create view er dataindlæsningen i dag lykkedes.

Hvordan kan det være, at en view, der har været der i et stykke tid, pludselig forårsager fejl?

[forums]

Venligst tilføj fejlen som tekst, det forbedrer læsbarheden og søgbarheden. Er det muligt at dele definitionen af viewet?

[tbx8]

Den fulde fejlmeddelelse er

ValidationException
Invantive.Basics.InvantiveSqlException
   at Invantive.Basics.ValidationException..ctor(GlobalState owner, ExecutionOptions executionOptions, String messageCode, String errorMessage, String kindRequest, String localStackTrace, String nk, Exception innerException, Boolean inheritMessageCodeWhenPresent, Nullable`1 uid, Nullable`1 isRecoverable, String poolIdentityId, String url, Nullable`1 partyUid, String partitionCode, String tableName, String parameter1, String parameter2, String parameter3, String parameter4, String parameter5, String clientId)
   at Invantive.Sql.V1.SqlSymbolTable.ThrowMissingSymbol(GlobalState owner, ExecutionOptions executionOptions, String alias, String name)
   at Invantive.Sql.V1.SqlSymbolTable.GetSymbol(GlobalState owner, ExecutionOptions executionOptions, String alias, String name)
   at Invantive.Sql.V1.ExpressionParser.LookupSymbol(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, String alias, String name)
   at Invantive.Sql.V1.TransformToExpression.GetExpressionForField(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, ParserRuleContext context, String alias, String fieldName, Type& type, Nullable`1& isNullExpression, Boolean& isPSqlParameter, DatabaseColumn& field)
   at Invantive.Sql.V1.TransformToExpression.VisitFieldIdentifier(FieldIdentifierContext context)
   at Invantive.Sql.V1.TransformToExpression.VisitExpression(ExpressionContext context)
   at Invantive.Sql.V1.TransformToExpression.ParseExpression(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, IParseTree tree, Type& expressionType, Boolean& isConstant, Object& data, Nullable`1& isNullable, Boolean& usesFields, DatabaseColumn[]& fieldsUsed)
   at Invantive.Sql.V1.ExpressionParser.ParseExpression(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, IProviderManager manager, SqlEngine sqlEngine, IParseTree expression)
   at Invantive.Sql.V1.SelectStatementTree.GetProjectionMetadata(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, List`1 selectList, ExpressionParser exprParser)
   at Invantive.Sql.V1.SelectStatementTree.OnExecute(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, SparseArrayPool sparseArrayPool, ParameterList parameters, QueryObject additionalFilters, ExpressionParser expressionParser, IQueryStatePerExecution queryStatePerExecution)
   at Invantive.Sql.V1.QueryTree.Execute(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, ParameterList parameters, QueryObject additionalFilters, ExpressionParser expressionParser, IQueryStatePerExecution queryStatePerExecution)
   at System.Lazy`1.ViaFactory(LazyThreadSafetyMode mode)
   at System.Lazy`1.CreateValue()
   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.Data.DataDictionaryProvider.A(GlobalState, ExecutionOptions, SqlExecutionStep sqlExecutionStep, ObjectDefinition, SqlViewSpec)
   at Invantive.Data.DataDictionaryProvider.<>c__DisplayClass308_0.<RegisterDataContainerMetadata>b__0(GlobalState, ExecutionOptions, SqlExecutionStep _sqlExecutionStep, ObjectDefinition)
   på Invantive.Data.ViewObjectDefinition.GetFields(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep)
   på Invantive.Cloud.Shared.ODataEdmUtility.A(GlobalState, ExecutionOptions, SqlExecutionStep sqlExecutionStep, IProviderManager, EdmModelCacheEntity, ObjectDefinition, DataContainerMetadata, Int32, Boolean)
   på Invantive.Cloud.Shared.ODataEdmUtility.A(GlobalState, ExecutionOptions, SqlExecutionStep sqlExecutionStep, IProviderManager, DataContainerMetadata, PartitionInfo partitionInfo, ObjectDefinition, EdmModelCache, DataContainerConnectionInfo dataContainerConnectionInfo, String, Int32, Boolean, Int32&, Int32&, Int32&, Int32&)
   på Invantive.Cloud.Shared.ODataEdmUtility.<>c__DisplayClass10_0.<ConstructNewDatabaseEdmModel>b__2(<>f__AnonymousType0`4, ParallelLoopState parallelLoopState, Int64)
   ved Invantive.Basics.ParallelUtility.<>c__DisplayClass4_0`1.<ForEachWithAggregatedExceptions>b__0(TSource tSource, ParallelLoopState parallelLoopState, Int64 index)
   at System.Threading.Tasks.Parallel.<>c__DisplayClass19_0`2.<ForWorker>b__1(RangeWorker& currentWorker, Int64 timeout, Boolean& replicationDelegateYieldedBeforeCompletion)
   at System.Threading.Tasks.TaskReplicator.Replica.Execute()
   at System.Threading.ExecutionContext.RunFromThreadPoolDispatchLoop(Thread threadPoolThread, ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
   at System.Threading.ThreadPoolWorkQueue.Dispatch()
   at System.Threading.PortableThreadPool.WorkerThread.WorkerThreadStart()
   at System.Threading.Thread.StartCallback()
   at Invantive.Sql.V1.SqlSymbolTable.ThrowMissingSymbol(GlobalState owner, ExecutionOptions executionOptions, String alias, String name)
   at Invantive.Sql.V1.SqlSymbolTable.GetSymbol(GlobalState owner, ExecutionOptions executionOptions, String alias, String name)
   at Invantive.Sql.V1.ExpressionParser.LookupSymbol(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, String alias, String name)
   at Invantive.Sql.V1.TransformToExpression.GetExpressionForField(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, ParserRuleContext context, String alias, String fieldName, Type& type, Nullable`1& isNullExpression, Boolean& isPSqlParameter, DatabaseColumn& field)
   at Invantive.Sql.V1.TransformToExpression.VisitFieldIdentifier(FieldIdentifierContext context)
   at Invantive.Sql.V1.TransformToExpression.VisitExpression(ExpressionContext context)
   at Invantive.Sql.V1.TransformToExpression.ParseExpression(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, IParseTree tree, Type& expressionType, Boolean& isConstant, Object& data, Nullable`1& isNullable, Boolean& usesFields, DatabaseColumn[]& fieldsUsed)
   at Invantive.Sql.V1.ExpressionParser.ParseExpression(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, IProviderManager manager, SqlEngine sqlEngine, IParseTree expression)
   at Invantive.Sql.V1.SelectStatementTree.GetProjectionMetadata(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, List`1 selectList, ExpressionParser exprParser)
   at Invantive.Sql.V1.SelectStatementTree.OnExecute(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, SparseArrayPool sparseArrayPool, ParameterList parameters, QueryObject additionalFilters, ExpressionParser expressionParser, IQueryStatePerExecution queryStatePerExecution)
   at Invantive.Sql.V1.QueryTree.Execute(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, ParameterList parameters, QueryObject additionalFilters, ExpressionParser expressionParser, IQueryStatePerExecution queryStatePerExecution)
   at System.Lazy`1.ViaFactory(LazyThreadSafetyMode mode)
   at System.Lazy`1.CreateValue()
   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.Data.DataDictionaryProvider.A(GlobalState, ExecutionOptions, SqlExecutionStep sqlExecutionStep, ObjectDefinition, SqlViewSpec)
   at Invantive.Data.DataDictionaryProvider.<>c__DisplayClass308_0.<RegisterDataContainerMetadata>b__0(GlobalState, ExecutionOptions, SqlExecutionStep _sqlExecutionStep, ObjectDefinition)
   at Invantive.Data.ViewObjectDefinition.GetFields(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep)
   at Invantive.Cloud.Shared.ODataEdmUtility.A(GlobalState, ExecutionOptions, SqlExecutionStep sqlExecutionStep, IProviderManager, EdmModelCacheEntity, ObjectDefinition, DataContainerMetadata, Int32, Boolean)
   at Invantive.Cloud.Shared.ODataEdmUtility.A(GlobalState, ExecutionOptions, SqlExecutionStep sqlExecutionStep, IProviderManager, DataContainerMetadata, PartitionInfo partitionInfo, ObjectDefinition, EdmModelCache, DataContainerConnectionInfo dataContainerConnectionInfo, String, Int32, Boolean, Int32&, Int32&, Int32&, Int32&)
   at Invantive.Cloud.Shared.ODataEdmUtility.<>c__DisplayClass10_0.<ConstructNewDatabaseEdmModel>b__2(<>f__AnonymousType0`4, ParallelLoopState parallelLoopState, Int64)
   ved Invantive.Basics.ParallelUtility.<>c__DisplayClass4_0`1.<ForEachWithAggregatedExceptions>b__0(TSource tSource, ParallelLoopState parallelLoopState, Int64 index)
--- Slutningen af staksporet fra tidligere placering ---
   ved Invantive.Basics.ErrorConstants.ThrowOneOrMoreExceptions(GlobalState owner, ExecutionOptions executionOptions, IEnumerable`1 exceptions)
   ved Invantive.Basics.ParallelUtility.ForEachWithAggregatedExceptions[TSource](GlobalState owner, ExecutionOptions executionOptions, IEnumerable`1 source, ParallelOptions parallelOptions, Action`3 body, Boolean shuffle, Boolean useCancellationTokenFromExecutionOptions, Boolean keepGoingOnError)
   ved Invantive.Cloud.Shared.ODataEdmUtility.A(GlobalState, ExecutionOptions, SqlExecutionStep sqlExecutionStep, DataContextBase, DatabaseConnectionInfo, String, String, HashSet`1, Int32, Boolean, Int32, String, Byte[], String, CancellationToken)
   ved Invantive.Cloud.Shared.ODataEdmUtility.ConstructDatabaseEdmModel(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, DataContextBase dataContext, DatabaseConnectionInfo databaseConnectionInfo, String databaseSegment, String userName, HashSet`1 allowedProviderNames, Int32 maxColumnCount, Boolean allowNonStandardEdmTypeNames, Int32 cacheLifetimeSec, String edmCacheUserDirectory, CancellationToken cancellationToken)
   ved Invantive.Bridge.Online.Logic.EdmModelBuilder.ConstructDatabaseEdmModel(GlobalState owner, ExecutionOptions executionOptions, BridgeConfig config, HttpContext httpContext, String databaseSegment) i c:\smoke\ws-26.0\Invantive.Bridge.Online\src\Invantive.Bridge.Online\Logic\EdmModelBuilder.cs:line 215
   ved Invantive.Web.Core.TaskExtensionMethods.GetOrAddTaskSafe[TTask](IStateHelper stateHelper, GlobalState owner, ExecutionOptions executionOptions, String listName, String key, Func`1 taskFactory, Nullable`1 timeOutMs, String providerName, String dataContainerId, String dataContainerAlias, String partitionCode, String tableName, String sqlStatement, CancellationToken cancellationToken, CancellationToken retrieveCancellationToken)
   ved Invantive.Bridge.Online.Logic.EdmModelBuilder.EnsureModelLoaded(GlobalState owner, ExecutionOptions executionOptions, BridgeConfig config, HttpContext httpContext, String databaseSegment, CancellationToken cancellationToken) i c:\smoke\ws-26.0\Invantive.Bridge.Online\src\Invantive.Bridge.Online\Logic\EdmModelBuilder.cs:line 83
   ved Invantive.Bridge.Online.Logic.EdmModelBuilder.GetEdmModel(GlobalState owner, ExecutionOptions executionOptions, BridgeConfig config, HttpContext httpContext, String databaseSegment, CancellationToken cancellationToken) i c:\smoke\ws-26.0\Invantive.Bridge.Online\src\Invantive.Bridge.Online\Logic\EdmModelBuilder.cs:line 49
   ved Invantive.Bridge.Online.Logic.ODataModelProvider.Invantive.Bridge.Online.Logic.IODataModelProvider.GetEdmModel(GlobalState owner, ExecutionOptions executionOptions, HttpContext httpContext, BridgeConfig config, String databaseSegment, CancellationToken cancellationToken) i c:\smoke\ws-26.0\Invantive.Bridge.Online\src\Invantive.Bridge.Online\Logic\OData\ODataModelProvider.cs:line 18
   ved Invantive.Bridge.Online.Logic.ODataRoutingMatcherPolicy.ApplyAsync(HttpContext httpContext, CandidateSet candidates) i c:\smoke\ws-26.0\Invantive.Bridge.Online\src\Invantive.Bridge.Online\Logic\OData\ODataRoutingMatcherPolicy.cs:line 104
   ved Microsoft.AspNetCore.Routing.Matching.DfaMatcher.SelectEndpointWithPoliciesAsync(HttpContext httpContext, IEndpointSelectorPolicy[] politikker, CandidateSet candidateSet)
   ved Microsoft.AspNetCore.Routing.EndpointRoutingMiddleware.<InDer er opstået en fejl i min opdatering

```ruby
api_key = "a quick brown fox"
fetch("https://api.example.com/data", headers: { 'Authorization' => api_key })

Hjælp mig venligst med at rette det.

Viewet, hvor jeg har maskeret ID’et i use. Som allerede nævnt, har dette view eksisteret i måneder. Siden tirsdag har det forårsaget en fejl ved indlæsningen af alle de tabeller, vi læser ind fra.

use [administratie]@eol;
create or replace force view ProjectSubscriptionCodes
as
select 
	cfd.Id,
    cfd.Code,
    cfd.Description,
    cfd.BUSBV_PROJ_Subscription AS SubscriptionCode,
	cfd.Modified
from   ( select prj.Division
         ,      prj.Id
         ,      prj.Code
         ,      prj.Description
		, prj.Modified
         ,      customvalues.PropertyName
         ,      customvalues.Value
         from   ExactOnlineREST.Project.Projects prj
         left
         outer
         join   CustomFieldValues
                ( division => prj.Division
                , linkId => prj.Id
                , BusinessComponentName => 'Project'
                ) customvalues
         where  prj.Division = 189708
		AND prj.ClassificationDescription in ('Continuous Improvement Services - Vast', 'Continuous Improvement Services - Flexibel', 'Service Level Agreement') 
       ) prj
pivot  ( max(prj.value)
         for prj.PropertyName in 
         ( 
          [BUSBV_PROJ_Subscription]
         )
       ) cfd;

[forums]

Problemet ligger i en fejl i forespørgselsevalueringen på 26.0.188, hvorved kolonnerne fra pivot får de forkerte aliaser. Som følge heraf genkendes cfd.id ikke, men id gør.

Der er en ny release tilgængelig, der bør løse dette problem. De nødvendige ændringer er tilgængelige fra release 26.0.195 og i alle fremtidige BETAversioner.

Denne nye version er/bliver taget i produktion på Invantive Cloud.

For mere information se:

Releasefrequentie Invantive Cloud

Go to English version In dit topic staat de omgang met releases voor Invantive Cloud-onderdelen beschreven. Welke componenten heeft Invantive Cloud? De Invantive Cloud bestaat voor eindgebruikers uit de volgende onderdelen: Invantive Cloud website (https://cloud.invantive.com) Invantive Bridge Online (https://bridge-online.cloud) Invantive App Online (https://app-online.cloud) Valuta Tools (https://valuta-tools.invantive.com) Get My Report (https://get-my-report.invantive.com) Daarnaast bes…

[forums]

Dette spørgsmål er automatisk lukket efter 1 uges inaktivitet. Det sidste givne svar er markeret som løsning.

Venligst stil et nyt spørgsmål i et separat emne, hvis problemet opstår igen. Inkluder venligst et link til dette emne i det nye spørgsmål ved at indsætte URL’en i teksten.