AnsweredAssumed Answered

No able to create a SQL with oracle and pentaho 8.1

Question asked by ashdam dourden on May 21, 2018
Latest reply on May 24, 2018 by Matthew Carter

We are migrating to Pentaho 8.1 but we found out that none of our reports work. We are using Oracle 11g R2 and ojdbc6.jar.

We tested same queries without parameters and it works but one you write a $ it crashes with

 

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(SimpleSQLReportDataFactory.java:356)

    at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.parametrizeAndQuery(SimpleSQLReportDataFactory.java:277)

    at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:179)

    ... 3 more

 

 

We found similar problem report by one guy [PRD-6006] Regression: Oracle SQL queries with parameters broken in PIR - Pentaho Platform Tracking

 

It really critical for us to make reports work. Can you suggest at least a possible work around?

 

Thank you

Outcomes