Repository upgrade fails during and after Replicate upgrade

[steeefan]

Good day,

I tried upgrading Qlik Replicate (Test) from version 2022.11.0.394 to version 2023.5.0.152. The installer completed and the service "Qlik Replicate Server" is running as expected. Unfortunately, "Qlik Replicate UI Server" is no longer working. In the repuictl.log file I found this message:

[START:  2023-07-10 07:33:47 Qlik Replicate Version: 2023.5.0.152]
 4 2023-07-10 07:33:47 [Host           ] [INFO ] Setting up web host
 4 2023-07-10 07:33:47 [Repository     ] [ERROR] Repository 'Global' is out of date
 4 2023-07-10 07:33:47 [Host           ] [ERROR] REPO-E-REPOOOD, Repository 'Global' or one of its ingredients are out of date, please run the following command to upgrade the repository: RepUiCtl.exe repository upgrade --repository <repository_full_path>
 4 2023-07-10 07:33:47 [Host           ] [INFO ] Stopping service on error...
 6 2023-07-10 07:33:48 [Host           ] [INFO ] Stopped web host
 1 2023-07-10 07:33:48 [Command        ] [INFO ] Replicate Control Program completed successfully.
[END:  2023-07-10 07:33:48]

I then referred to this post and executed the suggested command in "Qlik Replicate Command Line" as admin:

RepUiCtl.exe repository upgrade --repository "D:\Program Files\Attunity\Replicate\data\GlobalRepo.sqlite"

It did not work. This is the result:

Executing UpgradeRepositoryCommand command.
Upgrade operation failed (reason: Object reference not set to an instance of an object.)
Command UpgradeRepositoryCommand failed.
Object reference not set to an instance of an object.

Any suggestions?

[Arun_Arasu · Accepted solution]

Hi @steeefan ,

Thank you for reaching out to the Qlik community.

The issue lies with the Globalrepo.sqlite file, as it did not update correctly.

To resolve this, please follow the steps below:

1. Using DB Browser for SQLite (a free application), open the Globalrepo.sqlite file located in the ~\replicate\data folder.
2.  On the tab 'Browse Data' / Table : Versions
3. Look for the entry "AppHostConfiguration" and change its value to 2.
4. After making the change, click on "Write Changes" in the DB Browser for SQLite application.
5. Now, try running the "repuictl update" command again.

The updated command should be as follows:

repuictl repository upgrade --repository "d:\Program Files\Attunity\Replicate\data\GlobalRepo.sqlite"

Please let me know if you have any further questions or need additional assistance.

Best regards, 

Arun

[steeefan]

Hi @Arun_Arasu,

That was apparently exactly what I was looking for: Changing the value of the key "AppHostConfiguration" to 2 did the trick:

RepUiCtl.exe repository upgrade --repository "D:\Program Files\Attunity\Replicate\data\GlobalRepo.sqlite"
Executing UpgradeRepositoryCommand command.
Repository "GlobalRepo.sqlite" has been successfully upgraded.
Replicate Control Program completed successfully.

"Qlik Replicate UI Server" is back in service:

[START:  2023-07-10 08:27:21 Qlik Replicate Version: 2023.5.0.152]
 1 2023-07-10 08:27:21 [Command        ] [INFO ] Executing ServiceRunCommand command.
 4 2023-07-10 08:27:21 [Host           ] [INFO ] Setting up web host
 4 2023-07-10 08:27:22 [Host           ] [INFO ] The server will listen on the following location: http://.../attunityreplicate
 4 2023-07-10 08:27:22 [Host           ] [INFO ] The server will listen on the following location: https://.../attunityreplicate
 4 2023-07-10 08:27:22 [Host           ] [INFO ] Starting web host
 4 2023-07-10 08:27:22 [Host           ] [INFO ] Web host started

Thank you very much for your swift, concise and correct reply!

Take care
-Stefan

[Steve_Nguyen]

NOTES: if your data folder is in another location, best to run with the -d "datafolder"

example : if your Replicate programs is on C:\attunity\replicate\bin , and data folder is d:\attunity\data

~\replicate\bin>RepUiCtl.exe -d "d:\attunity\data" repository upgrade --repository "d:\attunity\data\GlobalRepo.sqlit