Tanya eror mondrian..

53 views
Skip to first unread message

Rudi Yanto

unread,
Jan 18, 2011, 5:56:19 AM1/18/11
to penta...@googlegroups.com
Sore pak Feris,

Mau tanya, saya lagi coba lihat hasil tes yang saya buat dari schema workbench, dangan melihat di tomcat.
Lalu muncul seperti ini, kenapa ya ?

file Jsp nya isinya seperti ini :
<%@ page session="true" contentType="text/html; charset=ISO-8859-1" %>
<%@ taglib uri="http://www.tonbeller.com/jpivot" prefix="jp" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %>

<jp:mondrianQuery id="query01" jdbcDriver="net.sourceforge.jtds.jdbc.Driver"
jdbcUrl="jdbc:jtds:sqlserver://localhost/d_warehouse" catalogUri="/sales.xml"
   jdbcUser="sa" jdbcPassword="teamver3.0" connectionPooling="false">
  
SELECT {[Measures].[qty]} ON COLUMNS,
{[sales].[Semua sales]} ON ROWS
FROM SALES
</jp:mondrianQuery>



<c:set var="title01" scope="session">Test Query uses Mondrian OLAP</c:set>

lalu erornya :


JPivot had an error ...

org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: java.lang.NullPointerException

org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: java.lang.NullPointerException
	at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:491)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401)
	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.RequestFilter.doFilter(RequestFilter.java:264)
	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: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:662)
Caused by: javax.servlet.ServletException: javax.servlet.jsp.JspException: org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: java.lang.NullPointerException
	at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
	at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
	at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:246)
	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)
	... 19 more
Caused by: org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: java.lang.NullPointerException
	at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:527)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401)
	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.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
	at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)
	at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)
	at com.tonbeller.wcf.utils.IncludeTag.doStartTag(IncludeTag.java:59)
	at org.apache.jsp.testpage_jsp._jspx_meth_wcf_005finclude_005f0(testpage_jsp.java:269)
	at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:126)
	... 22 more
Caused by: javax.servlet.ServletException: javax.servlet.jsp.JspException: java.lang.NullPointerException
	at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
	at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
	at org.apache.jsp.WEB_002dINF.queries.mondrian_jsp._jspService(mondrian_jsp.java:85)
	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)
	... 33 more
Caused by: java.lang.NullPointerException
	at com.tonbeller.jpivot.tags.MondrianOlapModelTag.getOlapModel(MondrianOlapModelTag.java:56)
	at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:62)
	at org.apache.jsp.WEB_002dINF.queries.mondrian_jsp._jspx_meth_jp_005fmondrianQuery_005f0(mondrian_jsp.java:135)
	at org.apache.jsp.WEB_002dINF.queries.mondrian_jsp._jspService(mondrian_jsp.java:69)
	... 36 more

javax.servlet.ServletException: javax.servlet.jsp.JspException: org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: java.lang.NullPointerException

javax.servlet.ServletException: javax.servlet.jsp.JspException: org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: java.lang.NullPointerException
	at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
	at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
	at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:246)
	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.RequestFilter.doFilter(RequestFilter.java:264)
	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: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:662)
Caused by: org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: java.lang.NullPointerException
	at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:527)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401)
	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.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
	at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)
	at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)
	at com.tonbeller.wcf.utils.IncludeTag.doStartTag(IncludeTag.java:59)
	at org.apache.jsp.testpage_jsp._jspx_meth_wcf_005finclude_005f0(testpage_jsp.java:269)
	at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:126)
	... 22 more
Caused by: javax.servlet.ServletException: javax.servlet.jsp.JspException: java.lang.NullPointerException
	at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
	at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
	at org.apache.jsp.WEB_002dINF.queries.mondrian_jsp._jspService(mondrian_jsp.java:85)
	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)
	... 33 more
Caused by: java.lang.NullPointerException
	at com.tonbeller.jpivot.tags.MondrianOlapModelTag.getOlapModel(MondrianOlapModelTag.java:56)
	at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:62)
	at org.apache.jsp.WEB_002dINF.queries.mondrian_jsp._jspx_meth_jp_005fmondrianQuery_005f0(mondrian_jsp.java:135)
	at org.apache.jsp.WEB_002dINF.queries.mondrian_jsp._jspService(mondrian_jsp.java:69)
	... 36 more

org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: java.lang.NullPointerException

org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: java.lang.NullPointerException
	at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:527)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401)
	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.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
	at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)
	at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)
	at com.tonbeller.wcf.utils.IncludeTag.doStartTag(IncludeTag.java:59)
	at org.apache.jsp.testpage_jsp._jspx_meth_wcf_005finclude_005f0(testpage_jsp.java:269)
	at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:126)
	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.RequestFilter.doFilter(RequestFilter.java:264)
	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: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:662)
Caused by: javax.servlet.ServletException: javax.servlet.jsp.JspException: java.lang.NullPointerException
	at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
	at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
	at org.apache.jsp.WEB_002dINF.queries.mondrian_jsp._jspService(mondrian_jsp.java:85)
	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)
	... 33 more
Caused by: java.lang.NullPointerException
	at com.tonbeller.jpivot.tags.MondrianOlapModelTag.getOlapModel(MondrianOlapModelTag.java:56)
	at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:62)
	at org.apache.jsp.WEB_002dINF.queries.mondrian_jsp._jspx_meth_jp_005fmondrianQuery_005f0(mondrian_jsp.java:135)
	at org.apache.jsp.WEB_002dINF.queries.mondrian_jsp._jspService(mondrian_jsp.java:69)
	... 36 more

javax.servlet.ServletException: javax.servlet.jsp.JspException: java.lang.NullPointerException

javax.servlet.ServletException: javax.servlet.jsp.JspException: java.lang.NullPointerException
	at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
	at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
	at org.apache.jsp.WEB_002dINF.queries.mondrian_jsp._jspService(mondrian_jsp.java:85)
	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.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
	at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)
	at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)
	at com.tonbeller.wcf.utils.IncludeTag.doStartTag(IncludeTag.java:59)
	at org.apache.jsp.testpage_jsp._jspx_meth_wcf_005finclude_005f0(testpage_jsp.java:269)
	at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:126)
	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.RequestFilter.doFilter(RequestFilter.java:264)
	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: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:662)
Caused by: java.lang.NullPointerException
	at com.tonbeller.jpivot.tags.MondrianOlapModelTag.getOlapModel(MondrianOlapModelTag.java:56)
	at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:62)
	at org.apache.jsp.WEB_002dINF.queries.mondrian_jsp._jspx_meth_jp_005fmondrianQuery_005f0(mondrian_jsp.java:135)
	at org.apache.jsp.WEB_002dINF.queries.mondrian_jsp._jspService(mondrian_jsp.java:69)
	... 36 more

java.lang.NullPointerException

java.lang.NullPointerException
	at com.tonbeller.jpivot.tags.MondrianOlapModelTag.getOlapModel(MondrianOlapModelTag.java:56)
	at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:62)
	at org.apache.jsp.WEB_002dINF.queries.mondrian_jsp._jspx_meth_jp_005fmondrianQuery_005f0(mondrian_jsp.java:135)
	at org.apache.jsp.WEB_002dINF.queries.mondrian_jsp._jspService(mondrian_jsp.java:69)
	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.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
	at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)
	at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)
	at com.tonbeller.wcf.utils.IncludeTag.doStartTag(IncludeTag.java:59)
	at org.apache.jsp.testpage_jsp._jspx_meth_wcf_005finclude_005f0(testpage_jsp.java:269)
	at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:126)
	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.RequestFilter.doFilter(RequestFilter.java:264)
	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: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:662)

        
Terima Kasih 
Rudi Yanto

Ali Gunawan

unread,
Jan 19, 2011, 1:41:52 AM1/19/11
to penta...@googlegroups.com
Dear Pak Feris,
 
    boleh tahu cara setting primary key di Spoon ? sy cek di table output nya tidak ada setting utk tentukan primary key nya ? dan pertanyaan sy primary key apakah perlu di setting ? kalau di setting itu SK nya atau kode nya yg menjadi primary key
 
thxs
  Ali G

Feris Thia

unread,
Jan 22, 2011, 1:19:56 AM1/22/11
to penta...@googlegroups.com
Dear Pak Ali,

Spoon hanya membantu untuk mendeteksi DDL... tidak bisa otomatis membuat primary key kecuali beberapa step tertentu seperti Dimension Lookup / Update atau step Insert/Update.

SK harus primary.

Regards,

Feris

2011/1/19 Ali Gunawan <gunl...@gmail.com>



--
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



Feris Thia

unread,
Jan 22, 2011, 1:32:10 AM1/22/11
to penta...@googlegroups.com
Siang Pak Rudi,

Saya sudah dapat schemanya juga. Mohon maaf, minggu ini agak repot memang.. akan saya coba lihat detilnya. Dari schema workbench sudah lancar ya eksekusi MDX nya ?

Regards,

Feris


On Tue, Jan 18, 2011 at 5:56 PM, Rudi Yanto <rhuddi...@gmail.com> wrote:
Sore pak Feris,

Mau tanya, saya lagi coba lihat hasil tes yang saya buat dari schema workbench, dangan melihat di tomcat.
Lalu muncul seperti ini, kenapa ya ?

file Jsp nya isinya seperti ini :
<%@ page session="true" contentType="text/html; charset=ISO-8859-1" %>
<%@ taglib uri="http://www.tonbeller.com/jpivot" prefix="jp" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %>

<jp:mondrianQuery id="query01" jdbcDriver="net.sourceforge.jtds.jdbc.Driver"
jdbcUrl="jdbc:jtds:sqlserver://localhost/d_warehouse" catalogUri="/sales.xml"
   jdbcUser="sa" jdbcPassword="teamver3.0" connectionPooling="false">
  
SELECT {[Measures].[qty]} ON COLUMNS,
{[sales].[Semua sales]} ON ROWS
FROM SALES
</jp:mondrianQuery>



<c:set var="title01" scope="session">Test Query uses Mondrian OLAP</c:set>

lalu erornya :



Ali Gunawan

unread,
Jan 23, 2011, 9:18:36 PM1/23/11
to penta...@googlegroups.com
Thxs Pak Feris,
 
    jadi pertanyaan saya untuk memakai PAD semua table dimensi dan fact table harus ada PK nya ? dan spoon tidak bisa set primary key kecuali menggunakan Dimensi Lookup / update ?
 
kalau sudah jalankan PAD itu akan membentuk table table pembantu yg secara otomatis di create ? apa itu akan meningkatkan perfomance pak ?
dan anehnya walau error PK tetap saja bisa dibuatkan table pembantunya ? apa itu tidak masalah ?
 
sorry pak banyak tanya
 
rgds
   Ali G

From: penta...@googlegroups.com [mailto:penta...@googlegroups.com] On Behalf Of Feris Thia
Sent: Saturday, January 22, 2011 1:20 PM
To: penta...@googlegroups.com
Subject: Re: [pentaho-id] Setting Primary key di Spoon

--
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.
Milis terkait : http://groups.google.com/group/indo-bi

Feris Thia

unread,
Jan 23, 2011, 9:36:00 PM1/23/11
to penta...@googlegroups.com
Hi Pak Ali,

2011/1/24 Ali Gunawan <gunl...@gmail.com>

Thxs Pak Feris,
 
    jadi pertanyaan saya untuk memakai PAD semua table dimensi dan fact table harus ada PK nya ?

Untuk dimension iya, untuk fact table tentu saja tidak harus.

 
dan spoon tidak bisa set primary key kecuali menggunakan Dimensi Lookup / update ?

Ya, Spoon adalah helper yang baik. Bukan tools untuk merancang model database yang baik. Dan dimension lookup / update kebetulan bisa menerapkan rule PK creation karena nature dari kasus Slowly Changing Dimension (SCD).
 
 
kalau sudah jalankan PAD itu akan membentuk table table pembantu yg secara otomatis di create ? apa itu akan meningkatkan perfomance pak ?


 
dan anehnya walau error PK tetap saja bisa dibuatkan table pembantunya ? apa itu tidak masalah ?

Tidak masalah Pak. 
 
 
sorry pak banyak tanya
 
rgds
   Ali G

Ali Gunawan

unread,
Jan 23, 2011, 10:07:33 PM1/23/11
to penta...@googlegroups.com
From: penta...@googlegroups.com [mailto:penta...@googlegroups.com] On Behalf Of Feris Thia
Sent: Monday, January 24, 2011 9:36 AM

To: penta...@googlegroups.com
Subject: Re: [pentaho-id] Setting Primary key di Spoon

Hi Pak Ali,

2011/1/24 Ali Gunawan <gunl...@gmail.com>
Thxs Pak Feris,
 
    jadi pertanyaan saya untuk memakai PAD semua table dimensi dan fact table harus ada PK nya ?

Untuk dimension iya, untuk fact table tentu saja tidak harus.
- -> Ok Clear :) 
 
dan spoon tidak bisa set primary key kecuali menggunakan Dimensi Lookup / update ?

Ya, Spoon adalah helper yang baik. Bukan tools untuk merancang model database yang baik. Dan dimension lookup / update kebetulan bisa menerapkan rule PK creation karena nature dari kasus Slowly Changing Dimension (SCD).
--> Jelas
 
kalau sudah jalankan PAD itu akan membentuk table table pembantu yg secara otomatis di create ? apa itu akan meningkatkan perfomance pak ?

Kalau dikonfigurasi di mondrian.properties. Baca dokumentasinya di :


 
dan anehnya walau error PK tetap saja bisa dibuatkan table pembantunya ? apa itu tidak masalah ?

Tidak masalah Pak. 
 
 
sorry pak banyak tanya
 
rgds
   Ali G



--
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