org.pentaho.di.core.exception.KettleXMLException: Error reading object from XML file Unable to get list of element types for namespace 'pentaho'

Pentaho BI Platform Tracking | Viktoryia Shalkova | 3 years ago
  1. 0

    1) Connect to "MS SQL Server" repository : Tools -> Repository -> Connect. 2) Trying to open any locally saved transformation / job (for example, using "drag-and-drop" or through main menu File -> Open Recent) =>The following error message appears "Unable to get list of element types for namespace 'pentaho'' (error screenshot attached). Reproduced in PDI CE: CI Build #832 and older. Works fine in PDI CE version 4.4.0. Error details: 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:3708) at org.pentaho.di.ui.spoon.TransFileListener.open(TransFileListener.java:51) at org.pentaho.di.ui.spoon.Spoon.openFile(Spoon.java:4340) at org.pentaho.di.ui.spoon.Spoon.lastFileSelect(Spoon.java:1751) at org.pentaho.di.ui.spoon.Spoon$6.run(Spoon.java:1667) 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:1250) at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7564) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:8885) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:626) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:151) 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:191) at org.pentaho.metastore.stores.delegate.DelegatingMetaStore.getElementTypes(DelegatingMetaStore.java:203) at org.pentaho.metastore.stores.delegate.DelegatingMetaStore.getElementTypeByName(DelegatingMetaStore.java:234) at org.pentaho.di.trans.TransMeta.importFromMetaStore(TransMeta.java:3723) at org.pentaho.di.trans.TransMeta.loadXML(TransMeta.java:3277) ... 21 more Caused by: org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: SELECT ID_NAMESPACE FROM R_NAMESPACE WHERE NAME = ? The data types text and nvarchar are incompatible in the equal to operator. at org.pentaho.di.core.database.Database.openQuery(Database.java:1711) at org.pentaho.di.core.database.Database.openQuery(Database.java:1640) at org.pentaho.di.core.database.Database.openQuery(Database.java:1635) at org.pentaho.di.core.database.Database.getOneRow(Database.java:3034) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.getOneRow(KettleDatabaseRepositoryConnectionDelegate.java:1764) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.getIDWithValue(KettleDatabaseRepositoryConnectionDelegate.java:1653) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryMetaStoreDelegate.getNamespaceId(KettleDatabaseRepositoryMetaStoreDelegate.java:65) at org.pentaho.di.repository.kdr.delegates.metastore.KettleDatabaseRepositoryMetaStore.getElementTypes(KettleDatabaseRepositoryMetaStore.java:176) ... 25 more Caused by: java.sql.SQLException: The data types text and nvarchar are incompatible in the equal to operator. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:776) at org.pentaho.di.core.database.Database.openQuery(Database.java:1680) ... 32 more

    Pentaho BI Platform Tracking | 3 years ago | Viktoryia Shalkova
    org.pentaho.di.core.exception.KettleXMLException: Error reading object from XML file Unable to get list of element types for namespace 'pentaho'
  2. 0

    1) Connect to "MS SQL Server" repository : Tools -> Repository -> Connect. 2) Trying to open any locally saved transformation / job (for example, using "drag-and-drop" or through main menu File -> Open Recent) =>The following error message appears "Unable to get list of element types for namespace 'pentaho'' (error screenshot attached). Reproduced in PDI CE: CI Build #832 and older. Works fine in PDI CE version 4.4.0. Error details: 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:3708) at org.pentaho.di.ui.spoon.TransFileListener.open(TransFileListener.java:51) at org.pentaho.di.ui.spoon.Spoon.openFile(Spoon.java:4340) at org.pentaho.di.ui.spoon.Spoon.lastFileSelect(Spoon.java:1751) at org.pentaho.di.ui.spoon.Spoon$6.run(Spoon.java:1667) 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:1250) at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7564) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:8885) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:626) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:151) 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:191) at org.pentaho.metastore.stores.delegate.DelegatingMetaStore.getElementTypes(DelegatingMetaStore.java:203) at org.pentaho.metastore.stores.delegate.DelegatingMetaStore.getElementTypeByName(DelegatingMetaStore.java:234) at org.pentaho.di.trans.TransMeta.importFromMetaStore(TransMeta.java:3723) at org.pentaho.di.trans.TransMeta.loadXML(TransMeta.java:3277) ... 21 more Caused by: org.pentaho.di.core.exception.KettleDatabaseException: An error occurred executing SQL: SELECT ID_NAMESPACE FROM R_NAMESPACE WHERE NAME = ? The data types text and nvarchar are incompatible in the equal to operator. at org.pentaho.di.core.database.Database.openQuery(Database.java:1711) at org.pentaho.di.core.database.Database.openQuery(Database.java:1640) at org.pentaho.di.core.database.Database.openQuery(Database.java:1635) at org.pentaho.di.core.database.Database.getOneRow(Database.java:3034) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.getOneRow(KettleDatabaseRepositoryConnectionDelegate.java:1764) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.getIDWithValue(KettleDatabaseRepositoryConnectionDelegate.java:1653) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryMetaStoreDelegate.getNamespaceId(KettleDatabaseRepositoryMetaStoreDelegate.java:65) at org.pentaho.di.repository.kdr.delegates.metastore.KettleDatabaseRepositoryMetaStore.getElementTypes(KettleDatabaseRepositoryMetaStore.java:176) ... 25 more Caused by: java.sql.SQLException: The data types text and nvarchar are incompatible in the equal to operator. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:776) at org.pentaho.di.core.database.Database.openQuery(Database.java:1680) ... 32 more

    Pentaho BI Platform Tracking | 3 years ago | Viktoryia Shalkova
    org.pentaho.di.core.exception.KettleXMLException: Error reading object from XML file Unable to get list of element types for namespace 'pentaho'
  3. 0

    Sybase ASE: Implicit conversion from TEXT to VARCHAR doesn't work

    GitHub | 4 years ago | lukaseder
    java.sql.SQLException: Implicit conversion from datatype 'TEXT' to 'VARCHAR' is not allowed. Use the CONVERT function to run this query.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error creating bean with name 'org.springframework.scheduling.quartz.SchedulerFactoryBean#0'

    Stack Overflow | 4 years ago | Swapnil
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.scheduling.quartz.SchedulerFactoryBean#0' defined in ServletContext resource [/WEB-INF/hmpn-mvc-dispatcher-servlet.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR. [See nested exception: java.sql.SQLException: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR.]]
  6. 0

    Error creating bean with name 'org.springframework.scheduling.quartz.SchedulerFactoryBean#0' - java pressing answers

    itanswerz.com | 1 year ago
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.scheduling.quartz.SchedulerFactoryBean#0' defined in ServletContext resource [/WEB-INF/hmpn-mvc-dispatcher-servlet.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR. [See nested exception: java.sql.SQLException: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR.]]

  1. ruifung 1 times, last 3 months ago
12 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.SQLException

    The data types text and nvarchar are incompatible in the equal to operator.

    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic()
  2. jTDS
    JtdsPreparedStatement.executeQuery
    1. net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
    2. net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
    3. net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
    4. net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
    5. net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
    6. net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:776)
    6 frames
  3. org.pentaho.di
    KettleDatabaseRepositoryMetaStore.getElementTypes
    1. org.pentaho.di.core.database.Database.openQuery(Database.java:1680)
    2. org.pentaho.di.core.database.Database.openQuery(Database.java:1640)
    3. org.pentaho.di.core.database.Database.openQuery(Database.java:1635)
    4. org.pentaho.di.core.database.Database.getOneRow(Database.java:3034)
    5. org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.getOneRow(KettleDatabaseRepositoryConnectionDelegate.java:1764)
    6. org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.getIDWithValue(KettleDatabaseRepositoryConnectionDelegate.java:1653)
    7. org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryMetaStoreDelegate.getNamespaceId(KettleDatabaseRepositoryMetaStoreDelegate.java:65)
    8. org.pentaho.di.repository.kdr.delegates.metastore.KettleDatabaseRepositoryMetaStore.getElementTypes(KettleDatabaseRepositoryMetaStore.java:176)
    8 frames
  4. org.pentaho.metastore
    DelegatingMetaStore.getElementTypeByName
    1. org.pentaho.metastore.stores.delegate.DelegatingMetaStore.getElementTypes(DelegatingMetaStore.java:203)
    2. org.pentaho.metastore.stores.delegate.DelegatingMetaStore.getElementTypeByName(DelegatingMetaStore.java:234)
    2 frames
  5. org.pentaho.di
    Spoon$6.run
    1. org.pentaho.di.trans.TransMeta.importFromMetaStore(TransMeta.java:3723)
    2. org.pentaho.di.trans.TransMeta.loadXML(TransMeta.java:3277)
    3. org.pentaho.di.ui.spoon.TransFileListener.open(TransFileListener.java:51)
    4. org.pentaho.di.ui.spoon.Spoon.openFile(Spoon.java:4340)
    5. org.pentaho.di.ui.spoon.Spoon.lastFileSelect(Spoon.java:1751)
    6. org.pentaho.di.ui.spoon.Spoon$6.run(Spoon.java:1667)
    6 frames
  6. JFace
    ActionContributionItem$5.handleEvent
    1. org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
    2. org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:545)
    3. org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:490)
    4. org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:402)
    4 frames
  7. RWT
    Display.readAndDispatch
    1. org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    2. org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    3. org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    4. org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    4 frames
  8. org.pentaho.di
    Spoon.main
    1. org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1250)
    2. org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7564)
    3. org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:8885)
    4. org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:626)
    4 frames
  9. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    4. java.lang.reflect.Method.invoke(Method.java:601)
    4 frames
  10. org.pentaho.commons
    Launcher.main
    1. org.pentaho.commons.launcher.Launcher.main(Launcher.java:151)
    1 frame