Skip to main content
Announcements
Marching toward a simplified navigation! READ ON

Document fails to reload with Error: Cannot open file: 'https://localhost:4780/QMS/AuthTable' while Management is configured to use SSL

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Jill_Masinde
Support
Support

Document fails to reload with Error: Cannot open file: 'https://localhost:4780/QMS/AuthTable' while Management is configured to use SSL

Last Update:

Jul 10, 2023 8:47:54 AM

Updated By:

Sonja_Bauernfeind

Created date:

Jul 10, 2023 8:47:54 AM

Following an otherwise successful setup of a third-party certificate (such as DigiCert) to be used with the QlikView Management Console, documents using a Section Access script defined in the Management Console will fail to reload with the following error in the document log:

Error: Cannot open file: 'https://localhost:4780/QMS/AuthTable'

Browsing to the URL named in the error functions as expected and the Auth table is displayed. The Service Account has access to and is included in the Section Access table.

Resolution

Disable loopback on the QlikView server and modify the Section Access Script by adding the domain name. Disabling loopback requires the Windows Registry to be edited. 

Windows Registry changes should at no point be carried out without first taking a backup and consulting with your local IT administrator.

Changes can be made either directly in the registry, or by deploying a PowerShell command. The change requires us to add a key in System\CurrentControlSet\Control\Lsa named DisableLoopbackCheck with a value of 1.

  1. Open PowerShell as administrator
  2. Execute the following: 

    New-ItemProperty HKLM:\System\CurrentControlSet\Control\Lsa -Name "DisableLoopbackCheck" -Value "1" -PropertyType dword
  3. Open the Section Access Script used and modify it by adding the domain name of the server (including the port). 

    Example:

    section access script.png

 

Environment:

QlikView 

Labels (1)
Version history
Last update:
‎2023-07-10 08:47 AM
Updated by: