ReportServer Forum

Glandike

Member

Registered: 2015-11-10

Pivot mode

Hello dear support!
I faced with strange bug, which appears recently. At the beginning my reportserver experience i tried to use pivot mode and all was fine, but recently i tried again to get some reports using pivot mode and it can't do absolutely nothing! Any report i want to generate freezes when i try to add field(dimensions or measures) to rows or columns. Catalina.log generates this warnings:

 
Mar 22, 2016 6:40:48 AM com.sun.jersey.spi.container.servlet.WebComponent filterFormParameters
WARNING: A servlet request, to the URI http://sppr-test.gz-spb.ru/reportserver/reportserver/rest/saiku/318081-6-1458643230355-1856002744/discover/ef8d5bd2-3c9e-43c2-854a-3cfbc0913ebd/GenericDynaListSchema/GenericDynaListSchema/GenericDynaListCube/dimensions?key=ef8d5bd2-3c9e-43c2-854a-3cfbc0913ebd%2FGenericDynaListSchema%2FGenericDynaListSchema%2FGenericDynaListCube&_=1458643247600, contains form parameters in the request body but the request body has been consumed by the servlet or a servlet filter accessing the request parameters. Only resource methods using @FormParam will work as expected. Resource methods consuming the request body by other means will not work as expected.
Mar 22, 2016 6:40:48 AM com.sun.jersey.spi.container.servlet.WebComponent filterFormParameters
WARNING: A servlet request, to the URI http://sppr-test.gz-spb.ru/reportserver/reportserver/rest/saiku/318081-6-1458643230355-1856002744/session?_=1458643247970, contains form parameters in the request body but the request body has been consumed by the servlet or a servlet filter accessing the request parameters. Only resource methods using @FormParam will work as expected. Resource methods consuming the request body by other means will not work as expected.
Mar 22, 2016 6:40:48 AM com.sun.jersey.spi.container.servlet.WebComponent filterFormParameters
WARNING: A servlet request, to the URI http://sppr-test.gz-spb.ru/reportserver/reportserver/rest/saiku/318081-6-1458643230355-1856002744/discover/?_=1458643248042, contains form parameters in the request body but the request body has been consumed by the servlet or a servlet filter accessing the request parameters. Only resource methods using @FormParam will work as expected. Resource methods consuming the request body by other means will not work as expected.
Mar 22, 2016 6:40:48 AM com.sun.jersey.spi.container.servlet.WebComponent filterFormParameters
WARNING: A servlet request, to the URI http://sppr-test.gz-spb.ru/reportserver/reportserver/rest/saiku/318081-6-1458643230355-1856002744/discover/4d73f2e3-a010-48ff-a2e0-92e3f3898db6/GenericDynaListSchema/GenericDynaListSchema/GenericDynaListCube/dimensions?key=4d73f2e3-a010-48ff-a2e0-92e3f3898db6%2FGenericDynaListSchema%2FGenericDynaListSchema%2FGenericDynaListCube&_=1458643248298, contains form parameters in the request body but the request body has been consumed by the servlet or a servlet filter accessing the request parameters. Only resource methods using @FormParam will work as expected. Resource methods consuming the request body by other means will not work as expected.
Mar 22, 2016 6:40:48 AM com.sun.jersey.spi.container.servlet.WebComponent filterFormParameters
WARNING: A servlet request, to the URI http://sppr-test.gz-spb.ru/reportserver/reportserver/rest/saiku/318081-6-1458643230355-1856002744/discover/4d73f2e3-a010-48ff-a2e0-92e3f3898db6/GenericDynaListSchema/GenericDynaListSchema/GenericDynaListCube/measures?key=4d73f2e3-a010-48ff-a2e0-92e3f3898db6%2FGenericDynaListSchema%2FGenericDynaListSchema%2FGenericDynaListCube&_=1458643248300, contains form parameters in the request body but the request body has been consumed by the servlet or a servlet filter accessing the request parameters. Only resource methods using @FormParam will work as expected. Resource methods consuming the request body by other means will not work as expected.

and localhost_access_log generates this:

 
192.168.90.24 - - [22/Mar/2016:06:48:51 -0400] "POST /reportserver/reportserver/saiku HTTP/1.0" 200 12
192.168.90.24 - - [22/Mar/2016:06:48:51 -0400] "GET /reportserver/resources/saiku/index.html?username=415255-6-1458643725921-1729336634&password=none HTTP/1.0" 200 33818
192.168.90.24 - - [22/Mar/2016:06:48:51 -0400] "POST /reportserver/reportserver/rest/saiku/415255-6-1458643725921-1729336634/session HTTP/1.0" 200 -
192.168.90.24 - - [22/Mar/2016:06:48:51 -0400] "GET /reportserver/reportserver/rest/saiku/415255-6-1458643725921-1729336634/session?_=1458643730943 HTTP/1.0" 200 137
192.168.90.24 - - [22/Mar/2016:06:48:51 -0400] "GET /reportserver/reportserver/rest/saiku/i18n/null/ HTTP/1.0" 200 6554
192.168.90.24 - - [22/Mar/2016:06:48:52 -0400] "GET /reportserver/reportserver/rest/saiku/415255-6-1458643725921-1729336634/discover/?_=1458643730965 HTTP/1.0" 200 644
192.168.90.24 - - [22/Mar/2016:06:48:52 -0400] "POST /reportserver/reportserver/rest/saiku/415255-6-1458643725921-1729336634/query/6ACE96BC-C25D-3E33-8594-1C47652AB412 HTTP/1.0" 200 1599
192.168.90.24 - - [22/Mar/2016:06:48:52 -0400] "GET /reportserver/reportserver/rest/saiku/415255-6-1458643725921-1729336634/discover/5de0e51e-5328-4b9d-ae6b-ae7c57ed0d70/GenericDynaListSchema/GenericDynaListSchema/GenericDynaListCube/measures?key=5de0e51e-5328-4b9d-ae6b-ae7c57ed0d70%2FGenericDynaListSchema%2FGenericDynaListSchema%2FGenericDynaListCube&_=1458643731192 HTTP/1.0" 200 420
192.168.90.24 - - [22/Mar/2016:06:48:52 -0400] "GET /reportserver/reportserver/rest/saiku/415255-6-1458643725921-1729336634/discover/5de0e51e-5328-4b9d-ae6b-ae7c57ed0d70/GenericDynaListSchema/GenericDynaListSchema/GenericDynaListCube/dimensions?key=5de0e51e-5328-4b9d-ae6b-ae7c57ed0d70%2FGenericDynaListSchema%2FGenericDynaListSchema%2FGenericDynaListCube&_=1458643731191 HTTP/1.0" 200 848
192.168.90.24 - - [22/Mar/2016:06:48:53 -0400] "POST /reportserver/reportserver/rest/saiku/415255-6-1458643725921-1729336634/query/6ACE96BC-C25D-3E33-8594-1C47652AB412/axis/COLUMNS/dimension/Measures/member/[Measures].[WORD] HTTP/1.0" 400 990 

I sure that is some settings issue, but i can't grasp where is trouble.

Hope for your help!

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: Pivot mode

Hi,

I am afraid the warnings that you see probably have nothing to do with the problem. I am not quite sure how we can help here. What kind of settings did you change?

Regards,
Arno