2025-08-27 15:08:00.150 [acqTask-75799bc70bb04d239947c19ac94999c5] INFO c.g.d.d.transfer.core.process.taskExecute.DefaultExecute.initTaskExecute:204 - 初始化任务执行 2025-08-27 15:08:00.153 [acqTask-75799bc70bb04d239947c19ac94999c5] INFO c.g.d.d.transfer.core.process.taskExecute.DefaultExecute.initTaskExecute:207 - Task信息: Task(modelCode=12, taskId=acqTask-75799bc70bb04d239947c19ac94999c5, jobInstanceId=JHK_OI2_DJ_HEFEI_C25_D3_2025_4_DI_20250814111024, jobId=1955829332110020609, jobName=JHK_OI2_DJ_HEFEI_C25_D3_2025_4_DI, label=1955440602730889218, timestampCol=W00P0000300, createTime=Wed Aug 27 15:06:37 CST 2025, overTime=-1, minTime=null, maxTime=null, startTime=Wed Aug 27 15:08:00 CST 2025, endTime=null, readerNumber=0, writeNumber=0, exceptionNumber=0, exceptionMessage=null, filterNumber=0, currentRetryNum=0, maxRetryNum=0, workerName=10.10.15.8:18003, executeClassName=com.gccloud.dsp.data.transfer.core.process.taskExecute.DefaultExecute, status=0, rule=filters: [] input: JDBC: params: fromParam: select C25_D3_ID,W00C2500600,W00C2500700,W00C2500800,W00C2500900,W00C2501000,W00C2501100,W00C2501200,Z00C0105500,W00C2501300,W00C2501400,W00C2501500,W00P0001500,W00C2501700,W00C2501800,W00C2501900,W00A0108400,W00C2502000,W00C2502100,W00P0100700,W00P0100900,W00C2502400,W00P0000800,W00C2502200,W00C2504700,W00C2101200,W00C2102400,W00C2504900 from C25_D3_2025_4 nodeName: '' nodeReMarks: '' fromConfig: '{"nullIsException":"0"}' runParam: {} isGroupOperate: '0' timestampCol: W00P0000300 sourceInfo: sourceId: '1952246485209194497' mima: ***** driverClass: dm.jdbc.driver.DmDriver userName: HEFEI_340100 url: jdbc:dm://10.100.214.189:33385?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8&compatibleMode=oracle&transformedBitIsBoolean=true&connectTimeout=3000&socketTimeout=5000&loginTimeout=10 output: JDBC: params: nodeName: '' toParam: JHK_OI2_DJ_HEFEI_C25_D3_2025_4_DI nodeReMarks: '' scheduleType: '0' outPutFields: '[{"colName":"C25_D3_ID","targetColName":"C25_D3_ID"},{"colName":"W00C2500600","targetColName":"W00C2500600"},{"colName":"W00C2500700","targetColName":"W00C2500700"},{"colName":"W00C2500800","targetColName":"W00C2500800"},{"colName":"W00C2500900","targetColName":"W00C2500900"},{"colName":"W00C2501000","targetColName":"W00C2501000"},{"colName":"W00C2501100","targetColName":"W00C2501100"},{"colName":"W00C2501200","targetColName":"W00C2501200"},{"colName":"Z00C0105500","targetColName":"Z00C0105500"},{"colName":"W00C2501300","targetColName":"W00C2501300"},{"colName":"W00C2501400","targetColName":"W00C2501400"},{"colName":"W00C2501500","targetColName":"W00C2501500"},{"colName":"W00P0001500","targetColName":"W00P0001500"},{"colName":"W00C2501700","targetColName":"W00C2501700"},{"colName":"W00C2501800","targetColName":"W00C2501800"},{"colName":"W00C2501900","targetColName":"W00C2501900"},{"colName":"W00A0108400","targetColName":"W00A0108400"},{"colName":"W00C2502000","targetColName":"W00C2502000"},{"colName":"W00C2502100","targetColName":"W00C2502100"},{"colName":"W00P0100700","targetColName":"W00P0100700"},{"colName":"W00P0100900","targetColName":"W00P0100900"},{"colName":"W00C2502400","targetColName":"W00C2502400"},{"colName":"W00P0000800","targetColName":"W00P0000800"},{"colName":"W00C2502200","targetColName":"W00C2502200"},{"colName":"W00C2504700","targetColName":"W00C2504700"},{"colName":"W00C2101200","targetColName":"W00C2101200"},{"colName":"W00C2102400","targetColName":"W00C2102400"},{"colName":"W00C2504900","targetColName":"W00C2504900"}]' pks: '' outPutInputColumn: '["C25_D3_ID","W00C2500600","W00C2500700","W00C2500800","W00C2500900","W00C2501000","W00C2501100","W00C2501200","Z00C0105500","W00C2501300","W00C2501400","W00C2501500","W00P0001500","W00C2501700","W00C2501800","W00C2501900","W00A0108400","W00C2502000","W00C2502100","W00P0100700","W00P0100900","W00C2502400","W00P0000800","W00C2502200","W00C2504700","W00C2101200","W00C2102400","W00C2504900"]' operation: IU sourceInfo: sourceId: '1953376595854290946' mima: ***** driverClass: dm.jdbc.driver.DmDriver userName: JHK_OI2_DJ_HEFEI url: jdbc:dm://10.100.214.193:31813?SCHEMA=JHK_OI2_DJ_HEFEI , parentId=null, workerId=acqWorker-A8D9E7DBE2BB97A9FDE9F8CFF0892C07BD5CF408C88B0FFB2C0F5CFB974B60D8, workerPid=1647322, tenantId=1767461873203122178, createBy=1862026998906675201, createDate=Thu Aug 14 11:10:24 CST 2025, dolphinSchedulerInstanceId=null, alarmUrl=null, exceptionStrategy=null, alarmConfig=null) 2025-08-27 15:08:00.167 [acqTask-75799bc70bb04d239947c19ac94999c5] INFO com.gccloud.dsp.data.transfer.core.model.JobRule.ruleParse:64 - 解析规则... 2025-08-27 15:08:00.168 [acqTask-75799bc70bb04d239947c19ac94999c5] INFO com.gccloud.dsp.data.transfer.core.model.JobRule.ruleParse:98 - 规则解析完成 2025-08-27 15:08:00.169 [acqTask-75799bc70bb04d239947c19ac94999c5] INFO c.g.d.d.transfer.core.process.taskExecute.DefaultExecute.initTaskExecute:226 - 输入规则:Input{configMap={params={fromParam=select C25_D3_ID,W00C2500600,W00C2500700,W00C2500800,W00C2500900,W00C2501000,W00C2501100,W00C2501200,Z00C0105500,W00C2501300,W00C2501400,W00C2501500,W00P0001500,W00C2501700,W00C2501800,W00C2501900,W00A0108400,W00C2502000,W00C2502100,W00P0100700,W00P0100900,W00C2502400,W00P0000800,W00C2502200,W00C2504700,W00C2101200,W00C2102400,W00C2504900 from C25_D3_2025_4, nodeName=, nodeReMarks=, fromConfig={"nullIsException":"0"}, runParam={}, isGroupOperate=0, timestampCol=W00P0000300, createTime=20250827150637}, sourceInfo={sourceId=1952246485209194497, mima=*****, driverClass=dm.jdbc.driver.DmDriver, userName=HEFEI_340100, url=jdbc:dm://10.100.214.189:33385?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8&compatibleMode=oracle&transformedBitIsBoolean=true&connectTimeout=3000&socketTimeout=5000&loginTimeout=10}}},输出规则:AbstractOutput{configMap={params={nodeName=, toParam=JHK_OI2_DJ_HEFEI_C25_D3_2025_4_DI, nodeReMarks=, scheduleType=0, outPutFields=[{"colName":"C25_D3_ID","targetColName":"C25_D3_ID"},{"colName":"W00C2500600","targetColName":"W00C2500600"},{"colName":"W00C2500700","targetColName":"W00C2500700"},{"colName":"W00C2500800","targetColName":"W00C2500800"},{"colName":"W00C2500900","targetColName":"W00C2500900"},{"colName":"W00C2501000","targetColName":"W00C2501000"},{"colName":"W00C2501100","targetColName":"W00C2501100"},{"colName":"W00C2501200","targetColName":"W00C2501200"},{"colName":"Z00C0105500","targetColName":"Z00C0105500"},{"colName":"W00C2501300","targetColName":"W00C2501300"},{"colName":"W00C2501400","targetColName":"W00C2501400"},{"colName":"W00C2501500","targetColName":"W00C2501500"},{"colName":"W00P0001500","targetColName":"W00P0001500"},{"colName":"W00C2501700","targetColName":"W00C2501700"},{"colName":"W00C2501800","targetColName":"W00C2501800"},{"colName":"W00C2501900","targetColName":"W00C2501900"},{"colName":"W00A0108400","targetColName":"W00A0108400"},{"colName":"W00C2502000","targetColName":"W00C2502000"},{"colName":"W00C2502100","targetColName":"W00C2502100"},{"colName":"W00P0100700","targetColName":"W00P0100700"},{"colName":"W00P0100900","targetColName":"W00P0100900"},{"colName":"W00C2502400","targetColName":"W00C2502400"},{"colName":"W00P0000800","targetColName":"W00P0000800"},{"colName":"W00C2502200","targetColName":"W00C2502200"},{"colName":"W00C2504700","targetColName":"W00C2504700"},{"colName":"W00C2101200","targetColName":"W00C2101200"},{"colName":"W00C2102400","targetColName":"W00C2102400"},{"colName":"W00C2504900","targetColName":"W00C2504900"}], pks=, outPutInputColumn=["C25_D3_ID","W00C2500600","W00C2500700","W00C2500800","W00C2500900","W00C2501000","W00C2501100","W00C2501200","Z00C0105500","W00C2501300","W00C2501400","W00C2501500","W00P0001500","W00C2501700","W00C2501800","W00C2501900","W00A0108400","W00C2502000","W00C2502100","W00P0100700","W00P0100900","W00C2502400","W00P0000800","W00C2502200","W00C2504700","W00C2101200","W00C2102400","W00C2504900"], operation=IU, createTime=20250827150637}, sourceInfo={sourceId=1953376595854290946, mima=*****, driverClass=dm.jdbc.driver.DmDriver, userName=JHK_OI2_DJ_HEFEI, url=jdbc:dm://10.100.214.193:31813?SCHEMA=JHK_OI2_DJ_HEFEI}}},过滤规则:[] 2025-08-27 15:08:00.169 [acqTask-75799bc70bb04d239947c19ac94999c5] INFO c.g.d.d.transfer.core.process.taskExecute.DefaultExecute.initTaskExecute:227 - 初始化过滤规则 2025-08-27 15:08:00.169 [acqTask-75799bc70bb04d239947c19ac94999c5] INFO c.g.d.d.transfer.core.process.taskExecute.DefaultExecute.initTaskExecute:228 - 初始化过滤规则 2025-08-27 15:08:00.169 [acqTask-75799bc70bb04d239947c19ac94999c5] INFO c.g.d.d.transfer.core.process.taskExecute.DefaultExecute.initTaskExecute:232 - 初始化过滤规则完成 2025-08-27 15:08:00.170 [acqTask-75799bc70bb04d239947c19ac94999c5] INFO c.g.d.d.transfer.core.process.taskExecute.DefaultExecute.initTaskExecute:235 - 初始化读数据源 2025-08-27 15:08:00.170 [acqTask-75799bc70bb04d239947c19ac94999c5] INFO com.gccloud.dsp.data.transfer.core.plugins.input.JDBC.init:53 - ------------ start init JDBC input------------- 2025-08-27 15:08:00.174 [acqTask-75799bc70bb04d239947c19ac94999c5] INFO com.gccloud.dsp.data.transfer.core.plugins.input.JDBC.init:170 - 传入的sql语句是:select C25_D3_ID,W00C2500600,W00C2500700,W00C2500800,W00C2500900,W00C2501000,W00C2501100,W00C2501200,Z00C0105500,W00C2501300,W00C2501400,W00C2501500,W00P0001500,W00C2501700,W00C2501800,W00C2501900,W00A0108400,W00C2502000,W00C2502100,W00P0100700,W00P0100900,W00C2502400,W00P0000800,W00C2502200,W00C2504700,W00C2101200,W00C2102400,W00C2504900 from C25_D3_2025_4 2025-08-27 15:08:00.174 [acqTask-75799bc70bb04d239947c19ac94999c5] INFO com.gccloud.dsp.data.transfer.core.plugins.input.JDBC.getCount:342 - 执行查询总量sql:select count(*) from (select C25_D3_ID,W00C2500600,W00C2500700,W00C2500800,W00C2500900,W00C2501000,W00C2501100,W00C2501200,Z00C0105500,W00C2501300,W00C2501400,W00C2501500,W00P0001500,W00C2501700,W00C2501800,W00C2501900,W00A0108400,W00C2502000,W00C2502100,W00P0100700,W00P0100900,W00C2502400,W00P0000800,W00C2502200,W00C2504700,W00C2101200,W00C2102400,W00C2504900 from C25_D3_2025_4) transferTemporaryTable 2025-08-27 15:08:00.177 [acqTask-75799bc70bb04d239947c19ac94999c5] INFO com.gccloud.dsp.data.transfer.core.plugins.input.JDBC.getCount:353 - 查询的的数据总共有17条 2025-08-27 15:08:00.179 [acqTask-75799bc70bb04d239947c19ac94999c5] INFO com.gccloud.dsp.data.transfer.core.plugins.input.JDBC.getResultSet:220 - 执行的sql是:select C25_D3_ID,W00C2500600,W00C2500700,W00C2500800,W00C2500900,W00C2501000,W00C2501100,W00C2501200,Z00C0105500,W00C2501300,W00C2501400,W00C2501500,W00P0001500,W00C2501700,W00C2501800,W00C2501900,W00A0108400,W00C2502000,W00C2502100,W00P0100700,W00P0100900,W00C2502400,W00P0000800,W00C2502200,W00C2504700,W00C2101200,W00C2102400,W00C2504900 from C25_D3_2025_4 2025-08-27 15:08:00.179 [acqTask-75799bc70bb04d239947c19ac94999c5] INFO com.gccloud.dsp.data.transfer.core.plugins.input.JDBC.init:187 - ------------init JDBC input success------------- 2025-08-27 15:08:00.179 [acqTask-75799bc70bb04d239947c19ac94999c5] INFO c.g.d.d.transfer.core.process.taskExecute.DefaultExecute.initTaskExecute:237 - 初始化读数据源完成 2025-08-27 15:08:00.179 [acqTask-75799bc70bb04d239947c19ac94999c5] INFO c.g.d.d.transfer.core.process.taskExecute.DefaultExecute.initTaskExecute:238 - 初始化写数据源 2025-08-27 15:08:00.179 [acqTask-75799bc70bb04d239947c19ac94999c5] INFO com.gccloud.dsp.data.transfer.core.plugins.output.JDBC.init:66 - ------------ start init JDBC output------------- 2025-08-27 15:08:00.186 [acqTask-75799bc70bb04d239947c19ac94999c5] INFO com.gccloud.dsp.data.transfer.core.plugins.output.JDBC.init:102 - ------------init JDBC output success------------- 2025-08-27 15:08:00.186 [acqTask-75799bc70bb04d239947c19ac94999c5] INFO c.g.d.d.transfer.core.process.taskExecute.DefaultExecute.initTaskExecute:240 - 初始化写数据源完成 2025-08-27 15:08:00.186 [acqTask-75799bc70bb04d239947c19ac94999c5] INFO c.g.d.d.transfer.core.process.taskExecute.DefaultExecute.initTaskExecute:241 - 初始化任务执行完成 2025-08-27 15:08:00.188 [acqTask-75799bc70bb04d239947c19ac94999c5] WARN c.g.d.d.transfer.core.process.taskExecute.DefaultExecute.doException:168 - 任务acqTask-75799bc70bb04d239947c19ac94999c5执行状态异常。 2025-08-27 15:08:00.188 [acqTask-75799bc70bb04d239947c19ac94999c5] INFO c.g.d.d.transfer.core.process.taskExecute.DefaultExecute.updateNum:247 - task readNumber is 17,writeNumber is 0,exceptionNumber is 17,filterNumber is 0 2025-08-27 15:08:00.190 [acqTask-75799bc70bb04d239947c19ac94999c5] INFO c.g.d.d.transfer.core.process.taskExecute.DefaultExecute.doClose:108 - 关闭源数据源连接... 2025-08-27 15:08:00.191 [acqTask-75799bc70bb04d239947c19ac94999c5] INFO c.g.d.d.transfer.core.process.taskExecute.DefaultExecute.doClose:112 - 源数据源连接关闭 2025-08-27 15:08:00.191 [acqTask-75799bc70bb04d239947c19ac94999c5] INFO c.g.d.d.transfer.core.process.taskExecute.DefaultExecute.doClose:113 - 关闭目标数据源连接... 2025-08-27 15:08:00.191 [acqTask-75799bc70bb04d239947c19ac94999c5] INFO c.g.d.d.transfer.core.process.taskExecute.DefaultExecute.doClose:117 - 目标数据源连接关闭 2025-08-27 15:08:00.192 [acqTask-75799bc70bb04d239947c19ac94999c5] ERROR c.g.d.d.transfer.core.process.taskExecute.DefaultExecute.run:227 - line 1, column 561, nearby [=] has error: Syntax error dm.jdbc.driver.DMException: line 1, column 561, nearby [=] has error: Syntax error 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:915) at dm.jdbc.driver.DmdbConnection.prepareStatement(SourceFile:1410) at com.gccloud.dsp.data.transfer.core.plugins.output.JDBC.batchOutput(JDBC.java:140) at com.gccloud.dsp.data.transfer.core.process.taskExecute.DefaultExecute.run(DefaultExecute.java:197) at java.lang.Thread.run(Thread.java:750) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:750) 找到显示错误的地方
时间: 2025-08-27 12:51:57 AIGC 浏览: 21
根据提供的错误信息 `dm.jdbc.driver.DMException: line 1, column 561, nearby [=] has error: Syntax error`,可以明确错误位置在 SQL 语句的第 1 行、第 561 列附近,具体是在 `[=]` 这个符号的位置出现了语法错误。
要定位到具体的错误,需要查看完整的 SQL 语句。假设完整的 SQL 语句存储在一个字符串变量中,可以通过以下 Java 代码来定位到错误位置:
```java
public class ErrorLocationFinder {
public static void main(String[] args) {
String sql = "这里填写完整的 SQL 语句";
int line = 1;
int column = 561;
int currentColumn = 0;
int currentLine = 1;
for (int i = 0; i < sql.length(); i++) {
if (currentLine == line && currentColumn == column - 1) {
System.out.println("错误位置的字符: " + sql.charAt(i));
System.out.println("错误位置附近的内容: " + sql.substring(Math.max(0, i - 10), Math.min(sql.length(), i + 10)));
break;
}
if (sql.charAt(i) == '\n') {
currentLine++;
currentColumn = 0;
} else {
currentColumn++;
}
}
}
}
```
上述代码会输出错误位置的字符以及错误位置附近的内容,有助于进一步排查语法错误。
阅读全文
相关推荐




















