Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Loop and Reduce Problem

Hi All,

We are experiencing an issue with Publisher+PDF distribution. Few weeks ago Publisher began behave in unexpected way - during distribution with “Loop and Reduce” stopped to select values from that loop field. In result only one set of data is created where should be as many sets as number of values in loop field. Consequence is that distribution sends all data to all recipients. There are no performance issues, there is no PDF printer problem. There are no errors in tasks.

Support is helpless. Did anyone experienced the same?

Regards,

Monika

Tags (1)
9 Replies
gainkarthi
Valued Contributor

Re: Loop and Reduce Problem

Have you done any changes in the task configuration or file/Task name?

Employee
Employee

Re: Loop and Reduce Problem

Hi Monika,

What are the distribution logs showing, can you attach a log for viewing?

Bill

Bill - Designated Support Engineer at Qlik
If a post helps to resolve your issue, please mark the appropriate replies as CORRECT.
Not applicable

Re: Loop and Reduce Problem

Hi,

No changes was made on tasks or file. After restarting qv services for while everything is ok but after about 24 hours issue apears again. It become to apear on other task on other documents. I had to disable all tasks and now I setup three distributions with different configuration (pdf, qvw) to my email address for testing. So for a while there was only few distributions to AccessPoint and three test task distribuiton to me. So there is no way that amount of distributions had some influence.

Regards,

Monika

Not applicable

Re: Loop and Reduce Problem

Hi Bill,

In distribuiton log you can see clear that when the issue apear publidher doesn't make a selection on a Loop field.

I would attach a log file but I don't know how How can I attach a file here?

Monika

Not applicable

Re: Loop and Reduce Problem

I experienced similiar issue at one of the clients a while back. They were running QV 11 IR if I remember correctly and we upgraded to the SR and the issue was resolved.

Also did you try recreating the task?

Not applicable

Re: Loop and Reduce Problem

The history of the problem is long because first time when it occured it was in 2011 on QV9, two years ago this client, where the problem exists, had some performance issues as well, so they decided to buy new server machine, because support recomended that and support was helpless like today in solving problem.

After setting up new environment everything was ok till now. It occured on QV11 SR2 about a month ago, I upgraded to QV11.2 sr2 and still the same.

Monika

Not applicable

Re: Loop and Reduce Problem

We have had this issue several times both in qv 10 and qv 11SR2.

I noticed that it will always happen if there are files on the accesspoint with the same name but in a different folder. All files on the accesspoint therefore need to have unique file names.

Unfortunately it has also happened to us even though i have made sure no duplicate files exist. To fix that problem i had to create a new accesspoint directory in place of the old one and rename the old one (for backup purposes).

After that the loop and reduce worked once again.

Not applicable

Re: Loop and Reduce Problem

OMG! I will try this asap! If this fix our problems I can't event think how could I repay you for advice!!!

gainkarthi
Valued Contributor

Re: Loop and Reduce Problem

Monika,

Whether this issue is fixed?.

Regards,

Karthi