Known Issue: FME Server Database Schema Creation Fails When Password Specified During Install Contains Special Character

Symptom 

After performing an install of FME Server, when you try and log in the response is 

Could not connect to FME Core.
Please ensure that it is running.


In the fmeserver, fmeconnection and fmeconfiguration logs located in <FMEServerSystemShare>\Resources\Logs\Core\Current there is an error:

SQLException: ERROR: relation "fme_config" does not exist

Other log files contain similar errors pointing to different 'relations'. 

Cause 

In FME Server 2021.0 and newer the user must specify the password the installer should use for database creation, when this password contains certain special characters, the createSchema.sql file fails to run successfully and the fme tables are not created. 

Special characters known to cause this problem are the percent sign (%), a white space character, or a leading single quote. 

Resolution

Option 1: Reinstall FME Server

Uninstall FME Server and reinstall it using a password that does not contain special characters. 

Option 2: Manually run the SQL script

1. Open Command Prompt run as Administrator and navigate to <FMEServerDir>\Utilities\pgsql\bin
2. Run the command

   psql -U fmeserver -d fmeserver -h 127.0.0.1 -p 7082 -f "<FMEServerDir>\Server\database\postgresql\postgresql_createSchema.sql"

   You will be prompted to enter the password. This is the same password you used in the installer

3. Restart FME Server

Note: <FMEServerDir> refers to the location of the FME Server installation folder, specified during installation. By default, this is C:\Program Files\FMEServer on a windows machine and /opt/fmeserver on a Linux machine.