[GRIFFIN-354] Table 'quartz.DATACONNECTOR' doesn't exist

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.6.0
• Component/s: Measure Module
• Labels: 0.6.0
• Assignee: Unassigned
• Reporter: Kingsley
• Created: 30/Dec/20 02:10
• Updated: 07/Sep/22 11:48

Description

when i create a measure, the log dispaly the below error information:

 

 

2020-12-29 21:44:38.992 ERROR 2997 — [http-nio-8080-exec-6] 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 => [5, \{"database":"default","table.name":"demo_src"}, 1609249478939, null, , 1day, null, source1609250030772, HIVE, 1.2]
Query: InsertObjectQuery(DataConnector{name=source1609250030772type=HIVE, version='1.2', config={"database":"default","table.name":"demo_src"}})] with root cause

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'quartz.DATACONNECTOR' doesn't exist

 

 

But I can't find the table name  in the  init_quartz_mysql_innodb.sql

It's confusing