Skip to content
  • Register

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

    eakasitTH
    eakasitTH New Altair Community Member
    edited November 2024 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:

    Welcome!

    It looks like you're new here. Sign in or register to get started.
    Sign In
    Register

    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. 

    Welcome!

    It looks like you're new here. Sign in or register to get started.
    Sign In
    Register

    Welcome!

    It looks like you're new here. Sign in or register to get started.
    Sign In
    Register

    Quick Links

    Categories