Error Occurred While getting Resultset -- di BI Server

[abdi rama]

Dear Pak Feris,

1) Saya mempunyai schema terlampir , dan sudah coba Execute MDX Query :

Query :
select {[Measures].[Nilai]} on columns,
{[Kegiatan].[All Kegiatans]} on rows
from PendapatanOPerasional

Hasil:
Axis #0:
{}
Axis #1:
{[Measures].[Nilai]}
Axis #2:
{[Kegiatan].[All Kegiatans]}
Row #0: 2,147,483,647

2) Dan Juga file Xaction terlampir :

3) Pada waktu coba di-klik di BI Server terdapat error :

Error Occurred While getting Resultset

	An error occurred while rendering Pivot.jsp. Please see the log for details.

4) Dan dari log file ada semacam pesan :
2010-08-13 16:39:25,359 WARN  [org.pentaho.platform.engine.services.runtime.TemplateUtil] not found: [Measures].[Nilai]
2010-08-13 16:39:25,359 WARN  [org.pentaho.platform.engine.services.runtime.TemplateUtil] not found: [Measures].[Nilai]
2010-08-13 16:39:25,359 WARN  [org.pentaho.platform.engine.services.runtime.TemplateUtil] not found: [Measures].[Nilai]
2010-08-13 16:39:25,359 WARN  [org.pentaho.platform.engine.services.runtime.TemplateUtil] not found: [Measures].[Nilai]
2010-08-13 16:39:25,484 DEBUG [mondrian.sql] 19: Segment.load: executing sql [select sum(`fact_aktual`.`rupiah`) as `m0` from `fact_aktual` as `fact_aktual`]
2010-08-13 16:39:25,484 DEBUG [mondrian.sql] 19: , exec+fetch 0 ms, 0 rows

5) Need your help ...

thanks & regards,
abdirama

[Feris Thia]

Dear Pak Abdi,

Sepertinya semua bagus ya. Apakah sudah refresh repository dan schema cachenya dari console portal ?

Selain itu bisa coba lihat potongan pentaho.log nya ? Lokasinya ada di folder [BISERVER]/tomcat/bin .

Semoga membantu Pak..

Regards,

Feris

2010/8/16 abdi rama <abdi...@gmail.com>

Dear Pak Feris,

1) Saya mempunyai schema terlampir , dan sudah coba Execute MDX Query :

Query :
select {[Measures].[Nilai]} on columns,
{[Kegiatan].[All Kegiatans]} on rows
from PendapatanOPerasional

Hasil:
Axis #0:
{}
Axis #1:
{[Measures].[Nilai]}
Axis #2:
{[Kegiatan].[All Kegiatans]}
Row #0: 2,147,483,647

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

[abdi rama]

Dear Pak Feris,

1) Refresh sudah, tapi hasil tetap.
2) Kemudian saya coba langsung di http://localhost/mondrian :
a) mysql connector sudah dicopykan ke
b) di C:\Documents and
Settings\mtcon\Tomcat\apache-tomcat-6.0.18\webapps\mondrian\WEB-INF\queries
-- mondrian.jsp
<%@ 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="com.mysql.jdbc.Driver"
jdbcUrl="jdbc:mysql://localhost/olap_ais"
catalogUri="/WEB-INF/queries/finance.mondrian.xml"
jdbcUser="root" jdbcPassword="" connectionPooling="false">

select
{[Measures].[Nilai]} on columns,

{[Waktu].[All Waktus]} ON rows
from PendapatanOPerasional
</jp:mondrianQuery>

c) error yang muncul :
JPivot had an error ...

org.apache.jasper.JasperException: javax.servlet.ServletException:
javax.servlet.jsp.JspTagException: javax.servlet.jsp.JspException: An
error occurred while evaluating custom action attribute "test" with
value "${query01.result.overflowOccured}": An error occurred while
getting property "result" from an instance of class
com.tonbeller.jpivot.tags.OlapModelProxy
(com.tonbeller.jpivot.olap.model.OlapException:
mondrian.olap.MondrianException: Mondrian Error:Internal error: Error
while executing query [select {[Measures].[Nilai]} ON COLUMNS,
{[Waktu].[All Waktus]} ON ROWS from [PendapatanOperasional] ])

org.apache.jasper.JasperException: javax.servlet.ServletException:
javax.servlet.jsp.JspTagException: javax.servlet.jsp.JspException: An
error occurred while evaluating custom action attribute "test" with
value "${query01.result.overflowOccured}": An error occurred while
getting property "result" from an instance of class
com.tonbeller.jpivot.tags.OlapModelProxy
(com.tonbeller.jpivot.olap.model.OlapException:
mondrian.olap.MondrianException: Mondrian Error:Internal error: Error
while executing query [select {[Measures].[Nilai]} ON COLUMNS,
{[Waktu].[All Waktus]} ON ROWS
from [PendapatanOperasional]
])
at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:522)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
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 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:128)
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:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)
Caused by: javax.servlet.ServletException:
javax.servlet.jsp.JspTagException: javax.servlet.jsp.JspException: An
error occurred while evaluating custom action attribute "test" with
value "${query01.result.overflowOccured}": An error occurred while
getting property "result" from an instance of class
com.tonbeller.jpivot.tags.OlapModelProxy
(com.tonbeller.jpivot.olap.model.OlapException:
mondrian.olap.MondrianException: Mondrian Error:Internal error: Error
while executing query [select {[Measures].[Nilai]} ON COLUMNS,
{[Waktu].[All Waktus]} ON ROWS
from [PendapatanOperasional]
])
at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:852)
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:255)
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:374)
... 20 more
Caused by: javax.servlet.jsp.JspTagException:
javax.servlet.jsp.JspException: An error occurred while evaluating
custom action attribute "test" with value
"${query01.result.overflowOccured}": An error occurred while getting
property "result" from an instance of class
com.tonbeller.jpivot.tags.OlapModelProxy
(com.tonbeller.jpivot.olap.model.OlapException:
mondrian.olap.MondrianException: Mondrian Error:Internal error: Error
while executing query [select {[Measures].[Nilai]} ON COLUMNS,
{[Waktu].[All Waktus]} ON ROWS
from [PendapatanOperasional]
])
at org.apache.taglibs.standard.tag.el.core.IfTag.condition(IfTag.java:65)
at javax.servlet.jsp.jstl.core.ConditionalTagSupport.doStartTag(ConditionalTagSupport.java:122)
at org.apache.jsp.testpage_jsp._jspx_meth_c_005fif_005f1(testpage_jsp.java:1270)
at org.apache.jsp.testpage_jsp._jspService(testpage_jsp.java:187)
... 23 more

d) Saya ikuti saran Pak Feris untuk memperhatikan penggunaan huruf
dalam penamaan tabel atau schema dimana harus kompak, namun masih sama
errornya.

3) Atau ada yang ketinggalan ?

thanks & regarsd,
abdirama

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

-- finance.mondrian.xml

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

Pak Abdi,

Coba saya investigasi dengan sample kecil per siang ini. Tapi, walau agak aneh coba penamaan schema diganti menjadi MTCon misalnya... tanpa spasi di schemanya.

<Schema name="New Schema1"> ==> <Schema name="MTCon">

Semoga membantu Pak..

Regards,

Feris

2010/8/18 abdi rama <abdi...@gmail.com>

org.apache.jasper.JasperException: javax.servlet.ServletException:
javax.servlet.jsp.JspTagException: javax.servlet.jsp.JspException: An
error occurred while evaluating custom action attribute "test" with
value "${query01.result.overflowOccured}": An error occurred while
getting property "result" from an instance of class
com.tonbeller.jpivot.tags.OlapModelProxy
(com.tonbeller.jpivot.olap.model.OlapException:
mondrian.olap.MondrianException: Mondrian Error:Internal error: Error
while executing query [select {[Measures].[Nilai]} ON COLUMNS,
 {[Waktu].[All Waktus]} ON ROWS
from [PendapatanOperasional]

[abdi rama]

Dear Pak Feris,

1) Saran perubahan nama schema -- tak 'effect'
2) Ternyata setelah saya rubah struktur database fact_rupiah untuk
field rupiah dari decimal 16,0 menjadi 20,0 ---- akhirnya muncul juga
3) Anyway, matur suwun Pak Feris -- nanti tanya yang lain ya ...

thanks & regards,
abdirama

On 8/18/10, Feris Thia <fe...@phi-integration.com> wrote:

[fe...@axis.blackberry.com]

Dear Pak Abdi,

Wah... "Temuan" baru lagi nih. Jadi penasaran juga :)

Btw Pak, terima kasih atas sharing berguna ini.

Regards,

Feris
Sent from my AXIS Worry Free BlackBerry® smartphone

[Feris Thia]

Dear Pak Abdi,

2010/8/18 abdi rama <abdi...@gmail.com> 

 

2) Ternyata setelah saya rubah struktur database fact_rupiah untuk
field rupiah dari decimal 16,0 menjadi 20,0 ---- akhirnya muncul juga

Agak penasaran.. jika dibalikkan kembali ke decimal(16,0) dan melakukan select query :

select sum(Nilai) from fact_rupiah

Apakah normal ?

 

3) Anyway, matur suwun Pak Feris -- nanti tanya yang lain ya ...

Sip Pak ;)

 

thanks & regards,
abdirama

[abdi rama]

Dear Pak Feris,

1) Sorry, kemarin sudah saya rubah-rubah lagi karena ada perhitungan yang salah
2) Namun pernah saya lihat di pentaho.log yang lama (sorry lagi, sudah
saya emptykan juga) ada informasi terkait dengan nilai integer yang
'over' pada waktu kalkulasi sum()
3) Barusan struktur saya kembalikan ke decimal 16,0 dengan data
olap_ais yang baru ternyata berjalan normal.
4) Kesimpulan : kemungkinan terkait dengan kalkulasi sum() yang tidak normal.

On 8/18/10, Feris Thia <fe...@phi-integration.com> wrote:

[Feris Thia]

Hi Pak Abdi,

Terima kasih atas infonya. Akan saya coba trace dengan contoh database PHI-Minimart dengan tipe data tersebut. Kalau boleh tahu MySQL versi berapa Pak ?

2010/8/19 abdi rama <abdi...@gmail.com>

2) Namun pernah saya lihat di pentaho.log yang lama (sorry lagi, sudah
saya emptykan juga) ada informasi terkait  dengan nilai integer yang
'over' pada waktu kalkulasi sum()

[abdi rama]

Hi juga Pak Feris,

Mysql versi 5.1.4

thanks & regards,
abdirama

2010/8/19 Feris Thia <fe...@phi-integration.com>

--

[Feris Thia]

Dear Pak Abdi,

Terima kasih atas infonya. Akan saya coba reproduce :)

2010/8/24 abdi rama <abdi...@gmail.com>

Hi juga Pak Feris,

Mysql versi 5.1.4

thanks & regards,
abdirama

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