Re: [pentaho-id] Tanya : SolutionEngine.ERROR_0007 - Action sequence execution failed

[Rio Bastian]

Salam kenal juga Kamelia,.

saya coba bantu ya.

Berdasarkan ERROR LOG,
Saya kira masalahnya ada di file global-department-list.xaction yang berada di ..\biserver-ce\pentaho-solutions\bi-developers\secure\

bila kita ingin membypass process ke file ini kita bisa lakukan melalui file sessionStartupActions.xml yang berada di ..\biserver-ce\pentaho-solutions\system\

coba komentari beans dengan class = org.pentaho.platform.engine.core.system.SessionStartupAction.

restart BI server, kemudian coba publish ulang.

regards

[Rio Bastian]

Pak? ngerasa dah tua TT.

Waktu coba, pakai BI-server dan mondrian skema versi berapa?

2013/1/14 Robiatul Kamelia <robiatul...@gmail.com>

Dear Pak Rio Bastian,

Terimakasih atas bantuannya.

Namun saya tidak menemukan file "global-department-list.xaction " seperti yang bapak maksud.Bahkan di direktori yang ada di laptop saya nggak ada folder bi-developer/secure :(

tapi kalo file sessionStartupActions.xml sudah sesuai instruksi bapak, dan masih tetap error.

Berikut saya lampirkan PENTAHO.LOG :

2013-01-14 09:20:32,495 WARN  [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http

2013-01-14 09:20:33,947 WARN  [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http

2013-01-14 09:20:34,441 WARN  [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http

2013-01-14 09:20:34,724 WARN  [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http

2013-01-14 09:20:35,209 ERROR [org.pentaho.platform.engine.services.solution.SolutionEngine] fa879566-5df0-11e2-88a7-877fffad2004:SOLUTION-ENGINE:global-department-list.xaction: SolutionEngine.ERROR_0007 - Action sequence execution failed

2013-01-14 09:20:35,209 ERROR [org.pentaho.platform.engine.services.solution.SolutionEngine] fa879566-5df0-11e2-88a7-877fffad2004:SOLUTION-ENGINE:global-department-list.xaction: SolutionEngine.ERROR_0007 - Action sequence execution failed

2013-01-14 09:20:58,274 ERROR [org.pentaho.platform.engine.services.solution.SolutionEngine] 084642a7-5df1-11e2-88a7-877fffad2004:SOLUTION-ENGINE:session-region-list.xaction: SolutionEngine.ERROR_0007 - Action sequence execution failed

2013-01-14 09:20:58,274 ERROR [org.pentaho.platform.engine.services.solution.SolutionEngine] 084642a7-5df1-11e2-88a7-877fffad2004:SOLUTION-ENGINE:session-region-list.xaction: SolutionEngine.ERROR_0007 - Action sequence execution failed

2013-01-14 09:22:45,641 ERROR [org.pentaho.platform.engine.services.solution.SolutionEngine] 4851fb58-5df1-11e2-88a7-877fffad2004:SOLUTION-ENGINE:session-region-list.xaction: SolutionEngine.ERROR_0007 - Action sequence execution failed

2013-01-14 09:22:45,641 ERROR [org.pentaho.platform.engine.services.solution.SolutionEngine] 4851fb58-5df1-11e2-88a7-877fffad2004:SOLUTION-ENGINE:session-region-list.xaction: SolutionEngine.ERROR_0007 - Action sequence execution failed

2013-01-14 09:22:45,941 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/pentaho].[SolutionRepositoryService]] Servlet.service() for servlet SolutionRepositoryService threw exception

java.lang.NullPointerException

at java.lang.String.<init>(Unknown Source)

at org.pentaho.platform.repository.solution.SolutionRepositoryBase.getLocalizedFileProperty(SolutionRepositoryBase.java:889)

at org.pentaho.platform.repository.solution.SolutionRepositoryServiceImpl.processRepositoryFile(SolutionRepositoryServiceImpl.java:244)

at org.pentaho.platform.repository.solution.SolutionRepositoryServiceImpl.processRepositoryFile(SolutionRepositoryServiceImpl.java:218)

at org.pentaho.platform.repository.solution.SolutionRepositoryServiceImpl.getSolutionRepositoryDoc(SolutionRepositoryServiceImpl.java:479)

at org.pentaho.platform.web.servlet.SolutionRepositoryService.dispatch(SolutionRepositoryService.java:152)

at org.pentaho.platform.web.servlet.SolutionRepositoryService.doGet(SolutionRepositoryService.java:78)

at org.pentaho.platform.web.servlet.SolutionRepositoryService.doPost(SolutionRepositoryService.java:193)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

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:215)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

at org.pentaho.platform.web.http.filters.ProxyTrustingFilter.doFilter(ProxyTrustingFilter.java:212)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)

at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)

at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)

at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)

at java.lang.Thread.run(Unknown Source)

Mohon bantuannya pak. terimakasih.

Regards,

Kamelia

--
Anda menerima pesan ini karena Anda telah terdaftar di Google
Groups "Pentaho User Group - Indonesia".
Untuk mengirim pesan ke grup ini, kirimkan email ke penta...@googlegroups.com
Untuk berhenti mendapatkan email dari grup ini,silahkan kirim email ke
pentaho-id+...@googlegroups.com
Untuk opsi lainnya, silahkan kunjungi http://groups.google.com/group/pentaho-id?hl=id.
Untuk artikel teknis Pentaho dari PHI-Integration.com, silahkan kunjungi http://pentaho.phi-integration.com.
http://pentaho-en.phi-integration.com.
Milis terkait : http://groups.google.com/group/indo-bi
Link knowledge base lainnya : http://www.belajarsql.com.

--
.: Rio Bastian :.

[Rio Bastian]

Maaf ada yg kurang,

di file sessionStartupAction.xml normalnya akan terdiri lebih dari lebih 1 bean dengan class = org.pentaho.platform.engine.core.system.SessionStartupAction

yang perlu di komentari adalah bean yang mengandung property name=actionPath dan value="bi-developers/secure/global-department-list.xaction"

file tersebut ada di dalam BI server Community Edition.

Ada baiknya mba kamelia uninstall versi Enterprise Editionya bila memang sudah tidak dipakai.

regards

2013/1/14 Robiatul Kamelia <robiatul...@gmail.com>

hehe.. salah ya? :D

Schema Workbench

Product Version : 3.2.0.13661
New Features : Access Control, Aggregate Tables
Java : 1.5 and above

BI-SERVER nya: 3.6.0.stable.41852

kenapa ya? bingung saya.. hiks..

[Rio Bastian]

sessionStartupAction.xml di path Pentaho\biserver-ce-3.6.0\biserver-ce\pentaho-solutions\system\

intinya java akan mencari class yg di butuhkan dari kedua jar file tersebut, dan dia akan menggunakan salah satunya,
saran saya remove salah satu, supaya lebih mudah di deteksi bila suatu saat ada error.

regards.

[Robiatul Kamelia]

saya masih bingung.

apa ada tutorial yang detail untuk mengubah BI server ke postgreSQL ?

saya rasa ada yg ga beres itu dari repository nya :(

tapi nggak tau yg mana... 

2013/1/14 Rio Bastian <altan...@gmail.com>

[Rio Bastian]

Masih belum bisa ya errornya, hmm bisa jadi itu bug,

Coba mba kamelia download versi terbaru dari Pentaho BI Server Community Edition dan Schema Mondrian yang support satu sama lain di sini

Untuk driver yang sesuai dengan Versi PostgreSQL yg sedang mba kamelia pakai bisa cek di sini

regards.

2013/1/14 Robiatul Kamelia <robiatul...@gmail.com>

[Robiatul Kamelia]

Terimakasih Pak/Mas Rio Bastian,

saya masih terus berusaha supaya pentaho nya bisa jalan di postgre tanpa bug.

mohon bantuannya ya pak. ini saya masih download. :)

2013/1/15 Rio Bastian <altan...@gmail.com>