[Logo] SpagoWorld Forums
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
[Groups] Back to home page  [Moderation Log] Moderation Log   [Register] Register /  [Login] Login 
Installing JPivot Engine  XML
Forum Index » Technical Help - SpagoBI Server - OLAP
Author Message
rjusher.spw

Newby

Joined: 25/08/2010 03:50:17
Messages: 12
Offline

I am currently running in a Ubuntu 10.04, installed tomcat6 from the repository (apt-get install tomcat6).

Then i downloaded all the engines for SpagoBI 2.6 to function, extracted the files to the webapps directory, installed the metadata.

So i start SpagoBI by going to http://localhost:8080/SpagoBI, and everything works ok, i can log in, create datasources, datasets, functionalities and documents.

After that i extracted the SpagoBIJPivotEngine in the webapps folder, after that i test the engine in the engine definition and it responds that everything is ok.

I create the foodmart datasource and it responds that everything is ok.

So after that i create a new document as a OLAP document, then i press the template button, after that it asks wich Schema to work with, i click ok, and then it gives the following error.

org.apache.jasper.JasperException: java.lang.NullPointerException

org.apache.jasper.JasperException: java.lang.NullPointerException
at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:491)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:419)
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 com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139)
at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)
at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.utilities.filters.EngineCheckSessionFilter.doFilter(EngineCheckSessionFilter.java:107)
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.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:29
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:58
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:636)
Caused by: java.lang.NullPointerException
at org.apache.jsp.editQuery_jsp._jspService(editQuery_jsp.java:233)
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)
... 23 more

java.lang.NullPointerException

java.lang.NullPointerException
at org.apache.jsp.editQuery_jsp._jspService(editQuery_jsp.java:233)
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 com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139)
at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)
at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.utilities.filters.EngineCheckSessionFilter.doFilter(EngineCheckSessionFilter.java:107)
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.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:29
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:58
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:636)

So at the end i cannot get the JPivotEngine to work, am i doing something wrong in the installation of the engine
dzerbett

SpagoBI supporter
[Avatar]

Joined: 08/07/2010 15:33:02
Messages: 151
Offline

Hi!
the document's template seems to be not correct. How does it look like?
Did you create it using the web interface or did you create it by hand and uploaded it into document's detail page?
You did not mention the OLAP schema... did you create it? if not, read at https://wiki.spagobi.org/xwiki/bin/view/spagobi_server/JPivot (Document template creation).
Hope this help.
Regards
Davide
rjusher.spw

Newby

Joined: 25/08/2010 03:50:17
Messages: 12
Offline

Thank you Davide,

This problem occurs when i try to use the web tool, to create the schema, the schema creator never comes up, it give me this errors.

Because I couldn't create the document from the web tool, i then copied the template from the demo version of SpagoBI, so i guess this is a correct document. But i am not 100% sure.

I even tried, instead of creating the document from the template creator, try to create the template with Schema Workbench and then upload it, but when i try to save the document i get "Generic error", but this error does not show any log information, so it is not telling me what might the problem be.

rjusher.spw

Newby

Joined: 25/08/2010 03:50:17
Messages: 12
Offline

I'm guessing here but i believe the problem might be that SpagoBI is not able to access the definition document.

I think it is because of a bad configuration of the resource folder, and its permissions.
rjusher.spw

Newby

Joined: 25/08/2010 03:50:17
Messages: 12
Offline

I think it was due to Ubuntu, because i did the installation in a XP Professional machine and it worked wonderfully, thanx anyway.

 
Forum Index » Technical Help - SpagoBI Server - OLAP
Go to:   
Powered by JForum 2.1.9 © JForum Team