Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
menaaaak
Contributor II
Contributor II

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
gareth_wilson12
Partner
Partner

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
Master II
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.

gareth_wilson12
Partner
Partner

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

View solution in original post

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

menaaaak
Contributor II
Contributor II
Author

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

thanks

menaaaak
Contributor II
Contributor II
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.