org.pentaho.di.core.exception.KettleDatabaseException: {color:red} Couldn't get field info from [SELECT /*+FIRST_ROWS*/ * FROM SYS=PROJECT=LOAD=all WHERE ROWNUM < 1] ORA-00933: SQL command not properly ended {color}

Pentaho BI Platform Tracking | Michaux | 2 years ago
  1. 0

    I work with a model having objects named like "SYS=PROJECT=LOAD=all", which is perfectly Ok everywhere but not for this transformation. I get the following error: {quote} 2015/05/19 13:25:28 - Get table names.0 - ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : Unexpected error 2015/05/19 13:25:28 - Get table names.0 - ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: {color:red} 2015/05/19 13:25:28 - Get table names.0 - Couldn't get field info from [SELECT /*+FIRST_ROWS*/ * FROM SYS=PROJECT=LOAD=all WHERE ROWNUM < 1] 2015/05/19 13:25:28 - Get table names.0 - 2015/05/19 13:25:28 - Get table names.0 - ORA-00933: SQL command not properly ended {color} 2015/05/19 13:25:28 - Get table names.0 - 2015/05/19 13:25:28 - Get table names.0 - 2015/05/19 13:25:28 - Get table names.0 - at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2198) 2015/05/19 13:25:28 - Get table names.0 - at org.pentaho.di.core.database.Database.getQueryFields(Database.java:2135) 2015/05/19 13:25:28 - Get table names.0 - at org.pentaho.di.core.database.Database.getQueryFields(Database.java:1812) 2015/05/19 13:25:28 - Get table names.0 - at org.pentaho.di.core.database.Database.getTableFields(Database.java:1808) 2015/05/19 13:25:28 - Get table names.0 - at org.pentaho.di.trans.steps.gettablenames.GetTableNames.processRow(GetTableNames.java:244) 2015/05/19 13:25:28 - Get table names.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2015/05/19 13:25:28 - Get table names.0 - at java.lang.Thread.run(Thread.java:745) 2015/05/19 13:25:28 - Get table names.0 - Caused by: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended 2015/05/19 13:25:28 - Get table names.0 - 2015/05/19 13:25:28 - Get table names.0 - at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) 2015/05/19 13:25:28 - Get table names.0 - at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) 2015/05/19 13:25:28 - Get table names.0 - at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) 2015/05/19 13:25:28 - Get table names.0 - at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) 2015/05/19 13:25:28 - Get table names.0 - at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) 2015/05/19 13:25:28 - Get table names.0 - at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) 2015/05/19 13:25:28 - Get table names.0 - at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225) 2015/05/19 13:25:28 - Get table names.0 - at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53) 2015/05/19 13:25:28 - Get table names.0 - at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:774) 2015/05/19 13:25:28 - Get table names.0 - at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925) 2015/05/19 13:25:28 - Get table names.0 - at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111) 2015/05/19 13:25:28 - Get table names.0 - at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) 2015/05/19 13:25:28 - Get table names.0 - at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845) 2015/05/19 13:25:28 - Get table names.0 - at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501) 2015/05/19 13:25:28 - Get table names.0 - at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2192) 2015/05/19 13:25:28 - Get table names.0 - ... 6 more {quote} I think it may come from missing double quotes if the command was executed as showed in the log.

    Pentaho BI Platform Tracking | 2 years ago | Michaux
    org.pentaho.di.core.exception.KettleDatabaseException: {color:red} Couldn't get field info from [SELECT /*+FIRST_ROWS*/ * FROM SYS=PROJECT=LOAD=all WHERE ROWNUM < 1] ORA-00933: SQL command not properly ended {color}
  2. 0

    Spring Boot with Spring Data JPA gives invalid character issue for findOne(…) on Oracle database

    Stack Overflow | 2 years ago | Rohit
    org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  3. 0

    ERROR: ORA-02289: sequence does not exist - org.hibernate.exception.SQLGrammarException: could not extract ResultSet

    Stack Overflow | 2 years ago | user2682305
    org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ERROR: ORA-02289: sequence does not exist (Object Relational Mapping forum at JavaRanch)

    coderanch.com | 1 year ago
    org.hibernate.exception.SQLGrammarException: could not extract ResultSet

  1. rafafviola 1 times, last 1 month ago
  2. wendellpereira 128 times, last 2 months ago
  3. balintn 4 times, last 2 months ago
  4. balintn 3 times, last 3 months ago
  5. pnaranja 2 times, last 4 months ago
1 more registered users
30 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLSyntaxErrorException

    ORA-00933: SQL command not properly ended

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)
    8. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)
    9. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:774)
    10. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925)
    11. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111)
    12. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)
    13. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845)
    14. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501)
    14 frames
  3. org.pentaho.di
    RunThread.run
    1. org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2192)
    2. org.pentaho.di.core.database.Database.getQueryFields(Database.java:2135)
    3. org.pentaho.di.core.database.Database.getQueryFields(Database.java:1812)
    4. org.pentaho.di.core.database.Database.getTableFields(Database.java:1808)
    5. org.pentaho.di.trans.steps.gettablenames.GetTableNames.processRow(GetTableNames.java:244)
    6. org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
    6 frames
  4. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:745)
    1 frame