AnsweredAssumed Answered

Problem publishing report with parameter

Question asked by Ignacio Fdez on Jun 25, 2018
Latest reply on Jun 26, 2018 by Ignacio Fdez

When i try to pulish a report on my server i show this error

 

10:11:09,450 ERROR [AbstractReportProcessor] 1843824525: Report processing failed.

org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT t1.idusuario

FROM cdl2.PED_pedido t1 where T1.FECHA > sysdate - ${numDias}

and T1.IDTIENDA in (1,8,15,1136,15136)

        at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFa

ctory.java:184)

       ........................

       ............................

Caused by: java.sql.SQLFeatureNotSupportedException: Funci├│n no soportada: checkValidIndex

        at oracle.jdbc.driver.OracleParameterMetaData.checkValidIndex(OracleParameterMetaData.java:196)

        at oracle.jdbc.driver.OracleParameterMetaData.getParameterClassName(OracleParameterMetaData.java:346)

        at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.parametrize(SimpleSQLReportData

Factory.java:356)

        at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.parametrizeAndQuery(SimpleSQLRe

portDataFactory.java:277)

        at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFa

Outcomes