Unable to start Qlik Replicate UI Server

[desmondchew]

We were on Qlik November 2022 version and it has been causing a lot of tasks failure. I attempted to revert to previous order version May 2022. I followed the guide to revert to previous version.

Reverting to a previous version

To revert to a previous version:

1. Back up the Replicate data directory to a location outside the product folder.
2. Uninstall the product and then reinstall to the same directory.
3. Once the installation is complete, stop all Replicate services.
4. Overwrite the data directory with the data directory that you backed up earlier.
5. Start all Replicate services.

Attunity server service was able to start. But we can't start the Qlik Server UI. It show failed to start.

The Qlik replicate server is running Windows server 2019. Are there any logs that we can see what's going?

[john_wang]

Hello @desmondchew ,

There are some files may show us some clue:

1. DATA/Logs file "repsrv.log"

2. DATA/Logs file "repuictl.log"

3. Windows Even viewer

Hope this helps.

Regards,

John.

[desmondchew]

We got this error.

[START: 2022-11-14 21:35:20 Attunity Replicate Version: 2021.5.0.1272]
5 2022-11-14 21:35:21 [Host ] [INFO ] Setting up web host
5 2022-11-14 21:35:21 [Repository ] [ERROR] Repository 'Global' is out of date
5 2022-11-14 21:35:21 [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>
5 2022-11-14 21:35:21 [Host ] [INFO ] Stopping service on error...
7 2022-11-14 21:35:21 [Host ] [INFO ] Stopped web host
1 2022-11-14 21:35:21 [Command ] [INFO ] Replicate Control Program completed successfully.
[END: 2022-11-14 21:35:21]

How to solve it?

[john_wang]

Hello @desmondchew ,

Looks like your environment is like:
1- you were running 2022.5

2- you upgraded to 2022.11 and hit issues, so

3- you rollback to 2021.5

Now you got new issue because you are not rollback to 2022.5 but to 2021.5. Can you please confirm if you are on the correct path?

Thank you,

John.

[desmondchew]

Hi John,

Our production has been running fine with 2021.5 but because our TEST is on 2022.5. We need to synchronize both environments. We noticed that you just released 2022.11. So we upgraded both environments to 2022.11.

Now the prod which was originally 2021.5 become 2022.11 and started to fail for some of its tasks. I reverted to 2021.5 as this has been the version production running on. 

I found out that the reason why I couldn't start the Qlik UI service was after I copy the "data" folder overwriting it. So it looks like version 2022.11 has something done on the "data" folder. I know this version 2022.11 remove Attunity server service and it park under Qlik replicate service now.

Anyway the error I got I have shared earlier.

5 2022-11-14 21:35:21 [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>

Thanks
Desmond

[john_wang]

Hello @desmondchew ,

Thanks for the detailed info.

It's the best practice to do acceptance test on UAT/DEV/TEST lower environment prior to implement to PROD system so far avoid urgent blocker issues in PROD systems.

Let's start from the current position: can you run below steps:

1. run "Qlik Replicate command line" prompt as Administrator

2. execute the above command on the SQLite files to upgrade the repository, sample command eg:

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

Let me know if it solves the issue.

(BTW, please keep an original copy of the DATA folder for backup)

Regards,

John.

[desmondchew]

Hi John,

Strangely TEST is running fine with Nov 2022. It was upgraded from May 2022 version though.

Prod was an upgrade from May 2021 --> Nov 2022 that failed.

Anyway, I can't run No2 now as we have gone past that stage. We restore our server.

I'd suggest we have more details in the upgrade and downgrade Qlik repository link.

Will keep command handy.

Thank you.
Desmond

[john_wang · Accepted solution]

Hello @desmondchew ,

To make things clear, the upgrade paths is that: Replicate support direct upgrade for two major versions. they are

Replicate 2021.11 --> 2022.11

Replicate 2022.5 --> 2022.11

For your scenario, you need 2 steps upgrade, it's

Replicate 2021.5 --> 2021.11 --> 2022.11

More detailed information can be found in 2022.11 Release Notes .

Regards,

John.

[desmondchew]

Looks like we need to upgrade Nov 2021 before hoping to Nov 2022. That explains. 

Thank you for help.

Desmond