Installing QPR ProcessAnalyzer Server on Windows - Revision history

TeeHiet: TK-62288

2025-12-15T10:09:19Z

TK-62288

← Older revision		Revision as of 10:09, 15 December 2025
Line 54:		Line 54:

	== Install .Net Runtime ==		== Install .Net Runtime ==
	QPR ProcessAnalyzer Server requires the .Net 8 runtime. Install .Net as follows:		QPR ProcessAnalyzer Server requires the .Net 10 runtime. Install .Net as follows:
	# Go to https://dotnet.microsoft.com/en-us/download/dotnet/8.0, and download the latest release of the package '''Hosting Bundle''' for Windows (in the '''ASP.NET Core Runtime''' section).		# Go to https://dotnet.microsoft.com/en-us/download/dotnet/10.0, and download the latest release of the package '''Hosting Bundle''' for Windows (in the '''ASP.NET Core Runtime''' section).
	# Install the downloaded components to the QPR ProcessAnalyzer Server computer.		# Install the downloaded components to the QPR ProcessAnalyzer Server computer.

Ollvihe: /* Create Databases */

2025-11-23T00:29:23Z

Create Databases

← Older revision		Revision as of 00:29, 23 November 2025
Line 20:		Line 20:

	== Create Databases ==		== Create Databases ==
	QPR ProcessAnalyzer uses the following three SQL Server databases (~~but~~ only the ''configuration database'' is mandatory):		QPR ProcessAnalyzer uses the following three SQL Server databases (only the ''configuration database'' is mandatory):
	* '''Configuration database''' for storing system objects, such as projects, scripts, users and usage logs. This database needs to be initialized before it can be used (see more below). Usually this database doesn't require much storage space, and queries to the database are lightweight, but still low latency in query performance is beneficial (i.e., prefer low latency over high data throughput in the storage hardware). Connection string to this database is set in the [[Server_settings_in_appsettings.json\|appsettings.json file]].		* '''Configuration database''' for storing system objects, such as projects, scripts, users and usage logs. This database needs to be initialized before it can be used (see more below). Usually this database doesn't require much storage space, and queries to the database are lightweight, but still low latency in query performance is beneficial (i.e., prefer low latency over high data throughput in the storage hardware). Connection string to this database is set in the [[Server_settings_in_appsettings.json\|appsettings.json file]].
	* '''Datatables database''' for storing data for the datatables, containing events and cases in the process mining models and also data processed by ETL. This database can be initially empty, so it doesn't require any initialization. Required storage space for this database depends on how much data is stored to the datatables. Queries to this database are heavy and data intensive, but usually low latency doesn't provide benefits (i.e., prefer high data throughput over low latency in the storage hardware). Connection string to this database will be set in the [[PA_Configuration_database_table#General_Settings\|configuration table]] (key ''SqlServerConnectionString'').		* '''Datatables database''' for storing data for the datatables, containing events and cases in the process mining models and also data processed by ETL. This database can be initially empty, so it doesn't require any initialization. Required storage space for this database depends on how much data is stored to the datatables. Queries to this database are heavy and data intensive, but usually low latency doesn't provide benefits (i.e., prefer high data throughput over low latency in the storage hardware). Connection string to this database will be set in the [[PA_Configuration_database_table#General_Settings\|configuration table]] (key ''SqlServerConnectionString'').

Ollvihe at 15:46, 22 November 2025

2025-11-22T15:46:47Z

← Older revision		Revision as of 15:46, 22 November 2025
Line 1:		Line 1:
	<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">		<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
	This page contains instructions for a new QPR ProcessAnalyzer installation. If you are updating an existing installation, instead follow the [[Updating_QPR_ProcessAnalyzer_Server\|update instructions]].		This page contains instructions for a new QPR ProcessAnalyzer installation on the Windows operating system. If you are updating an existing installation, instead follow the [[Updating_QPR_ProcessAnalyzer_Server\|update instructions]].
	</div>		</div>

Ollvihe at 15:42, 22 November 2025

2025-11-22T15:42:29Z

← Older revision		Revision as of 15:42, 22 November 2025
Line 72:		Line 72:
	# Go to '''Sites''' and find the web site for QPR ProcessAnalyzer. Select the previously created QPRPA directory and select '''Convert to Application'''. In the dialog, select the previously created application pool and also select '''Enable Preload'''.		# Go to '''Sites''' and find the web site for QPR ProcessAnalyzer. Select the previously created QPRPA directory and select '''Convert to Application'''. In the dialog, select the previously created application pool and also select '''Enable Preload'''.
	# Set an '''https''' binding to the IIS web site (click in '''Edit Bindings...'''), unless using QPR ProcessAnalyzer through a load-balancer terminating the https connection.		# Set an '''https''' binding to the IIS web site (click in '''Edit Bindings...'''), unless using QPR ProcessAnalyzer through a load-balancer terminating the https connection.
	# Create a directory '''C:\ProgramData\QPR Software\QPR ProcessAnalyzer\Logs\''' for log files. Note that this directory will be later set to the [[~~#Server_settings_file_.28appsettings~~.json~~.29~~\|appsettings.json]] file.		# Create a directory '''C:\ProgramData\QPR Software\QPR ProcessAnalyzer\Logs\''' for log files. Note that this directory will be later set to the [[Server_settings_in_appsettings.json\|appsettings.json]] file.

	=== Set Application Pool Always Running ===		=== Set Application Pool Always Running ===

Ollvihe: /* Logging Settings */

2025-11-22T15:41:21Z

Logging Settings

← Older revision		Revision as of 15:41, 22 November 2025
Line 119:		Line 119:

	More information about IIS Application Pool Pinging: https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2008-R2-and-2008/cc725836(v=ws.10)		More information about IIS Application Pool Pinging: https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2008-R2-and-2008/cc725836(v=ws.10)

	~~== Logging Settings ==~~
	QPR ProcessAnalyzer uses the log4net component (https://logging.apache.org/log4net/) for logging, allowing to flexibly define what is logged and where the logs are stored. For example, the following settings can be set in the '''log4net.config''' file (located in the '''bin''' folder in the server application files):
	* log4net > appender > '''maximumFileSize''': Maximum size of the log file. When the maximum size is reached, the log writing continues in a new file, and the old file is archived. The default setting is 100MB. (https://logging.apache.org/log4net/log4net-1.2.13/release/sdk/log4net.Appender.RollingFileAppender.MaximumFileSize.html)
	* log4net > appender > '''maxSizeRollBackups''': Maximum number of archived log files that are stored. When the maximum file size is reached and new file is created, the oldest archived log file is removed if the maximum number of archived files is reached. The default setting is 1. (http://logging.apache.org/log4net/log4net-1.2.15/release/sdk/html/P_log4net_Appender_RollingFileAppender_MaxSizeRollBackups.htm)
	* log4net > appender > '''lockingModel''': By default, the server log works in the ''ExclusiveLock'' mode, i.e. the log file is reserved by the QPR ProcessAnalyzer process for the entire time QPR ProcessAnalyzer is running. Thus it's not possible to edit or delete log files during that time.

	== Installing SAP NetWeaver RFC Library ==		== Installing SAP NetWeaver RFC Library ==

Ollvihe: /* Introduction */

2025-11-22T15:29:00Z

Introduction

← Older revision		Revision as of 15:29, 22 November 2025
Line 8:		Line 8:
	# Check that [[QPR_ProcessAnalyzer_System_Requirements#System_Requirements_for_QPR_ProcessAnalyzer_Server\|System Requirements]] are fulfilled.		# Check that [[QPR_ProcessAnalyzer_System_Requirements#System_Requirements_for_QPR_ProcessAnalyzer_Server\|System Requirements]] are fulfilled.
	# [[#Create Databases\|Create SQL Server databases]].		# [[#Create Databases\|Create SQL Server databases]].
	# [[#~~Create Databases~~\|Initialize configuration database]].		# [[#Initialize Configuration Database\|Initialize configuration database]].
	# [[#Install IIS Server Roles and Features\|Install Roles and Features for IIS]].		# [[#Install IIS Server Roles and Features\|Install Roles and Features for IIS]].
	# [[#Install .Net Runtime\|Install .Net Runtime]].		# [[#Install .Net Runtime\|Install .Net Runtime]].

Ollvihe: /* Introduction */

2025-11-22T15:28:41Z

Introduction

← Older revision		Revision as of 15:28, 22 November 2025
Line 10:		Line 10:
	# [[#Create Databases\|Initialize configuration database]].		# [[#Create Databases\|Initialize configuration database]].
	# [[#Install IIS Server Roles and Features\|Install Roles and Features for IIS]].		# [[#Install IIS Server Roles and Features\|Install Roles and Features for IIS]].
	# [[#~~Initialize Configuration Database~~\|Install .Net Runtime]].		# [[#Install .Net Runtime\|Install .Net Runtime]].
	# [[#IIS_Configuration\|Configure IIS]] for QPR ProcessAnalyzer.		# [[#IIS_Configuration\|Configure IIS]] for QPR ProcessAnalyzer.
	# [[Server_settings_in_appsettings.json\|Configure appsettings.json]].		# [[Server_settings_in_appsettings.json\|Configure appsettings.json]].

Ollvihe: /* Introduction */

2025-11-22T15:28:07Z

Introduction

← Older revision		Revision as of 15:28, 22 November 2025
Line 10:		Line 10:
	# [[#Create Databases\|Initialize configuration database]].		# [[#Create Databases\|Initialize configuration database]].
	# [[#Install IIS Server Roles and Features\|Install Roles and Features for IIS]].		# [[#Install IIS Server Roles and Features\|Install Roles and Features for IIS]].
	# [[#~~Install .Net 8 Runtime~~\|Install .Net Runtime]].		# [[#Initialize Configuration Database\|Install .Net Runtime]].
	# [[#IIS_Configuration\|Configure IIS]] for QPR ProcessAnalyzer.		# [[#IIS_Configuration\|Configure IIS]] for QPR ProcessAnalyzer.
	# [[Server_settings_in_appsettings.json\|Configure appsettings.json]].		# [[Server_settings_in_appsettings.json\|Configure appsettings.json]].

Ollvihe: /* Introduction */

2025-11-22T15:27:54Z

Introduction

← Older revision		Revision as of 15:27, 22 November 2025
Line 7:		Line 7:
	This page describes QPR ProcessAnalyzer Server installation. Go through the following installation steps:		This page describes QPR ProcessAnalyzer Server installation. Go through the following installation steps:
	# Check that [[QPR_ProcessAnalyzer_System_Requirements#System_Requirements_for_QPR_ProcessAnalyzer_Server\|System Requirements]] are fulfilled.		# Check that [[QPR_ProcessAnalyzer_System_Requirements#System_Requirements_for_QPR_ProcessAnalyzer_Server\|System Requirements]] are fulfilled.
	# [[#Create ~~and Initialize Database~~\|~~Setup~~ SQL Server databases]].		# [[#Create Databases\|Create SQL Server databases]].
			# [[#Create Databases\|Initialize configuration database]].
	# [[#Install IIS Server Roles and Features\|Install Roles and Features for IIS]].		# [[#Install IIS Server Roles and Features\|Install Roles and Features for IIS]].
	# [[#Install .Net 6 Runtime\|Install .Net Runtime]].		# [[#Install .Net 8 Runtime\|Install .Net Runtime]].
	# [[#IIS_Configuration\|Configure IIS]] for QPR ProcessAnalyzer.		# [[#IIS_Configuration\|Configure IIS]] for QPR ProcessAnalyzer.
	# [[Server_settings_in_appsettings.json\|Configure appsettings.json]].		# [[Server_settings_in_appsettings.json\|Configure appsettings.json]].

Ollvihe: /* Create Databases */

2025-11-22T15:26:35Z

Create Databases

← Older revision		Revision as of 15:26, 22 November 2025
Line 22:		Line 22:
	* '''Configuration database''' for storing system objects, such as projects, scripts, users and usage logs. This database needs to be initialized before it can be used (see more below). Usually this database doesn't require much storage space, and queries to the database are lightweight, but still low latency in query performance is beneficial (i.e., prefer low latency over high data throughput in the storage hardware). Connection string to this database is set in the [[Server_settings_in_appsettings.json\|appsettings.json file]].		* '''Configuration database''' for storing system objects, such as projects, scripts, users and usage logs. This database needs to be initialized before it can be used (see more below). Usually this database doesn't require much storage space, and queries to the database are lightweight, but still low latency in query performance is beneficial (i.e., prefer low latency over high data throughput in the storage hardware). Connection string to this database is set in the [[Server_settings_in_appsettings.json\|appsettings.json file]].
	* '''Datatables database''' for storing data for the datatables, containing events and cases in the process mining models and also data processed by ETL. This database can be initially empty, so it doesn't require any initialization. Required storage space for this database depends on how much data is stored to the datatables. Queries to this database are heavy and data intensive, but usually low latency doesn't provide benefits (i.e., prefer high data throughput over low latency in the storage hardware). Connection string to this database will be set in the [[PA_Configuration_database_table#General_Settings\|configuration table]] (key ''SqlServerConnectionString'').		* '''Datatables database''' for storing data for the datatables, containing events and cases in the process mining models and also data processed by ETL. This database can be initially empty, so it doesn't require any initialization. Required storage space for this database depends on how much data is stored to the datatables. Queries to this database are heavy and data intensive, but usually low latency doesn't provide benefits (i.e., prefer high data throughput over low latency in the storage hardware). Connection string to this database will be set in the [[PA_Configuration_database_table#General_Settings\|configuration table]] (key ''SqlServerConnectionString'').
	* '''Sandbox database''' for running scripts written with SQL. This database is primarily needed for the SQL query processing where only temporary objects are stored, and thus the ''tempdb'' performance has a critical role. It's also possible to configure the sandbox database to permanently store database objects, and in that case also this database requires space for storage.		* '''Sandbox database''' for running scripts written with SQL. This database is primarily needed for the SQL query processing where only temporary objects are stored, and thus the ''tempdb'' performance has a critical role. It's also possible to configure the sandbox database to permanently store database objects, and in that case also this database requires space for storage. Setup of the ''sandbox database'' is instructed in the section [[Setting_up_Scripting_Sandbox\|Scripting Sandbox]].

	It's possible to connect to the SQL Server either using Windows authentication (Windows account) or SQL Server authentication.		It's possible to connect to the SQL Server either using Windows authentication (Windows account) or SQL Server authentication.

← Older revision		Revision as of 15:29, 22 November 2025
Line 8:		Line 8:
	# Check that [[QPR_ProcessAnalyzer_System_Requirements#System_Requirements_for_QPR_ProcessAnalyzer_Server\|System Requirements]] are fulfilled.		# Check that [[QPR_ProcessAnalyzer_System_Requirements#System_Requirements_for_QPR_ProcessAnalyzer_Server\|System Requirements]] are fulfilled.
	# [[#Create Databases\|Create SQL Server databases]].		# [[#Create Databases\|Create SQL Server databases]].
	# [[#~~Create Databases~~\|Initialize configuration database]].		# [[#Initialize Configuration Database\|Initialize configuration database]].
	# [[#Install IIS Server Roles and Features\|Install Roles and Features for IIS]].		# [[#Install IIS Server Roles and Features\|Install Roles and Features for IIS]].
	# [[#Install .Net Runtime\|Install .Net Runtime]].		# [[#Install .Net Runtime\|Install .Net Runtime]].

← Older revision		Revision as of 15:28, 22 November 2025
Line 10:		Line 10:
	# [[#Create Databases\|Initialize configuration database]].		# [[#Create Databases\|Initialize configuration database]].
	# [[#Install IIS Server Roles and Features\|Install Roles and Features for IIS]].		# [[#Install IIS Server Roles and Features\|Install Roles and Features for IIS]].
	# [[#~~Initialize Configuration Database~~\|Install .Net Runtime]].		# [[#Install .Net Runtime\|Install .Net Runtime]].
	# [[#IIS_Configuration\|Configure IIS]] for QPR ProcessAnalyzer.		# [[#IIS_Configuration\|Configure IIS]] for QPR ProcessAnalyzer.
	# [[Server_settings_in_appsettings.json\|Configure appsettings.json]].		# [[Server_settings_in_appsettings.json\|Configure appsettings.json]].

← Older revision		Revision as of 15:28, 22 November 2025
Line 10:		Line 10:
	# [[#Create Databases\|Initialize configuration database]].		# [[#Create Databases\|Initialize configuration database]].
	# [[#Install IIS Server Roles and Features\|Install Roles and Features for IIS]].		# [[#Install IIS Server Roles and Features\|Install Roles and Features for IIS]].
	# [[#~~Install .Net 8 Runtime~~\|Install .Net Runtime]].		# [[#Initialize Configuration Database\|Install .Net Runtime]].
	# [[#IIS_Configuration\|Configure IIS]] for QPR ProcessAnalyzer.		# [[#IIS_Configuration\|Configure IIS]] for QPR ProcessAnalyzer.
	# [[Server_settings_in_appsettings.json\|Configure appsettings.json]].		# [[Server_settings_in_appsettings.json\|Configure appsettings.json]].

← Older revision		Revision as of 15:27, 22 November 2025
Line 7:		Line 7:
	This page describes QPR ProcessAnalyzer Server installation. Go through the following installation steps:		This page describes QPR ProcessAnalyzer Server installation. Go through the following installation steps:
	# Check that [[QPR_ProcessAnalyzer_System_Requirements#System_Requirements_for_QPR_ProcessAnalyzer_Server\|System Requirements]] are fulfilled.		# Check that [[QPR_ProcessAnalyzer_System_Requirements#System_Requirements_for_QPR_ProcessAnalyzer_Server\|System Requirements]] are fulfilled.
	# [[#Create ~~and Initialize Database~~\|~~Setup~~ SQL Server databases]].		# [[#Create Databases\|Create SQL Server databases]].
			# [[#Create Databases\|Initialize configuration database]].
	# [[#Install IIS Server Roles and Features\|Install Roles and Features for IIS]].		# [[#Install IIS Server Roles and Features\|Install Roles and Features for IIS]].
	# [[#Install .Net 6 Runtime\|Install .Net Runtime]].		# [[#Install .Net 8 Runtime\|Install .Net Runtime]].
	# [[#IIS_Configuration\|Configure IIS]] for QPR ProcessAnalyzer.		# [[#IIS_Configuration\|Configure IIS]] for QPR ProcessAnalyzer.
	# [[Server_settings_in_appsettings.json\|Configure appsettings.json]].		# [[Server_settings_in_appsettings.json\|Configure appsettings.json]].