RapidMiner Server Installation - Step 2 ERROR: Failed to check Quartz scheduler tables

eakasitTH
eakasitTH New Altair Community Member
edited November 5 in Community Q&A

Hi,

I just installed RapidMiner 7.3 on Windows 10 and I found the error in installation step 2. The error messages are shown below:

Executing installation.

INFO: Quartz tables successfully created.
INFO: SQL dialect specified: MYSQL.
ERROR: Failed to check Quartz scheduler tables: java.sql.SQLException: Table name pattern can not be NULL or empty.

 Thank you in advance for your help.

 

Best Regards,
EP

Tagged:

Best Answers

  • brandon_harris
    brandon_harris New Altair Community Member
    Answer ✓

    I saw this same error as well. OpenSUSE 42.2 / MySQL (14.14 Distrib 5.6.34) / JRE 8 (1.8.0_111-b14). 

     

    INFO: Quartz tables successfully created.
    INFO: SQL dialect specified: MYSQL.
    ERROR: Failed to check Quartz scheduler tables: java.sql.SQLException: Table name pattern can not be NULL or empty.

     

    I believe I resolved it by going back to the 5.1.31 mysql connector (accidentally downloaded the latest version).

     

  • Marco_Boeck
    Marco_Boeck New Altair Community Member
    Answer ✓

    Hi,

     

    please use the version 5.1 MySQL JDBC connectors, e.g. "mysql-connector-java-5.1.40-bin.jar". It will not work with MySQL version 6.0 drivers.

     

    Regards,

    Marco

Answers

  • Marco_Boeck
    Marco_Boeck New Altair Community Member

    Hi,

     

    cannot reproduce that on a Win10 machine. Do you have the server.log from the SERVER/standalone/logs folder available?

     

    Regards,

    Marco

  • eakasitTH
    eakasitTH New Altair Community Member

    Hi Macro,

    Thank you for your response. I got these message on the terminal.
    -----

    CREATE TABLE QRTZ_LOCKS
    (
    LOCK_NAME VARCHAR(40) NOT NULL,
    PRIMARY KEY (LOCK_NAME)
    )
    21:33:12,747 INFO [de.rapidanalytics.SQLScriptExecutor] (http-/0.0.0.0:8080-1) Executing:


    INSERT INTO QRTZ_LOCKS values('TRIGGER_ACCESS')
    21:33:12,771 INFO [de.rapidanalytics.SQLScriptExecutor] (http-/0.0.0.0:8080-1) Executing:
    INSERT INTO QRTZ_LOCKS values('JOB_ACCESS')
    21:33:12,802 INFO [de.rapidanalytics.SQLScriptExecutor] (http-/0.0.0.0:8080-1) Executing:
    INSERT INTO QRTZ_LOCKS values('CALENDAR_ACCESS')
    21:33:12,901 INFO [de.rapidanalytics.SQLScriptExecutor] (http-/0.0.0.0:8080-1) Executing:
    INSERT INTO QRTZ_LOCKS values('STATE_ACCESS')
    21:33:12,969 INFO [de.rapidanalytics.SQLScriptExecutor] (http-/0.0.0.0:8080-1) Executing:
    INSERT INTO QRTZ_LOCKS values('MISFIRE_ACCESS')
    21:33:13,076 INFO [de.rapidanalytics.SQLScriptExecutor] (http-/0.0.0.0:8080-1) Executing:


    commit
    21:33:13,082 INFO [de.rapidanalytics.RapidAnalyticsSetup] (http-/0.0.0.0:8080-1) Quartz tables successfully created.
    21:33:13,083 INFO [de.rapidanalytics.RapidAnalyticsSetup] (http-/0.0.0.0:8080-1) INITIAL SETUP CHECK: Checking RapidMiner Server setup.
    21:33:13,086 INFO [de.rapidanalytics.RapidAnalyticsSetup] (http-/0.0.0.0:8080-1) INITIAL SETUP CHECK: Successfully accessed java:/jdbc/RapidAnalyticsDS
    21:33:13,093 WARNING [de.rapidanalytics.RapidAnalyticsSetup] (http-/0.0.0.0:8080-1) INITIAL SETUP CHECK: Failed to check for quartz tables: java.sql.SQLException: Table name pattern can not be NULL or empty.: java.sql.SQLException: Table name pattern can not be NULL or empty.
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:569)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:537)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:527)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:512)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:480)
    at com.mysql.cj.jdbc.DatabaseMetaData.getTables(DatabaseMetaData.java:3844)
    at de.rapidanalytics.RapidAnalyticsSetup.checkSetup(RapidAnalyticsSetup.java:129) [rapidminer-server-commons-7.3.1.jar:]
    at de.rapidanalytics.RapidAnalyticsSetup.runSetupNow(RapidAnalyticsSetup.java:196) [rapidminer-server-commons-7.3.1.jar:]
    at de.rapidanalytics.web.beans.SetupBean.runSetupNow(SetupBean.java:102) [classes:]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_91]
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) [rt.jar:1.8.0_91]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) [rt.jar:1.8.0_91]
    at java.lang.reflect.Method.invoke(Unknown Source) [rt.jar:1.8.0_91]
    at org.apache.el.parser.AstValue.invoke(AstValue.java:258) [jbossweb-7.5.3.Final.jar:7.5.3.Final]
    at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:278) [jbossweb-7.5.3.Final.jar:7.5.3.Final]
    at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68) [jsf-facelets-1.1.15.B1.jar:1.1.15.B1]
    at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:87) [jboss-jsf-api_2.1_spec-2.1.28.Final-redhat-1.jar:2.1.28.Final-redhat-1]
    at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:101) [jsf-impl-2.1.28.redhat-6.jar:2.1.28.redhat-6]
    at javax.faces.component.UICommand.broadcast(UICommand.java:315) [jboss-jsf-api_2.1_spec-2.1.28.Final-redhat-1.jar:2.1.28.Final-redhat-1]
    at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:329) [richfaces-impl-jsf2-3.3.3.Final.jar:3.3.3.Final]
    at org.ajax4jsf.component.AjaxViewRoot.broadcastEventsForPhase(AjaxViewRoot.java:304) [richfaces-impl-jsf2-3.3.3.Final.jar:3.3.3.Final]
    at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:261) [richfaces-impl-jsf2-3.3.3.Final.jar:3.3.3.Final]
    at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:474) [richfaces-impl-jsf2-3.3.3.Final.jar:3.3.3.Final]
    at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81) [jsf-impl-2.1.28.redhat-6.jar:2.1.28.redhat-6]
    at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101) [jsf-impl-2.1.28.redhat-6.jar:2.1.28.redhat-6]
    at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118) [jsf-impl-2.1.28.redhat-6.jar:2.1.28.redhat-6]
    at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593) [jboss-jsf-api_2.1_spec-2.1.28.Final-redhat-1.jar:2.1.28.Final-redhat-1]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) [jbossweb-7.5.3.Final.jar:7.5.3.Final]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.3.Final.jar:7.5.3.Final]
    at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:206) [richfaces-impl-jsf2-3.3.3.Final.jar:3.3.3.Final]
    at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:290) [richfaces-impl-jsf2-3.3.3.Final.jar:3.3.3.Final]
    at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:388) [richfaces-impl-jsf2-3.3.3.Final.jar:3.3.3.Final]
    at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:515) [richfaces-impl-jsf2-3.3.3.Final.jar:3.3.3.Final]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.5.3.Final.jar:7.5.3.Final]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.3.Final.jar:7.5.3.Final]
    at de.rapidanalytics.web.filter.SetupFilter.doFilter(SetupFilter.java:77) [classes:]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.5.3.Final.jar:7.5.3.Final]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.3.Final.jar:7.5.3.Final]
    at de.rapidanalytics.web.filter.IE8CompatibilityFilter.doFilter(IE8CompatibilityFilter.java:40) [classes:]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.5.3.Final.jar:7.5.3.Final]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.3.Final.jar:7.5.3.Final]
    at de.rapidanalytics.web.filter.AccessLogFilter.doFilter(AccessLogFilter.java:50) [classes:]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.5.3.Final.jar:7.5.3.Final]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.3.Final.jar:7.5.3.Final]
    at de.rapidanalytics.web.filter.LicenseCheckFilter.doFilter(LicenseCheckFilter.java:56) [classes:]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.5.3.Final.jar:7.5.3.Final]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.3.Final.jar:7.5.3.Final]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) [spring-security-web-3.2.4.RELEASE.jar:3.2.4.RELEASE]
    at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118) [spring-security-web-3.2.4.RELEASE.jar:3.2.4.RELEASE]
    at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84) [spring-security-web-3.2.4.RELEASE.jar:3.2.4.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.2.4.RELEASE.jar:3.2.4.RELEASE]
    at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) [spring-security-web-3.2.4.RELEASE.jar:3.2.4.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.2.4.RELEASE.jar:3.2.4.RELEASE]
    at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103) [spring-security-web-3.2.4.RELEASE.jar:3.2.4.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.2.4.RELEASE.jar:3.2.4.RELEASE]
    at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) [spring-security-web-3.2.4.RELEASE.jar:3.2.4.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.2.4.RELEASE.jar:3.2.4.RELEASE]
    at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154) [spring-security-web-3.2.4.RELEASE.jar:3.2.4.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.2.4.RELEASE.jar:3.2.4.RELEASE]
    at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45) [spring-security-web-3.2.4.RELEASE.jar:3.2.4.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.2.4.RELEASE.jar:3.2.4.RELEASE]
    at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199) [spring-security-web-3.2.4.RELEASE.jar:3.2.4.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.2.4.RELEASE.jar:3.2.4.RELEASE]
    at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:110) [spring-security-web-3.2.4.RELEASE.jar:3.2.4.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.2.4.RELEASE.jar:3.2.4.RELEASE]
    at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50) [spring-security-web-3.2.4.RELEASE.jar:3.2.4.RELEASE]
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-3.2.8.RELEASE.jar:3.2.8.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.2.4.RELEASE.jar:3.2.4.RELEASE]
    at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) [spring-security-web-3.2.4.RELEASE.jar:3.2.4.RELEASE]
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) [spring-security-web-3.2.4.RELEASE.jar:3.2.4.RELEASE]
    at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192) [spring-security-web-3.2.4.RELEASE.jar:3.2.4.RELEASE]
    at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160) [spring-security-web-3.2.4.RELEASE.jar:3.2.4.RELEASE]
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) [spring-web-3.2.8.RELEASE.jar:3.2.8.RELEASE]
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) [spring-web-3.2.8.RELEASE.jar:3.2.8.RELEASE]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.5.3.Final.jar:7.5.3.Final]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.3.Final.jar:7.5.3.Final]
    at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176) [urlrewritefilter-4.0.3.jar:4.0.3]
    at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) [urlrewritefilter-4.0.3.jar:4.0.3]
    at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) [urlrewritefilter-4.0.3.jar:4.0.3]
    at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394) [urlrewritefilter-4.0.3.jar:4.0.3]
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.5.3.Final.jar:7.5.3.Final]
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.3.Final.jar:7.5.3.Final]
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) [jbossweb-7.5.3.Final.jar:7.5.3.Final]
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.5.3.Final.jar:7.5.3.Final]
    at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa-7.5.0.Final-redhat-15.jar:7.5.0.Final-redhat-15]
    at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa-7.5.0.Final-redhat-15.jar:7.5.0.Final-redhat-15]
    at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.5.0.Final-redhat-15.jar:7.5.0.Final-redhat-15]
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:150) [jbossweb-7.5.3.Final.jar:7.5.3.Final]
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.5.3.Final.jar:7.5.3.Final]
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.5.3.Final.jar:7.5.3.Final]
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344) [jbossweb-7.5.3.Final.jar:7.5.3.Final]
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:854) [jbossweb-7.5.3.Final.jar:7.5.3.Final]
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb-7.5.3.Final.jar:7.5.3.Final]
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926) [jbossweb-7.5.3.Final.jar:7.5.3.Final]
    at java.lang.Thread.run(Unknown Source) [rt.jar:1.8.0_91]

    ----
    Best Regards,

    EP

  • brandon_harris
    brandon_harris New Altair Community Member
    Answer ✓

    I saw this same error as well. OpenSUSE 42.2 / MySQL (14.14 Distrib 5.6.34) / JRE 8 (1.8.0_111-b14). 

     

    INFO: Quartz tables successfully created.
    INFO: SQL dialect specified: MYSQL.
    ERROR: Failed to check Quartz scheduler tables: java.sql.SQLException: Table name pattern can not be NULL or empty.

     

    I believe I resolved it by going back to the 5.1.31 mysql connector (accidentally downloaded the latest version).

     

  • Marco_Boeck
    Marco_Boeck New Altair Community Member
    Answer ✓

    Hi,

     

    please use the version 5.1 MySQL JDBC connectors, e.g. "mysql-connector-java-5.1.40-bin.jar". It will not work with MySQL version 6.0 drivers.

     

    Regards,

    Marco

  • eakasitTH
    eakasitTH New Altair Community Member

    Hi brandon_harris and Marco_Boeck,

     

    Thank you so much for your kindly help. I can use RapidMiner Server now.

     

    Best Regards,

    EP

  • jaydeepmarvaniy
    jaydeepmarvaniy New Altair Community Member

    I was having the same issue with my windows installation. Thanks for the suggestion. Your help has solved the issue. 

Categories