Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
patricesalem
Creator II
Creator II

Operation Monitor task Fails - Unable to connect to database (Qlik Sense Server Sept 2019)

Hello

Since last week, the operation monitor task won't reload (it has been going on without any issue for the last 7 months).

No change on the server, no upgrade...

Here is what says the script when editing the app from the hub :

 

Reloading Operations Monitor 7.16.0 from MX-QLIK running QIX Engine version 12.421.4. Default log source selected (will check database first, then files)

Working on Monitor App Reload Stats

monitor_app_reload_stats << Operations_Monitor_Reload_Stats_7.16.0
Lignes extraites : 19 092
monitor_app_reload_stats << AUTOGENERATE(1)
Lignes extraites : 19 093
Verifying logging database.
Connecté
ERROR: Connector reply error: ***

Working on Monitor App Reload Stats

monitor_app_reload_stats << AUTOGENERATE(1)
Lignes extraites : 19 094
Could not validate active database logging. Sourcing from file logs instead.

Last Reload Compare time = 2020-04-06. CutoffDate = 2020-04-06.

Checking for base qvd

Incremental reload of LogContent table (i.e. not first reload)
L'erreur suivante s'est produite:
Connector reply error: Unable to connect to database:
    Connection failed:
Please check the values for Username‚ Password‚ Host‚ and other properties.
Emplacement de l'erreur:
db_check:
    SELECT "id" 
    FROM "public"."log_entries" 
    WHERE "entry_timestamp" >= '2020-07-06 11:25:29'
L'erreur suivante s'est produite:
Unsupported or bad format in QVD file
Emplacement de l'erreur:
LogContent:
        NoConcatenate
    	Load * FROM [lib://ServerLogFolder/governanceLogContent_7.16.0_file.qvd] (qvd)
        WHERE LogTimeStamp >= '2020-04-06'
Les données n'ont pas été chargées. Corrigez l'erreur, puis recommencez l'opération de chargement.

 

 

I went though many posts + pdf including :

https://community.qlik.com/t5/Qlik-Support-Knowledge-Base/Operations-Monitor-or-License-Monitor-Task...

https://community.qlik.com/cyjdu72974/attachments/cyjdu72974/new-to-qlik-sense/142805/1/Troubleshoot...

 

Thanks for your advices

Patrice

2 Replies
ChotanaBI
Contributor III
Contributor III

Bonjour,

 

1- Ton connecteur n'a-t-il pas sauté ? // The connector has been deleted?

2- le fichier existe toujours ?  // Does the file still exists?

lib://ServerLogFolder/governanceLogContent_7.16.0_file.qvd

3- Le mot de passe a-t-il expiré ? //Password has expired?

Connector reply error: Unable to connect to database:
    Connection failed:

 

/Chotana

www.bi-formation-service.fr

 

Chotana
http://bi-formation-service.fr
patricesalem
Creator II
Creator II
Author

Hi

 

thanks for the head up.

Image 1915.jpg

The QVD is there...

 

Since I haven't installed the Qlik Server myself, I don't know where to check if the password is expired...

Image 1916.jpg

Thanks for your help

Patrice