Problem uploading files to the sense hub "cannot read property id of undefined"
Article Number: 000058627 | Last Modified: 2018/11/22
Drag and Drop a file into the app. Cannot read property ‘id’ of undefined, as shown below. After the error occurs, insight advisor does not launch.
Qlik Sense September 2018
One-off issue, Problem: file storage location for upload is pointing to \\hostname\qlikshare\StaticContent\AppContent\ ... was not accessible.
One-off issue, Problem will not be fixed.QLIK-91446
Manually enter the data by going into the data load editor and selecting the file from the AttachedFiles data connection
Here are the steps to update the AttachedFiles connection ID.
1. Shutdown services on all Nodes
2. Run an SQL Script on all nodes to update the Database. (details below)
3. Restart all services
I’ve attached a video to show how I’ve updated the database using pgAdmin4.exe which should be located in "C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6\bin” on the servers.
Add a connection to the server if you don’t have one already
Connect to the server.
Click on ‘QSR’
Click the ‘SQL’ Icon that is now enabled in the Toolbar of pgAdmin4
Paste this script into the editor:
set "ID" = '4xxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxx',
This should succeed and notify you that 1 row has been updated.
Once this has been done on all the nodes, you can restart the services.
! Information provided on this defect is given as is at the time of documenting. For up to date information, please review the most recent Release Notes, or contact support at support.qlik.com with the QLIK-91446 for reference.