Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

Getting an load error

Hi All,

Please assist.

I am getting a load error.

The load script is below -

IF vLoadInsurers=1 THEN
TRACE Loading insurers from database;

[DWQMV_INSURER]:
LOAD "INSURER_KEY",
"INSURER_NAME";
SQL SELECT "INSURER_KEY",
"INSURER_NAME"
FROM DWQMV_INSURER;

TRACE Storing insurers into file;

STORE [DWQMV_INSURER] INTO 'lib://QlikData/Model_Insurers.qvd' (qvd);

ELSEIF vMapInsurers=1 THEN

TRACE Loading insurers file;

[DWQMV_INSURER]:
LOAD * FROM 'lib://QlikData/Model_Insurers.qvd' (qvd);

ENDIF

 

 

Error.PNG

 

2 Replies
thkarner
Partner - Creator III
Partner - Creator III

Hi,

a) go to the Data Load Editor and check if you see the data connection "QlikData" on the right side
If not, you should need to create the connection or get access to it. Seems that you need to contact your Qlik Sense admin in this case

b) If you can find the connection , click on the first button below and check if you can browse the file "Model_Insurers.qvd".

If not, the error is because the file is not existing. Reason could be, that there another app (script) needs to run before, to create this file.

 

BR Thomas

 

 

 

Channa
Specialist III
Specialist III

ur path is not correct just create LIB path till QlikDate and select ur QVD

it should be like below

FROM [lib://QVD/FACT_DECLARATION.qvd]

 

Channa