Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Add Data Wizard Returns Error message "Unable to get property 'id' of undefined or null reference"

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
ToniKautto
Employee
Employee

Add Data Wizard Returns Error message "Unable to get property 'id' of undefined or null reference"

Last Update:

Apr 10, 2021 5:43:55 PM

Updated By:

Sebastian_Linser

Created date:

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. 

Drop the file to load data.png


Drag and Drop fails with the following error:

Unable to get property 'id' of undefined or null reference

an error occured unable to get property.png

 

And the Attach Files option can not bee seen in Add Data wizard's data source selection:

 

select a data source.png

Resolution

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.

  1. Stop all Qlik Sense services on all nodes, except the Qlik Sense Repository Database
  2. Connect to the database as described in How To Connect To And Modify The PostgreSQL Database Used For Qlik Sense Repository
  3. Execute the following SQL query; 
    UPDATE "DataConnections"
    SET "ID" = '47a1cfd8-f70e-4a98-a00d-00fca6c8e253',
    "EngineObjectId"='47a1cfd8-f70e-4a98-a00d-00fca6c8e253'
    WHERE "Name"='AttachedFiles';​
  4. Successful execution is notified by "1 row has been updated" message
  5. Start all Qlik Sense services on all nodes

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';​

 

 

 

 

 

Labels (2)
Version history
Last update:
‎2021-04-10 05:43 PM
Updated by: