PostgreSQL error on Qlik Sense Central Node

[er77]

Hi,

from one week on the event viewer every 30 seconds I'm getting an error like this below; is the DB corrupted?

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: null value in column "payload" violates not-null constraint
DETAIL: Failing row contains (20639131, 2018-11-19 09:38:33.375534+01, INFO, 63, Qlik.Printing.Rendering.CefSharp.Communication.RemotingServer, EU-SRVQLIKCN, printing, 8048, null).
CONTEXT: COPY log_entries, line 1
STATEMENT: COPY public.log_entries (entry_timestamp, entry_level, thread, logger, process_host, process_name, process_id, payload) FROM STDIN WITH BINARY

[Gysbert_Wassenaar]

Looks like your QS installation is trying to write a log entry to the QLogs database and Postgresql won't let it because a the log entry is missing a value in a column that should have value. Doesn't look like anything serious to me. Logs are by default also written to text files. But you could ask Qlik Support to have a look at it. Perhaps they know an easy way to get rid of what's causing the error.

[Giuseppe_Novello]

Can you try a small test. Check windows event logs, and check the last error, then Can you go to your hub>open an app> open a sheet and export the sheet to PDF. Once exported, go to your windows event logs, and check if and new event entry was generated at the same time that the export happen. Let me know the results and what version of QS do you have install. 

BR

Gio

[er77]

Unfortunately this error is happening every second also if there are no users working on Qlik.

I'm running the last version: November 2018 Patch 1

[Giuseppe_Novello]

I encourage to you, to open a Qlik Support ticket, since this is not normal behavior . Please provide detail information about you environment, provide a copy of the Qlik Sense logs and Windows event logs.  

Best Regards,

Gio

[JustinDallas]

Hello Err77,

I had a similar issue yesterday after upgrading last Friday.  While QS was writing to event viewer, I didn't notice any problems on the front end by users, or in the admin end by me.  I restarted the server yesterday, and those "payload" errors went away except for 2 strange PostgreSQL errors this morning.

[dipankarm]

Having the same issue. Logged a case with Qlik Support. R&D has not yet commented on the Bug.

[korsikov]

Having the same issue. Create a case on Qlik Support. Have a Bug ID QLIK-92703. w/o any comments and notification when it will be fixed.

workaround - restart QlikSense Logging service.

[dipankarm]

Hi @korsikov, I restarted Logging service but the error message seems to be still logged every second. Does this require a server restart?

Thanks!

[korsikov]

qs logging service is not the root of the problem. Only eliminates the consequences. The reason is something else.

When user do export, everything repeat again.