java.sql.SQLSyntaxErrorException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Reg: Error in creating schema by RCu for OIM 11.1.2.2.0
    via by 87f4c891-b4b4-4dec-b7ff-0594536c95b7,
  • Running RCU for OIM R2 PS2 gives error
    via by 2665779,
  • Error installing OIM 11.1.2.2
    via by 87f4c891-b4b4-4dec-b7ff-0594536c95b7,
  • hibernate.cfg.xml file error
    via Stack Overflow by user2517370
    ,
  • Unable to get list of element types for namespace 'pentaho' org.pentaho.di.core.exception.KettleXMLException: Error reading object from XML file Unable to get list of element types for namespace 'pentaho' at org.pentaho.di.trans.TransMeta.loadXML(TransMeta.java:3388) at org.pentaho.di.ui.spoon.TransFileListener.open(TransFileListener.java:51) at org.pentaho.di.ui.spoon.Spoon.openFile(Spoon.java:4254) at org.pentaho.di.ui.spoon.Spoon.openFile(Spoon.java:3932) at org.pentaho.di.ui.spoon.Spoon.importFile(Spoon.java:3872) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123) at org.pentaho.ui.xul.jface.tags.JfaceMenuitem.access$100(JfaceMenuitem.java:26) at org.pentaho.ui.xul.jface.tags.JfaceMenuitem$1.run(JfaceMenuitem.java:88) at org.eclipse.jface.action.Action.runWithEvent(Action.java:498) at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:545) at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:490) at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:402) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1227) at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7368) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:8673) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:625) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.intellij.rt.execution.CommandLineWrapper.main(CommandLineWrapper.java:112) Caused by: org.pentaho.metastore.api.exceptions.MetaStoreException: Unable to get list of element types for namespace 'pentaho' at org.pentaho.di.repository.kdr.delegates.metastore.KettleDatabaseRepositoryMetaStore.getElementTypes(KettleDatabaseRepositoryMetaStore.java:187) at org.pentaho.metastore.stores.delegate.DelegatingMetaStore.getElementTypes(DelegatingMetaStore.java:185) at org.pentaho.metastore.stores.delegate.DelegatingMetaStore.getElementTypeByName(DelegatingMetaStore.java:215) at org.pentaho.di.trans.TransMeta.importFromMetaStore(TransMeta.java:3402) at org.pentaho.di.trans.TransMeta.loadXML(TransMeta.java:2967) ... 30 more Caused by: org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: SELECT ID_NAMESPACE FROM R_NAMESPACE WHERE NAME = ? ORA-00932: inconsistent datatypes: expected - got CLOB at org.pentaho.di.core.database.Database.openQuery(Database.java:1641) at org.pentaho.di.core.database.Database.openQuery(Database.java:1574) at org.pentaho.di.core.database.Database.openQuery(Database.java:1569) at org.pentaho.di.core.database.Database.getOneRow(Database.java:2933) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.getOneRow(KettleDatabaseRepositoryConnectionDelegate.java:1525) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.getIDWithValue(KettleDatabaseRepositoryConnectionDelegate.java:1426) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryMetaStoreDelegate.getNamespaceId(KettleDatabaseRepositoryMetaStoreDelegate.java:64) at org.pentaho.di.repository.kdr.delegates.metastore.KettleDatabaseRepositoryMetaStore.getElementTypes(KettleDatabaseRepositoryMetaStore.java:172) ... 34 more Caused by: java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got CLOB at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491) at org.pentaho.di.core.database.Database.openQuery(Database.java:1611) ... 41 more Table R_NAMESPACE contains field NAME with type CLOB while query tries to use VARCHAR2 type for SELECT statement. Available solutions change NAME field type to VARCHAR on the creating repository step, or add support for type CLOB or LONSTRING or etc.
    via by Dzmitry Stsiapanau,
    • java.sql.SQLSyntaxErrorException: ORA-00904: "DEV_OIM"."XL_SP_DBCHECK": invalid identifier at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491) at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeQuery(JDBCEngine.java:1203) at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeQuery(JDBCEngine.java:921) at oracle.sysman.assistants.rcu.backend.validation.PrereqEngine.execute(PrereqEngine.java:100) at oracle.sysman.assistants.rcu.backend.validation.PrereqEngine.execute(PrereqEngine.java:71) at oracle.sysman.assistants.rcu.backend.validation.PrereqHelper.evaluatePrereq(PrereqHelper.java:72) at oracle.sysman.assistants.rcu.backend.validation.PrereqEvaluator.evaluatePrereq(PrereqEvaluator.java:139) at oracle.sysman.assistants.rcu.backend.validation.PrereqEvaluator.evaluatePrereqSet(PrereqEvaluator.java:192) at oracle.sysman.assistants.rcu.backend.validation.PrereqEvaluator.evaluatePrereqSet(PrereqEvaluator.java:146) at oracle.sysman.assistants.rcu.backend.action.AbstractAction.evaluateValidIf(AbstractAction.java:312) at oracle.sysman.assistants.rcu.backend.task.AbstractCompTask.execute(AbstractCompTask.java:235) at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:306) at java.lang.Thread.run(Thread.java:662)

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    571 more bugmates