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

Welcome!

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

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.

Welcome!

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