PA Configuration database table: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 11: Line 11:
||86400
||86400
||Maximum duration for a user session in seconds. Even if a session is used so that the SessionIdleTimeout is not reached, the session is expired after this amount of time.
||Maximum duration for a user session in seconds. Even if a session is used so that the SessionIdleTimeout is not reached, the session is expired after this amount of time.
|-
||<span style="color:green;font-weight:bold;">SandboxDatabaseConnectionString</span>
||<empty>
||Connection string to scripting sandbox database (ETL). If not defined, ETL scripts cannot be run. Connection string for the scripting sandbox database is similar to the  [[Web.config_file_in_QPR_ProcessAnalyzer#Connection_Strings_Section|QPR ProcessAnalyzer database connection string]].
|-
|-
||StartupModelLoadingMaxParallelism
||StartupModelLoadingMaxParallelism
Line 19: Line 23:


This setting affects only the model loading during the server startup and it doesn't restrict models loadings initiated by users.
This setting affects only the model loading during the server startup and it doesn't restrict models loadings initiated by users.
|-
||AllowNonTemporaryETLTargetTable
||false
||Defined whether ETL scripts are allowed to create global temporary database tables (tables starting with ##).
|-
|-
||DeleteModelsInRecycleBinOnStartup
||DeleteModelsInRecycleBinOnStartup
Line 31: Line 39:
||5000
||5000
||BulkCopyBatchSize given for QPR ProcessAnalyzer database SqlBulkCopy operations.
||BulkCopyBatchSize given for QPR ProcessAnalyzer database SqlBulkCopy operations.
|-
|<span style="color:lightgrey;">SandboxDatabaseBulkCopyTimeout</span>
||600
||BulkCopyTimeout given for sandbox SqlBulkCopy operations.
|-
||<span style="color:lightgrey;">SandboxDatabaseBulkCopyBatchSize</span>
||5000
||BulkCopyBatchSize given for sandbox SqlBulkCopy operations.
|-
|-
|<span style="color:lightgrey;">DatabaseAvailabilityMode</span>
|<span style="color:lightgrey;">DatabaseAvailabilityMode</span>
Line 48: Line 64:
||<empty>
||<empty>
||Installation package URL shown to a user when the user doesn't have the recommended client version installed.
||Installation package URL shown to a user when the user doesn't have the recommended client version installed.
|}
|}


== Sandbox Settings ==
{| class="wikitable" style="text-align: left"
!Name !!Default&nbsp;value !!Description
|-
||<span style="color:green;font-weight:bold;">SandboxDatabaseConnectionString</span>
||<empty>
||Connection string to scripting sandbox database (ETL). If not defined, ETL scripts cannot be run. Connection string for the scripting sandbox database is similar to the  [[Web.config_file_in_QPR_ProcessAnalyzer#Connection_Strings_Section|QPR ProcessAnalyzer database connection string]].
|-
||AllowNonTemporaryETLTargetTable
||false
||Defined whether ETL scripts are allowed to create global temporary database tables (tables starting with ##).
|-
|<span style="color:lightgrey;">SandboxDatabaseBulkCopyTimeout</span>
||600
||BulkCopyTimeout given for sandbox SqlBulkCopy operations.
|-
||<span style="color:lightgrey;">SandboxDatabaseBulkCopyBatchSize</span>
||5000
||BulkCopyBatchSize given for sandbox SqlBulkCopy operations.
|}


== LDAP Authentication Settings ==
== LDAP Authentication Settings ==

Revision as of 21:51, 26 October 2019

In QPR ProcessAnalyzer database, there is a configuration table PA_Configuration. It contains settings listed in the table below. You need SQL Server Management Studio to edit the settings in the configuration table. QPR ProcessAnalyzer Service needs to be restarted for the changes to take effect.

Name Default value Description
SessionIdleTimeout 3600 Idle user session expiration timeout in seconds. User session expires if the session hasn't been used after this amount of time. This time should be set same as QPR UI session expiration timeout.
SessionMaximumDuration 86400 Maximum duration for a user session in seconds. Even if a session is used so that the SessionIdleTimeout is not reached, the session is expired after this amount of time.
SandboxDatabaseConnectionString <empty> Connection string to scripting sandbox database (ETL). If not defined, ETL scripts cannot be run. Connection string for the scripting sandbox database is similar to the QPR ProcessAnalyzer database connection string.
StartupModelLoadingMaxParallelism 2 Maximum number of QPR ProcessAnalyzer models that are loaded into memory simultaneously by the Automatic Loading on Server Startup. If this setting is not defined, 2 is used as a default value. If there are more models to be loaded on the server startup than this setting, loading for the rest of the models is started one by one when previous model loadings are completed.

Loading more models at the same time will speed up the whole model loading process, but on the other hand, it causes more load on the system, which affects the system responsiveness for users. Model loading consists of (1) transferring data from the datasource to QPR ProcessAnalyzer and (2) loaded data preprocessing into a model. The former uses mainly network bandwidth (if datasource is in a different server) and the latter uses mainly processor capacity in the QPR ProcessAnalyzer server.

This setting affects only the model loading during the server startup and it doesn't restrict models loadings initiated by users.

AllowNonTemporaryETLTargetTable false Defined whether ETL scripts are allowed to create global temporary database tables (tables starting with ##).
DeleteModelsInRecycleBinOnStartup 0 When set to 1, deleted QPR ProcessAnalyzer models in the recycle bin are permanently deleted when restarting the QPR ProcessAnalyzer Server. After restarting, the DeleteModelsInRecycleBinOnStartup is automatically set back to 0, so the recycle bin is not emptied every time the server is started.
DatabaseBulkCopyTimeout 600 BulkCopyTimeout given for QPR ProcessAnalyzer database SqlBulkCopy operations.
DatabaseBulkCopyBatchSize 5000 BulkCopyBatchSize given for QPR ProcessAnalyzer database SqlBulkCopy operations.
SandboxDatabaseBulkCopyTimeout 600 BulkCopyTimeout given for sandbox SqlBulkCopy operations.
SandboxDatabaseBulkCopyBatchSize 5000 BulkCopyBatchSize given for sandbox SqlBulkCopy operations.
DatabaseAvailabilityMode 0

One of the following options:

  • 0: Available: no limitations for usage
  • 1: Archived: when connecting with Excel Client, user is informed that the database is archived and is not used for production
  • 2: Unavailable: users can't connect to the database
RecommendedClientVersion <empty> If set, contains the EXTERNAL version number (=product version) of a client libraries that is recommended for using QPR ProcessAnalyzer Server. The value should either be empty or contain a string in format <major>.<minor> where <major> is major version number and <minor> is minor version number. Example: "2018.4".

Having the value empty equals to the case where the <major> and <minor> version numbers are equal to the external version number of the client library that connected to the database.

ExcelAddInInstallationUrl <empty> Installation package URL shown to a user when the user doesn't have the recommended client version installed.


LDAP Authentication Settings

Name Default value Description
AuthenticationMethod 1 Authentication related settings, see detailed information in LDAP/AD Authentication.
LDAPConnectionString <empty>
LDAPUserFilter <empty>
LDAPUserSearchBase <empty>
LDAPUserIdAttributeName <empty>
LDAPServerUserName <empty>
LDAPServerPassword <empty>

Readonly Information

Name Default value Description
DatabaseId <random GUID> Unique identifier for the database. Unless the database has been copied from another database, there shouldn't be two databases with the same database id.
DatabaseVersion <current version> Database schema version. It will be updated automatically when a QPR ProcessAnalyzer Server of a newer version connects to the database and performs migration for the database.
InitializationScriptDatabaseVersion