注册

SQL 错误 [22000]: 数据未找到

ㅤㅤㅤㅤㅤㅤㅤㅤlove_ddz 2023/08/08 735 1

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:7.3.5
【操作系统】:Linux
【CPU】:
【问题描述】*:
执行SQL报异常:SQL 错误 [22000]: 数据未找到

MERGE INTO HYDRO.ST_RSVR_R t1 USING( SELECT '614K0042' stcd, '2023-08-08 15:54:00' tm, 899.830 rz, NULL inq, NULL wstcp, NULL otq, NULL rwchrcd, NULL rwptn, NULL inqdr, NULL msqmt FROM dual ) t2 ON (t1.stcd = t2.stcd AND t1.tm = t2.tm ) WHEN NOT MATCHED THEN INSERT (stcd, tm, rz, inq, wstcp, otq, rwchrcd, rwptn, inqdr, msqmt, dtuptm) VALUES (t2.stcd, t2.tm, t2.rz, t2.inq, t2.wstcp, t2.otq, t2.rwchrcd, t2.rwptn, t2.inqdr, msqmt, sysdate()) WHEN MATCHED THEN UPDATE SET t1.rz = t2.rz, t1.inq = t2.inq, t1.wstcp = t2.wstcp, t1.otq = t2.otq, t1.rwchrcd = t2.rwchrcd, t1.rwptn = t2.rwptn, t1.inqdr = t2.inqdr, t1.msqmt = t2.msqmt, t1.dtuptm = sysdate()
org.jkiss.dbeaver.model.sql.DBSQLException: SQL 错误 [22000]: 数据未找到 at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:133) at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQLQueryJob.java:509) at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.lambda$0(SQLQueryJob.java:440) at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:168) at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:427) at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.extractData(SQLQueryJob.java:812) at org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:3226) at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:118) at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:168) at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:116) at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$ResultSetDataPumpJob.run(ResultSetViewer.java:4516) at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:105) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63) Caused by: dm.jdbc.driver.DMException: 数据未找到 at dm.jdbc.driver.DBError.throwException(SourceFile:711) at dm.jdbc.a.a.x.i(SourceFile:615) at dm.jdbc.a.a.f.i(SourceFile:137) at dm.jdbc.a.a.x.q(SourceFile:550) at dm.jdbc.a.a.x.x(SourceFile:531) at dm.jdbc.a.a.a(SourceFile:271) at dm.jdbc.a.a.a(SourceFile:762) at dm.jdbc.driver.DmdbStatement.executeInner(SourceFile:730) at dm.jdbc.driver.DmdbStatement.do_execute(SourceFile:189) at dm.jdbc.driver.DmdbStatement.do_execute(SourceFile:181) at dm.jdbc.driver.DmdbStatement.execute(SourceFile:1300) at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.execute(JDBCStatementImpl.java:327) at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:130) ... 12 more
回答 0
暂无回答
扫一扫
联系客服