topic Re: Re: Need Help in QlikView

Need Help

Fri, 05 Sep 2014 05:22:04 GMT

I have one data model which take more than 21 hr to reload ,day before yesterday i divide that app into two parts and schedule the divided first part at server

But today show me confusing result

At QMC it show that job failed if check the log at QMC it also shows that execution failed,if if i checked the log file present in the main folder at my system, it display that the execution is finished ,but a synthetic is created even after exit script

I am confused now ,whether i have reload the first part or 2nd part? or whether the first part is successful or not

see the snapshots

Re: Need Help

tresB — Fri, 05 Sep 2014 05:39:10 GMT

21 hours reload time! very unusual. Probably there would a scope of fine-tuning. But yes, if the data is that big, not impossible. Coming back to your issue, your screen shot doesn't properly show the entire error message. Try to share specially the error portion of the log.

Re: Re: Need Help

Fri, 05 Sep 2014 05:41:53 GMT

Re: Need Help

tresB — Fri, 05 Sep 2014 05:53:07 GMT

I would assume that your data size is very big. And when a synthetic key is generated with big data, it matters. Your synthetic key '$Syn 1 = Source QVD Flag+Terminal' could be the culprit. Try to remove that and reload.

Re: Re: Need Help

Fri, 05 Sep 2014 05:59:09 GMT

Actually i break the code of it the removal of synthetic code present in 2nd part of application,

if i checked the reload time in part 1 it show that app has been removed

see the snapshot

If i now reload the part2 directly i removed the synthetic key .What to do now,reload the part1 or part2

Re: Need Help

tresB — Fri, 05 Sep 2014 06:06:11 GMT

Could not really get your point. Can't view your snapshot as well.

Re: Re: Need Help

Fri, 05 Sep 2014 06:10:05 GMT

i want 2 know ,if reload the part2 then i removed the synthetic key,as it show that the job is failed at QMC but in log file it show the execution finished with synthetic key,now instead of reloading again part1,if i reload part2,whether the change display in app means whether records fetched from part1 are stored in data model or not

Re: Need Help

tresB — Fri, 05 Sep 2014 06:22:24 GMT

In a text box =ReloadTime() , this will give you which version(time) of reload data is available in your app.

If you are worried about data which is saved in qvw, reloadTime() would give you the answer and there you dont have to be confused with Publisher error: 'Could not close the SourceDocument..', that is somthing else(possibly something trivial with the source document qvw in the publisher).

Re: Re: Need Help

Fri, 05 Sep 2014 06:25:25 GMT

what to do now

Re: Re: Need Help

Fri, 05 Sep 2014 06:27:00 GMT

what to do now

Re: Need Help

Fri, 05 Sep 2014 06:37:34 GMT

what should i do reload part1 or 2

Re: Need Help

tresB — Fri, 05 Sep 2014 06:41:21 GMT

Not sure how you broke the apps. Otherwise, I would go with part2.

Re: Need Help

preminqlik — Fri, 05 Sep 2014 06:41:50 GMT

you have to do one thing

in each and every application write in starting of the script like below

Let starttime = now();//starting of the script;

---------------------------------

------------------

-----------

let endtime=now();//end of the scrpt

or else make table like below

START_TIME:

Load now() as Starttime,
DocumentName() as Documentname,
DocumentPath() as DocumentPath
AutoGenerate 1;

And at the end of the application script

START_TIME:

Load now() as EndTime,
DocumentName() as Documentname,
DocumentPath() as DocumentPath
AutoGenerate 1;

Use as per your convenient way like store it as qvds or csv and track it acoording to your document name by creating another application o with above two tables or filter in excel.

Hope this helps you DAIL

Re: Need Help

Fri, 05 Sep 2014 06:56:17 GMT

thats not the answer of my quz

Re: Need Help

Fri, 05 Sep 2014 06:57:55 GMT

thanx tresesco, one more thing reload is the proff that data has been saved into my app ? Is It?

Re: Need Help

tresB — Fri, 05 Sep 2014 07:15:44 GMT

In the server environment this is deafult feature. If you check the log, be able to see once the application is loaded, then it saves it as the next step of task.

Re: Need Help

Fri, 05 Sep 2014 07:22:07 GMT

means

Re: Need Help

Tue, 09 Sep 2014 08:04:33 GMT

today reloading the app ,it show a confusing result that sales ,penetration data terminal T1 is showing 12 lakhs but should be 38,00000

Is that happens because i reload that part2 app instead of reloading part1 again