Initialisation of transformation failed: 2023/08/03 10:32:28 - Carte - Installing timer to purge stale objects after 1440 minutes.2023/08/03 10:32:28 - Carte - Created listener for webserver @ address : 0.0.0.0:180802023/08/03 15:44:44 - General - I couldn’t find the repository with name 'repo’2023/08/03 15:50:04 - General - I couldn’t find the repository with name 'repo’2023/08/03 16:19:01 - General - I couldn’t find the repository with name 'repo’2023/08/03 16:19:02 - trans_ds_c8ca6a26_f025_48e9_8624_550ea1e32c89 - Dispatching started for transformation [trans_ds_c8ca6a26_f025_48e9_8624_550ea1e32c89]2023/08/03 16:19:02 - UserDefinedJavaClass.0 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Error initializing UserDefinedJavaClass:2023/08/03 16:19:02 - UserDefinedJavaClass.0 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : org.codehaus.janino.CompileException: Line 27, Column 16: Expression “List < String > fields” is not an lvalue2023/08/03 16:19:02 - UserDefinedJavaClass.0 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Error initializing step [UserDefinedJavaClass]2023/08/03 16:19:02 - trans_ds_c8ca6a26_f025_48e9_8624_550ea1e32c89 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Step [UserDefinedJavaClass.0] failed to initialize!2023/08/03 16:19:02 - 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:1157) at org.pentaho.di.www.PrepareExecutionTransServlet.doGet(PrepareExecutionTransServlet.java:216) 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)
kettle 跟 dataease 部署在一起不？还是分开部署的？
kettle 跟doris 都是单独部署在服务器上的 不是用的容器
kettle doris dataease 都是在同一个服务器上
kettle 的家目录要取 dataease 的 /opt/dataease/data/kettle，这一步检查下呢
kettle：192.168.32.66:18080
doris: 192.168.32.66:9050/8030
dataease 后端服务 192.168.32.66:8081
类似是这种的
是在kettle的配置里 指定 根目录 到/opt/dataease/data/kettle 么
是的，conf 下有 kettle 的配置文件，可以检查下。
这么看配置文件没有问题，kettle 的报错信息是否还有更多？目前看来无法判断出是什么原因
现在上传excel文件的时候也会报错/opt/dataease/data/kettle/admin/423709c9-b8f1-4a1c-8a1d-ea4d18b9a0c7.xlsx (Permission denied)",
chmod 777 /opt/dataease/data/kettle/
修改下这个文件目录权限试试
修改之后可以成功上传 但是 数据是空的 而且显示失败 失败的错误如下
There was an error preparing the transformation for excution on the remote server:
Initialisation of transformation failed: 2023/08/03 10:32:28 - Carte - Installing timer to purge stale objects after 1440 minutes.2023/08/03 10:32:28 - Carte - Created listener for webserver @ address : 0.0.0.0:180802023/08/03 15:44:44 - General - I couldn’t find the repository with name 'repo’2023/08/03 15:50:04 - General - I couldn’t find the repository with name 'repo’2023/08/03 16:19:01 - General - I couldn’t find the repository with name 'repo’2023/08/03 16:26:43 - General - I couldn’t find the repository with name 'repo’2023/08/03 17:31:29 - General - I couldn’t find the repository with name 'repo’2023/08/03 17:32:24 - General - I couldn’t find the repository with name 'repo’2023/08/03 17:33:20 - General - I couldn’t find the repository with name 'repo’2023/08/03 17:33:20 - trans_ds_652833b8_84c7_452d_b423_1a04e10b8a5b - Dispatching started for transformation [trans_ds_652833b8_84c7_452d_b423_1a04e10b8a5b]2023/08/03 17:33:20 - UserDefinedJavaClass.0 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Error initializing UserDefinedJavaClass:2023/08/03 17:33:20 - UserDefinedJavaClass.0 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : org.codehaus.janino.CompileException: Line 27, Column 16: Expression “List < String > fields” is not an lvalue2023/08/03 17:33:20 - UserDefinedJavaClass.0 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Error initializing step [UserDefinedJavaClass]2023/08/03 17:33:20 - trans_ds_652833b8_84c7_452d_b423_1a04e10b8a5b - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Step [UserDefinedJavaClass.0] failed to initialize!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:1157) at org.pentaho.di.www.PrepareExecutionTransServlet.doGet(PrepareExecutionTransServlet.java:216) 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)
你的 kettle 的版本是 7 吗？换成 8 试试
换成8可以了 感谢！！！
点赞点赞
There was an error preparing the transformation for excution on the remote server:
Initialisation of transformation failed: 2023/10/13 13:33:24 - Carte - Installing timer to purge stale objects after 1440 minutes.2023/10/13 13:33:24 - Carte - Created listener for webserver @ address : 192.168.2.186:80802023/10/13 13:35:46 - RepositoriesMeta - Reading repositories XML file: /root/.kettle/repositories.xml2023/10/13 13:46:19 - RepositoriesMeta - Reading repositories XML file: /root/.kettle/repositories.xml2023/10/13 13:46:19 - trans_ds_8d65f57e_1b98_46f3_8249_f8f812253b48 - Dispatching started for transformation [trans_ds_8d65f57e_1b98_46f3_8249_f8f812253b48]2023/10/13 13:46:20 - Data Input 1.0 - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : No file(s) specified! Stop processing.2023/10/13 13:46:20 - Data Input 1.0 - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : Error initializing step [Data Input 1]2023/10/13 13:46:20 - trans_ds_8d65f57e_1b98_46f3_8249_f8f812253b48 - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : Step [Data Input 1.0] failed to initialize!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:1301) at org.pentaho.di.www.PrepareExecutionTransServlet.doGet(PrepareExecutionTransServlet.java:219) at javax.servlet.http.HttpServlet.service(HttpServlet.java:687) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:873) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:542) at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1700) at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1345) at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:480) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1667) at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1247) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:220) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:61) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:513) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132) at org.eclipse.jetty.server.Server.handle(Server.java:505) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:370) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:267) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:305) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103) at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126) at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:698) at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:804) at java.lang.Thread.run(Thread.java:748)
请问下。我导入Excel数据集也是遇到这个问题，我的kettle不是用容器安装的。配置放在/root/.kettle/目录下。如下图
麻烦大佬看下啥问题
看看上面的评论，参考修改试试，你的kettle版本是version 9.4.0