In the application event viewer log are many entries from PostgreSQL: FATAL: Database »SenseServices« does not exist
After upgrade to Qlik Sense June 2018 or later error messages in Windows Application Event Log: FATAL: database SenseServices does not exist
Environments:
- QlikSense June 2018 and up
After a upgrade to QlikSense June 2018 or later the SenseServices database has not been created automatically.
Open the pgadmin tool on the node with the database and connect to PostgreSQL database used by Qlik Sense as described on
Installing and Configuring PGAdmin 4 to access the PostgreSQL database used by Qlik Sense :
To create a new, empty PostgreSQL database with the name SenseServices using the pgAdmin tool:
- In the pgAdmin Browser, under Servers, right-click the PostgreSQL node and then click Connect Server.
- Enter your PostgreSQL superuser password to make a connection. A green status bar appears in the lower right corner of your screen when the server connection is successful.
- Right-click the Databases node, click Create, and then click Database.
- Enter the name of the database you are creating (SenseServices), and then click Save.
- Make qliksenserepository the owner of the SenseServices database. To do this, right-click the SenseServices database you created earlier, and then click Properties. In the General tab, in the Owner drop-down, select qliksenserepository as Owner of the SenseServices databases and click Save.
- Open the Query Tool. Select the database SenseServices, to display the Query Tool option in the Tools menu and run the following scripts:
- GRANT TEMPORARY, CONNECT ON DATABASE "SenseServices" TO PUBLIC;
- GRANT ALL ON DATABASE "SenseServices" TO postgres;
- GRANT CREATE ON DATABASE "SenseServices" TO qliksenserepository;
With those steps the SenseServices database should have been created and have the correct permissions in place in order to be able that QlikSense can write into it.
The SenseServices database contains schemas for each of the Qlik Sense services and allows growth independently of the Qlik Sense Repository Database, while still sharing the same PostgreSQL instance and login role.