Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Highlighted
MynhardtBurger
New Contributor III

PostgreSQL event viewer errors

Our November 2018 Patch 2 Qlik Sense install has been experiencing some crashes and bouts of non-responsiveness.

When reviewing the windows event viewer the errors all seems to relate to PostgreSQL.

Did something in our postgresql database get corrupted?
Is there a way to repair the database?

The two most common errors are listed below:

The description for Event ID 0 from source PostgreSQL cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event: 

ERROR:  column c.CreatedOn does not exist at character 10
STATEMENT:  SELECT 
	c."CreatedOn"
	FROM "__MigrationHistory" AS c
	LIMIT 1 
The description for Event ID 0 from source PostgreSQL cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event: 

ERROR:  relation "nodes" already exists
STATEMENT:  CREATE TABLE nodes (
		hash BYTEA PRIMARY KEY,
		refs INT NOT NULL,
		value BYTEA,
		value_string TEXT,
		datatype TEXT,
		language TEXT,
		iri BOOLEAN,
		bnode BOOLEAN,
		value_int BIGINT,
		value_bool BOOLEAN,
		value_float double precision,
		value_time timestamp with time zone
	);
Labels (2)
1 Solution

Accepted Solutions

Re: PostgreSQL event viewer errors

Hello, 

So those two events are harmless to your system.

  • The first one will occur every time you start the Qlik Sense Repository Service https://support.qlik.com/articles/000005410
  • The second one shows up whenever precedents service starts up (Qlik Sense Dispatcher Service), we re-run the appropriate database initialization request. This is to ensure the required tables exist before we start using them. An unfortunate side effect is that an event gets logged when the tables already exist https://support.qlik.com/articles/000071291

There is no proper way to get rid of those events as far as I know.

Hope this helps! 

 

Bastien Laugiero
If a post helps to resolve your issue, please mark the appropriate replies as CORRECT.
2 Replies

Re: PostgreSQL event viewer errors

Hello, 

So those two events are harmless to your system.

  • The first one will occur every time you start the Qlik Sense Repository Service https://support.qlik.com/articles/000005410
  • The second one shows up whenever precedents service starts up (Qlik Sense Dispatcher Service), we re-run the appropriate database initialization request. This is to ensure the required tables exist before we start using them. An unfortunate side effect is that an event gets logged when the tables already exist https://support.qlik.com/articles/000071291

There is no proper way to get rid of those events as far as I know.

Hope this helps! 

 

Bastien Laugiero
If a post helps to resolve your issue, please mark the appropriate replies as CORRECT.
MynhardtBurger
New Contributor III

Re: PostgreSQL event viewer errors

Thank you for the quick response.