xuanbo / kettle-web Goto Github PK

org.pentaho.di.core 这个包时哪个依赖 没动代码个依赖，运行就报这个包里很多没有。

建议使用官方提供的

<repository>
            <id>pentaho-public</id>
            <name>Pentaho Public</name>
            <url>https://repo.orl.eng.hitachivantara.com/artifactory/pnt-mvn/</url>
            <releases>
                <enabled>true</enabled>
                <updatePolicy>always</updatePolicy>
            </releases>
            <snapshots>
                <enabled>true</enabled>
                <updatePolicy>always</updatePolicy>
            </snapshots>
</repository>

database type with plugin id [HIVE2] couldn't be found!这个问题还存在吗？
这个应该是kettle的big-data-plugin没有集成进来，怎么解决？

Caused by: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: Table 'kettleweb.qrtz_locks' doesn't exist [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'kettleweb.qrtz_locks' doesn't exist]

Could not transfer artifact pentaho-kettle:kettle-core:pom:7.1.0.0-12 from/to maven-default-http-blocker (http://0.0.0.0/): Blocked mirror for repositories: [aliyun (http://maven.aliyun.com/nexus/content/groups/public/, default, releases+snapshots)]

[dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is jetbrick.io.resource.ResourceNotFoundException: templates/index.html] with root cause
jetbrick.io.resource.ResourceNotFoundException: templates/index.html

1、前端页面需要优化升级、不支持修改任务，只支持新增和删除任务操作。
2、不支持调度，数据资源库、和文件资源库的脚本。
3、不支持调度本地Ktr文件，存在想要调度单个转换必须要写一个JOB。
4、没有登录界面、不支持用户管理、大屏运维监控、实时日志、任务超时停止、任务终止杀死后台进程等功能，需要进一步优化升级!!!!!
@xuanbo @YNZH

项目中怎么没看到库表文件呢

你好，请问这个调度的是本地文件资源库是吧

pentaho-kettle:kettle-engine:jar:7.1.0.0-12 was not found in https://maven.aliyun.com/repository/public during a previous attempt. This failure was cached in the local repository and resolution is not reattempted until the update interval of aliyunmaven has elapsed or updates are forced

两个问题 1、某些日志输出乱码
2、Failure obtaining db row lock "对象名无效" 错误

如图：

我的数据源（database-platform: org.hibernate.dialect.SQLServer2008Dialect）是用SQLServer

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'kettleweb.qrtz_locks' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:123)
... 24 common frames omitted

打包能正常打包，直接run和打包后运行都是在启动banner就停了，是因为什么呢？
没有任何日志

不好意思哈，项目的jar包有点难下，没看到如何评论，只能发个issue提问哈~~

java: 读取XXX\repository\org\mozilla\javascript\1.7.2\javascript-1.7.2.jar时出错; error in opening zip file
java: java.lang.RuntimeException: java.io.IOException: Error reading file C:\software\repository\org\mozilla\javascript\1.7.2\javascript-1.7.2.jar: error in opening zip file
本地仓库有该jar包

[ERROR] Failed to execute goal org.springframework.boot:spring-boot-maven-plugin:2.2.0.RELEASE:run (default-cli) on project kettle-web: Application finished with exit code: 1 -> [Help 1]

morg.springframework.beans.factory.BeanCreationException: Error creating bean with name 'kettleConfiguration': Invocation of init method failed; nested exception is java.lang.NoClassDefFoundError: org/apache/commons/vfs2/impl/StandardFileSystemManager
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:160)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:416)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1795)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:595)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:879)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:878)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:550)
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:141)
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:747)
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:315)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1215)
at com.xinqing.etl.kettleweb.Application.main(Application.java:19)

StandardFileSystemManager一直找不到

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'kettleConfiguration': Invocation of init method failed; nested exception is java.lang.NoClassDefFoundError: com/google/common/util/concurrent/SettableFuture
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:160)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:416)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1795)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:595)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:879)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:878)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:550)
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:141)
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:747)
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:315)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1215)
at com.xinqing.etl.kettleweb.Application.main(Application.java:19)

Error creating bean with name 'kettleConfiguration': Invocation of init method failed; nested exception is java.lang.NoClassDefFoundError: com/google/common/util/concurrent/SettableFuture，请问是什么原因？

大佬您好，能加个微信不？目前是kettle新手，可以交流一下吗？我的微信号: M0525M