Dataphin数据集成中SAP HANA可以选到表,但是管道任务中报错“invalid table name: Could not find table/view CE9PB00_H in schema SLT_USER”
更新时间:2022-09-27 06:15:15
问题描述
Dataphin数据集成中SAP HANA可以选到表,但是管道任务中报错“invalid table name: Could not find table/view CE9PB00_H in schema SLT_USER”。
2022-09-23 09:42:20.231 [job-1042479] ERROR DlinkTransPreview - Exception when job run
com.alibaba.dt.pipeline.plugin.center.exception.DataXException: Code:[DBUtilErrorCode-06], Description:[执行数据库 Sql 失败, 请检查您的配置的 column/table/where/querySql或者向 DBA 寻求帮助.]. - 执行的SQL为: select * from CE9PB00_H where 1=2 具体错误信息为:com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [259] (at 14): invalid table name: Could not find table/view CE9PB00_H in schema SLT_USER: line 1 col 15 (at pos 14)
at com.alibaba.dt.pipeline.plugin.center.exception.DataXException.asDataXException(DataXException.java:40) ~[plugin.center.base-v2.9.5.3-2.RELEASE.jar:na]
at com.alibaba.datax.plugin.rdbms.util.RdbmsException.asQueryException(RdbmsException.java:97) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.plugin.rdbms.util.DBUtil.getTableColumnsByConnInternal(DBUtil.java:693) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.plugin.rdbms.util.DBUtil.getTableColumnsByConn(DBUtil.java:665) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.plugin.rdbms.util.DBUtil.getTableColumns(DBUtil.java:661) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.plugin.rdbms.reader.util.OriginalConfPretreatmentUtil.dealColumnConf(OriginalConfPretreatmentUtil.java:249) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.plugin.rdbms.reader.util.OriginalConfPretreatmentUtil.simplifyConf(OriginalConfPretreatmentUtil.java:71) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.plugin.rdbms.reader.util.OriginalConfPretreatmentUtil.doPretreatment(OriginalConfPretreatmentUtil.java:43) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Job.init(CommonRdbmsReader.java:84) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.plugin.reader.saphanareader.SAPHanaReader$Job.init(SAPHanaReader.java:55) ~[saphanareader-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.dt.dlink.core.trans.DlinkTransRunner.initJobReader(DlinkTransRunner.java:59) ~[dlink-engine-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.dt.dlink.core.trans.DlinkTransPreview.doInit(DlinkTransPreview.java:285) ~[dlink-engine-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.dt.dlink.core.trans.DlinkTransPreview.start(DlinkTransPreview.java:230) ~[dlink-engine-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.dt.dlink.core.Engine.runTransPreview(Engine.java:101) [dlink-engine-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.dt.dlink.core.Engine.entry(Engine.java:174) [dlink-engine-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.dt.dlink.core.Engine.main(Engine.java:246) [dlink-engine-0.0.1-SNAPSHOT.jar:na]
2022-09-23 09:42:20.242 [job-1042479] ERROR Engine -
问题原因
数据源URL中没有加入schema信息。目前我们的设计,需要配置一个兜底的schema。
解决方案
SAP HANA数据源中URL加入schema信息。
具体格式:jdbc:sap://host:Port/?databaseName=¤tSchema=
适用于
- Dataphin
该文章对您有帮助吗?
- 本页导读
- 问题描述
- 问题原因
- 解决方案
- 适用于