Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Tool_Tip
Creator III
Creator III

Changes after upgrading postgres from 12 to 14

Dear all,

After upgrading postgres from 12 to 14, we have found  below new changes to our enviornment, which we want to understand/confirm if those are normal:

Steps followed using URL "https://help.qlik.com/en-US/sense-admin/November2024/Subsystems/DeployAdministerQSE/Content/Sense_De... 

1) Qlik Sense Repository Database service is disappeared 

2) New service named postgresql-x64-14  is running

3) Default path of postgres changed 

    FROM : C:\Program Files\Qlik\Sense\Repository\PostgreSQL\12.5

    TO : C:\Program Files\PostgreSQL\14

4) Unable to run Qliksenseutil as it is throwing below error :

     

Tool_Tip_0-1733719237604.png

 

 

Labels (1)
19 Replies
mpc
Partner Ambassador
Partner Ambassador

Hi, 

Quite strange since DB Host Name should be specified after QlikSenseUtil is launched. Di you try to launch it with administrator privilege and check logs as suggested

Best

From Next Decision and mpc with love
Tool_Tip
Creator III
Creator III
Author

Dear Mpc

You have mentioned regarding only point (4) if I am not wrong. If yes can you tell where I can see log file ?

mpc
Partner Ambassador
Partner Ambassador

Exact, 

Point 1,2,3 seem to be correct. 
Logs of Qlik Sense utils should be in a folder at the root of the QlikSenseUtil.exe one

Best

From Next Decision and mpc with love
Tool_Tip
Creator III
Creator III
Author

There is nothing in this folder 

Tool_Tip_0-1733907491191.png

 

Tool_Tip
Creator III
Creator III
Author

Here you go 

Error pinging host:'abcd.com:4545' Exception message: No connection could be made because the target machine actively refused it 10.203.17.15:4545

mpc
Partner Ambassador
Partner Ambassador

And if you retry to launch the tools with administrator privileges
From Next Decision and mpc with love
mpc
Partner Ambassador
Partner Ambassador

Ok, I've a idea, please check this: Postgres database moved to new host but some Qlik ... - Qlik Community - 1714567

From Next Decision and mpc with love
Tool_Tip
Creator III
Creator III
Author

As I mentioned before the default path of postgre has been changed during upgrade;

     FROM : C:\Program Files\Qlik\Sense\Repository\PostgreSQL\12.5

     TO : C:\Program Files\PostgreSQL\14

And as per your solution in given URL , we need to connect to qliksenseutil and which again not supposed to be used as per qlik...

Tool_Tip_0-1733912339780.png

 

mpc
Partner Ambassador
Partner Ambassador

In the provided solution, no need to connect to QlikSenseUtil, you need to change conf. of microservice, again this check this doc: Postgres database moved to new host but some Qlik ... - Qlik Community - 1714567 only Resolution Part

From Next Decision and mpc with love