When installing Qlik Sense using a custom database user, the installation might fail at Creating schema 'precedents_service' as below.
CAQuietExec: Creating schema 'precedents_service'.
CAQuietExec: Error executing database command "SELECT 1 FROM information_schema.schemata WHE
CAQuietExec: RE schema_name = 'precedents_service'": psql: fe_sendauth: no password supplied
CAQuietExec: 発生場所 C:\Program Files\Qlik\Sense\PrecedentsService\install\install-utils\Po
CAQuietExec: stgres.ps1:104 文字:9
CAQuietExec: + throw "Error executing database command "" ...
CAQuietExec: + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
CAQuietExec: + CategoryInfo : OperationStopped: (:) , Exception
CAQuietExec: + FullyQualifiedErrorId : Error executing database command "SELECT 1 FROM
CAQuietExec: information_schema.schemata WHERE schema_name = 'precedents_service'": psq
CAQuietExec: l: fe_sendauth: no password supplied
CAQuietExec:
CAQuietExec: Error 0x80070001: Command line returned an error.
CAQuietExec: Error 0x80070001: QuietExec Failed
CAQuietExec: Error 0x80070001: Failed in ExecCommon method
CustomAction CA_SetupPS returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
Environment
Resolution
Use the default database user "qliksenserepository" during the setting of Shared persistence database connection settings.
Cause:
Using a custom username