#1 2014-09-04 12:26:48

karolina
Member
Registered: 2014-08-09

parametrized dynamic list and pivot

Hello,

I tried to create parametrized dynamic list and its pivot variant. The report refers to sales amount and its datasource is a Firebird database.
I have 2 paramerers: starting date and ending date.
Standard version of the list works fine.
When I try to make pivot variant, I get: GDSException: conversion error from string ""

Here is an extract from catalina.out log:

Sep 04, 2014 2:19:37 PM com.sun.jersey.spi.container.servlet.WebComponent filterFormParameters
WARNING: A servlet request, to the URI http://91.250.112.226:8088/reportserver/reportserver/rest/saiku/200426-28702-1409833131952--172057015/session?_=1409833179871, 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.
Sep 04, 2014 2:19:37 PM com.sun.jersey.spi.container.servlet.WebComponent filterFormParameters
WARNING: A servlet request, to the URI http://91.250.112.226:8088/reportserver/reportserver/rest/saiku/200426-28702-1409833131952--172057015/discover/?_=1409833179935, 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.
Sep 04, 2014 2:19:37 PM com.sun.jersey.spi.container.servlet.WebComponent filterFormParameters
WARNING: A servlet request, to the URI http://91.250.112.226:8088/reportserver/reportserver/rest/saiku/200426-28702-1409833131952--172057015/discover/1ebc1510-d694-429f-8a79-c350f5d66803/GenericDynaListSchema/GenericDynaListSchema/GenericDynaListCube/dimensions?key=1ebc1510-d694-429f-8a79-c350f5d66803%2FGenericDynaListSchema%2FGenericDynaListSchema%2FGenericDynaListCube&_=1409833180307, 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.
Sep 04, 2014 2:19:37 PM com.sun.jersey.spi.container.servlet.WebComponent filterFormParameters
WARNING: A servlet request, to the URI http://91.250.112.226:8088/reportserver/reportserver/rest/saiku/200426-28702-1409833131952--172057015/discover/1ebc1510-d694-429f-8a79-c350f5d66803/GenericDynaListSchema/GenericDynaListSchema/GenericDynaListCube/measures?key=1ebc1510-d694-429f-8a79-c350f5d66803%2FGenericDynaListSchema%2FGenericDynaListSchema%2FGenericDynaListCube&_=1409833180308, 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.
Sep 04, 2014 2:19:50 PM com.sun.jersey.spi.container.servlet.WebComponent filterFormParameters
WARNING: A servlet request, to the URI http://91.250.112.226:8088/reportserver/reportserver/rest/saiku/200426-28702-1409833131952--172057015/session?_=1409833193569, 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.
Sep 04, 2014 2:19:50 PM com.sun.jersey.spi.container.servlet.WebComponent filterFormParameters
WARNING: A servlet request, to the URI http://91.250.112.226:8088/reportserver/reportserver/rest/saiku/200426-28702-1409833131952--172057015/discover/?_=1409833193641, 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.
Sep 04, 2014 2:19:51 PM com.sun.jersey.spi.container.servlet.WebComponent filterFormParameters
WARNING: A servlet request, to the URI http://91.250.112.226:8088/reportserver/reportserver/rest/saiku/200426-28702-1409833131952--172057015/discover/1ebc1510-d694-429f-8a79-c350f5d66803/GenericDynaListSchema/GenericDynaListSchema/GenericDynaListCube/dimensions?key=1ebc1510-d694-429f-8a79-c350f5d66803%2FGenericDynaListSchema%2FGenericDynaListSchema%2FGenericDynaListCube&_=1409833194062, 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.
Sep 04, 2014 2:19:51 PM com.sun.jersey.spi.container.servlet.WebComponent filterFormParameters
WARNING: A servlet request, to the URI http://91.250.112.226:8088/reportserver/reportserver/rest/saiku/200426-28702-1409833131952--172057015/discover/1ebc1510-d694-429f-8a79-c350f5d66803/GenericDynaListSchema/GenericDynaListSchema/GenericDynaListCube/measures?key=1ebc1510-d694-429f-8a79-c350f5d66803%2FGenericDynaListSchema%2FGenericDynaListSchema%2FGenericDynaListCube&_=1409833194063, 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.
Sep 04, 2014 2:19:53 PM com.sun.jersey.spi.container.servlet.WebComponent filterFormParameters
WARNING: A servlet request, to the URI http://91.250.112.226:8088/reportserver/reportserver/rest/saiku/200426-28702-1409833131952--172057015/session?_=1409833195763, 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.
Sep 04, 2014 2:19:53 PM com.sun.jersey.spi.container.servlet.WebComponent filterFormParameters
WARNING: A servlet request, to the URI http://91.250.112.226:8088/reportserver/reportserver/rest/saiku/200426-28702-1409833131952--172057015/discover/?_=1409833195826, 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.
Sep 04, 2014 2:19:53 PM com.sun.jersey.spi.container.servlet.WebComponent filterFormParameters
WARNING: A servlet request, to the URI http://91.250.112.226:8088/reportserver/reportserver/rest/saiku/200426-28702-1409833131952--172057015/discover/532ed85f-7efe-430d-bb12-37df16282d16/GenericDynaListSchema/GenericDynaListSchema/GenericDynaListCube/dimensions?key=532ed85f-7efe-430d-bb12-37df16282d16%2FGenericDynaListSchema%2FGenericDynaListSchema%2FGenericDynaListCube&_=1409833196138, 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.
Sep 04, 2014 2:19:53 PM com.sun.jersey.spi.container.servlet.WebComponent filterFormParameters
WARNING: A servlet request, to the URI http://91.250.112.226:8088/reportserver/reportserver/rest/saiku/200426-28702-1409833131952--172057015/discover/532ed85f-7efe-430d-bb12-37df16282d16/GenericDynaListSchema/GenericDynaListSchema/GenericDynaListCube/measures?key=532ed85f-7efe-430d-bb12-37df16282d16%2FGenericDynaListSchema%2FGenericDynaListSchema%2FGenericDynaListCube&_=1409833196139, 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.
Sep 04, 2014 2:20:15 PM com.sun.jersey.spi.container.servlet.WebComponent filterFormParameters
WARNING: A servlet request, to the URI http://91.250.112.226:8088/reportserver/reportserver/rest/saiku/200426-28702-1409833131952--172057015/query/A6186618-65D4-34A9-9B94-0F09AEB29782/result/flattened?limit=0&_=1409833218395, 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.
Sep 04, 2014 2:20:15 PM net.datenwerke.rs.saiku.service.saiku.OlapQueryServiceImpl execute
INFO: runId:16	Type:QM:
SELECT
{Hierarchize({[NAZWA].[NAZWA].Members})} ON COLUMNS,
CrossJoin({[Measures].[AMOUNT_PLN]}, [ACCOUNT_DATE].[ACCOUNT_DATE].Members) ON ROWS
FROM [GenericDynaListCube]
Sep 04, 2014 2:20:15 PM net.datenwerke.rs.saiku.service.saiku.OlapQueryServiceImpl execute
INFO: runId:16	Exception: GDSException: conversion error from string ""
Sep 04, 2014 2:20:15 PM net.datenwerke.rs.saiku.server.rest.resources.QueryResource execute
SEVERE: Cannot execute query (A6186618-65D4-34A9-9B94-0F09AEB29782)
org.saiku.service.util.exception.SaikuServiceException: runId:16	Can't execute query: A6186618-65D4-34A9-9B94-0F09AEB29782
	at net.datenwerke.rs.saiku.service.saiku.OlapQueryServiceImpl.execute(OlapQueryServiceImpl.java:236)
	at net.datenwerke.rs.saiku.service.saiku.OlapQueryServiceImpl.execute(OlapQueryServiceImpl.java:189)
	at net.datenwerke.rs.saiku.server.rest.resources.QueryResource.execute(QueryResource.java:765)
	at sun.reflect.GeneratedMethodAccessor574.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
	at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
	at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
	at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
	at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
	at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
	at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
	at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
	at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542)
	at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473)
	at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419)
	at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409)
	at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409)
	at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:540)
	at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:715)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263)
	at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178)
	at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)
	at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62)
	at com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:89)
	at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163)
	at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
	at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118)
	at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:745)
Caused by: org.olap4j.OlapException: mondrian gave exception while executing query
	at mondrian.olap4j.MondrianOlap4jConnection$Helper.createException(MondrianOlap4jConnection.java:843)
	at mondrian.olap4j.MondrianOlap4jStatement.executeOlapQueryInternal(MondrianOlap4jStatement.java:423)
	at mondrian.olap4j.MondrianOlap4jStatement.executeOlapQuery(MondrianOlap4jStatement.java:347)
	at org.saiku.olap.query.OlapQuery.execute(OlapQuery.java:260)
	at net.datenwerke.rs.saiku.service.saiku.OlapQueryServiceImpl.execute(OlapQueryServiceImpl.java:216)
	... 46 more
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {Hierarchize({[NAZWA].[NAZWA].Members})} ON COLUMNS,
  Crossjoin({[Measures].[AMOUNT_PLN]}, [ACCOUNT_DATE].[ACCOUNT_DATE].Members) ON ROWS
from [GenericDynaListCube]
]
	at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:972)
	at mondrian.olap.Util.newInternal(Util.java:2404)
	at mondrian.olap.Util.newError(Util.java:2420)
	at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:706)
	at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:51)
	at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:622)
	at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:621)
	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
	... 3 more
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Populating member cache with members for [[NAZWA].[NAZWA]]; sql=[select "GenericDynaListCube"."NAZWA" as "c0" from (SELECT * FROM (SELECT * FROM KB_SALES WHERE ACCOUNT_DATE BETWEEN '' AND '' ) wrappedQry) "GenericDynaListCube" group by "GenericDynaListCube"."NAZWA" order by "GenericDynaListCube"."NAZWA" ASC NULLS LAST]
	at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:972)
	at mondrian.olap.Util.newInternal(Util.java:2404)
	at mondrian.olap.Util.newError(Util.java:2420)
	at mondrian.rolap.SqlStatement.handle(SqlStatement.java:353)
	at mondrian.rolap.SqlTupleReader.prepareTuples(SqlTupleReader.java:489)
	at mondrian.rolap.SqlTupleReader.readMembers(SqlTupleReader.java:507)
	at mondrian.rolap.SqlMemberSource.getMembersInLevel(SqlMemberSource.java:527)
	at mondrian.rolap.SmartMemberReader.getMembersInLevel(SmartMemberReader.java:146)
	at mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.getMembersInLevel(RolapCubeHierarchy.java:723)
	at mondrian.rolap.RolapSchemaReader.getLevelMembers(RolapSchemaReader.java:566)
	at mondrian.rolap.RolapSchemaReader.getLevelMembers(RolapSchemaReader.java:552)
	at mondrian.rolap.RolapCube$RolapCubeSchemaReader.getLevelMembers(RolapCube.java:2814)
	at mondrian.olap.DelegatingSchemaReader.getLevelMembers(DelegatingSchemaReader.java:195)
	at mondrian.olap.Query$QuerySchemaReader.getLevelMembers(Query.java:1505)
	at mondrian.olap.fun.FunUtil.getNonEmptyLevelMembers(FunUtil.java:2201)
	at mondrian.olap.fun.FunUtil.levelMembers(FunUtil.java:2209)
	at mondrian.olap.fun.LevelMembersFunDef$1.evaluateList(LevelMembersFunDef.java:37)
	at mondrian.olap.fun.HierarchizeFunDef$1.evaluateList(HierarchizeFunDef.java:46)
	at mondrian.calc.impl.AbstractListCalc.evaluateIterable(AbstractListCalc.java:71)
	at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:875)
	at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:700)
	at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:656)
	at mondrian.rolap.RolapResult.<init>(RolapResult.java:288)
	at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:671)
	... 7 more
Caused by: org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544334. conversion error from string ""
	at org.firebirdsql.jdbc.FBStatementFetcher.fetch(FBStatementFetcher.java:206)
	at org.firebirdsql.jdbc.FBStatementFetcher.next(FBStatementFetcher.java:119)
	at org.firebirdsql.jdbc.AbstractResultSet.next(AbstractResultSet.java:273)
	at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207)
	at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207)
	at mondrian.rolap.SqlTupleReader.prepareTuples(SqlTupleReader.java:426)
	... 26 more
Caused by: org.firebirdsql.gds.GDSException: conversion error from string ""
	at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.readStatusVector(AbstractJavaGDSImpl.java:2092)
	at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.receiveResponse(AbstractJavaGDSImpl.java:2042)
	at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscDsqlFetch(AbstractJavaGDSImpl.java:1322)
	at org.firebirdsql.gds.impl.GDSHelper.fetch(GDSHelper.java:265)
	at org.firebirdsql.jdbc.FBStatementFetcher.fetch(FBStatementFetcher.java:201)
	... 31 more

I get similar results with text parameters.

karolina

Offline

Board footer

Powered by FluxBB