Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Apr 10, 2021 5:43:55 PM
Jan 5, 2017 6:32:11 PM
When dragging and dropping a data file in the Add Data wizard of Qlik Sense Enterprise does not start the data selection wizard as expected.
Drag and Drop fails with the following error:
Unable to get property 'id' of undefined or null reference
And the Attach Files option can not bee seen in Add Data wizard's data source selection:
The issue is caused by the Attached Files data connection ID being incorrect in the Qlik Sense database repository. This can be corrected by manually altering the data connection ID as described below.
IMPORTANT: Manual modification to Qlik Sense Repository database must only be done when recommended by Qlik Support.
PREREQUISITE: Make sure to have backup that allows restoring the environment if the manual database modification fails or if you accidentally change something in the database.
UPDATE "DataConnections"
SET "ID" = '47a1cfd8-f70e-4a98-a00d-00fca6c8e253',
"EngineObjectId"='47a1cfd8-f70e-4a98-a00d-00fca6c8e253'
WHERE "Name"='AttachedFiles';
In additon to the steps above it might be that another value need to be adjusted e.g. username or password. See the table below for a standard entry right after a fresh Qlik Sense installation.
Query: SELECT * FROM public."DataConnections" WHERE "Name"='AttachedFiles';
ID | Name | Connectionstring | Type | EngineObjectId | Username | PasswordString | CreatedDate | ModifiedDate | ModifiedByUserName | Owner_ID | Architecture | LogOn |
47a1cfd8-f70e-4a98-a00d-00fca6c8e253 | AttachedFiles | \\servername\share\StaticContent\AppContent\<APP_ID> | folder | 47a1cfd8-f70e-4a98-a00d-00fca6c8e253 | NULL | 2020-12-18 20:49:55.453265 | 2020-12-18 20:49:55.453265 | INTERNAL\sa_repository | ca9c1f30-d400-42d3-8045-d31fd3dc9adb | 0 | 0 |
As in step 3. run the query with additonal parameters:
UPDATE "DataConnections"
SET "ID" = '47a1cfd8-f70e-4a98-a00d-00fca6c8e253',
"EngineObjectId"='47a1cfd8-f70e-4a98-a00d-00fca6c8e253',
"PasswordString"=''
WHERE "Name"='AttachedFiles';