ReportServer Forum

anirudha.k

Member

Registered: 2020-03-26

pivot http 500 error

When I activate pivot mode and click pivot/preview I get HTTP status 500 error:
Message mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:sqlserver:........
So does it requires mondrian OLAp to be configured? If yes, then how?
Thanks

eduardo

Administrator

Registered: 2016-11-01

Website

Re: pivot http 500 error

Hi anirudha.k,

please post the complete error stack and your exact version (rsversion.properties).

Regards,
Eduardo

anirudha.k

Member

Registered: 2020-03-26

Re: pivot http 500 error

Version:
RS3.1.1-6020 (2020-01-28-16-18-55)
----------------------------

Exception Report

Message mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:sqlserver://SEPL5SQLEXPRESS;databaseName=AP; JdbcUser=***; JdbcPassword=****

Description The server encountered an unexpected condition that prevented it from fulfilling the request.

Exception

java.lang.RuntimeException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:sqlserver://SEPL55SQLEXPRESS;databaseName=AP-DPMS; JdbcUser=sa; JdbcPassword=sa@123
    net.datenwerke.rs.saiku.server.rest.resources.OlapDiscoverResource.getConnections(OlapDiscoverResource.java:127)
    java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    java.base/java.lang.reflect.Method.invoke(Method.java:566)
    com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
    com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
    com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
    com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
    com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
    com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
    com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
    com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542)
    com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473)
    com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419)
    com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409)
    com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409)
    com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558)
    com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
    com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263)
    com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178)
    com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)
    com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62)
    com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:89)
    com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163)
    com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
    com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)
    com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
    com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)
    com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
    com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118)
    com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113)
Root Cause

mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:sqlserver://SEP5SQLEXPRESS;databaseName=AP; JdbcUser=***; JdbcPasswor=******
    mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:992)
    mondrian.olap.Util.newInternal(Util.java:2543)
    mondrian.olap.Util.newError(Util.java:2559)
    mondrian.rolap.RolapConnection.<init>(RolapConnection.java:239)
    mondrian.rolap.RolapSchema.<init>(RolapSchema.java:191)
    mondrian.rolap.RolapSchemaLoader.loadStage1(RolapSchemaLoader.java:313)
    mondrian.rolap.RolapSchemaLoader.loadStage0(RolapSchemaLoader.java:272)
    mondrian.rolap.RolapSchemaLoader.createSchema(RolapSchemaLoader.java:4303)
    mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:210)
    mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:62)
    mondrian.rolap.RolapConnection.<init>(RolapConnection.java:160)
    mondrian.rolap.RolapConnection.<init>(RolapConnection.java:84)
    mondrian.olap.DriverManager.getConnection(DriverManager.java:112)
    mondrian.olap.DriverManager.getConnection(DriverManager.java:68)
    mondrian.olap4j.MondrianOlap4jConnection.<init>(MondrianOlap4jConnection.java:153)
    mondrian.olap4j.FactoryJdbc4Plus$AbstractConnection.<init>(FactoryJdbc4Plus.java:323)
    mondrian.olap4j.FactoryJdbc41Impl$MondrianOlap4jConnectionJdbc41.<init>(FactoryJdbc41Impl.java:118)
    mondrian.olap4j.FactoryJdbc41Impl.newConnection(FactoryJdbc41Impl.java:32)
    mondrian.olap4j.MondrianOlap4jDriver.connect(MondrianOlap4jDriver.java:139)
    java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
    java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189)
    net.datenwerke.rs.saiku.service.saiku.OlapUtilServiceImpl.getOlapConnection(OlapUtilServiceImpl.java:340)
    net.datenwerke.rs.saiku.service.saiku.OlapUtilServiceImpl.getCube(OlapUtilServiceImpl.java:127)
    net.datenwerke.rs.saiku.server.rest.resources.OlapDiscoverResource.getConnections(OlapDiscoverResource.java:117)
    java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    java.base/java.lang.reflect.Method.invoke(Method.java:566)
    com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
    com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
    com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
    com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
    com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
    com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
    com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
    com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542)
    com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473)
    com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419)
    com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409)
    com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409)
    com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558)
    com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
    com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263)
    com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178)
    com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)
    com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62)
    com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:89)
    com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163)
    com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
    com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)
    com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
    com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)
    com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
    com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118)
    com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113)
Root Cause

com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host SEPL55SQLEXPRESS, port 1433 has failed. Error: "null. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
    com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:191)
    com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:242)
    com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2280)
    com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:493)
    com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1388)
    com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1069)
    com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:905)
    com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:452)
    com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1014)
    java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
    java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189)
    org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:78)
    org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
    org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1188)
    org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
    mondrian.rolap.RolapConnection.<init>(RolapConnection.java:212)
    mondrian.rolap.RolapSchema.<init>(RolapSchema.java:191)
    mondrian.rolap.RolapSchemaLoader.loadStage1(RolapSchemaLoader.java:313)
    mondrian.rolap.RolapSchemaLoader.loadStage0(RolapSchemaLoader.java:272)
    mondrian.rolap.RolapSchemaLoader.createSchema(RolapSchemaLoader.java:4303)
    mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:210)
    mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:62)
    mondrian.rolap.RolapConnection.<init>(RolapConnection.java:160)
    mondrian.rolap.RolapConnection.<init>(RolapConnection.java:84)
    mondrian.olap.DriverManager.getConnection(DriverManager.java:112)
    mondrian.olap.DriverManager.getConnection(DriverManager.java:68)
    mondrian.olap4j.MondrianOlap4jConnection.<init>(MondrianOlap4jConnection.java:153)
    mondrian.olap4j.FactoryJdbc4Plus$AbstractConnection.<init>(FactoryJdbc4Plus.java:323)
    mondrian.olap4j.FactoryJdbc41Impl$MondrianOlap4jConnectionJdbc41.<init>(FactoryJdbc41Impl.java:118)
    mondrian.olap4j.FactoryJdbc41Impl.newConnection(FactoryJdbc41Impl.java:32)
    mondrian.olap4j.MondrianOlap4jDriver.connect(MondrianOlap4jDriver.java:139)
    java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
    java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189)
    net.datenwerke.rs.saiku.service.saiku.OlapUtilServiceImpl.getOlapConnection(OlapUtilServiceImpl.java:340)
    net.datenwerke.rs.saiku.service.saiku.OlapUtilServiceImpl.getCube(OlapUtilServiceImpl.java:127)
    net.datenwerke.rs.saiku.server.rest.resources.OlapDiscoverResource.getConnections(OlapDiscoverResource.java:117)
    java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    java.base/java.lang.reflect.Method.invoke(Method.java:566)
    com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
    com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
    com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
    com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
    com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
    com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
    com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
    com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542)
    com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473)
    com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419)
    com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409)
    com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409)
    com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558)
    com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
    com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263)
    com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178)
    com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)
    com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62)
    com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:89)
    com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163)
    com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
    com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)
    com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
    com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)
    com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
    com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118)
    com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113)

eduardo

Administrator

Registered: 2016-11-01

Website

Re: pivot http 500 error

Hi anirudha.k,

can you please copy your environment information on the Administration -> License Management page ? (OS, Java, etc).

Also, which MSSQL driver are you using exactly ?

Regards,
Eduardo

anirudha.k

Member

Registered: 2020-03-26

Re: pivot http 500 error

Hi,
Server information
Version:
RS3.1.1-6020 (2020-01-28-16-18-55)
Server ID:
2fdaba86-4a4a-435e-b2e8-96a7d8936354
Installation date:
2020 March 17
License:
Enterprise Edition (Evaluation)
Expiration date:
2020 May 1
Java version:
AdoptOpenJDK OpenJDK 64-Bit Server VM 11.0.6+10 (11)
Application server:
Apache Tomcat/9.0.31
Operation system:
Windows 7
Browser:
Chrome
Browser version:
76.0.3809.100
Enterprise Edition:
Purchase ReportServer Enterprise Edition

-----
ODBC driver 13 and 17 for sql server

eduardo

Administrator

Registered: 2016-11-01

Website

Re: pivot http 500 error

Hi anirudha.k,

"ODBC driver 13 and 17 for sql server"

I don't get this. Which one exactly? What is the file name of the driver and where did you download it?

Regards,
Eduardo

anirudha.k

Member

Registered: 2020-03-26

Re: pivot http 500 error

which version you are talking about and where can I find it?

eduardo

Administrator

Registered: 2016-11-01

Website

Re: pivot http 500 error

Hi anirudha.k,

"ODBC driver 13 and 17 for sql server"

Please just post the file name of the driver you are using and if available the download page.

You include two versions here: 13 and 17. Which one are you using exactly ?

Regards,
Eduardo

anirudha.k

Member

Registered: 2020-03-26

Re: pivot http 500 error

following is sql server version i am using:
Microsoft SQL Server 2017 (RTM-GDR) (KB4494351) - 14.0.2014.14 (X64)
    Apr  5 2019 09:18:51
    Copyright (C) 2017 Microsoft Corporation
    Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: )

anirudha.k

Member

Registered: 2020-03-26

Re: pivot http 500 error

I have put mondrian jar in Web-INF\lib directory.
getting follow error:
Exception Report

Message java.lang.NoClassDefFoundError: org/apache/commons/vfs2/FileSystemException

Description The server encountered an unexpected condition that prevented it from fulfilling the request.

Exception

javax.servlet.ServletException: java.lang.NoClassDefFoundError: org/apache/commons/vfs2/FileSystemException
    com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:420)
    com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558)
    com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
    com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263)
    com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178)
    com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)
    com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62)
    com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:89)
    com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163)
    com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
    com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)
    com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
    com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)
    com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
    com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118)
    com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113)
Root Cause

java.lang.NoClassDefFoundError: org/apache/commons/vfs2/FileSystemException
    mondrian.rolap.RolapSchemaPool.createRolapSchema(RolapSchemaPool.java:294)
    mondrian.rolap.RolapSchemaPool.getByKey(RolapSchemaPool.java:227)
    mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:166)
    mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:72)
    mondrian.rolap.RolapConnection.<init>(RolapConnection.java:161)
    mondrian.rolap.RolapConnection.<init>(RolapConnection.java:91)
    mondrian.olap.DriverManager.getConnection(DriverManager.java:113)
    mondrian.olap.DriverManager.getConnection(DriverManager.java:69)
    mondrian.olap4j.MondrianOlap4jConnection.<init>(MondrianOlap4jConnection.java:164)
    mondrian.olap4j.FactoryJdbc4Plus$AbstractConnection.<init>(FactoryJdbc4Plus.java:323)
    mondrian.olap4j.FactoryJdbc41Impl$MondrianOlap4jConnectionJdbc41.<init>(FactoryJdbc41Impl.java:118)
    mondrian.olap4j.FactoryJdbc41Impl.newConnection(FactoryJdbc41Impl.java:32)
    mondrian.olap4j.MondrianOlap4jDriver.connect(MondrianOlap4jDriver.java:97)
    java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
    java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189)
    net.datenwerke.rs.saiku.service.saiku.OlapUtilServiceImpl.getOlapConnection(OlapUtilServiceImpl.java:340)
    net.datenwerke.rs.saiku.service.saiku.OlapUtilServiceImpl.getCube(OlapUtilServiceImpl.java:127)
    net.datenwerke.rs.saiku.server.rest.resources.OlapDiscoverResource.getConnections(OlapDiscoverResource.java:117)
    java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    java.base/java.lang.reflect.Method.invoke(Method.java:566)
    com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
    com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
    com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
    com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
    com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
    com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
    com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
    com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542)
    com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473)
    com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419)
    com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409)
    com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409)
    com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558)
    com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
    com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263)
    com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178)
    com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)
    com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62)
    com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:89)
    com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163)
    com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
    com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)
    com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
    com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)
    com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
    com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118)
    com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113)
Root Cause

java.lang.ClassNotFoundException: org.apache.commons.vfs2.FileSystemException
    org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1365)
    org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1188)
    mondrian.rolap.RolapSchemaPool.createRolapSchema(RolapSchemaPool.java:294)
    mondrian.rolap.RolapSchemaPool.getByKey(RolapSchemaPool.java:227)
    mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:166)
    mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:72)
    mondrian.rolap.RolapConnection.<init>(RolapConnection.java:161)
    mondrian.rolap.RolapConnection.<init>(RolapConnection.java:91)
    mondrian.olap.DriverManager.getConnection(DriverManager.java:113)
    mondrian.olap.DriverManager.getConnection(DriverManager.java:69)
    mondrian.olap4j.MondrianOlap4jConnection.<init>(MondrianOlap4jConnection.java:164)
    mondrian.olap4j.FactoryJdbc4Plus$AbstractConnection.<init>(FactoryJdbc4Plus.java:323)
    mondrian.olap4j.FactoryJdbc41Impl$MondrianOlap4jConnectionJdbc41.<init>(FactoryJdbc41Impl.java:118)
    mondrian.olap4j.FactoryJdbc41Impl.newConnection(FactoryJdbc41Impl.java:32)
    mondrian.olap4j.MondrianOlap4jDriver.connect(MondrianOlap4jDriver.java:97)
    java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
    java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189)
    net.datenwerke.rs.saiku.service.saiku.OlapUtilServiceImpl.getOlapConnection(OlapUtilServiceImpl.java:340)
    net.datenwerke.rs.saiku.service.saiku.OlapUtilServiceImpl.getCube(OlapUtilServiceImpl.java:127)
    net.datenwerke.rs.saiku.server.rest.resources.OlapDiscoverResource.getConnections(OlapDiscoverResource.java:117)
    java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    java.base/java.lang.reflect.Method.invoke(Method.java:566)
    com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
    com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
    com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
    com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
    com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
    com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
    com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
    com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542)
    com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473)
    com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419)
    com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409)
    com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409)
    com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558)
    com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
    com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263)
    com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178)
    com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)
    com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62)
    com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:89)
    com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163)
    com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
    com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)
    com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
    com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)
    com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
    com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118)
    com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113)
Note The full stack trace of the root cause is available in the server logs.

Apache Tomcat/9.0.31

Last edited by anirudha.k (2020-04-28 10:34:40)

eduardo

Administrator

Registered: 2016-11-01

Website

Re: pivot http 500 error

Hi anirudha.k,

I still don't know which exact SQLSERVER driver you are using. You sent me the SQLSERVER version, but not the driver. Please check this.

"I have put mondrian jar in Web-INF\lib directory."
-> What exactly have you put here? what is "mondrian jar"?

Regards,
Eduardo

anirudha.k

Member

Registered: 2020-03-26

Re: pivot http 500 error

Hi Eduardo,
can you please guide me how can see which sql server driver I am using? Where to find it?

I have downloaded mondrian in order to resolve the error related to mondrian which I posted earlier.
And I have kept downloaded mondrian which is  a jar file(I thought due to this the mondrian error will go off) in WEB-INF\lib directory.
I have downloaded mondrian from below link:
https://sourceforge.net/projects/mondrian/

My aim is to install/configure mondrian so that I can create OLAP cubes in reportServer.

Last edited by anirudha.k (2020-04-28 13:24:22)

eduardo

Administrator

Registered: 2016-11-01

Website

Re: pivot http 500 error

Hi anirudha.k,

you don't have to download any mondrian driver, all necessary mondrian drivers are included in ReportServer. Please delete the driver you inserted from WEB-INF/lib.
For testing, please use one of the Bitnami installer packages downloadable here: https://reportserver.net/en/download/ (in such a way, we will make sure you have a valid installation).

"can you please guide me how can see which sql server driver I am using? Where to find it?" -> In order for MSSQL to work, you have to add a MSSQL driver (jar) to WEB-INF/lib. Which one did you add ?

Regards,
Eduardo

anirudha.k

Member

Registered: 2020-03-26

Re: pivot http 500 error

OK. Thanks for reply.
the jdbc driver is sqljdbc42.jar

eduardo

Administrator

Registered: 2016-11-01

Website

Re: pivot http 500 error

Hi anirudha.k,

thanks for the driver information.

Please try with a standard installation and this additional drier (sqljdbc42.jar). Mondrian should work without any other changes.

Your original error was: "null. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall."

Is the original dynamic list working (preview) before you click on pivot ? can you please post some screenshots?  You can use http://www.imgbb.com for this.

Regards,
Eduardo

anirudha.k

Member

Registered: 2020-03-26

Re: pivot http 500 error

yes, original Dynamic List before clicking pivot is working.

https://ibb.co/3rnWpBy

eduardo

Administrator

Registered: 2016-11-01

Website

Re: pivot http 500 error

Hi anirudha.k,

did you perform a manual installation or did you install one of the Bitnami packages?

Regards,
Eduardo

anirudha.k

Member

Registered: 2020-03-26

Re: pivot http 500 error

I have not installed manual but I have installed follow Bitnami

https://ibb.co/WGzgYYN
https://ibb.co/sV75VqG

eduardo

Administrator

Registered: 2016-11-01

Website

Re: pivot http 500 error

Dear anirudha.k,

we cannot reproduce the issue. We use SQL Server ourselves a lot, including Pivot and Dynamic List, etc. Do you have any idea what could be specific about your permission configuration in MSSQL ? Is there a chance to access your database - arbitrary table for testing purposes? So we could directly access and test this issue from here ? we are very interested in resolving this issue.

Regards,
Eduardo

anirudha.k

Member

Registered: 2020-03-26

Re: pivot http 500 error

ok.
We will try to give you connection.
Meanswhile, we have aaslo installed on different machine for another user but error is coming while data source creation:database type not spcified.
https://ibb.co/b1DbK32

eduardo

Administrator

Registered: 2016-11-01

Website

Re: pivot http 500 error

Hi anirudha.k,

for new errors/issues, please always open a new thread.

Anyhow, can you make sure you pressed the "Apply" button before testing the connection?

Regards,
Eduardo

anirudha.k

Member

Registered: 2020-03-26

Re: pivot http 500 error

ok. got now. thanks