Hi Xin, Can you tell us which version you're using? Can you provide more details?
Thanks, Kevin On Wed, Oct 28, 2020 at 10:36 PM William Guo <[email protected]> wrote: > I don't think we should have a dataconnector table for quartz? > Could you share the full log? > > > > On Wed, Oct 28, 2020 at 10:26 PM [email protected] < > [email protected]> wrote: > > > when i submit > > > > > > get the error > > ''' > > 2020-10-28 16:01:35.218 ERROR 872879 --- [http-nio-8080-exec-10] > > o.a.c.c.C.[.[.[.[dispatcherServlet] [175] : Servlet.service() for > > servlet [dispatcherServlet] in context with path [] threw exception > > [Request processing failed; nested exception is > > org.springframework.transaction.TransactionSystemException: Could not > > commit JPA transaction; nested exception is > > javax.persistence.RollbackException: Exception [EclipseLink-4002] > (Eclipse > > Persistence Services - 2.6.0.v20150309-bf26070): > > org.eclipse.persistence.exceptions.DatabaseException > > Internal Exception: > > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > > 'quartz.DATACONNECTOR' doesn't exist > > Error Code: 1146 > > Call: INSERT INTO DATACONNECTOR (ID, CONFIG, CREATEDDATE, DATAFRAMENAME, > > DATATIMEZONE, DATAUNIT, MODIFIEDDATE, NAME, TYPE, VERSION) VALUES (?, ?, > ?, > > ?, ?, ?, ?, ?, ?, ?) > > bind => [12, {"database":"test","table.name > ":"hdfs_meta_data_sum1","where":""}, > > 1603872095196, null, , 1day, null, source1603869251654, HIVE, 1.2] > > Query: InsertObjectQuery(DataConnector{name=source1603869251654type=HIVE, > > version='1.2', config={"database":"test","table.name > ":"hdfs_meta_data_sum1","where":""}})] > > with root cause > > > > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > > 'quartz.DATACONNECTOR' doesn't exist > > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > > ~[?:1.8.0_60] > > at > > > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) > > ~[?:1.8.0_60] > > at > > > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > > ~[?:1.8.0_60] > > at java.lang.reflect.Constructor.newInstance(Constructor.java:422) > > ~[?:1.8.0_60] > > at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) > > ~[mysql-connector-java-5.1.47.jar:5.1.47] > > at com.mysql.jdbc.Util.getInstance(Util.java:408) > > ~[mysql-connector-java-5.1.47.jar:5.1.47] > > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944) > > ~[mysql-connector-java-5.1.47.jar:5.1.47] > > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978) > > ~[mysql-connector-java-5.1.47.jar:5.1.47] > > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914) > > ~[mysql-connector-java-5.1.47.jar:5.1.47] > > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) > > ~[mysql-connector-java-5.1.47.jar:5.1.47] > > > > ''' > > i can not find 'quartz.DATACONNECTOR ' in Init_quartz_mysql_innodb.sql > > < > https://github.com/apache/griffin/blob/master/service/src/main/resources/Init_quartz_mysql_innodb.sql > > > > please help me. > > ------------------------------ > > > > 姓 名：张 欣 > > > > 邮 件：[email protected] > > > > 地 址：杭州市滨江区江南大道3688号潮人汇9楼 > > > > 网 址：www.ngarihealth.com > > >
