Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

PostgreSQL error "column c.CreatedOn does not exists" when starting up Qlik Sense Repository Service

0% helpful (0/1)
cancel
Showing results for 
Search instead for 
Did you mean: 
Bjorn_Wedbratt
Former Employee
Former Employee

PostgreSQL error "column c.CreatedOn does not exists" when starting up Qlik Sense Repository Service

Last Update:

May 19, 2021 9:11:45 AM

Updated By:

Andre_Sostizzo

Created date:

Oct 2, 2014 8:57:36 AM


When starting Qlik Sense Repository Service you may receive the following error in the Windows Application log:
 

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 


Environment:

 

 

Resolution:

 

The "column c.CreatedOn does not exist" exception is expected. 
 
The CreatedOn column is used only in PostreSQL and Entity Framework 4.3 and below. However, the internal check for the table "__MigrationHistory" and, accordingly, for the "CreatedOn" column still exists and, consequently, in later versions this gives an error. However, the implementation of this request does not stop the application and does not affect the result.


This message will not impact the Qlik Sense system. Should the Qlik Sense system experience service interruption, review the appropriate service log files. More information can be found in our Knowledge Base, or with assistance of our Qlik Community.
Labels (1)
Comments
PWJ67
Contributor II
Contributor II

Hi, 

After upgrade to qlik Sense enterprise August 2023, and PostgreSQL 14, I have this error in windows event viewer (INSTRUCTION : SELECT c."CreatedOn" FROM "__MigrationHistory" AS c LIMIT 1)

At first Qlik Sense were unable to launch. After Windows restart, it's ok but the error is allready there.

Is the no fix Since nov 2021 ?

Thx.

 

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @PWJ67 

This message is not an indication of an actual error. At launch, it checks for this specific table, but the table will not exist. It has no impact on the database itself.

If you still experience issues with Qlik Sense starting after the upgrade, a different error is going to be the culprit.

All the best,
Sonja 

Contributors
Version history
Last update:
‎2021-05-19 09:11 AM
Updated by: