定时同步EXCEL可以导入,同步成功但是数据为空。定时同步SQL数据集,直接同步失败,请问如何解决?

定时同步SQL数据集,直接报错



下面是报错的内容

There was an error preparing the transformation for excution on the remote server:
Initialisation of transformation failed: 2025/11/02 13:26:00 - Carte - Installing timer to purge stale objects after 1440 minutes.2025/11/02 13:26:00 - Carte - Created listener for webserver @ address : kettle:180802025/11/02 13:42:53 - General - I couldn’t find the repository with name 'repo’2025/11/02 13:42:54 - General - I couldn’t find the repository with name 'repo’2025/11/02 13:43:52 - General - I couldn’t find the repository with name 'repo’2025/11/02 13:43:53 - General - I couldn’t find the repository with name 'repo’2025/11/02 13:50:25 - General - I couldn’t find the repository with name 'repo’2025/11/02 13:50:49 - General - I couldn’t find the repository with name 'repo’2025/11/02 13:56:52 - General - I couldn’t find the repository with name 'repo’2025/11/02 13:56:52 - General - I couldn’t find the repository with name 'repo’2025/11/02 13:58:03 - General - I couldn’t find the repository with name 'repo’2025/11/02 14:02:03 - General - I couldn’t find the repository with name 'repo’2025/11/02 14:06:09 - General - I couldn’t find the repository with name 'repo’2025/11/02 14:06:09 - General - I couldn’t find the repository with name 'repo’2025/11/02 14:24:17 - General - I couldn’t find the repository with name 'repo’2025/11/02 14:24:17 - General - I couldn’t find the repository with name 'repo’2025/11/02 14:25:54 - General - I couldn’t find the repository with name 'repo’2025/11/02 14:25:54 - General - I couldn’t find the repository with name 'repo’2025/11/02 14:38:21 - General - I couldn’t find the repository with name 'repo’2025/11/02 14:38:21 - General - I couldn’t find the repository with name 'repo’2025/11/02 14:47:31 - General - I couldn’t find the repository with name 'repo’2025/11/02 14:47:31 - General - I couldn’t find the repository with name 'repo’2025/11/02 14:55:59 - General - I couldn’t find the repository with name 'repo’2025/11/02 14:55:59 - General - I couldn’t find the repository with name 'repo’2025/11/02 14:58:03 - General - I couldn’t find the repository with name 'repo’2025/11/02 14:58:03 - General - I couldn’t find the repository with name 'repo’2025/11/02 15:00:19 - General - I couldn’t find the repository with name 'repo’2025/11/02 15:00:19 - General - I couldn’t find the repository with name 'repo’2025/11/02 15:13:55 - General - I couldn’t find the repository with name 'repo’2025/11/02 15:15:59 - General - I couldn’t find the repository with name 'repo’2025/11/02 15:24:37 - General - I couldn’t find the repository with name 'repo’2025/11/02 15:25:59 - General - I couldn’t find the repository with name 'repo’2025/11/02 15:43:38 - General - I couldn’t find the repository with name 'repo’2025/11/02 15:47:38 - General - I couldn’t find the repository with name 'repo’2025/11/02 15:47:38 - trans_ds_98f8a34e_a02b_4f39_99d4_d81c42ef1454 - Dispatching started for transformation [trans_ds_98f8a34e_a02b_4f39_99d4_d81c42ef1454]2025/11/02 15:47:38 - UserDefinedJavaClass.0 - ERROR (version 8.3.0.0-371, build 8.3.0.0-371 from 2019-06-11 11.09.08 by buildguy) : Error initializing UserDefinedJavaClass:2025/11/02 15:47:38 - UserDefinedJavaClass.0 - ERROR (version 8.3.0.0-371, build 8.3.0.0-371 from 2019-06-11 11.09.08 by buildguy) : org.pentaho.di.core.exception.KettleException: 2025/11/02 15:47:38 - UserDefinedJavaClass.0 - null2025/11/02 15:47:38 - UserDefinedJavaClass.0 - ERROR (version 8.3.0.0-371, build 8.3.0.0-371 from 2019-06-11 11.09.08 by buildguy) : Error initializing step [UserDefinedJavaClass]2025/11/02 15:47:38 - Data Input.0 - ERROR (version 8.3.0.0-371, build 8.3.0.0-371 from 2019-06-11 11.09.08 by buildguy) : An error occurred, processing will be stopped: 2025/11/02 15:47:38 - Data Input.0 - Error occurred while trying to connect to the database2025/11/02 15:47:38 - Data Input.0 - 2025/11/02 15:47:38 - Data Input.0 - Error connecting to database: (using class org.gjt.mm.mysql.Driver)2025/11/02 15:47:38 - Data Input.0 - Communications link failure2025/11/02 15:47:38 - Data Input.0 - 2025/11/02 15:47:38 - Data Input.0 - The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.2025/11/02 15:47:38 - Data Input.0 - ERROR (version 8.3.0.0-371, build 8.3.0.0-371 from 2019-06-11 11.09.08 by buildguy) : Error initializing step [Data Input]2025/11/02 15:47:38 - trans_ds_98f8a34e_a02b_4f39_99d4_d81c42ef1454 - ERROR (version 8.3.0.0-371, build 8.3.0.0-371 from 2019-06-11 11.09.08 by buildguy) : Step [Data Input.0] failed to initialize!2025/11/02 15:47:38 - trans_ds_98f8a34e_a02b_4f39_99d4_d81c42ef1454 - ERROR (version 8.3.0.0-371, build 8.3.0.0-371 from 2019-06-11 11.09.08 by buildguy) : Step [UserDefinedJavaClass.0] failed to initialize!2025/11/02 15:47:38 - Data Input.0 - Finished reading query, closing connection.org.pentaho.di.core.exception.KettleException: We failed to initialize at least one step. Execution can not begin! at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:1277) at org.pentaho.di.www.PrepareExecutionTransServlet.doGet(PrepareExecutionTransServlet.java:218) at javax.servlet.http.HttpServlet.service(HttpServlet.java:575) at javax.servlet.http.HttpServlet.service(HttpServlet.java:668) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:684) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:503) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:229) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:429) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:255) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:522) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116) at org.eclipse.jetty.server.Server.handle(Server.java:370) at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:494) at org.eclipse.jetty.server.BlockingHttpConnection.handleRequest(BlockingHttpConnection.java:53) at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:971) at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1033) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:644) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235) at org.eclipse.jetty.server.BlockingHttpConnection.handle(BlockingHttpConnection.java:72) at org.eclipse.jetty.server.bio.SocketConnector$ConnectorEndPoint.run(SocketConnector.java:264) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543) at java.lang.Thread.run(Thread.java:748)

进行EXCEL的定时同步,同步成功,但是数据显示为空

查询drios数据库发现创建的表数据都为空

下面是kettle的配置信息:

<?xml version="1.0" encoding="UTF-8"?> KettleFileRepository repo File repository false /BITools/resource/data/kettle N N

kettle挂载点有对应导入的EXCEL文件,其数据显示正常

下面是kettle的配置信息:

<?xml version="1.0" encoding="UTF-8"?>
<repositories>
    <repository>    <id>KettleFileRepository</id>
        <name>repo</name>
        <description>File repository</description>
        <is_default>false</is_default>
        <base_directory>/BITools/resource/data/kettle</base_directory>
        <read_only>N</read_only>
        <hides_hidden_files>N</hides_hidden_files>
    </repository>  </repositories>

解决方法可以参考一下这个帖子
同步数据的时候显示同步失败错误如下,前后端分离源码部署的,不知道是哪里的问题 - DataEase - 社区论坛 - FIT2CLOUD 飞致云

您好,我这边是下载docker desktop软件,直接部署在windows的,是以容器的形式部署,我看了配置都一样,主要是报错找不到‘repo’

源码部署的话需要自己研究一下