Troubleshooting Qlik DataTransfer
This section describes problems that can occur when using Qlik DataTransfer.
Qlik DataTransfer opens to a white screen
I open Qlik DataTransfer, but it only displays a white screen. If I check Services in Windows, Qlik DataTransfer is shown as running.
Possible cause
There may be one or more of the following issues.
-
The client certificate is not available from C:\ProgramData\Qlik\DataTransfer\DataUpload\certificate
-
The server certificate is not available from C:\ProgramData\Qlik\DataTransfer\DataUpload\certificate
-
Certificates are invalid.
-
Certificate chain is invalid.
-
Certificates are not present in the Windows Certificate Store.
Proposed action
If only Qlik DataTransfer is installed on the machine, do the following:
-
In Windows Services, stop the Qlik DataTransfer service.
- Navigate to C:\ProgramData\Qlik\DataTransfer\DataUpload\certificate and delete the certificates there.
-
Navigate to C:\Program Files\Qlik\DataTransfer\DataUploadService\install-utils.
-
Run Remove-Certificate.ps1 in PowerShell.
-
Start the Qlik DataTransfer service.
-
Navigate to C:\ProgramData\Qlik\DataTransfer\DataUpload\certificate and confirm the following files are present:
-
client.pfx
-
server.pfx
-
If Qlik DataTransfer and Qlik Sense Enterprise on Windows are installed on the machine, do the following:
-
In Windows, Services, stop the Qlik DataTransfer service.
- Navigate to C:\ProgramData\Qlik\DataTransfer\DataUpload\certificate and delete the certificates in the folder.
-
In the Windows Certificate Store, delete the following certificates:
-
Local Computer > Personal > QdtClient
-
Local Computer > Trusted Root Certification Authority > <hostname.domain> or <hostname>
-
Current user > Personal > QdtClient
Alternatively, you can run Remove-Certificate.ps1 in PowerShell as the administrator.
-
-
Run Configure-Service.ps1 in PowerShell as the Qlik Sense services user.
-
For the first input dataTransferCertificatePath, enter C:\ProgramData\Qlik\DataTransfer\DataUpload\certificate.
-
For the second input qsefwPresent, enter Yes.
-
-
Navigate to C:\ProgramData\Qlik\DataTransfer\DataUpload\certificate and confirm the following files are present:
-
root.pfx
-
client.pfx
-
server.pfx
-
-
Restart the Qlik DataTransfer service.
Qlik DataTransfer opens to a white screen and https://localhost:5505/ shows the error err_ssl_version_or_cipher_mismatch
I open Qlik DataTransfer, but it only displays a white screen. If I check Services in Windows, Qlik DataTransfer is shown as running. If I go to https://localhost:5505/ in a browser, I get the error err_ssl_version_or_cipher_mismatch.
Possible cause
The TLS cipher suite on your server is not supported by Qlik DataTransfer.
Proposed action
Add the TLS cipher suite in the server group policy by following the steps in the following support article: Disabling Weak Cipher suites for TLS 1.2 in Qlik Sense Application.
Qlik DataTransfer is not running and the log shows there was an error executing a PowerShell script command
Qlik DataTransfer is not running. The log shows the following error message:
Error while executing powershell script command,Command failed: & "C:\Program
Files\Qlik\DataTransfer\DataUploadService\install-utils\Remove-Certificate.ps1"
& : File C:\Program Files\Qlik\DataTransfer\DataUploadService\install-utils\Remove-Certificate.ps1 cannot be loaded
because running scripts is disabled on this system. For more information, see about_Execution_Policies at
https:/go.microsoft.com/fwlink/?LinkID=135170.
At line:1 char:3
+ & "C:\Program Files\Qlik\DataTransfer\DataUploadService\install-utils ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : SecurityError: (:) [], PSSecurityException
+ FullyQualifiedErrorId : UnauthorizedAccess"
Possible cause
ExecutionPolicy is disabled or restricted for that user.
Proposed action
Enable or give permissions to execute PowerShell script by giving the user the RemoteSigned execution policy. You can do this from PowerShell in administrator mode by running PS C:\> Set-ExecutionPolicy RemoteSigned in PowerShell and selecting Y. You can contact your system administrator to do the same.
I am experiencing high CPU usage from Qlik DataTransfer
Qlik DataTransfer is using a high amount of CPU.
Possible cause
There may be a shared folder configured as a data folder, Qlik DataTransfer may be polling on the folder, which uses more CPU.
Proposed action
Do one of the following:
-
To stop polling, navigate to the services.conf file, located in %Program Files%\Qlik\DataTransfer. Open the file and remove --usePolling. This will discontinue watching a shared folder after the service is restarted.
-
To poll at a greater interval, you can change the default polling interval from 100 milliseconds to a greater value, such as 3000 milliseconds. Navigate to the services.conf file, located in %Program Files%\Qlik\DataTransfer. Open the file and add --pollingInterval after --usePolling. Set the polling interval in milliseconds, for example --pollingInterval 3000.
Qlik DataTransfer shows a blank page when installed on secondary nodes of Qlik Sense Enterprise on Windows cluster
Qlik DataTransfer has a blank page. Qlik Sense certificates are not exportable in a developer node.
Possible cause
Qlik DataTransfer was not installed on the central node.
Proposed action
Follow these step:
-
Perform the regular installation steps.
-
In Windows Services, stop the Qlik DataTransfer service.
-
Navigate to C:\ProgramData\Qlik\DataTransfer\DataUpload\certificate and delete the certificates in the folder.
-
In the Windows Certificate Store, delete the following certificates, if available:
-
Local Computer > Personal > QdtClient
-
Local Computer > Trusted Root Certification Authority > <hostname.domain> or <hostname>
-
Current User > Personal > QdtClient
-
-
Navigate to C:\Program Files\Qlik\DataTransfer\DataUploadService\install-utils.
-
Copy Configure-Service.ps1.
-
Log in to central node using Qlik Sense Enterprise on Windows service user account.
-
Paste this file to central node at any location.
-
Run Configure-Service.ps1 in PowerShell as the Qlik Sense services user.
-
For the first input dataTransferCertificatePath, enter any folder location on the machine. This will export certificates to this location.
-
For the second input qsefwPresent, enter Yes.
-
Navigate to location where certificates are exported and confirm the following files are present:
-
root.pfx
-
client.pfx
-
server.pfx
-
-
Copy all three certificates.
-
Go to the Qlik DataTransfer installed machine.
-
Navigate to C:\ProgramData\Qlik\DataTransfer\DataUpload\certificate and paste all certificates.
-
Restart the Qlik DataTransfer service.
Alternatively, you can run Remove-Certificate.ps1 (C:\Program Files\Qlik\DataTransfer\DataUploadService\install-utils) in PowerShell as the administrator.