Error : Error Di BI Server

92 views
Skip to first unread message

Bambang sistriadianto

unread,
Jul 29, 2011, 12:17:33 AM7/29/11
to penta...@googlegroups.com
Dear Pak Feris dan rekan Semua,

Saya saat ini ada ketemu error ketika memindahkan Analisys report (yg sebelumnya di execute via mondrian ) ke Bi server;
error nya seperti in :

2011-07-29 11:01:06,410 WARN  [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
2011-07-29 11:01:07,958 WARN  [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
2011-07-29 11:01:08,202 WARN  [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
2011-07-29 11:01:08,464 WARN  [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
2011-07-29 11:01:08,796 WARN  [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
2011-07-29 11:01:09,165 WARN  [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
2011-07-29 11:01:09,379 WARN  [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
2011-07-29 11:01:09,607 WARN  [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
2011-07-29 11:01:24,301 ERROR [org.pentaho.platform.web.servlet.GenericServlet] GenericServlet.ERROR_0004 - Resource /data-access/resources/gwt/nativeScripts.js not found in plugin Pentaho Data Access
2011-07-29 11:01:24,359 ERROR [org.pentaho.platform.web.servlet.GenericServlet] GenericServlet.ERROR_0004 - Resource /data-access/resources/gwt/modeler_en.properties not found in plugin Pentaho Data Access
2011-07-29 11:01:24,534 ERROR [org.pentaho.platform.web.servlet.GenericServlet] GenericServlet.ERROR_0004 - Resource /data-access/resources/gwt/main_wizard_panel_en.properties not found in plugin Pentaho Data Access
2011-07-29 11:01:24,864 ERROR [org.pentaho.platform.web.servlet.GenericServlet] GenericServlet.ERROR_0004 - Resource /data-access/resources/gwt/gwt-dnd.css not found in plugin Pentaho Data Access
2011-07-29 11:01:25,611 ERROR [org.pentaho.platform.web.servlet.GenericServlet] GenericServlet.ERROR_0004 - Resource /data-access/resources/gwt/main_wizard_panel_en_US.properties not found in plugin Pentaho Data Access
2011-07-29 11:01:37,350 ERROR [com.tonbeller.jpivot.tags.OlapModelTag] 
mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Anonymous data source=org.apache.tomcat.dbcp.dbcp.BasicDataSource@67c8f3da
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:841)
at mondrian.olap.Util.newInternal(Util.java:1539)
at mondrian.olap.Util.newError(Util.java:1555)
at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:233)
at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:184)
at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:218)
at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:54)
at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:992)
at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:797)
at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:173)
at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:95)
at mondrian.olap.DriverManager.getConnection(DriverManager.java:110)
at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:518)
at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132)
at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:77)
at com.tonbeller.jpivot.tags.StackStateManager.initializeAndShow(StackStateManager.java:76)
at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:160)
at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:81)
at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:889)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:77)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:103)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1452)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:213)
... 81 more
Caused by: java.lang.NullPointerException
at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(JdbcOdbcDriver.java:507)
at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(JdbcOdbcDriver.java:476)
at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(JdbcOdbcDriver.java:307)
at java.sql.DriverManager.getDriver(DriverManager.java:253)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1437)
... 84 more


Apakah ada rekan2 semua yang pernah mengalami hal seperti ini ?
mohon masukan dari rekan2 semua



Terima Kasih


Bambang Sistriadianto

Bambang Sistriadianto

unread,
Jul 29, 2011, 6:59:43 AM7/29/11
to Pentaho User Group Indonesia
Dear Pak feris dan rekan2 semua,

Saya sudah ketemu solusinya dimana,..kalo dilhat dari error :

Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
create
> JDBC driver of class '' for connect URL 'null'

Sepertinya path jdbc nya tidak ditemukan , saya akhirnya coba
pindahkan file context.xml yang di biserver-ce\tomcat\webapps\pentaho
\META-INF
ke biserver-ce\tomcat\conf , lalu restart dan start lagi "-
pentaho.bat" nya... semua berjalan normal seperti yang diharapkan..:)


Demikian updatenya ...


Terima kasih,

Bambang sistriadianto


On Jul 29, 11:17 am, Bambang sistriadianto
> com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.j ava:160)
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.jav a:109)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Htt p11Protocol.java:588)
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
> at java.lang.Thread.run(Thread.java:619)
> Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
> JDBC driver of class '' for connect URL 'null'
> at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDa taSource.java:1452)
> at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSourc e.java:1371)
> at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.j ava:1044)
> at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:213)
> ... 81 more
> Caused by: java.lang.NullPointerException
> at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(JdbcOdbcDriver.java:507)
> at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(JdbcOdbcDriver.java:476)
> at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(JdbcOdbcDriver.java:307)
> at java.sql.DriverManager.getDriver(DriverManager.java:253)
> at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDa taSource.java:1437)

Feris Thia

unread,
Jul 31, 2011, 10:42:51 AM7/31/11
to penta...@googlegroups.com
Dear Pak Bambang,

Terima kasih atas sharingnya. Saya yakin akan bermanfaat bagi kita semua.

Regards,

Feris

2011/7/29 Bambang Sistriadianto <bambang.si...@gmail.com>

Dear Pak feris dan rekan2 semua,

Saya sudah ketemu solusinya dimana,..kalo dilhat dari error :

Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
create
> JDBC driver of class '' for connect URL 'null'

Sepertinya path jdbc nya tidak ditemukan , saya akhirnya coba
pindahkan file context.xml yang di biserver-ce\tomcat\webapps\pentaho
\META-INF
ke biserver-ce\tomcat\conf , lalu restart dan start lagi "-
pentaho.bat" nya... semua berjalan normal seperti yang diharapkan..:)


Demikian updatenya ...


Terima kasih,

Bambang sistriadianto



--
Thanks & Best Regards,

Feris Thia
Business Intelligence Consultant
PT. Putera Handal Indotama
Phone  : +6221-30119353
Fax      : +6221-5513483
Mobile : +628176-474-525
http://www.phi-integration.com
http://pentaho.phi-integration.com
http://sqlserver-tips.phi-integration.com



Reply all
Reply to author
Forward
0 new messages