Itgenclr096 Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

Vragen
, ,
1

Bij het incrementeel kopieren van een grote Exact Online-omgeving naar Azure SQL Server krijg ik nu structureel de volgende foutmelding met Data Hub 24.0.490 Multi-platform op Windows:

2024-10-30 12:59:41.185 Warning itgendhb173: Context: c:\jobs\sql\eol2dwh.sql: --
-- Incrementele kopie van TransactionLinesBulk.
--
-- Er...l')
  , sys_context('USERENV', 'SESSIONID', 'eol')
  );
end;
2024-10-30 12:59:41.200 Error itgencun016: Error itgenclr096: External error in Invantive Data Hub.

En daarna:

Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
Operation cancelled by user.
The statement has been terminated.

The wait operation timed out.
2024-10-30 12:59:43.207 Error itgenclr096: System.ComponentModel.Win32Exception

Call stack:

System.Data.SqlClient.SqlException
ValidationException
   at System.Environment.get_StackTrace()
   at Invantive.Basics.ErrorConstants.GetEnvironmentStackTrace(Boolean ignoreErrors, String valueOnError)
   at Invantive.Basics.ExtensionMethods.GetAllStackTraces(Exception exception, GlobalState owner, ExecutionOptions executionOptions, Boolean deepestFirst, Boolean useDefaultStackTrace)
   at Invantive.Producer.ConsoleUserInteraction.PresentErrorToUser(GlobalState owner, ExecutionOptions executionOptions, ErrorDialogInformation errorDialogInformation)
   at Invantive.Data.Error.HandleUnexpectedException(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, DataContextBase dataContext, IProviderManager manager, Nullable`1 messageId, Exception exceptionRaised, Boolean askContinue, String customErrorMessageWithoutCode, Boolean showErrorToUser, String parameters, LoggingLevel loggingLevel, String applicationNameWithVersion, String applicationName, String applicationVersion, String windowTitle, Dictionary`2 metrics, IBasicProviderInfo originatingProvider, String kindRequest)
   at Invantive.Data.Error.HandleUnexpectedException(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, DataContextBase dataContext, Nullable`1 messageId, Exception exceptionRaised, Boolean askContinue, String customErrorMessageWithoutCode, Boolean showErrorToUser, String parameters, LoggingLevel loggingLevel, String applicationNameWithVersion, String applicationName, String applicationVersion, String windowTitle, Dictionary`2 metrics, IBasicProviderInfo originatingProvider, String kindRequest)
   at Invantive.Data.Error.HandleUnexpectedException(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, Nullable`1 messageId, Exception exceptionRaised, Boolean askContinue, String customErrorMessageWithoutCode, Boolean showErrorToUser, String parameters, LoggingLevel loggingLevel, String applicationNameWithVersion, String applicationName, String applicationVersion, String windowTitle, Dictionary`2 metrics, IBasicProviderInfo originatingProvider)
   at Invantive.Data.Error.HandleUnexpectedException(GlobalState owner, ExecutionOptions executionOptions, Nullable`1 messageId, Exception exceptionRaised, Boolean askContinue, String customErrorMessageWithoutCode, Boolean showErrorToUser, String parameters, LoggingLevel loggingLevel, String applicationNameWithVersion, String applicationName, String applicationVersion, String windowTitle, Dictionary`2 metrics, IBasicProviderInfo originatingProvider)
   at Invantive.Producer.ApplicationErrorHelper.HandleUnexpectedException(GlobalState owner, ExecutionOptions executionOptions, Nullable`1 messageId, Exception exceptionRaised, Boolean askContinue, String customErrorMessage, Boolean showErrorToUser, String parameters, LoggingLevel level, Dictionary`2 metrics, IBasicProviderInfo originatingProvider)
   at Invantive.Producer.Data.Hub.QueryEngine.ProcessStatements(GlobalState owner, ExecutionOptions executionOptions, Action`3 fetchMoreRows, Action`9 executeStatement, IEnumerable`1 statements, String sourceFileName, ScriptingLanguageNextStepSpecification& exitSpecification) in c:\smoke\ws-24.0\Invantive.Data.Hub\src\Invantive.Producer.Data.Hub\QueryEngine.cs:line 1538
   at Invantive.Producer.Data.Hub.QueryEngine.Run(GlobalState owner, ExecutionOptions executionOptions, String[] arguments) in c:\smoke\ws-24.0\Invantive.Data.Hub\src\Invantive.Producer.Data.Hub\QueryEngine.cs:line 567
   at Invantive.Producer.Data.Hub.Program.Main(String[] args) in c:\smoke\ws-24.0\Invantive.Data.Hub\src\Invantive.Producer.Data.Hub\Program.cs:line 40
2024-10-30 12:59:43.207 Information itgendhb221: End program execution with exit code 6.
2

De time-out blijkt betrekking te hebben op SQL Server zelf en treedt ook op als je voor een specifieke datum alle boekingsregels ophaalt.

Oplossing is toevoegen indexen op deze table (circa 22 GB):

CREATE INDEX  eol_transaction_lines_date ON eol_transaction_lines (date)

CREATE INDEX  eol_transaction_lines_account ON eol_transaction_lines (account)

CREATE INDEX  eol_transaction_lines_accountcode ON eol_transaction_lines (accountcode)

CREATE INDEX  eol_transaction_lines_accountname ON eol_transaction_lines (accountname)

CREATE INDEX  eol_transaction_lines_created ON eol_transaction_lines (created)

CREATE INDEX  eol_transaction_lines_entryid ON eol_transaction_lines (entryid) 

CREATE INDEX  eol_transaction_lines_entrynumber ON eol_transaction_lines (entrynumber) 

CREATE INDEX  eol_transaction_lines_id ON eol_transaction_lines (id) 

CREATE INDEX  eol_transaction_lines_invoicenumber ON eol_transaction_lines (invoicenumber) 

CREATE INDEX  eol_transaction_lines_yourref ON eol_transaction_lines (yourref)
3

Dit topic is 3 dagen na het laatste antwoord automatisch gesloten. Nieuwe antwoorden zijn niet meer toegestaan.