Qlik Sense Enterprise on Windows Repository Database does not start

[Bastien_Laugiero]

The Qlik Sense Repository Database does not start.

The service fails with the error: 

The Qlik Sense Repository Database service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.

 
The Windows Application log reads:

PostgreSQL "PANIC:  could not open control file "global/pg_control": Permission denied"

 

Environment:

Qlik Sense Enterprise on Windows 

 

 

Resolution

The Qlik Sense Repository Database Service needs to at all times be run by the Local System account. If the account has been changed, the service cannot start.

To change the account:

1. Open the Windows Services Console
2. Locate the Qlik Sense Repository Database Service
3. Right-click go to Properties 
4. Go to the Log On tab
5. Select the Local System account.
6. The Qlik Sense Repository Database service will now start. 
   
   

 

If the service still does not start, then then the database files may have been set to Read Only, which can happen as a result of permissions inheritance in the file system.

To fix this:

1. On the database server navigate to the postgres directory (if installed with Qlik Sense it will be located at %ProgramData%\Qlik\Sense\Repository\PostgreSQL\9.6)
2. Select all
3. Click Properties
4. Uncheck Read Only
5. Click Apply
6. Ensure Apply Changes to the selected items, subfolders and files is select
7. Click OK
8. Restart the Database service

Related Content:

Qlik Sense Repository Database starts and stops: "FATAL: lock file "postmaster.pid" already exists" 
Qlik Sense repository service fails to start due to error " 'SeSecurityPrivilege " error