topic Re: Strange issue with Reload Data- Need suggestion in QlikView

Strange issue with Reload Data- Need suggestion

sridhar_sigired — Wed, 18 Nov 2015 14:17:45 GMT

Hello Experts,

We have found an issue with deployed application. Issue is something like this.

End user find out the final figures (near to/) doubles than original for some metrics when we are doing refresh at multiple times in a day.

When we schedule once in a day, figures are matching with DB figures, however when we are refreshing multiple times this issue is there but not every time, once in a week or two weeks.

Incremental code is OK as of now... what might be the reason for this strange behavior.

Any suggestions pls?

Re: Strange issue with Reload Data- Need suggestion

Colin-Albert — Wed, 18 Nov 2015 14:22:34 GMT

Is your reload concatenating the same data twice?

Are you joining any tables? If so does your join match two rows so the values are included twice? ApplyMap will avoid this rather than joining tables.

Re: Strange issue with Reload Data- Need suggestion

sridhar_sigired — Wed, 18 Nov 2015 14:30:07 GMT

In that case, it should be multiplied how many times i reload those many times. But here it is not happening every time and even i run it 10 times in a day, it is showing double result.

However your point is valid. I will check it also. Thank you.

Re: Strange issue with Reload Data- Need suggestion

sridhar_sigired — Wed, 18 Nov 2015 15:44:43 GMT

Can anybody give more suggestions pls?

Re: Strange issue with Reload Data- Need suggestion

Colin-Albert — Wed, 18 Nov 2015 16:03:33 GMT

Can you post your load script?

Re: Strange issue with Reload Data- Need suggestion

rwunderlich — Wed, 18 Nov 2015 16:29:16 GMT

Create a TableBox with $Table and $Rows. Check for row count differences when you see the doubles when you do not.

-Rob

Re: Strange issue with Reload Data- Need suggestion

Mark_Little — Wed, 18 Nov 2015 16:53:55 GMT

Hi,

Just thinking, have you looked at the source system? Could it be the way that system posts information in the data, moving between draft, Posting, Posted?

Think like suggested, pin down what is duplicated and on which tables and then you can focus more where to trouble shoot.

Mark

Re: Strange issue with Reload Data- Need suggestion

sridhar_sigired — Thu, 19 Nov 2015 04:18:17 GMT

Sure Colin, i will try to figure out the issue today. If i cannot i will take your help. Thanks.

Re: Strange issue with Reload Data- Need suggestion

avinashelite — Thu, 19 Nov 2015 05:08:45 GMT

Hi Sridhar,

Add a column with the reload time stamp and check at each reload how much data is getting added to the dashboard. With the time column you can compare the DB data and your script this would give a better way to analyze the issue

Re: Strange issue with Reload Data- Need suggestion

sridhar_sigired — Mon, 23 Nov 2015 04:44:04 GMT

Hi Coil,

We are unable to figure out the issue. Can you help me on this?

Which one you need? is that script related to generator? or mail application?

I believe, you need the script of incremental load generator? Right?