Summary
ExecuteConsolidatedQuery in report end scripts silently returns an empty DataTable
because TenantIsolationLevel defaults to None in ReportRuntimeSettings,
even when the server is configured with Consolidation or Write.
Root Cause
ReportToolSettings (v1.0.0) has no TenantIsolationLevel property.
ReportProcessor.GetRuntimeSettings never sets it, so ReportRuntimeSettings.TenantIsolationLevel
stays at the default None, triggering:
ExecuteConsolidatedQuery blocked: server TenantIsolationLevel is None (minimum required: Consolidation).
Affected Files
Domain.Application/ReportToolSettings.cs — missing TenantIsolationLevel propertyApi.Core/ApiServiceFactory.cs — NewReportSetService does not read PayrollServerConfigurationDomain.Application/ReportProcessor.cs — GetRuntimeSettings does not forward the level
Symptom
ExecuteConsolidatedQuery always returns an empty table in reports,
regardless of the configured TenantIsolationLevel in appsettings.json.
Version
Backend v1.0.0
Summary
ExecuteConsolidatedQueryin report end scripts silently returns an emptyDataTablebecause
TenantIsolationLeveldefaults toNoneinReportRuntimeSettings,even when the server is configured with
ConsolidationorWrite.Root Cause
ReportToolSettings(v1.0.0) has noTenantIsolationLevelproperty.ReportProcessor.GetRuntimeSettingsnever sets it, soReportRuntimeSettings.TenantIsolationLevelstays at the default
None, triggering:Affected Files
Domain.Application/ReportToolSettings.cs— missingTenantIsolationLevelpropertyApi.Core/ApiServiceFactory.cs—NewReportSetServicedoes not readPayrollServerConfigurationDomain.Application/ReportProcessor.cs—GetRuntimeSettingsdoes not forward the levelSymptom
ExecuteConsolidatedQueryalways returns an empty table in reports,regardless of the configured
TenantIsolationLevelinappsettings.json.Version
Backend v1.0.0