PA Configuration database table

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.
StartupModelLoadingMaxParallelism	2	Maximum number of QPR ProcessAnalyzer models that are loaded into memory at the same time 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 server startup than this setting, loading for the rest of the models is started when previous are finnished. Loading more models at the same time speeds up model loading, but on the other hand, it causes more load to the system, which slows down system responsiveness for usage at the same time. This setting doesn't restrict when models loadings are triggered by users.
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 to 0, so the bin is not emptied every time the server is started. Default value is 0, meaning that nothing is done.
DatabaseAvailabilityMode	0	One of the following options: 0: Available (no usage restrictions) 1: Archived (when connecting with Excel Client, client tells the user that the database is archived and is not used for production) 2: Unavailable (users can't connect to PA database marked as unavailable)
DatabaseBulkCopyTimeout	600	BulkCopyTimeout given for non-sandbox SqlBulkCopy operations.
DatabaseBulkCopyBatchSize	5000	BulkCopyBatchSize given for non-sandbox SqlBulkCopy operations.
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.

Sandbox Settings

Name	Default value	Description
SandboxDatabaseConnectionString	<empty>	If set, defines the connection string to ETL sandbox database. If not defined, running ETL scripts is not possible.
SandboxDatabaseBulkCopyTimeout	600	BulkCopyTimeout given for sandbox SqlBulkCopy operations.
SandboxDatabaseBulkCopyBatchSize	5000	BulkCopyBatchSize given for sandbox SqlBulkCopy operations.
AllowNonTemporaryETLTargetTable	false	Defined whether ETL scripts allowed to create global temporary database tables (tables starting with ##).

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 client with a new version connects to the database and does the migration (see UpdateDatabaseIfNeeded setting documentation for web.config).
InitializationScriptDatabaseVersion