Error SystemLink Could Not Find Configuration File for PostgreSQLDatabase

Issue Details

• On my SystemLink Server, the PostgreSQLDatabase service is stuck and will not finish starting. In the Skyline logs, I see a fatal error about the PostgreSQLDatabase configuration file. How can I fix this?
• My SystemLink Skyline logs report that the PostgreSQLDatabase service configuration file could not be found. How can I troubleshoot this?
• The PostgreSQLDatabase service will not start and I see the below error repeatedly in the SystemLink Skyline logs.

PostgreSQLDatabase | ERROR - C:\Program Files\National Instruments\Shared\Skyline\PostgreSQLDatabase\NationalInstruments.PostgresConfig.exe - NationalInstruments.PostgresConfig: Fatal: Could not find configuration file for service "PostgreSQLDatabase" in configuration directory "C:\ProgramData\National Instruments\Skyline\Config". 

Solution

This error can occur due to a corrupt configuration file for the SystemLink PostgreSQLDatabase service. 

On the SystemLink Server PC, navigate to C:\ProgramData\National Instruments\Skyline\Config and verify that a PostgreSQLDatabase.json file is present.
Follow the relevant sections below depending on if the JSON file is present.
 

PostgreSQLDatabase.json is Present

If the JSON file is present, it may be corrupt.
 

1. If you have a known working version of this file (from another SystemLink Server or previous snapshot):
   1. Copy the known working version of the JSON file to your problem server (making sure to move the problematic JSON file to another folder first).
   2. Modify the JSON file so that the Postrges.Password and Postgres.ConnectionString resemble the image below.
   3. Note: If you are using an external PostgreSQL database, the Postgres.User and Postgres.Database will also need to be modified to match your required configuration.
   4. Save changes and then restart your SystemLink services using the NI SystemLink Server Configuration application.

 

2. If you do not have a known working version of the JSON file, download the copy attached to this article and follow the instructions from the previous step.
3. If the issue persists, refer to the troubleshooting steps in SystemLink PostgreSQL Database No Longer Starts.

PostgreSQLDatabase.json is Not Present

If the JSON file is not present, that indicates that the SystemLink installation is corrupt.
Using NI Package Manager, uninstall and then reinstall SystemLink. Refer to Installing, Updating, Repairing, and Removing NI Software for instructions.