Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

Upgrade to Qlik Sense enterprise June 2017 failure

Hi,

I'm trying to upgrade our Qlik Sense 3.1 iatnstallation to June 2017 release. I have gone through the instructions here:

Upgrading and migrating from synchronized to shared persistence ‒ Qlik Sense

When i start the actual installation from the command line (Qlik_Sense_setup_June2017.exe databasedumpfile=d:\QlikSense.dmp) everything seems fine for a while, but then I get an error message:

Capture.PNG

I'm pretty sure I have given the same postgres password everywhere, so I don't think this is the actual problem. Has anybody any suggestions on how to solve this? I have tried to look in the log files (a large postgres and a smaller), but have not found anything yet.

Erik

10 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Hi,

check this link, which has steps to change the password.

Changing the repository database user password ‒ Qlik Sense

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted

Hi,

That's look like the same procedure as in step 3 in the page I have followed. I did that and then I used the same password in step 5 as superuserpassword.

Regards,

Erik

Highlighted

When I look in the log file I find the following:

Calling custom action Qlik.QustomActions64!Qlik.QustomActions64.DatabaseInitializer.RestoreDatabaseFromDumpFile

Action 08:54:25 81 POSTGRESQL_PORT: 4432

Action 08:54:25 81 POSTGRESQL_DIR: C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6\bin\

Action 08:54:25 81 POSTGRESQL_SUPERUSER: postgres

Action 08:54:25 81 The property RANDOMPASSWORD is empty.

Action 08:54:25 81 POSTGRESQL_DB_DIR: C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.6

Action 08:54:25 81 The property DBLIMITEDUSERNAME is empty.

Action 08:54:25 81 DBDUMPFILEPATH: d:\QlikSense.dmp

Action 08:54:25 81 POSTGRESQL_DIR: C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6\bin\

Action 08:54:25 81 POSTGRESQL_PORT: 4432

MSI (s) (08:68) [08:54:31:848]: Executing op: ActionStart(Name=CA_ValidateLimitedUserPassword,Description=Verifying database user password,Template=Verifying database user password)

Action 08:54:31 83 REMOVEDUMP: 0

MSI (s) (08:68) [08:54:31:850]: Executing op: CustomActionSchedule(Action=CA_ValidateLimitedUserPassword,ActionType=11265,Source=BinaryData,Target=**********,CustomActionData=**********)

MSI (s) (08:5C) [08:54:31:863]: Invoking remote custom action. DLL: C:\Windows\Installer\MSICDF5.tmp, Entrypoint: ValidateSuperUserPassword

SFXCA: Extracting custom action to temporary directory: C:\Windows\Installer\MSICDF5.tmp-\

SFXCA: Binding to CLR version v4.0.30319

Calling custom action Qlik.QustomActions64!Qlik.QustomActions64.DatabaseInitializer.ValidateSuperUserPassword

Action 08:54:32 04 POSTGRESQL_DIR: C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6\bin\

Action 08:54:32 05 POSTGRESQL_PORT: 4432

Action 08:54:32 05 POSTGRESQL_SUPERUSER: qliksenserepository

Action 08:54:32 05 POSTGRESQL_DB_DIR: C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.6

Action 08:54:34 09 Trying again.

Action 08:54:36 14 Trying again.

Action 08:54:38 18 Trying again.

Action 08:54:40 23 Trying again.

Action 08:54:42 27 Trying again.

Action 08:54:42 31 Password validation failed.

CustomAction CA_ValidateLimitedUserPassword returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)

What looks a bit strange to me is that POSTGRESQL_SUPERUSER has two different values, first its postgres, then it's qliksenserepository. Is that the way it should be??


Erik

Highlighted

And when I look in the dump file it is in text format. Passwords are as far as I can tell md5 encrypted. Can I bypass the password verification? I'm not really interested in importing the passwords, it's the data I'm after.

Erik

Highlighted

Or perhaps I can make a standard install and then import the dumpfile after that??

Erik

Highlighted

FYI: I gave this upp and made a fresh install instead.

Best regards

Erik

Highlighted

What looks very strange is that it tries 5 times. That looks more like a timeout problem than an actual invalid username/password. If you get 'Invalid username/password' from postgres why would you try again??

Erik

Highlighted
MVP & Luminary
MVP & Luminary

I would suggest you log a case with Qlik Support.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
Creator II
Creator II

Hi,

Wich service release was on your Qlik Sense 3.1.x? I have the same problem