You are not logged in.
Pages: 1
Topic closed
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 moreI get similar results with text parameters.
karolina
Offline
Pages: 1
Topic closed