Bij het uitvoeren van de query op een XAF-bestand van 500 MB:
select count(*)
from TransactionLines@xaf
krijg ik een System.OutofMemoryException:
Warning itgendhb173: Context: Invantive\Scripts\sql\XAF.sql: select count(*) from TransactionLines@xaf
Error itgenclr007: External error in Invantive Data Hub.
Exception of type ‘System.OutOfMemoryException’ was thrown.
System.OutOfMemoryException
ValidationException
at System.Text.StringBuilder.ToString()
at Invantive.Data.ResultSet.ContentAsJsonUnspecified(GlobalState owner, ExecutionOptions executionOptions, List `1 converters) at Invantive.Data.ResultSet.ContentAsJsonDataSet(GlobalState owner, ExecutionOptions executionOptions) at Invantive.Data.ResultSet.ToJsonDataSet(GlobalState owner, ExecutionOptions executionOptions) at Invantive.Data.Providers.DataCache.DataCacheProvider.SaveFactsOnDisk(GlobalState owner, ExecutionOptions executionOptions, DcTablePartitionVersion tablePartitionVersion, String diskCacheFileNamePath, ResultSet valueRows, Boolean compressFactsInDiskCache, Boolean encryptFactsInDiskCache) at Invantive.Data.P...tring actionSql, ParameterList parameters, String callSafeNameOverrule) at Invantive.Data.ActionProceduresBase.PassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters) at IDH.B.ProcessStatement(GlobalState owner, ExecutionOptions executionOptions, String statement, ResultSet& resultSet, Action` 2 fetchMoreRows, Action `9 executeStatement, Boolean isInInteractiveMode, ScriptingLanguageNextStepSpecification& nextStepSpecification) at IDH.B.ProcessStatements(GlobalState owner, ExecutionOptions executionOptions, Action` 2 fetchMoreRows, Action `9 executeStatement, IEnumerable` 1 statements, String sourceFileName, ScriptingLanguageNextStepSpecification& exitSpecification)