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

patricesalem — Mon, 06 Jul 2020 09:52:42 GMT

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-Tasks-Do-Not-Reload/ta-p/1714596?_ga=2.255408269.447395979.1594024602-1818586065.1576566891

https://community.qlik.com/cyjdu72974/attachments/cyjdu72974/new-to-qlik-sense/142805/1/Troubleshooting%20monitoring%20Apps.pdf

Thanks for your advices

Patrice

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

ChotanaBI — Mon, 06 Jul 2020 12:15:44 GMT

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

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

patricesalem — Mon, 06 Jul 2020 12:38:45 GMT

thanks for the head up.

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...

Thanks for your help

Patrice

topic Re: Operation Monitor task Fails - Unable to connect to database (Qlik Sense Server Sept 2019) in Management & Governance

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

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

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