Qlik Replicate UI service fails to start after upgrade

[Steve_Nguyen]

Qlik Replicate was upgraded to 2022.11. The Qlik Replicate UI service fails to start post-upgrade. 

Environment

Qlik Replicate version 2022.11 

Resolution

Review the repuictl.log stored in ~\replicate\data\logs and look for the following message:

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>

After verifying the error:

1. Open a command prompt as Administrator
2. Change directory to ~\replicate\data\bin
3. From bin run: 
   
   RepUiCtl.exe repository upgrade --repository "d:\Program Files\Attunity\Replicate\data\GlobalRepo.sqlite"
   
   In our example, our install folder is on D:\. Modify this accordingly. 
   
   
4. You will receive a confirmation:
   
   Repository "GlobalRepo.sqlite" has been successfully upgraded.
   Replicate Control Program completed successfully.
   
   
5. Start the Qlik Replicate UI Server Service.

If your data folder is in a custom location, run the command with the -d "datafolder" addition.

An example with Qlik Replicate installed in C:\attunity\replicate\bin and the data folder in d:\attunity\data:

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

Cause

the "GlobalRepo.sqlite" file did not get update during the upgrade process.

[vinci_wu]

Hi @Steve_Nguyen ,

QEM 2023.05 encounter same issue. QEM 2023.05 was running for some weeks. We use "aemctl.exe configuration show" to show configuration to security team, it failed "Executing ShowHostConfigurationCommand command.
Operation failed (reason: REPO-E-REPOOOD, Repository 'cfgrepo' or one of its ingredients are out of date, please run the following command to upgrade the repository: aemctl.exe repository upgrade --repository <repository_full_path>)".

Then we upgrade cfgrepo.

C:\Program Files\Attunity\Enterprise Manager\bin>aemctl.exe repository upgrade --repository "D:\Attunity\Data\cfgrepo.sqlite"
Executing UpgradeRepositoryCommand command.
Repository "cfgrepo.sqlite" has been successfully upgraded.
EnterpriseManager Control Program completed successfully.

aemctl.exe configuration show still failed. 

C:\Program Files\Attunity\Enterprise Manager\bin>aemctl.exe repository upgrade --repository "D:\Attunity\Data\cfgrepo.sqlite"
Executing UpgradeRepositoryCommand command.
Repository "cfgrepo.sqlite" has been successfully upgraded.
EnterpriseManager Control Program completed successfully.

[vinci_wu]

Sorry for input wrong  detail.

C:\Program Files\Attunity\Enterprise Manager\bin>aemctl.exe repository upgrade --repository "D:\Attunity\Data\cfgrepo.sqlite"
Executing UpgradeRepositoryCommand command.
Repository "cfgrepo.sqlite" has been successfully upgraded.
EnterpriseManager Control Program completed successfully.

C:\Program Files\Attunity\Enterprise Manager\bin>aemctl.exe configuration show
Executing ShowHostConfigurationCommand command.
Operation failed (reason: REPO-E-REPOOOD, Repository 'cfgrepo' or one of its ingredients are out of date, please run the following command to upgrade the repository: aemctl.exe repository upgrade --repository <repository_full_path>)
Command ShowHostConfigurationCommand failed.
REPO-E-REPOOOD, Repository 'cfgrepo' or one of its ingredients are out of date, please run the following command to upgrade the repository: aemctl.exe repository upgrade --repository <repository_full_path>

[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