Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Jan 30, 2023 2:15:27 AM
Oct 6, 2016 4:26:46 PM
The Repository service does not start after patch removal or repair installation.
The Windows Application Event logs record the following:
Log Name: Application
Source: PostgreSQL
EventID:0
Level: Error:
User: N/A
General:
...
FATAL: password authentication failed for the user "postgres"
DETAIL: Password does not match for user "postgres".
Connection matched pg_hba.conf line 80: "host all all 127.0.0.1/32 md5"
The Repository > Trace > System Repository logs the following:
Fatal exception password authentication failed for user "postgres"??The provider did not return a ProviderManifestToken string.??An error occurred accessing the database. This usually means that the connection to the database failed. Check that the connection string is correct and that the appropriate DbContext constructor is being used to specify it or find it in the application's config file
or
ERROR SERVERNAME System.Repository.Repository.Repository.QRSMain 6 <ID> domain\user Fatal exception during startup Waiting for database timed out after 0 seconds
The repository configuration file (C:\Program Files\Qlik\Sense\Repository\Repository.exe.config) has been modified and is no longer passing the correct credentials.
<connectionStrings>
<add name="QSR" connectionString="User ID=postgres;Host=localhost;Port=4432;Database=QSR;Pooling=true;Min Pool Size=0;Max Pool Size=90;Connection Lifetime=3600;Unicode=true;Password='ENTERYOURSUPERUSERPASSWORDHERE';" providerName="Devart.Data.PostgreSql" />
</connectionStrings>
Qlik Sense Enterprise on Windows