Why does the migration window opens when I am installing Rapidminer server for first time?

khadevishal18
khadevishal18 New Altair Community Member
edited November 5 in Community Q&A
I am installing Rapidminer headless server first time on my linux machine using headless installation.The login page opens in browser and after login a migration window opens and the migration fails.
Why does the migration window opens when I am installing Rapidminer server for first time?
Migration fails when I continue to follow migration steps?

Answers

  • mmichel
    mmichel New Altair Community Member
    edited November 2018
    Hi khadevishal18,

    which version of RapidMiner Server are you using? The latest is currently 9.0.4.
    Just tried a headleass installation with MySQL and everything worked like expected. So, it might be nice to know which database and JDBC driver you are using. For a new installation it is also important that the database/schema does not contain any content - please make sure that it is actually empty.

    If the migration steps are still shown please let us know the version information of the migration page: configured version and the installed version.

    Cheers,
    Marcel
  • khadevishal18
    khadevishal18 New Altair Community Member
    We have created new database schema and privileges are also given we are doing fresh installation on Linux machine but we got the below errors?
    After first schema update we got error as "Table or view does not exists".
    We have started installing Rapidminer server on windows machine the server startup was successful.
    When we compared both logs we observed in LINUX MACHINE that Server startup is getting failed before RapidAnalytics setup is created.
    Below is log from Linux machine..
    Complete Log is also attached.


    07:17:23,385 INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (ServerService Thread Pool -- 52) HHH000261: Table found: SYSTEM.RA_REL_USER_GROUP
    07:17:23,386 INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (ServerService Thread Pool -- 52) HHH000037: Columns: [groupname, username]
    07:17:23,386 INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (ServerService Thread Pool -- 52) HHH000108: Foreign keys: [fk_io9l744nr09bkt92vku4k9mdd, fk_r1699qsprpnessx99imqmw4j4]
    07:17:23,387 INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (ServerService Thread Pool -- 52) HHH000126: Indexes: []
    07:17:23,392 INFO  [org.hibernate.tool.hbm2ddl.SchemaUpdate] (ServerService Thread Pool -- 52) HHH000232: Schema update complete
    07:17:24,035 INFO  [org.jboss.ejb.client] (ServerService Thread Pool -- 54) JBoss EJB Client version 1.0.26.Final-redhat-1
    07:17:24,550 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB default - 1) SQL Error: 942, SQLState: 42000
    07:17:24,552 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB default - 1) ORA-00942: table or view does not exist

    07:17:24,550 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (ServerService Thread Pool -- 60) SQL Error: 942, SQLState: 42000
    07:17:24,555 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (ServerService Thread Pool -- 60) ORA-00942: table or view does not exist

    07:17:24,555 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (ServerService Thread Pool -- 59) SQL Error: 942, SQLState: 42000


  • mmichel
    mmichel New Altair Community Member
    So, both machines are using the same DB? Or have you installed the DB on the host as well? Could you please provide the DB version you are using? It might also be helpful to know the Linux distribution/version. You are using the Oracle JRE, right?