注册

关于kettle

会跑的鱼 2025/06/17 237 2

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8.0
【操作系统】:win10
【CPU】:
【问题描述】*:我连接上达梦库后,新建一个转换报错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:192)
at org.pentaho.metastore.stores.delegate.DelegatingMetaStore.getElementTypes(DelegatingMetaStore.java:204)
at org.pentaho.metastore.stores.delegate.DelegatingMetaStore.getElementTypeByName(DelegatingMetaStore.java:235)
at org.pentaho.di.base.AbstractMeta.importFromMetaStore(AbstractMeta.java:471)
at org.pentaho.di.ui.spoon.Spoon.newTransFile(Spoon.java:4554)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:313)
at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:157)
at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:141)
at org.pentaho.ui.xul.jface.tags.JfaceMenuitem.access$100(JfaceMenuitem.java:43)
at org.pentaho.ui.xul.jface.tags.JfaceMenuitem$1.run(JfaceMenuitem.java:106)
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.Display.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:1215)
at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7930)
at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9184)
at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:541)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)
Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
An error occurred executing SQL:
SELECT ID_NAMESPACE FROM R_NAMESPACE WHERE NAME = ?
第1 行附近出现错误:
数据类型不匹配

at org.pentaho.di.core.database.Database.openQuery(Database.java:1763)
at org.pentaho.di.core.database.Database.openQuery(Database.java:1693)
at org.pentaho.di.core.database.Database.openQuery(Database.java:1688)
at org.pentaho.di.core.database.Database.getOneRow(Database.java:3162)
at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.lambda$getOneRow$17(KettleDatabaseRepositoryConnectionDelegate.java:1866)
at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.callRead(KettleDatabaseRepositoryConnectionDelegate.java:1992)
at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.getOneRow(KettleDatabaseRepositoryConnectionDelegate.java:1866)
at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.getIDWithValue(KettleDatabaseRepositoryConnectionDelegate.java:1712)
at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryMetaStoreDelegate.getNamespaceId(KettleDatabaseRepositoryMetaStoreDelegate.java:66)
at org.pentaho.di.repository.kdr.delegates.metastore.KettleDatabaseRepositoryMetaStore.getElementTypes(KettleDatabaseRepositoryMetaStore.java:177)
... 31 more
Caused by: dm.jdbc.driver.DMException: 第1 行附近出现错误:
数据类型不匹配
at dm.jdbc.driver.DBError.throwException(SourceFile:789)
at dm.jdbc.a.a.ac.s(SourceFile:639)
at dm.jdbc.a.a.f.s(SourceFile:143)
at dm.jdbc.a.a.ac.K(SourceFile:571)
at dm.jdbc.a.a.ac.V(SourceFile:552)
at dm.jdbc.a.a.a(SourceFile:276)
at dm.jdbc.a.a.a(SourceFile:803)
at dm.jdbc.driver.DmdbPreparedStatement.prepareSql(SourceFile:269)
at dm.jdbc.driver.DmdbPreparedStatement.allocateHandle(SourceFile:212)
at dm.jdbc.driver.DmdbPreparedStatement.<init>(SourceFile:149)
at dm.jdbc.driver.DmdbPreparedStatement.<init>(SourceFile:179)
at dm.jdbc.driver.DmdbConnection.do_prepareStatement(SourceFile:924)
at dm.jdbc.driver.DmdbConnection.do_prepareStatement(SourceFile:919)
at dm.jdbc.driver.DmdbConnection.prepareStatement(SourceFile:1647)
at org.pentaho.di.core.database.Database.openQuery(Database.java:1706)
... 40 more

回答 0
暂无回答
扫一扫
联系客服