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
Ignacio, this is a known error that can be found here: [PRD-6006] Regression: SQL queries with parameters broken in PRD - Pentaho Platform Tracking . If you are using the EE version, the fix is available in 8.0.0.6 or 8.1.0.1.