Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

data can not be loaded

dear Qlikers

Im working on some application in Qlik sense, i made several connections and loaded multiple data sources easily but suddenly the data load process is no longer working, with no errors but i get couldnt load data at the end of the load, this is happening to the new data and the old data ive already loaded, i tested the connections and they are working .


any idea what is the problem??

appreciate your help


Mina

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Or use the EXIT SCRIPT; command and place after each data source load until you find the offending one.

View solution in original post

6 Replies
ogster1974
Partner - Master II
Partner - Master II

Create a new app and Copy your connections and perform reload one at a time until you hit the step that is causing the error to troubleshoot your issue.

Anonymous
Not applicable
Author

Or use the EXIT SCRIPT; command and place after each data source load until you find the offending one.

rahulpawarb
Specialist III
Specialist III

Hello Mena,

Trust that you are doing well!

I agree with Andy & Gareth! However, You can make use of TRACE statement in your script. Place the TRACE statement in between of different loads and check the reload timings.

Table1:

LOAD Field1,

     Field2

FROM Table1;

TRACE "Table1";

Table2:

LOAD Field1,

     Field3

FROM Table2;

TRACE "Table2";

Hope this will be of help.

Regards!

Rahul

Anonymous
Not applicable
Author

Thank you Andy, i tried that after posting the issue and it worked perfectly.

thanks

Anonymous
Not applicable
Author

Thanks Rahul, i will try that

Reagrds

john9inno
Creator
Creator

alternatively you can use disconnect statement to when ETL of one data source is completed.

So QV won't get mixed up with multiple data source.