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

Liz Sanderson
Liz Sanderson
  • Updated

FME Version

  • FME 2021.0
Known Issue ID DEVOPS-1037 & DEVOPS-1468
Discovered 2021.0.3
Affects 2021.0 and newer 
Resolved 2022.0 b22325

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.
Screen Shot 2021-06-09 at 4.04.27 PM.png

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.

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.