Exact Online: itgensql035 & Onbekende ID \u0027CFD.ID\u0027. Overweeg een van de volgende: ID, Modified

[tbx8]

Sinds 4 augustus 2026 krijgen we op elke call via de Invantive Bridge Online een melding:

itgensql035
Onbekende ID \u0027CFD.ID\u0027.
Overweeg een van de volgende: ID, Modified.
(itgensql035, 2b4cfe89-a973-4292-b0bd-6795a10aea1f)

In de monitoring tijdlijn is deze ook zichtbaar maar dan met de melding:

Onbekende ID ‘CFD.ID’.
Overweeg een van de volgende: ID, Modified. (CFD.ID).‘

Aan de aanroepende kant is er niets aangepast, we vragen ofwel alle data op een endpoint of gewijzigde data (op Modified) op.

Wat gaat hier mis?

[forums]

Aanvullen informatie

Is het mogelijk om een (geanonimiseerde) schermafdruk van de details van het verzoek in Invantive Bridge Online Monitoring toe te voegen zoals beschreven in Meer inzicht met nieuwe Bridge Online Monitoring?

De details vindt u door te klikken op het downloadverzoek welke het onderwerp van dit onderwerp representeert.

Het downloadverzoek heeft meestal een SQL-statement waarin de tabelnaam zichtbaar is.

Gelieve tenminste de volgende gegevens zichtbaar te laten van beide kolommen:

• de titelbalk met de request ID,
• de statuscode, netwerkgrootte, pad en tijdstippen in de linkerkolom,
• de foutcode en foutmelding helemaal onderaan in de linkerkolom,
• de gehele rechterkolom inclusief het SQL statement, tabelnaam en parameterwaardes.

Bijvoorbeeld:

Controleer juiste server en gebruiker

Controleer zorgvuldig dat u zich aanmeldt op de Bridge Online-website die ook gebruikt wordt vanuit Power BI en met dezelfde gebruikersnaam. U ziet alleen de verzoeken van de Invantive Cloud-gebruiker waarmee u zich aanmeldt op de website.

Er zijn vier servers in gebruik:

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

De gebruikte server ziet u in uw script of broncode van rapportage.

Controleer juiste aanvraag en details

Zorg ervoor dat u het verzoek eerst selecteert om de details weer te geven. Er hoort maar één verzoek zichtbaar zijn in de schermafbeelding.

Controleer ook zorgvuldig of het verzoek een pad heeft met odata4 of apps. Verzoeken met andere paden zijn over het algemeen niet relevant voor dit doel.

Foutmelding en tips per e-mail

Daarnaast zal de Invantive Cloud-gebruiker die de foutmelding heeft op zijn e-mailadres veelal een e-mail ontvangen met een foutmelding en tips als er sprake is van een foutmelding in Power BI, Power Query, Azure Data Factory, Qlik of Tableau.

Advies is om de spam van de betrokken gebruiker te controleren op dergelijke e-mails verzonden vanaf support@invantive.com.

[tbx8]

Zie bijgevoegd een screenshot van de download van de systeemberichten bij deze error..

Nogmaals: deze fout treed sinds afgelopen dinsdag op, daarvoor is dit niet voorgekomen en er zijn zowel aan de Invantive kant als de aanroepende kant (Fabric) geen wijzigingen geweest in de credentials, manieren van aanroepen, etc.

In de Invantive database zit wel een view waarin we Exact Online custom velden uitlezen (op basis van de op het forum gedeelde instructies, en gekoppeld aan de startup van de database) daarin werd het view alias CFD zoals in de error vermeld). Deze view staat er al meerdere maanden.

Na weghalen van deze create view heeft de load van data vandaag wel gedraaid.

Hoe kan het dat een view die er al een behoorlijke tijd staat nu opeens voor errors zorgt?

[forums]

Svp de foutmelding als tekst toevoegen, dat bevorderd de leesbaarheid en vindbaarheid. Is het mogelijk de definitie van de view te delen?

[tbx8]

De volledige foutmelding is

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)
   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)
   at 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)
   at Invantive.Basics.ParallelUtility.<>c__DisplayClass4_0`1.<ForEachWithAggregatedExceptions>b__0(TSource tSource, ParallelLoopState parallelLoopState, Int64 index)
--- End of stack trace from previous location ---
   at Invantive.Basics.ErrorConstants.ThrowOneOrMoreExceptions(GlobalState owner, ExecutionOptions executionOptions, IEnumerable`1 exceptions)
   at Invantive.Basics.ParallelUtility.ForEachWithAggregatedExceptions[TSource](GlobalState owner, ExecutionOptions executionOptions, IEnumerable`1 source, ParallelOptions parallelOptions, Action`3 body, Boolean shuffle, Boolean useCancellationTokenFromExecutionOptions, Boolean keepGoingOnError)
   at Invantive.Cloud.Shared.ODataEdmUtility.A(GlobalState, ExecutionOptions, SqlExecutionStep sqlExecutionStep, DataContextBase, DatabaseConnectionInfo, String, String, HashSet`1, Int32, Boolean, Int32, String, Byte[], String, CancellationToken)
   at 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)
   at Invantive.Bridge.Online.Logic.EdmModelBuilder.ConstructDatabaseEdmModel(GlobalState owner, ExecutionOptions executionOptions, BridgeConfig config, HttpContext httpContext, String databaseSegment) in c:\smoke\ws-26.0\Invantive.Bridge.Online\src\Invantive.Bridge.Online\Logic\EdmModelBuilder.cs:line 215
   at 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)
   at Invantive.Bridge.Online.Logic.EdmModelBuilder.EnsureModelLoaded(GlobalState owner, ExecutionOptions executionOptions, BridgeConfig config, HttpContext httpContext, String databaseSegment, CancellationToken cancellationToken) in c:\smoke\ws-26.0\Invantive.Bridge.Online\src\Invantive.Bridge.Online\Logic\EdmModelBuilder.cs:line 83
   at Invantive.Bridge.Online.Logic.EdmModelBuilder.GetEdmModel(GlobalState owner, ExecutionOptions executionOptions, BridgeConfig config, HttpContext httpContext, String databaseSegment, CancellationToken cancellationToken) in c:\smoke\ws-26.0\Invantive.Bridge.Online\src\Invantive.Bridge.Online\Logic\EdmModelBuilder.cs:line 49
   at Invantive.Bridge.Online.Logic.ODataModelProvider.Invantive.Bridge.Online.Logic.IODataModelProvider.GetEdmModel(GlobalState owner, ExecutionOptions executionOptions, HttpContext httpContext, BridgeConfig config, String databaseSegment, CancellationToken cancellationToken) in c:\smoke\ws-26.0\Invantive.Bridge.Online\src\Invantive.Bridge.Online\Logic\OData\ODataModelProvider.cs:line 18
   at Invantive.Bridge.Online.Logic.ODataRoutingMatcherPolicy.ApplyAsync(HttpContext httpContext, CandidateSet candidates) in c:\smoke\ws-26.0\Invantive.Bridge.Online\src\Invantive.Bridge.Online\Logic\OData\ODataRoutingMatcherPolicy.cs:line 104
   at Microsoft.AspNetCore.Routing.Matching.DfaMatcher.SelectEndpointWithPoliciesAsync(HttpContext httpContext, IEndpointSelectorPolicy[] policies, CandidateSet candidateSet)
   at Microsoft.AspNetCore.Routing.EndpointRoutingMiddleware.<Invoke>g__AwaitMatch|10_1(EndpointRoutingMiddleware middleware, HttpContext httpContext, Task matchTask)
   at Microsoft.AspNetCore.Diagnostics.StatusCodePagesMiddleware.Invoke(HttpContext context)
   at Invantive.Bridge.Online.Startup.LogUsageStatistics(HttpContext ctx, Func`1 next) in c:\smoke\ws-26.0\Invantive.Bridge.Online\src\Invantive.Bridge.Online\Startup.Middleware.cs:line 562
   at Invantive.Bridge.Online.Startup.CheckUserStatus(HttpContext ctx, Func`1 next) in c:\smoke\ws-26.0\Invantive.Bridge.Online\src\Invantive.Bridge.Online\Startup.Middleware.cs:line 767
   at Invantive.Bridge.Online.Startup.CallAndRewriteCancellationExceptions(HttpContext ctx, Func`1 next) in c:\smoke\ws-26.0\Invantive.Bridge.Online\src\Invantive.Bridge.Online\Startup.Middleware.cs:line 502
   at Invantive.Bridge.Online.Startup.IgnoreExceptionsAlreadyWrittenToOutput(HttpContext ctx, Func`1 next) in c:\smoke\ws-26.0\Invantive.Bridge.Online\src\Invantive.Bridge.Online\Startup.Middleware.cs:line 476
   at Invantive.Bridge.Online.Startup.ReleaseResources(HttpContext ctx, Func`1 next) in c:\smoke\ws-26.0\Invantive.Bridge.Online\src\Invantive.Bridge.Online\Startup.Middleware.cs:line 457
   at Invantive.Bridge.Online.Startup.MonitoringSetUserAfterAuthentication(HttpContext ctx, Func`1 next) in c:\smoke\ws-26.0\Invantive.Bridge.Online\src\Invantive.Bridge.Online\Startup.Middleware.cs:line 407
   at Invantive.Bridge.Online.Startup.MarkSessionInUse(HttpContext ctx, Func`1 next) in c:\smoke\ws-26.0\Invantive.Bridge.Online\src\Invantive.Bridge.Online\Startup.Middleware.cs:line 429
   at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
   at Invantive.Bridge.Online.Startup.MonitoringSetUserBeforeAuthentication(HttpContext ctx, Func`1 next) in c:\smoke\ws-26.0\Invantive.Bridge.Online\src\Invantive.Bridge.Online\Startup.Middleware.cs:line 386
   at Invantive.Bridge.Online.Startup.MonitoringSetUserBeforeAuthentication(HttpContext ctx, Func`1 next) in c:\smoke\ws-26.0\Invantive.Bridge.Online\src\Invantive.Bridge.Online\Startup.Middleware.cs:line 386
   at Invantive.Bridge.Online.Startup.MonitoringSetUserBeforeAuthentication(HttpContext ctx, Func`1 next) in c:\smoke\ws-26.0\Invantive.Bridge.Online\src\Invantive.Bridge.Online\Startup.Middleware.cs:line 386
   at Invantive.Web.Core.CentralizedMonitoring.CentralizedMonitoringMiddleware.Invoke(HttpContext httpContext, IInvantiveCentralizedMonitoring monitoring)
   at Invantive.Web.Core.CentralizedMonitoring.CentralizedMonitoringMiddleware.Invoke(HttpContext httpContext, IInvantiveCentralizedMonitoring monitoring)
   at Invantive.Web.Core.CentralizedMonitoring.CentralizedMonitoringMiddleware.Invoke(HttpContext httpContext, IInvantiveCentralizedMonitoring monitoring)
   at Invantive.Bridge.Online.Startup.DisableBuffering(HttpContext ctx, Func`1 next) in c:\smoke\ws-26.0\Invantive.Bridge.Online\src\Invantive.Bridge.Online\Startup.Middleware.cs:line 222
   at Invantive.Bridge.Online.Startup.ValidateIpAddress(HttpContext ctx, Func`1 next) in c:\smoke\ws-26.0\Invantive.Bridge.Online\src\Invantive.Bridge.Online\Startup.Middleware.cs:line 132
   at Invantive.Web.Core.RequestFiltering.InvantiveRequestFilteringMiddleware.Invoke(HttpContext context)
   at Invantive.Web.Core.CentralizedMonitoring.CentralizedMonitoringMiddleware.Invoke(HttpContext httpContext, IInvantiveCentralizedMonitoring monitoring)
   at Invantive.Web.Core.CentralizedMonitoring.CentralizedMonitoringMiddleware.Invoke(HttpContext httpContext, IInvantiveCentralizedMonitoring monitoring)
   at Invantive.Web.Core.CentralizedMonitoring.CentralizedMonitoringMiddleware.Invoke(HttpContext httpContext, IInvantiveCentralizedMonitoring monitoring)
   at Invantive.Bridge.Online.Startup.DisableRobotCrawlers(HttpContext ctx, Func`1 next) in c:\smoke\ws-26.0\Invantive.Bridge.Online\src\Invantive.Bridge.Online\Startup.Middleware.cs:line 80
   at Microsoft.AspNetCore.Diagnostics.StatusCodePagesMiddleware.Invoke(HttpContext context)
   at Invantive.Web.Core.RequestStatistics.InvantiveRequestStatisticsMiddleware.Invoke(HttpContext context, IInvantiveRequestStatistics statistics)
   at Invantive.Web.Core.InvantiveExceptionLoggerMiddleware.Invoke(HttpContext httpContext, IDataContextService dataContextService)

De view, waarbij ik bij de use het id heb gemaskeerd. Zoals al aangegeven, deze view staat er al maanden, sinds dinsdag zorgt deze voor een error op de load van alle tabellen die we uitlezen.

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]

Het probleem zit in een fout in de query evaluatie op 26.0.188 waardoor de kolommen uit de pivot de verkeerde alias krijgen. Daardoor wordt cfd.id niet herkend, maar id wel.

Er is een nieuwe release beschikbaar die dit probleem zou moeten oplossen. De benodigde wijzigingen zijn beschikbaar vanaf release 26.0.195 en in alle toekomstige BETA versies.

Deze nieuwe release is/wordt in productie genomen op Invantive Cloud.

Voor meer informatie zie:

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…