Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Problems with SubReport and Jdbc DB2

  1. #1

    Question Problems with SubReport and Jdbc DB2

    Hello Pentahos...

    Hi Friends I am problems with the subreports in pentaho-demo 1.6, when I execute my action apears the error below ! but i tried to execute in POSTGRESQL and no apears errors ... my query is Ok !!

    I try too to atualize my drives jdbc in pentaho, but I have still errors...

    Can you Help me ??
    thanks




    13:31:27,809 ERROR [SQLLookupRule] Error end:
    13:31:27,819 ERROR [SQLLookupRule] Error Start: Pentaho Pentaho BI Platform 1.6.
    0.GA.863
    13:31:27,819 ERROR [SQLLookupRule] bb03da18-8826-11de-8138-612bc57afa16:COMPONEN
    T:context-10002790-1250181079542:Carteira_CONST.xaction[pt_103] SQLBaseComponent
    .ERROR_0006 - [pt_122] Could not execute Carteira_CONST.xaction
    com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-954, SQLSTATE=57011, SQ
    LERRMC=null, DRIVER=4.7.85
    at com.ibm.db2.jcc.am.dd.a(dd.java:679)
    at com.ibm.db2.jcc.am.dd.a(dd.java:60)
    at com.ibm.db2.jcc.am.dd.a(dd.java:127)
    at com.ibm.db2.jcc.am.nm.c(nm.java:2493)
    at com.ibm.db2.jcc.t4.db.o(db.java:829)
    at com.ibm.db2.jcc.t4.db.g(db.java:142)
    at com.ibm.db2.jcc.t4.db.a(db.java:39)
    at com.ibm.db2.jcc.t4.t.a(t.java:32)
    at com.ibm.db2.jcc.t4.sb.h(sb.java:135)
    at com.ibm.db2.jcc.am.nm.gb(nm.java:1921)
    at com.ibm.db2.jcc.am.om.kc(om.java:2806)
    at com.ibm.db2.jcc.am.om.qc(om.java:2921)
    at com.ibm.db2.jcc.am.om.setObject(om.java:1738)
    at org.pentaho.data.connection.sql.SQLConnection.prepareAndExecuteQuery(
    SQLConnection.java:253)
    at org.pentaho.plugin.sql.SQLBaseComponent.executePrepared(SQLBaseCompon
    ent.java:493)
    at org.pentaho.plugin.jfreereport.helper.PentahoTableDataFactory.queryDa
    ta(PentahoTableDataFactory.java:115)
    at org.jfree.report.states.CachingDataFactory.queryData(CachingDataFacto
    ry.java:286)
    at org.jfree.report.states.datarow.ReportDataRow.createDataRow(ReportDat
    aRow.java:89)
    at org.jfree.report.states.datarow.DefaultFlowController.performSubRepor
    tQuery(DefaultFlowController.java:206)
    at org.jfree.report.states.process.ProcessState.<init>(ProcessState.java
    :120)
    at org.jfree.report.states.process.BeginGroupHandler.commit(BeginGroupHa
    ndler.java:51)
    at org.jfree.report.states.process.ProcessState.commit(ProcessState.java
    :290)
    at org.jfree.report.layout.output.AbstractReportProcessor.processPaginat
    ionLevel(AbstractReportProcessor.java:708)
    at org.jfree.report.layout.output.AbstractReportProcessor.prepareReportP
    rocessing(AbstractReportProcessor.java:426)
    at org.jfree.report.layout.output.AbstractReportProcessor.processReport(
    AbstractReportProcessor.java:977)
    at org.pentaho.plugin.jfreereport.outputs.JFreeReportPdfComponent.perfor
    mExport(JFreeReportPdfComponent.java:53)
    at org.pentaho.plugin.jfreereport.outputs.AbstractGenerateStreamContentC
    omponent.performExport(AbstractGenerateStreamContentComponent.java:67)
    at org.pentaho.plugin.jfreereport.outputs.AbstractGenerateContentCompone
    nt.executeAction(AbstractGenerateContentComponent.java:135)
    at org.pentaho.plugin.ComponentBase.execute(ComponentBase.java:454)
    at org.pentaho.plugin.jfreereport.outputs.JFreeReportAllContentComponent
    .executeAction(JFreeReportAllContentComponent.java:46)
    at org.pentaho.plugin.ComponentBase.execute(ComponentBase.java:454)
    at org.pentaho.plugin.jfreereport.JFreeReportComponent.executeReportActi
    on(JFreeReportComponent.java:204)
    at org.pentaho.plugin.jfreereport.JFreeReportComponent.executeAction(JFr
    eeReportComponent.java:135)
    at org.pentaho.plugin.ComponentBase.execute(ComponentBase.java:454)
    at org.pentaho.core.runtime.RuntimeContext.executeComponent(RuntimeConte
    xt.java:1122)
    at org.pentaho.core.runtime.RuntimeContext.executeAction(RuntimeContext.
    java:1094)
    at org.pentaho.core.runtime.RuntimeContext.performActions(RuntimeContext
    .java:1006)
    at org.pentaho.core.runtime.RuntimeContext.executeLoop(RuntimeContext.ja
    va:961)
    at org.pentaho.core.runtime.RuntimeContext.executeSequence(RuntimeContex
    t.java:864)
    at org.pentaho.core.runtime.RuntimeContext.executeSequence(RuntimeContex
    t.java:768)
    at org.pentaho.core.solution.SolutionEngine.executeInternal(SolutionEngi
    ne.java:333)
    at org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:
    241)
    at org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:
    169)
    at org.pentaho.core.services.BaseRequestHandler.handleActionRequest(Base
    RequestHandler.java:150)
    at org.pentaho.ui.servlet.ViewAction.handleActionRequest(ViewAction.java
    :139)
    at org.pentaho.ui.servlet.ViewAction.doGet(ViewAction.java:261)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
    icationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:206)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:264)
    at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(Filt
    erSecurityInterceptor.java:107)
    at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(Fi
    lterSecurityInterceptor.java:72)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTra
    nslationFilter.java:110)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(S
    witchUserProcessingFilter.java:335)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFi
    lter.java:76)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFil
    ter(AnonymousProcessingFilter.java:125)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(R
    ememberMeProcessingFilter.java:142)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(Re
    questParameterAuthenticationFilter.java:164)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicPr
    ocessingFilter.java:178)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProces
    singFilter.java:217)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:1
    08)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSes
    sionReuseDetectionFilter.java:130)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilte
    r(HttpSessionContextIntegrationFilter.java:193)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doF
    ilter(SecurityContextHolderAwareRequestFilter.java:81)
    at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(F
    ilterChainProxy.java:274)
    at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.jav
    a:148)
    at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.j
    ava:98)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
    icationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:206)
    at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilte
    r.java:53)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
    icationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:206)
    at org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharact
    erEncodingFilter.java:112)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
    icationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:206)
    at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi
    lter.java:96)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
    icationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
    alve.java:230)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
    alve.java:175)
    at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit
    yAssociationValve.java:179)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
    at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
    at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
    at java.lang.Thread.run(Thread.java:619)
    Thiago
    Polos IT- System Analyst

  2. #2
    Join Date
    Mar 2003
    Posts
    8,085

    Default

    Well, what does your DB2 manual say about these Error codes?

    DB2 SQL Error: SQLCODE=-954, SQLSTATE=57011, SQLERRMC=null, DRIVER=4.7.85
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.