topic Re: QMC Reduce Issue in QlikView

QMC Reduce Issue

tmumaw — Fri, 13 Jun 2014 17:33:22 GMT

Hi All,

I am trying to do a loop and reduce on a QVW. When I click on the Reduce tab, then the Open Document is churns away for awhile, but nothing gets displayed in the Fields or Values columns. I have tried deleting all files associated with the QVW and even deleting and recreating the QVW. Any ideas?

Thanks

Thom

Re: QMC Reduce Issue

ashfaq_haseeb — Sun, 15 Jun 2014 10:27:53 GMT

Hi,

Can you tell what version of QlikView you are on?

You have to hit on open document to display all fields available in your document.

Regards

ASHFAQ

Re: QMC Reduce Issue

tmumaw — Mon, 16 Jun 2014 11:23:40 GMT

11.2.SR5

Re: QMC Reduce Issue

ashfaq_haseeb — Mon, 16 Jun 2014 11:27:27 GMT

Hi,

Did you try by clicking open document button.

Did it displayed all the fields?

Regards

ASHFAQ

Re: QMC Reduce Issue

tmumaw — Mon, 16 Jun 2014 11:29:35 GMT

Clicked on it and it displayed nothing. I heard there is something in the config needs set higher.

Re: QMC Reduce Issue

ashfaq_haseeb — Mon, 16 Jun 2014 11:35:37 GMT

Hi,

I have no idea about this setting.

I'm sure Bill Britt can help here.

Regards

ASHFAQ

Re: QMC Reduce Issue

Bill_Britt — Mon, 16 Jun 2014 12:02:58 GMT

Hi,

Any synthetic keys or loops in the data model or section access applied to the document?

Bill

Re: QMC Reduce Issue

tmumaw — Mon, 16 Jun 2014 12:04:56 GMT

Nope

Re: QMC Reduce Issue

tmumaw — Mon, 16 Jun 2014 12:08:10 GMT

Bill

Here is the message from Management Service Log: Error QDS did not respond to request. Last exception (for http://kqlikviewprd:4720/QDS/Service😞 The maximum message size quota for incoming messages (262144) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element.

Re: QMC Reduce Issue

Bill_Britt — Mon, 16 Jun 2014 12:11:34 GMT

Nothing attached. Also, can you post an image of you data model?

Bill

Re: QMC Reduce Issue

Bill_Britt — Mon, 16 Jun 2014 12:26:30 GMT

Hi Thom,

Not sure why it is moderating you last reply. However, I was able to read it. You need to change the below setting.

Locate the file QVManagementService.exe.config (default location C:\Program Files\QlikView\Management Service)

Edit the file and increase the size of "MaxReceivedMessageSize"

Default value: <add key="MaxReceivedMessageSize" value="262144"/>
Exampe value: <add key="MaxReceivedMessageSize" value="2621440"/>

Save the file and restart QlikView Management Service

Re: Re: QMC Reduce Issue

tmumaw — Mon, 16 Jun 2014 12:26:53 GMT

Here you go Bill.

Re: QMC Reduce Issue

tmumaw — Mon, 16 Jun 2014 12:29:04 GMT

Thanks Bill I will give it a try.

Re: QMC Reduce Issue

tmumaw — Mon, 16 Jun 2014 13:19:29 GMT

Thanks Bill. It worked perfectly.

Re: QMC Reduce Issue

Thu, 18 Dec 2014 18:13:51 GMT

Guys,

the issue was resolved with a higher 'value' of "MaxReceivedMessageSize".

Has this something to do with Bug 65616 which was fixed in SR9 (release notes)?

Thanks in advance.

/olli