2025-10-26 18:09:10.242 [927733] INFO launcher.DefaultLauncher.run:68 [tid=0a0f0215cf9854f2] - Task start. (id:d192e8fb0007323b82247a860756717d,name:JDBC_DATATARGER)
2025-10-26 18:09:10.252 [927733] INFO launcher.DefaultLauncher.run:72 [tid=0a0f0215cf9854f2] - Agent:default
2025-10-26 18:09:10.282 [927733] INFO repository.NodeStatusRepository.executeUpdate:158 [tid=0a0f0215cf9854f2] - Report status successful.(state:RUNNING)
2025-10-26 18:09:10.283 [927733] INFO node.GenericNode.start:108 [tid=0a0f0215cf9854f2] - Node start. (id:d192e8fb0007323b82247a860756717d,name:JDBC_DATATARGER)
2025-10-26 18:09:10.283 [927733] INFO datatarget.JdbcDataTargetNode.checkConfig:330 [tid=0a0f0215cf9854f2] - loaded advanced properties: {}
2025-10-26 18:09:10.311 [927733] INFO datasources.InMemoryFileIndex.logInfo:60 [tid=0a0f0215cf9854f2] - It took 2 ms to list leaf files for 1 paths.
2025-10-26 18:09:10.343 [927733] INFO spark.SparkContext.logInfo:60 [tid=0a0f0215cf9854f2] - Starting job: parquet at DatasetEvent.java:247
2025-10-26 18:09:10.370 [927733] INFO scheduler.DAGScheduler.logInfo:60 [tid=0a0f0215cf9854f2] - Job 297869 finished: parquet at DatasetEvent.java:247, took 0.027076 s
2025-10-26 18:09:10.372 [927733] INFO util.EventSerializeUtil.deserialize:106 [tid=0a0f0215cf9854f2] - Deserialization event finished，took 0.088 s
2025-10-26 18:09:10.372 [927733] INFO datatarget.JdbcDataTargetNode.datasetColumnChange:283 [tid=0a0f0215cf9854f2] - Finish rename the Dataset-Column!
2025-10-26 18:09:10.703 [927733] INFO util.JdbcHelper.execute:262 [tid=0a0f0215cf9854f2] - Incorrect datetime value: '20220241' for function str_to_date
java.sql.SQLException: Incorrect datetime value: '20220241' for function str_to_date
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:130) ~[mysql-connector-j-8.1.0.jar:8.1.0]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-j-8.1.0.jar:8.1.0]
at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763) ~[mysql-connector-j-8.1.0.jar:8.1.0]
at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648) ~[mysql-connector-j-8.1.0.jar:8.1.0]
at smartbix.datamining.engine.util.JdbcHelper.execute(JdbcHelper.java:256) [EngineCore-1.0.jar:?]
at smartbix.datamining.engine.datasource.JdbcHandler.executeRollBackMode(JdbcHandler.java:402) [EngineCore-1.0.jar:?]
at smartbix.datamining.engine.execute.node.datasource.handler.MysqlHandler.executor(MysqlHandler.java:37) [EngineCommonNode-1.0.jar:?]
at smartbix.datamining.engine.execute.node.datatarget.JdbcDataTargetNode.execute(JdbcDataTargetNode.java:177) [EngineCommonNode-1.0.jar:?]
at smartbix.datamining.engine.execute.node.GenericNode.start(GenericNode.java:118) [EngineCore-1.0.jar:?]
at smartbix.datamining.engine.agent.execute.executor.DefaultNodeExecutor.execute(DefaultNodeExecutor.java:60) [EngineAgent-1.0.jar:?]
at smartbix.datamining.engine.agent.execute.launcher.DefaultLauncher.run(DefaultLauncher.java:79) [EngineAgent-1.0.jar:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_422]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_422]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_422]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_422]
at java.lang.Thread.run(Thread.java:750) [?:1.8.0_422]
2025-10-26 18:09:10.722 [927733] ERROR node.GenericNode.handleExecuteError:150 [tid=0a0f0215cf9854f2] - Node execution failed.(id:d192e8fb0007323b82247a860756717d,name:JDBC_DATATARGER)
smartbix.datamining.engine.execute.exception.ExecuteException: 删除数据执行失败,详情请看日志
at smartbix.datamining.engine.datasource.JdbcHandler.executeRollBackMode(JdbcHandler.java:405) ~[EngineCore-1.0.jar:?]
at smartbix.datamining.engine.execute.node.datasource.handler.MysqlHandler.executor(MysqlHandler.java:37) ~[EngineCommonNode-1.0.jar:?]
at smartbix.datamining.engine.execute.node.datatarget.JdbcDataTargetNode.execute(JdbcDataTargetNode.java:177) ~[EngineCommonNode-1.0.jar:?]
at smartbix.datamining.engine.execute.node.GenericNode.start(GenericNode.java:118) [EngineCore-1.0.jar:?]
at smartbix.datamining.engine.agent.execute.executor.DefaultNodeExecutor.execute(DefaultNodeExecutor.java:60) [EngineAgent-1.0.jar:?]
at smartbix.datamining.engine.agent.execute.launcher.DefaultLauncher.run(DefaultLauncher.java:79) [EngineAgent-1.0.jar:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_422]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_422]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_422]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_422]
at java.lang.Thread.run(Thread.java:750) [?:1.8.0_422]
Caused by: smartbix.datamining.engine.execute.exception.ExecuteException: java.sql.SQLException: Incorrect datetime value: '20220241' for function str_to_date
at smartbix.datamining.engine.util.JdbcHelper.execute(JdbcHelper.java:263) ~[EngineCore-1.0.jar:?]
at smartbix.datamining.engine.datasource.JdbcHandler.executeRollBackMode(JdbcHandler.java:402) ~[EngineCore-1.0.jar:?]
... 10 more
Caused by: java.sql.SQLException: Incorrect datetime value: '20220241' for function str_to_date
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:130) ~[mysql-connector-j-8.1.0.jar:8.1.0]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-j-8.1.0.jar:8.1.0]
at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763) ~[mysql-connector-j-8.1.0.jar:8.1.0]
at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648) ~[mysql-connector-j-8.1.0.jar:8.1.0]
at smartbix.datamining.engine.util.JdbcHelper.execute(JdbcHelper.java:256) ~[EngineCore-1.0.jar:?]
at smartbix.datamining.engine.datasource.JdbcHandler.executeRollBackMode(JdbcHandler.java:402) ~[EngineCore-1.0.jar:?]
... 10 more
2025-10-26 18:09:10.723 [927733] INFO flow.DistributionFlowContext.notifyNodeFail:538 [tid=0a0f0215cf9854f2] - Number of records outputed:0
2025-10-26 18:09:10.754 [927733] INFO repository.NodeStatusRepository.executeUpdate:158 [tid=0a0f0215cf9854f2] - Report status successful.(state:FAIL)
日志里面显示有20220241这种不规范的数值，可是我去报表里面筛选发现没有呀
| 
