PDA

View Full Version : how to publish metadata into BI server?



wasabi
04-09-2009, 04:07 PM
I download Pentaho and it's up and running in my XP machine. But, I don't install the sample data from hsqldb. Instead, I use metadata editor to create a new business view by connecting to the oracle server. Very simple, just one table, then save this domain as tst_promotion_info. Then I want to publish to server.

I am getting the error while trying to publish metadata into the server.

says unable to save file (metadata.xmi) to server. Correct any server, id or password errors and try again.

Details given.

publish location: samples
Web Publish URL: http://localhost:8080/pentaho/RepositoryFilePublisher (http://localhost:8080/pentaho/RepositoryFilePublisher)
(also tried http://localhost:8080/pentaho/ (http://localhost:8080/pentaho/RepositoryFilePublisher)
and
http://localhost:18080/pentaho/RepositoryFilePublisher (http://localhost:8080/pentaho/RepositoryFilePublisher)
and
http://localhost:18080/pentaho/ (http://localhost:8080/pentaho/RepositoryFilePublisher)
)
Publish Password: password ( as provided in biserver-ce\pentaho-solutions\system\publisher_config.xml )
Server Userid: edwardc ( tried both joe and admin )
Server Password: password

I have the error message popped up when I use port 18080, and when I use port 8080, no error message, but I don't see business model loaded in BI.

I am confused which port I should use 18080 or 8080. Also, when I click on http://localhost:8080/, (http://localhost:8080/pentaho/RepositoryFilePublisher)I don't see any thing "...Failed to Connect..."
When I click on http://localhost:18080/pentaho/RepositoryFilePublisher, (http://localhost:8080/pentaho/RepositoryFilePublisher)
I login and I see a blank page except number 2 on the page

help how to publish metadata to BI Server.

Many Thanks,


Edward

pstoellberger
04-10-2009, 04:33 AM
Usually you need:

Publish location: bi-developers
Publish URL: http://localhost:8080/pentaho/RepositoryFilePublisher
Publish password: (as in system/publisher_config.xml)
Userid: joe
Password: password

When you create the Business model/view you need to make sure that you set permissions on that, otherwise you won't see anything in the user console. See http://wiki.pentaho.com/display/ServerDoc2x/05.+Adding+Security+to+Metadata+Business+Objects for details

Once you've published your business model log into the user console and do a Tools > Refresh > Reporting Metadata and Solution Repository

wasabi
04-10-2009, 11:23 AM
It still doesn't work. I followed your steps and I don't see any error popped up. But when I open user console, there is still no business model there even I refresh. In your documentation for setting up security service, I cannot open my http://localhost:8080/pentaho or http://localhost:8080/pentaho/ServiceAction
I have the following error

Failed to Connect
Firefox can't establish a connection to the server at localhost:8080.
Though the site seems valid, the browser was unable to establish a connection.

* Could the site be temporarily unavailable? Try again later.
* Are you unable to browse other sites? Check the computer's network connection.
* Is your computer or network protected by a firewall or proxy? Incorrect settings can interfere with Web browsing.


It seems I need to set up something for http://localhost:8080/pentaho and make it up and running, right? If so, how? It seems this is Tomcat

Please help again.

karthikeyan
04-13-2009, 10:06 PM
am getting the same error while trying to publish metadata into the server.

as posted last week with details in http://forums.pentaho.org/showthread.php?t=54720

says unable to save file (metadata.xmi) to server. Correct any server, id or password errors and try again.

Details given.

publish location: samples
Web Publish URL: http://localhost:8080/pentaho/RepositoryFilePublisher
Publish Password: password ( as provided in biserver-ce\pentaho-solutions\system\publisher_config.xml )
Server Userid: joe ( tried both joe and admin )
Server Password: password


Pls. help how to publish metadata to BI Server.

Many Thanks,

Regards,
Karthik

am getting the below error while trying to publish.

java.lang.NullPointerException
at java.io.FileOutputStream.write(Unknown Source)
at org.pentaho.platform.repository.solution.dbbased.D bBasedSolutionRepository.publishIcon(DbBasedSoluti onRepository.java:733)
at org.pentaho.platform.repository.solution.dbbased.D bBasedSolutionRepository.addIndexToRepository(DbBa sedSolutionRepository.java:521)
at org.pentaho.platform.repository.solution.dbbased.D bBasedSolutionRepository.processDir(DbBasedSolutio nRepository.java:322)
at org.pentaho.platform.repository.solution.dbbased.D bBasedSolutionRepository.loadSolutionPath(DbBasedS olutionRepository.java:233)
at org.pentaho.platform.repository.solution.dbbased.D bBasedSolutionRepository.getCachedSolutionDocument (DbBasedSolutionRepository.java:279)
at org.pentaho.platform.repository.solution.dbbased.D bBasedSolutionRepository.getSolutions(DbBasedSolut ionRepository.java:748)
at org.pentaho.platform.repository.solution.SolutionR epositoryBase.getSolutions(SolutionRepositoryBase. java:517)
at org.pentaho.platform.engine.services.metadata.Meta dataPublisher.loadAllMetadata(MetadataPublisher.ja va:102)
at org.pentaho.platform.engine.services.metadata.Meta dataPublisher.publish(MetadataPublisher.java:76)
at org.pentaho.platform.engine.core.system.BasePublis her.publish(BasePublisher.java:36)
at org.pentaho.platform.engine.core.system.PentahoSys tem.publish(PentahoSystem.java:796)
at org.apache.jsp.jsp.Publish_jsp._jspService(Publish _jsp.java:88)
at org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
at org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:331)
at org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:329)
at org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:188)
at org.acegisecurity.util.FilterChainProxy$VirtualFil terChain.doFilter(FilterChainProxy.java:265)
at org.acegisecurity.intercept.web.FilterSecurityInte rceptor.invoke(FilterSecurityInterceptor.java:107)
at org.acegisecurity.intercept.web.FilterSecurityInte rceptor.doFilter(FilterSecurityInterceptor.java:72 )
at org.acegisecurity.util.FilterChainProxy$VirtualFil terChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.ExceptionTranslationFilter.do Filter(ExceptionTranslationFilter.java:124)
at org.acegisecurity.util.FilterChainProxy$VirtualFil terChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.switchuser.SwitchUserProcessi ngFilter.doFilter(SwitchUserProcessingFilter.java: 341)
at org.acegisecurity.util.FilterChainProxy$VirtualFil terChain.doFilter(FilterChainProxy.java:275)
at org.pentaho.platform.web.http.security.SecuritySta rtupFilter.doFilter(SecurityStartupFilter.java:85)
at org.acegisecurity.util.FilterChainProxy$VirtualFil terChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.providers.anonymous.AnonymousPro cessingFilter.doFilter(AnonymousProcessingFilter.j ava:125)
at org.acegisecurity.util.FilterChainProxy$VirtualFil terChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.rememberme.RememberMeProcessi ngFilter.doFilter(RememberMeProcessingFilter.java: 142)
at org.acegisecurity.util.FilterChainProxy$VirtualFil terChain.doFilter(FilterChainProxy.java:275)
at org.pentaho.platform.web.http.security.RequestPara meterAuthenticationFilter.doFilter(RequestParamete rAuthenticationFilter.java:169)
at org.acegisecurity.util.FilterChainProxy$VirtualFil terChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.basicauth.BasicProcessingFilt er.doFilter(BasicProcessingFilter.java:174)
at org.acegisecurity.util.FilterChainProxy$VirtualFil terChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.AbstractProcessingFilter.doFi lter(AbstractProcessingFilter.java:271)
at org.acegisecurity.util.FilterChainProxy$VirtualFil terChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.logout.LogoutFilter.doFilter( LogoutFilter.java:110)
at org.acegisecurity.util.FilterChainProxy$VirtualFil terChain.doFilter(FilterChainProxy.java:275)
at org.pentaho.platform.web.http.security.HttpSession ReuseDetectionFilter.doFilter(HttpSessionReuseDete ctionFilter.java:134)
at org.acegisecurity.util.FilterChainProxy$VirtualFil terChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.context.HttpSessionContextIntegr ationFilter.doFilter(HttpSessionContextIntegration Filter.java:249)
at org.acegisecurity.util.FilterChainProxy$VirtualFil terChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.wrapper.SecurityContextHolderAwa reRequestFilter.doFilter(SecurityContextHolderAwar eRequestFilter.java:81)
at org.acegisecurity.util.FilterChainProxy$VirtualFil terChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.util.FilterChainProxy.doFilter(F ilterChainProxy.java:149)
at org.acegisecurity.util.FilterToBeanProxy.doFilter( FilterToBeanProxy.java:98)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:188)
at org.pentaho.platform.web.http.filters.ProxyTrustin gFilter.doFilter(ProxyTrustingFilter.java:192)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:188)
at org.pentaho.platform.web.http.filters.SystemStatus Filter.doFilter(SystemStatusFilter.java:60)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:188)
at org.pentaho.platform.web.http.filters.SetCharacter EncodingFilter.doFilter(SetCharacterEncodingFilter .java:113)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:174)
at org.apache.catalina.authenticator.AuthenticatorBas e.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.invok e(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11 ConnectionHandler.processConnection(Http11BaseProt ocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.process Socket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThr ead.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Unknown Source):rolleyes: