The Qlik Sense Repository service fails to start.
When investigating further, no logs are generated in the logs folder, but in Windows Event Viewer a pair of events can be found in the Applications section.
These errors look somewhat like the following:
Application Error:
Faulting application name: Repository.exe, version: 12.22.6.0, time stamp: 0x59099c47
Faulting module name: KERNELBASE.dll, version: 6.3.9600.18666, time stamp: 0x58f33794
Exception code: 0xe0434352
Fault offset: 0x00000000000095fc
Faulting process id: 0x10ac
Faulting application start time: 0x01d342abc0456c53
Faulting application path: C:\Program Files\Qlik\Sense\Repository\Repository.exe
Faulting module path: C:\windows\system32\KERNELBASE.dll
Report Id: 088425f8-ae9f-11e7-80c7-005056825589
Faulting package full name:
Faulting package-relative application ID: .
NET runtime Error:
Application: Repository.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: Autofac.Core.DependencyResolution
Exception Stack: at Autofac.Core.Resolving.ResolveOperation.Execute(Autofac.Core.IComponentRegistration, System.Collections.Generic.IEnumerable`1) at Autofac.ResolutionExtensions.ResolveService(Autofac.IComponentContext, Autofac.Core.Service, System.Collections.Generic.IEnumerable`1) at Autofac.ResolutionExtensions.Resolve[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]](Autofac.IComponentContext, System.Collections.Generic.IEnumerable`1) at Repository.QRSService.Main(System.String[])
Environment:
Qlik Sense Enterprise on Windows
, all versions
Cause:
These errors are generated when the connection string found in the repository.exe.config file located in the Qlik Sense install folder\Repository\ has a bad, encrypted connection string.
The most common cause of this is a config file copied from another computer as the connection string is encrypted by the windows operating system itself using the machine ID and cannot be decrypted if located on another computer.
Resolution:
Fortunately this is relatively simple to fix, either restore the old repository.exe.config from a backup, or recreate the connection string using the connection string editor.
This is located in the utils folder normally located in the Qlik Sense Installation folder \Repository\Util
Open the editor as an administrator and then paste in the following connection string making the appropriate changes for your environment
<connectionStrings>
<add name="QSR" connectionString="User ID=qliksenserepository;Host='DATABASEHOST';Port='DATABASEPORT(default-4432)';Database=QSR;Pooling=true;Min Pool Size=0;Max Pool Size=90;Connection Lifetime=3600;Unicode=true;Password='QLIKSENSEUSERPASSWORD';" providerName="Devart.Data.PostgreSql" />
<add name="postgres" connectionString="User ID=postgres;Host=DATABASEHOST;Port=DATABASEPORT(default-4432);Database=postgres;Pooling=true;Min Pool Size=0;Max Pool Size=90;Connection Lifetime=3600;Unicode=true;" providerName="Devart.Data.PostgreSql" />
</connectionStrings>
Then click Save
Finally start up your Qlik Sense Server
