PAW installation manual – Brief overview

This is a technical manual to support certain configuration aspects of the PAW installer. This manual assumes a certain level of technical knowledge of working with servers.

The installer installs all necessary services in IIS and standalone (Workflow service) to enable full PAW functionality. During the installation, a new PAW_master database is created that contains links to associated PANTHEON databases. The default server port is 9000, so after the installation, the user can run localhost:9000 (or appropriate IP or servername) to access PAW and login to PANTHEON database that was selected during installation.

1. IIS Prerequisites

• Microsoft Windows Server 2019 operating system or newer
• Microsoft SQL Server 2019 or newer
• Microsoft .NET 4.8 or newer
• Microsoft IIS installation (installed as server role)
• Mandatory features of IIS:
  • .NET extensibility 4.7
  • ASP.NET 4.7

• .NET Core 2.1. Hosting bundle (download link: https://dotnet.microsoft.com/download/dotnet-core/thank-you/runtime-aspnetcore-2.1.20-windows-hosting-bundle-installer).

HINT Make sure you restart server, if asked after .NET Core installation.

2. SQL Server Prerequisites

• One or more MSSQL servers installed, one for PAW_master, others (recommended) for PANTHEON databases – can be the same if not otherwise possible
• PANTHEON installation (only database needed, not EXE)
• SQL server user that has permission to create a new database (PAW_master)
• SQL server users that can access PANTHEON databases (only to check connection). If SQL instance is the same for PAW_master database and PANTHEON database, the user can be the same.

3. PANTHEON prerequisites

• Activated PAW license
• In PANTHEON, the Country field for Our company field must not be empty.

4. Installation – important steps

1. Enter information about PAW Master SQL server:

PAW_master database will be automatically created if needed.

2. Enter information about PANTHEON SQL server together with the PANTHEON database name (can be the same server as above):

3. PAW language

WARNING PAW language has to be the same as selected company's country.

In BackOffice/Web.config file search for SiteConfig. Uncomment the appropriate line to change PAW language.

For installations with cyrillic alphabets, enter databaseLocalization field below exactly as is entered in PANTHEON. Run the following SQL to retrieve the data from PANTHEON database:

select acISOCode from the_setCountry where acCountry = (select acCountry from the_setSubj where acSubject = (select acOurCompany from tpa_sysparam))

5. PAAS configuration

PANTHEON Automation Server is automatically installed or upgraded during PAW installation or upgrade.

*For upgrades from existing installation (before version 23.10): After upgrade, PAW\PA\PAAS.ini needs to be manually edited, because ServerName default value is current server, but needs to be changed to PANTHEON database server.

WARNING After installation, Pantheon.exe for your localization needs to be manually downloaded and copied to PAW\PA folder. Pantheon.exe that is already present has EU localization (English) and may not be appropriate for your configuration. Simply replace the existing Pantheon.exe.

6. Additional configuration options 

• Additional web sites

Open table “tRA_MasterComSite” in newly created PAW_master database. Add new rows following the example of an already inserted row. Each row is a link to another PANTHEON database.

• Ports (for advanced users only)

By default, PAW needs Ports 9000, 9001, 9003, 9004 to be free, because installation uses those ports to install different PAW services to those ports. If you need to install PAW to different ports, please consult support.

7. Checking if services are operational

• WebApi: Open in browser localhost:9001/swagger. If anything opens, it works.
• BackOffice: Open in browser localhost:9000. If login screen opens, it works.
• WorkflowService: Open in browser localhost:9003. If it asks for username/password, it works.
• PAAS: Open in browser localhost:9004. If a page opens, it works.

8. Invalid login error

This is very common error, which can be caused by a large range of configuration options or system errors. Here, you can find some of the most common issues with configuration options that should be checked:

• PAW does not support login without password, while PANTHEON does.
• Check the above prerequisites and check if all three services are operational (WebApi, WorkflowService, PAAS).
• Check that the country is defined for Our company field in PANTHEON.
• Check if PAW language is the same as the company's country (see above on how to check/fix it).
• Check if the correct license for PAW is installed in the target database.
• Check user permissons for PAW in PANTHEON.

9. Other errors

Here are a few other possible errors and the tips for their troubleshooting:

• HTTP Error 500.19 – Internal Server Error and one of the first lines is Module IIS Web Core.
  • Re-run .NET Core 2.1. Hosting bundle installer (select Repair), and after instalation restart IIS.
• In EventViewer, there is an error writing to WebApi/logs:
  • In folder WebApi, create subfolder logs and give everyone full permissions to it.
• Check WebApi/web.config if <aspNetCore processPath="dotnet.exe"...> is available on your system Path.