ParameterDescriptionMinimum/default valueMaximum valueJDBCMaxCount

Maximum number of connections to the Smart Reporting database.

25300JDBCMinCount

Minimum number of connections to the Smart Reporting database.

250JDBCTimeoutTimeout of JDBC Connections in seconds.3001800JDBCRecycleJDBC Connection refresh or recycle time.10800NAJDBCFetchSize

Default Fetch size for connecting to the Smart Reporting configuration database.

1000NAJDBCVerify

Checks the Smart Reporting database connection by returning the schema.

TRUENAJDBCNoLockApplies NO LOCK to some database queries when using MS SQL Server.TRUENAPSCacheSizeNumber of Prepared Statements to cache per connection (maximum). 20NAIsolationLevel

Isolation Level for connecting to the Smart Reporting configuration database.

SerializableNADisableHeatBeatDisables heartbeat (periodic queries) against the Repository database.FALSENAReportCacheSizeSize of report result set cache in bytes.2020ReportCacheMaxAgeThe maximum age of result sets in the report result cache in milliseconds.8640000086400000ImageCacheMaxBytesMaximum size of image memory cache in bytes.52428800(50 MB)52428800(50 MB)ReportDefinitionCacheSizeNumber of result sets to store in the report result cache.1000
ReportDefinitionCacheTimeoutMaximum time in milliseconds to store a report definition in the cache86400000
GeometryCacheSizeDefines how many items are allowed in the cache. GeometryCache is initialized with this size. The default size is 4000.4000

DashboardDefinitionCacheSize

Number of definitions that can be stored in the cache.1000
DashboardDefinitionCacheTimeoutMaximum timeout in milliseconds for an element in this cache.86400000
TranslationCacheSizeThis specifies how many translation objects should be cached in memory.5000
TranslationCacheMaxAgeMaximum timeout in milliseconds for an element in this cache.86400000
CachedFilterCacheMethod

Filter methods for data stored in cache. You can specify one of the following values for CachedFilterCacheMethod:

NO_CACHE: No memory caching. Data is loaded from the database each time an hierarchy is requested.
CACHE_BY_USER: Cache values by user.
CACHE_BY_SOURCE_FILTER: Cache by different source filter values.

CACHE_BY_USER
CachedFilterCacheSizeNumber of cached filter entries that can be stored in the cache. Unless source substitution or source filters are in use, their is one entry per filter hierarchy. If source substitution or source filters are in use, their may be one entry per user, or source filter value depending on the cache method. Each entry stores the available values for each filter in the hierarchy. 100
CachedFilterCachePeriodMaximum timeout in milliseconds for an element in this cache.86400000
ExecutionQueueConcurrentTasksNumber of reports that can be run concurrently.10
ExecutionQueueInitialWaitTimeDuration in seconds for which the server will wait to finish a report before the client shows the delivery popup and starts polling.5
ExecutionQueueMaximumExecutionTimeMaximum time in minutes the reports can run in the execution queue before they are terminated.240
DisableTaskSchedulerIndicate whether the task scheduler is active.FALSE
DisableTaskSchedulerPollingSet to allow or prevent a node from becoming a Master node.FALSE
TaskSchedulerThreadsNumber of tasks that can run concurrently.5
TaskSchedulerMaxThreadQueueMaximum number of tasks allowed to wait to be executed, if all threads are currently being used. If the value is set below the number of threads, the system will always allocate at least the same number of slots in the queue as the number of threads.20
MaxThreadsPerTransformationPreviewJobNumber of threads that will be available for each Data Transformation Flow, for internal processing in Preview (edit) mode.2
MaxBackgroundTransformationThreadsNumber of threads that will be available for all Data Transformation Flows, for internal processing during background execution.2