Itgensgr134 Repeating cache key

Vragen
,
1

Er komt nu een andere foutmelding naar boven bij het handmatig uitvoeren van de applicatie:

An error occured - 81518ce6-b19f-43d9-a469-7bd78d1b7f23
itgensgr134:
Detecting repeating cache key.
This will result in endless loops.
(/https://api.loket.nl/v2/developer.loket.nl/*************./b5e62fb6-3673-41c6-8e8a-98216f08eee2/DEFAULT/LoketNlRest.Employment.EmploymentsByEmployerId/api.loket.nl/v2/providers/employers/…"

Heeft dit hiermee te maken of kan dit anders opgelost worden?

Itgenlnr007: De authenticatiegegevens voor LoketNlRest zijn onjuist
Itgensgr170 Loket - Status 500 Internal Server Error
2

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.

Gelieve tenminste de volgende gegevens zichtbaar te laten:

  • de titelbalk met de request ID,
  • de statuscode, netwerkgrootte en tijdstippen in de linkerkolom,
  • de foutcode en foutmelding helemaal onderaan in de linkerkolom,
  • de gehele rechterkolom.
3

image
image1437×461 27.8 KB

4

Is het mogelijk om een schermafdruk toe te voegen van het request dat deze itgensgr134-foutmelding geeft?

5

Het gaat om de applicatiemodule “load loket”.

6

Deze module draait op Invantive App Online.

Deze was nog niet geupgrade qua Loket-driver aangezien een nieuwe productlijn gisteren daarop live ging.

Deze upgrade is inmiddels uitgevoerd.

Gelieve nogmaals te proberen.

7

Wij krijgen dezelfde fout maar dan in de Query Tool en Data Hub.

8

Onderstaand de melding vanuit de Query Tool.

itgensgr134: Detecting repeating cache key. This will result in endless loops.
Bericht ID: 8c4097aa-2c7b-44c0-a30d-580ce65c921b
Opgetreden (UTC): 28-8-2024 8:37:42

select bde.* prefix with ‘bde_’,
ept.* prefix with ‘ept_’
from EmployersByUserId@lnl epr
left join EmploymentsByEmployerId@lnl(epr.id) ept
left join BenefitsAndDeductionsByEmploymentId@lnl(ept.id) bde

InvantiveSystemException
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, Nullable1 partyUid, String partitionCode, String tableName)
at Invantive.Basics.InvantiveSystemException…ctor(GlobalState owner, ExecutionOptions executionOptions, String validationCode, String errorMessage, String kindRequest, String stackTrace, String nk, Exception innerException, Boolean inheritMessageCodeWhenPresent, Nullable1 uid, Boolean isRecoverable, String poolIdentityId, String partitionCode, String tableName) at Invantive.Data.Providers.Swagger.SwaggerProvider.LHF.MoveNext() at System.Linq.Enumerable.<SelectManyIterator>d__172.MoveNext()
at Invantive.Data.GenericProvider.MGY.MoveNext()
at System.Linq.Enumerable.d__172.MoveNext() at System.Linq.Enumerable.WhereSelectEnumerableIterator2.MoveNext()
at Invantive.Sql.V1.DataSourceOrFunctionWithRotatorTree.d__51.MoveNext()
at Invantive.Data.CompressedEnumerable1.<GetEnumerator>d__10.MoveNext() at Invantive.Sql.V1.FirehoseResultSet.SZ.MoveNext() at Invantive.Sql.V1.FirehoseResultSet.AZ.MoveNext() at Invantive.Data.CompressedEnumerable1.d__10.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.SZ.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.AZ.MoveNext()
at Invantive.Data.ExtensionMethods.IteratorWithFinally1.IteratorWithFinallyEnumerator.MoveNext() at Invantive.Data.ExtensionMethods.CacheFirstEnumerable1.d__9.MoveNext()
at Invantive.Sql.V1.JoinIterator.d__22.MoveNext()
at Invantive.Sql.V1.JoinIterator.d__17.MoveNext()
at Invantive.Sql.V1.JoinIterator.d__33.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.AZ.MoveNext()
at Invantive.Data.ExtensionMethods.IteratorWithFinally1.IteratorWithFinallyEnumerator.MoveNext() at Invantive.Data.ExtensionMethods.CacheFirstEnumerable1.d__9.MoveNext()
at Invantive.Sql.V1.JoinIterator.d__22.MoveNext()
at Invantive.Sql.V1.JoinIterator.d__17.MoveNext()
at Invantive.Sql.V1.JoinIterator.d__33.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.AZ.MoveNext()
at Invantive.Sql.V1.ChainedFirehose.HZ.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.AZ.MoveNext()
at Invantive.Sql.V1.SelectListIterator.YO.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.AZ.MoveNext()
at Invantive.Data.CompressedEnumerable1.<GetEnumerator>d__10.MoveNext() at Invantive.Sql.V1.FirehoseResultSet.SZ.MoveNext() at Invantive.Sql.V1.MaterializeSparseArrayIterator.<Iterator>d__1.MoveNext() at Invantive.Sql.V1.QueryPlan.DL.MoveNext() at Invantive.Data.ExtensionMethods.IteratorWithFinally1.IteratorWithFinallyEnumerator.MoveNext()
at System.Collections.Generic.List1..ctor(IEnumerable1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source) at Invantive.Data.ConnectionManager.PX.Y(QueryPlan ) at System.Linq.Enumerable.WhereSelectArrayIterator2.MoveNext()
at System.Linq.Buffer1..ctor(IEnumerable1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable1 source) 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) at Invantive.Data.ConnectionManager.PG(GlobalState , ExecutionOptions , SqlExecutionStep , String , ParameterList , String ) at Invantive.Data.ActionProceduresBase.PassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters) at Invantive.Producer.Windows.Forms.QueryToolResults.TWL(GlobalState , ExecutionOptions , IProgressNotifier , String , ParameterList , Boolean , Boolean , Boolean , Boolean ) at Invantive.Producer.Windows.Forms.QueryToolResults.XWL(GlobalState , ExecutionOptions , String , ParameterList ) at Invantive.Producer.Windows.Forms.QueryToolResults.BH.M() 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.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() at Invantive.Data.Providers.Swagger.SwaggerProvider.LHF.MoveNext() at System.Linq.Enumerable.<SelectManyIterator>d__172.MoveNext()
at Invantive.Data.GenericProvider.MGY.MoveNext()
at System.Linq.Enumerable.d__172.MoveNext() at System.Linq.Enumerable.WhereSelectEnumerableIterator2.MoveNext()
at Invantive.Sql.V1.DataSourceOrFunctionWithRotatorTree.d__51.MoveNext()
at Invantive.Data.CompressedEnumerable1.<GetEnumerator>d__10.MoveNext() at Invantive.Sql.V1.FirehoseResultSet.SZ.MoveNext() at Invantive.Sql.V1.FirehoseResultSet.AZ.MoveNext() at Invantive.Data.CompressedEnumerable1.d__10.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.SZ.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.AZ.MoveNext()
at Invantive.Data.ExtensionMethods.IteratorWithFinally1.IteratorWithFinallyEnumerator.MoveNext() at Invantive.Data.ExtensionMethods.CacheFirstEnumerable1.d__9.MoveNext()
at Invantive.Sql.V1.JoinIterator.d__22.MoveNext()
at Invantive.Sql.V1.JoinIterator.d__17.MoveNext()
at Invantive.Sql.V1.JoinIterator.d__33.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.AZ.MoveNext()
at Invantive.Data.ExtensionMethods.IteratorWithFinally1.IteratorWithFinallyEnumerator.MoveNext() at Invantive.Data.ExtensionMethods.CacheFirstEnumerable1.d__9.MoveNext()
at Invantive.Sql.V1.JoinIterator.d__22.MoveNext()
at Invantive.Sql.V1.JoinIterator.d__17.MoveNext()
at Invantive.Sql.V1.JoinIterator.d__33.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.AZ.MoveNext()
at Invantive.Sql.V1.ChainedFirehose.HZ.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.AZ.MoveNext()
at Invantive.Sql.V1.SelectListIterator.YO.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.AZ.MoveNext()
at Invantive.Data.CompressedEnumerable1.<GetEnumerator>d__10.MoveNext() at Invantive.Sql.V1.FirehoseResultSet.SZ.MoveNext() at Invantive.Sql.V1.MaterializeSparseArrayIterator.<Iterator>d__1.MoveNext() at Invantive.Sql.V1.QueryPlan.DL.MoveNext() at Invantive.Data.ExtensionMethods.IteratorWithFinally1.IteratorWithFinallyEnumerator.MoveNext()
at System.Collections.Generic.List1..ctor(IEnumerable1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source) at Invantive.Data.ConnectionManager.PX.Y(QueryPlan ) at System.Linq.Enumerable.WhereSelectArrayIterator2.MoveNext()
at System.Linq.Buffer1..ctor(IEnumerable1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
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.PG(GlobalState , ExecutionOptions , SqlExecutionStep , String , ParameterList , String )
— End of stack trace from previous location where exception was thrown —
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Invantive.Data.ConnectionManager.PG(GlobalState , ExecutionOptions , SqlExecutionStep , String , ParameterList , String )
at Invantive.Data.ActionProceduresBase.PassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters)
at Invantive.Producer.Windows.Forms.QueryToolResults.TWL(GlobalState , ExecutionOptions , IProgressNotifier , String , ParameterList , Boolean , Boolean , Boolean , Boolean )
at Invantive.Producer.Windows.Forms.QueryToolResults.XWL(GlobalState , ExecutionOptions , String , ParameterList )

9

image

Ik krijg nog dezelfde foutmelding op:

begin


create or replace table lok_Employer_Employments@mss
as
select 
*
from LoketNlRest.Views.EmployerEmployments@lnr;



create or replace table lok_Employer_Employees@mss
as 
select 
* 
from LoketNlRest.Views.EmployerEmployees@lnr; 



create or replace table lok_Employment_Working_Hours@mss
as
select 
* 
from LoketNlRest.Views.EmploymentWorkingHours@lnr; 



create or replace table lok_Employee_Absences@mss
as
select 
*
from LoketNlRest.Views.EmployeeAbsences@lnr; 



create or replace table lok_Employee_Absence_Progresses@mss
as
select 
*
from LoketNlRest.Views.EmployeeAbsenceProgresses@lnr;



create or replace table lok_Payroll_Administration_Payroll_Run_Period_Component_Results@mss
as
select 
*
from LoketNlRest.Views.PayrollAdministrationPayrollRunPeriodComponentResults@lnr;



create or replace table lok_Employment_Organizational_Entities@mss
as
select 
*
from LoketNlRest.Views.EmploymentOrganizationalEntities@lnr;



create or replace table lok_Employment_Leave_Balances@mss
as
select *
from LoketNlRest.Views.EmploymentLeaveBalances@lnr;



create or replace table lok_Employment_Leaves@mss
as
select 
*
from LoketNlRest.Views.EmploymentLeaves@lnr;



create or replace table lok_Employment_Wages@mss
as
select 
*
from LoketNlRest.Views.EmploymentWages@lnr;



create or replace table lok_last_loaddate@mss
as
select getdate() as LastLoadDate;


end
10

Is er misschien een update of dit opgepakt is/wordt?

Ik krijg vandaag nog dezelfde error.

11

Het probleem was gisteren nog niet reproduceerbaar gebleken. Een developer zal hier vandaag verder naar kijken.

12

Bij andere klanten van ons speelt probleem ook nog, krijgen nu geen actuele Loket data over

13

De oplossing van dit probleem zal naar verwachting tenminste tot 2 september duren.

Voor gebruikers van Invantive Cloud krijgen na oplossing automatisch een verbeterde versie. Gebruikers van on-premises producten zoals Invantive Data Hub en Invantive Query Tool dienen na release een upgrade door te voeren.

14

De foutmelding itgensgr134 blijkt uitsluitend op te wekken via de volgende query:

select *
from   EmploymentsByEmployerId@lnr('b5e62fb6-3673-41c6-8e8a-98216f08eee2') ept

Deze query wordt als onderdeel van een drietal views in de PSQL-code aangeroepen.

15

Onduidelijk of bovenstaande slechts een constatering is of een oplossingsrichting, maar krijgen de foutmelding nog steeds.

16

Een oplossing voor de foutmelding itgensgr134 bij het ophalen van dienstverbanden is in productie genomen op Invantive Cloud als onderdeel van release 24.0.301.

De release 24.0.301 of nieuwer is vereist voor gebruik met Loket.nl na 24 augustus 2024.

Gebruikers van on-premises producten kunnen deze downloaden via https://releasenotes.invantive.com.

17

Deze fix lijkt het bij ons te hebben opgelost. Bedankt voor het handelen!

18

Helaas lijkt deze nu te zijn vervangen voor een nieuwe foutmelding:

An error occured - 39ec9c37-35dc-475e-86eb-2e7796190a47
itgenase094: De tabel kan niet worden gemaakt. (LOK_EMPLOYER_EMPLOYMENTS).

itgenspr029: Onderhoud van de tabel ‘LOK_EMPLOYER_EMPLOYMENTS’ is mislukt.

itgenclr096: There is already an object named ‘LOK_EMPLOYER_EMPLOYMENTS_pk’ in the database.
Could not create constraint or index. See previous errors.

19

Het lijkt erop dat alle tabellen weggooien helpt, maar zou de create or replace table dat niet automatisch moeten doen?

20

Misschien voor de volledigheid nog de links naar de nieuwe versie:

Voor Windows:
https://download.invantive.com/release/msi/Invantive+Data+Hub-24.0.301-net48.msi

Voor Unix:
https://download.invantive.com/release/msi/Invantive+Data+Hub-linux-arm64-net8.0-24.0.301.zip