Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
simon_minifie
Partner - Creator III
Partner - Creator III

Reduce by Field Value. No fields shown on open document

Hi All,

Does anyone know if there's a max number of fields that can be displayed in Source Documents -> Task -> Reduce -> Reduce by Field Value?

I select open document and can see it being loaded into RAM. The Processing swirl appears while it's loading, and then vanishes as expected. However, no field list appears. The document has 1828 fields. (Large I know, but I can't find anything that states there's a limit.outside of what the RAM can handle.)

If I do the same with Reduce by Bookmark, I get a bookmark list.

Same has been tried on a qvw with 60 fields, and that displays without issue.

So, back to the question, is there a limit to the number of fields that QlikView can handle in the reduce by field display?

Many thanks in advance,

Simon

1 Solution

Accepted Solutions
simon_minifie
Partner - Creator III
Partner - Creator III
Author

In case this comes up for anyone else..

This from Qlik support which resolved the issue.

"The issue is due to the maximum message bytes. Since there are lot of fields , the maximum message size has exceeded. If you go to logs under C:\ProgramData\QlikTech\ManagementService\Log you will see an error message

"Error QDS did not respond to request.

Last exception (for http://qlikserver1: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."

I am attaching an article for you to resolve the issue. Follow the below steps;

  1. Stop QlikView Distribution Service and QlikView Management Service.
  2. Navigate to QVManagementService.exe.config file, located in %ProgramFiles%\QlikView\Management Service
  3. Edit the QVManagementService.exe.config file with a text editor such as Notepad++ (it may be necessary to first launch the text editor with administrative privileges)
  4. Under the <appSettings> insert/Modify the line <add key="MaxReceivedMessageSize" value="26214400"/> and save the file (notice, the two additional zeroes than what the default is defined as in the error message: 262144)
  5. Restart the QlikView Distribution Service and QlikView Management Service"

View solution in original post

2 Replies
simon_minifie
Partner - Creator III
Partner - Creator III
Author

In case this comes up for anyone else..

This from Qlik support which resolved the issue.

"The issue is due to the maximum message bytes. Since there are lot of fields , the maximum message size has exceeded. If you go to logs under C:\ProgramData\QlikTech\ManagementService\Log you will see an error message

"Error QDS did not respond to request.

Last exception (for http://qlikserver1: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."

I am attaching an article for you to resolve the issue. Follow the below steps;

  1. Stop QlikView Distribution Service and QlikView Management Service.
  2. Navigate to QVManagementService.exe.config file, located in %ProgramFiles%\QlikView\Management Service
  3. Edit the QVManagementService.exe.config file with a text editor such as Notepad++ (it may be necessary to first launch the text editor with administrative privileges)
  4. Under the <appSettings> insert/Modify the line <add key="MaxReceivedMessageSize" value="26214400"/> and save the file (notice, the two additional zeroes than what the default is defined as in the error message: 262144)
  5. Restart the QlikView Distribution Service and QlikView Management Service"
kdmarkee
Specialist
Specialist

Great post...helped me as well with the same issue.