rapidminer-batch.sh on mac error

RyandaRyanda Member Posts: 3 Newbie
edited April 2020 in Help
Hi, i need some help to fix this. i've searched for possible solution but still getting the same error.

i want to run a process using script in terminal, i opened a terminal from script folder directly and input this code:
sh rapidminer-batch.sh -f /Users/ryanda/Documents/Rapidminer/Alfa/test_write_from_database.rm
and then i got this error message:

<p>RAPIDMINER_HOME is not set. Trying the directory '/Applications/RapidMiner Studio.app/Contents/Resources/RapidMiner-Studio'...</p>
<p>Exception in thread "main" java.lang.NoClassDefFoundError: javax/xml/bind/DatatypeConverter</p>
<p><span>	at com.rapidminer.security.PluginSandboxPolicy.createPublicKey(PluginSandboxPolicy.java:161)</span></p>
<p><span>	at com.rapidminer.security.PluginSandboxPolicy.<clinit>(PluginSandboxPolicy.java:111)</span></p>
<p><span>	at com.rapidminer.launcher.CommandLineLauncher.main(CommandLineLauncher.java:309)</span></p>
<p>Caused by: java.lang.ClassNotFoundException: javax.xml.bind.DatatypeConverter</p>
<p><span>	at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:602)</span></p>
<p><span>	at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:178)</span></p>
<p><span>	at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:522)</span></p>
<p><span>	... 3 more</span></p>

i found another post saying you need JDK 8 for rapidminer.
my rapidminer is version 9.6 and this is the java version i'm using:

<p>java version "1.8.0_241"</p>
<p>Java(TM) SE Runtime Environment (build 1.8.0_241-b07)</p>
<p>Java HotSpot(TM) 64-Bit Server VM (build 25.241-b07, mixed mode)</p>


Thanks,

Tagged:

Best Answer

  • rfuentealbarfuentealba Moderator, RapidMiner Certified Analyst, Member, University Professor Posts: 568 Unicorn
    Solution Accepted
    Hello.

    What does the JAVA_HOME environment look like? That might be pointing to another version of Java.

    Perhaps if instead of using sh, you just give permissions to the rapidminer-batch.sh?

    All.the best,

    Rod.

Answers

  • RyandaRyanda Member Posts: 3 Newbie
    Hi thanks for the answer,

    After i check the java environment it was pointing to JDK 14 that i have.
    I changed it to version 1.8 and now the result is this:

    /Library/Java/JavaVirtualMachines/jdk1.8.0_241.jdk/Contents/Home


    Then i tried to run the same command as i post before and it show me this:
    RAPIDMINER_HOME is not set. Trying the directory '/Applications/RapidMiner Studio.app/Contents/Resources/RapidMiner-Studio'...
    RapidMiner Studio version 9.6.000, Copyright (C) 2001-2020 RapidMiner GmbH
    See End User License Agreement information in the file named EULA.
    Apr 14, 2020 7:59:36 PM com.rapidminer.tools.I18N <clinit>
    INFO: Set locale to en.
    Apr 14, 2020 7:59:36 PM com.rapidminer.tools.PlatformUtilities logInfo
    INFO: rapidminer.home is '/Applications/RapidMiner Studio.app/Contents/Resources/RapidMiner-Studio'.
    Apr 14, 2020 7:59:36 PM com.rapidminer.core.license.ProductConstraintManager initialize
    INFO: Initializing license manager.
    Apr 14, 2020 7:59:36 PM com.rapidminer.core.license.ProductConstraintManager initialize
    INFO: Using default license location.
    Apr 14, 2020 7:59:36 PM com.rapidminer.core.license.ProductConstraintManager initialize
    INFO: Registering default product.
    Apr 14, 2020 7:59:39 PM com.rapidminer.tools.plugin.Plugin registerPlugins
    INFO: Register plugin: Converters
    Apr 14, 2020 7:59:39 PM com.rapidminer.tools.plugin.Plugin registerPlugins
    INFO: Register plugin: In-Database Processing
    Apr 14, 2020 7:59:39 PM com.rapidminer.tools.plugin.Plugin registerPlugins
    INFO: Register plugin: Python Scripting
    Apr 14, 2020 7:59:39 PM com.rapidminer.tools.plugin.Plugin registerPlugins
    INFO: Register plugin: Text Processing
    Apr 14, 2020 7:59:39 PM com.rapidminer.tools.plugin.Plugin registerPlugins
    INFO: Register plugin: Blending
    Apr 14, 2020 7:59:39 PM com.rapidminer.tools.plugin.Plugin registerPlugins
    INFO: Register plugin: Process Scheduling
    Apr 14, 2020 7:59:39 PM com.rapidminer.tools.plugin.Plugin registerPlugins
    INFO: Register plugin: Cloud Connectivity
    Apr 14, 2020 7:59:39 PM com.rapidminer.tools.plugin.Plugin registerPlugins
    INFO: Register plugin: Advanced File Connectors
    Apr 14, 2020 7:59:39 PM com.rapidminer.tools.plugin.Plugin registerPlugins
    INFO: Register plugin: Legacy Result Access
    Apr 14, 2020 7:59:39 PM com.rapidminer.tools.plugin.Plugin registerPlugins
    INFO: Register plugin: Concurrency
    Apr 14, 2020 7:59:39 PM com.rapidminer.tools.plugin.Plugin registerPlugins
    INFO: Register plugin: HTML5 Charts
    Apr 14, 2020 7:59:39 PM com.rapidminer.tools.plugin.Plugin registerPlugins
    INFO: Register plugin: Model Deployment Management
    Apr 14, 2020 7:59:39 PM com.rapidminer.tools.plugin.Plugin registerPlugins
    INFO: Register plugin: Time Series
    Apr 14, 2020 7:59:39 PM com.rapidminer.tools.plugin.Plugin registerPlugins
    INFO: Register plugin: Remote Repository
    Apr 14, 2020 7:59:39 PM com.rapidminer.tools.plugin.Plugin registerPlugins
    INFO: Register plugin: Browser
    Apr 14, 2020 7:59:39 PM com.rapidminer.tools.plugin.Plugin registerPlugins
    INFO: Register plugin: Utility
    Apr 14, 2020 7:59:39 PM com.rapidminer.tools.plugin.Plugin registerPlugins
    INFO: Register plugin: Professional
    Apr 14, 2020 7:59:39 PM com.rapidminer.tools.plugin.Plugin registerPlugins
    INFO: Register plugin: Model Simulator
    Apr 14, 2020 7:59:39 PM com.rapidminer.tools.plugin.Plugin registerPlugins
    INFO: Register plugin: CTA
    Apr 14, 2020 7:59:39 PM com.rapidminer.tools.plugin.Plugin registerPlugins
    INFO: Register plugin: H2O
    Apr 14, 2020 7:59:39 PM com.rapidminer.tools.plugin.Plugin registerPlugins
    INFO: Register plugin: Data Editor
    Apr 14, 2020 7:59:39 PM com.rapidminer.tools.plugin.Plugin registerPlugins
    INFO: Register plugin: Productivity
    Apr 14, 2020 7:59:39 PM com.rapidminer.tools.plugin.Plugin registerPlugins
    INFO: Register plugin: Social Media
    Apr 14, 2020 7:59:39 PM com.rapidminer.tools.plugin.Plugin registerPlugins
    INFO: Register plugin: Operator Recommender
    Apr 14, 2020 7:59:39 PM com.rapidminer.tools.plugin.Plugin registerPlugins
    INFO: Register plugin: JDBC Connectors
    Apr 14, 2020 7:59:40 PM com.rapidminer.tools.config.ConfigurationManager register
    INFO: Registered configurator Twitter Connection.
    Apr 14, 2020 7:59:41 PM com.rapidminer.tools.config.ConfigurationManager register
    INFO: Registered configurator Salesforce Connection.
    Apr 14, 2020 7:59:41 PM com.rapidminer.tools.config.ConfigurationManager register
    INFO: Registered configurator Amazon S3 Connection.
    Apr 14, 2020 7:59:41 PM com.rapidminer.tools.config.ConfigurationManager register
    INFO: Registered configurator Azure Blob Storage Connection.
    Apr 14, 2020 7:59:41 PM com.rapidminer.tools.config.ConfigurationManager register
    INFO: Registered configurator Azure Data Lake Storage Gen1 Connection.
    Apr 14, 2020 7:59:41 PM com.rapidminer.tools.config.ConfigurationManager register
    INFO: Registered configurator Google Cloud Storage Connection.
    Apr 14, 2020 7:59:41 PM com.rapidminer.tools.config.ConfigurationManager register
    INFO: Registered configurator Dropbox Connection.
    Apr 14, 2020 7:59:43 PM com.rapidminer.extension.jdbc.tools.jdbc.JDBCProperties <init>
    WARNING: Missing database driver class name for ODBC Bridge (e.g. Access)
    Apr 14, 2020 7:59:43 PM com.rapidminer.extension.jdbc.tools.jdbc.JDBCProperties <init>
    WARNING: Missing database driver class name for Ingres
    Apr 14, 2020 7:59:45 PM com.rapidminer.repository.RepositoryManager registerExtensionSamples
    INFO: Registered 'Time Series' as sample folder.
    Apr 14, 2020 7:59:45 PM com.rapidminer.extension.jdbc.tools.jdbc.JDBCProperties <init>
    WARNING: Missing database driver class name for ODBC Bridge (e.g. Access)
    Apr 14, 2020 7:59:45 PM com.rapidminer.extension.jdbc.tools.jdbc.JDBCProperties <init>
    WARNING: Missing database driver class name for Ingres
    Apr 14, 2020 7:59:46 PM com.rapidminer.extension.indatabase.provider.DatabaseProviderFactory registerProvider
    INFO: Registered database provider: GoogleBigQueryProvider
    Apr 14, 2020 7:59:46 PM com.rapidminer.extension.indatabase.provider.DatabaseProviderFactory registerProvider
    INFO: Registered database provider: MySQLProvider
    Apr 14, 2020 7:59:46 PM com.rapidminer.extension.indatabase.provider.DatabaseProviderFactory registerProvider
    INFO: Registered database provider: PostgreSQLProvider
    Apr 14, 2020 7:59:46 PM com.rapidminer.extension.indatabase.provider.DatabaseProviderFactory registerProvider
    INFO: Registered database provider: EmbeddedProvider
    Apr 14, 2020 7:59:46 PM com.rapidminer.extension.indatabase.provider.DatabaseProviderFactory registerProvider
    INFO: Registered database provider: GenericProvider
    Apr 14, 2020 7:59:46 PM com.rapidminer.tools.config.ConfigurationManager register
    INFO: Registered configurator Google BigQuery Connection.
    Apr 14, 2020 7:59:46 PM com.rapidminer.tools.plugin.Plugin initAll
    INFO: Extension Converters was loaded in 8ms.
    Apr 14, 2020 7:59:46 PM com.rapidminer.tools.plugin.Plugin initAll
    INFO: Extension Text Processing was loaded in 77ms.
    Apr 14, 2020 7:59:46 PM com.rapidminer.tools.plugin.Plugin initAll
    INFO: Extension Blending was loaded in 122ms.
    Apr 14, 2020 7:59:46 PM com.rapidminer.tools.plugin.Plugin initAll
    INFO: Extension Utility was loaded in 123ms.
    Apr 14, 2020 7:59:46 PM com.rapidminer.tools.plugin.Plugin initAll
    INFO: Extension Python Scripting was loaded in 132ms.
    Apr 14, 2020 7:59:46 PM com.rapidminer.tools.plugin.Plugin initAll
    INFO: Extension Process Scheduling was loaded in 141ms.
    Apr 14, 2020 7:59:46 PM com.rapidminer.tools.plugin.Plugin initAll
    INFO: Extension Data Editor was loaded in 153ms.
    Apr 14, 2020 7:59:46 PM com.rapidminer.tools.plugin.Plugin initAll
    INFO: Extension Model Deployment Management was loaded in 158ms.
    Apr 14, 2020 7:59:46 PM com.rapidminer.tools.plugin.Plugin initAll
    INFO: Extension Professional was loaded in 167ms.
    Apr 14, 2020 7:59:46 PM com.rapidminer.tools.plugin.Plugin initAll
    INFO: Extension Productivity was loaded in 172ms.
    Apr 14, 2020 7:59:46 PM com.rapidminer.tools.plugin.Plugin initAll
    INFO: Extension CTA was loaded in 175ms.
    Apr 14, 2020 7:59:46 PM com.rapidminer.tools.plugin.Plugin initAll
    INFO: Extension Advanced File Connectors was loaded in 203ms.
    Apr 14, 2020 7:59:46 PM com.rapidminer.tools.plugin.Plugin initAll
    INFO: Extension In-Database Processing was loaded in 207ms.
    Apr 14, 2020 7:59:46 PM com.rapidminer.tools.plugin.Plugin initAll
    INFO: Extension Operator Recommender was loaded in 221ms.
    Apr 14, 2020 7:59:46 PM com.rapidminer.tools.plugin.Plugin initAll
    INFO: Extension HTML5 Charts was loaded in 251ms.
    Apr 14, 2020 7:59:46 PM com.rapidminer.tools.plugin.Plugin initAll
    INFO: Extension Social Media was loaded in 252ms.
    Apr 14, 2020 7:59:46 PM com.rapidminer.tools.plugin.Plugin initAll
    INFO: Extension Browser was loaded in 289ms.
    Apr 14, 2020 7:59:46 PM com.rapidminer.tools.plugin.Plugin initAll
    INFO: Extension Concurrency was loaded in 325ms.
    Apr 14, 2020 7:59:46 PM com.rapidminer.tools.plugin.Plugin initAll
    INFO: Extension Remote Repository was loaded in 325ms.
    Apr 14, 2020 7:59:46 PM com.rapidminer.tools.plugin.Plugin initAll
    INFO: Extension Time Series was loaded in 370ms.
    Apr 14, 2020 7:59:46 PM com.rapidminer.tools.plugin.Plugin initAll
    INFO: Extension Model Simulator was loaded in 382ms.
    Apr 14, 2020 7:59:46 PM com.rapidminer.tools.plugin.Plugin initAll
    INFO: Extension Legacy Result Access was loaded in 419ms.
    Apr 14, 2020 7:59:46 PM com.rapidminer.tools.plugin.Plugin initAll
    INFO: Extension H2O was loaded in 499ms.
    Apr 14, 2020 7:59:46 PM com.rapidminer.tools.plugin.Plugin initAll
    INFO: Extension Cloud Connectivity was loaded in 645ms.
    Apr 14, 2020 7:59:46 PM com.rapidminer.tools.plugin.Plugin initAll
    INFO: Extension JDBC Connectors was loaded in 926ms.
    Apr 14, 2020 8:00:02 PM com.rapidminer.extension.timeseries.operator.basetransformation.equalize.AbstractEqualizeTimeSeriesOperator getAdditionalParameterTypes
    WARNING: No operator description object given for 'com.rapidminer.extension.timeseries.operator.transformation.ReplaceMissingValuesOperator'
    Apr 14, 2020 8:00:02 PM com.rapidminer.extension.timeseries.operator.basetransformation.equalize.AbstractEqualizeTimeSeriesOperator getAdditionalParameterTypes
    WARNING: No operator description object given for 'com.rapidminer.extension.timeseries.operator.transformation.ReplaceMissingValuesOperator'
    Apr 14, 2020 8:00:02 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration
    INFO: Load configuration for Amazon S3 Connection.
    Apr 14, 2020 8:00:02 PM com.rapidminer.tools.config.ClientConfigurationManager loadAllParameters
    INFO: No configuration file found for Amazon S3 Connection
    Apr 14, 2020 8:00:02 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration
    INFO: Loaded configurations for 0 objects of type Amazon S3 Connection.
    Apr 14, 2020 8:00:02 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration
    INFO: Load configuration for Azure Blob Storage Connection.
    Apr 14, 2020 8:00:02 PM com.rapidminer.tools.config.ClientConfigurationManager loadAllParameters
    INFO: No configuration file found for Azure Blob Storage Connection
    Apr 14, 2020 8:00:02 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration
    INFO: Loaded configurations for 0 objects of type Azure Blob Storage Connection.
    Apr 14, 2020 8:00:02 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration
    INFO: Load configuration for Azure Data Lake Storage Gen1 Connection.
    Apr 14, 2020 8:00:02 PM com.rapidminer.tools.config.ClientConfigurationManager loadAllParameters
    INFO: No configuration file found for Azure Data Lake Storage Gen1 Connection
    Apr 14, 2020 8:00:02 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration
    INFO: Loaded configurations for 0 objects of type Azure Data Lake Storage Gen1 Connection.
    Apr 14, 2020 8:00:02 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration
    INFO: Load configuration for Dropbox Connection.
    Apr 14, 2020 8:00:02 PM com.rapidminer.tools.config.ClientConfigurationManager loadAllParameters
    INFO: No configuration file found for Dropbox Connection
    Apr 14, 2020 8:00:02 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration
    INFO: Loaded configurations for 0 objects of type Dropbox Connection.
    Apr 14, 2020 8:00:02 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration
    INFO: Load configuration for Salesforce Connection.
    Apr 14, 2020 8:00:02 PM com.rapidminer.tools.config.ClientConfigurationManager loadAllParameters
    INFO: No configuration file found for Salesforce Connection
    Apr 14, 2020 8:00:02 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration
    INFO: Loaded configurations for 0 objects of type Salesforce Connection.
    Apr 14, 2020 8:00:02 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration
    INFO: Load configuration for Google BigQuery Connection.
    Apr 14, 2020 8:00:02 PM com.rapidminer.tools.config.ClientConfigurationManager loadAllParameters
    INFO: No configuration file found for Google BigQuery Connection
    Apr 14, 2020 8:00:02 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration
    INFO: Loaded configurations for 0 objects of type Google BigQuery Connection.
    Apr 14, 2020 8:00:02 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration
    INFO: Load configuration for Google Cloud Storage Connection.
    Apr 14, 2020 8:00:02 PM com.rapidminer.tools.config.ClientConfigurationManager loadAllParameters
    INFO: No configuration file found for Google Cloud Storage Connection
    Apr 14, 2020 8:00:02 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration
    INFO: Loaded configurations for 0 objects of type Google Cloud Storage Connection.
    Apr 14, 2020 8:00:02 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration
    INFO: Load configuration for Twitter Connection.
    Apr 14, 2020 8:00:02 PM com.rapidminer.tools.config.ClientConfigurationManager loadAllParameters
    INFO: No configuration file found for Twitter Connection
    Apr 14, 2020 8:00:02 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration
    INFO: Loaded configurations for 0 objects of type Twitter Connection.
    Apr 14, 2020 8:00:05 PM com.rapidminer.tools.ResultService init
    INFO: No filename given for result file, using stdout for logging results!
    Apr 14, 2020 8:00:05 PM com.rapidminer.Process execute
    INFO: Process /Users/ryanda/Documents/Rapidminer/Alfa/test_write_from_database.rmp starts
    Apr 14, 2020 8:00:08 PM com.rapidminer.launcher.CommandLineLauncher runProcessAndQuit
    SEVERE: Process failed: Database error occurred: Could not connect to address=(host=reportdb.alfatrex.id)(port=3306)(type=master) : Socket fail to connect to host:reportdb.alfatrex.id, port:3306. reportdb.alfatrex.id
    com.rapidminer.operator.UserError: Database error occurred: Could not connect to address=(host=reportdb.alfatrex.id)(port=3306)(type=master) : Socket fail to connect to host:reportdb.alfatrex.id, port:3306. reportdb.alfatrex.id
    at com.rapidminer.extension.jdbc.operator.io.DatabaseDataReader.getResultSet(DatabaseDataReader.java:127)
    at com.rapidminer.extension.jdbc.operator.io.DatabaseDataReader.createExampleSet(DatabaseDataReader.java:134)
    at com.rapidminer.operator.io.AbstractExampleSource.read(AbstractExampleSource.java:53)
    at com.rapidminer.extension.jdbc.operator.io.DatabaseDataReader.read(DatabaseDataReader.java:101)
    at com.rapidminer.extension.jdbc.operator.io.DatabaseDataReader.read(DatabaseDataReader.java:82)
    at com.rapidminer.operator.io.AbstractReader.doWork(AbstractReader.java:271)
    at com.rapidminer.operator.Operator.execute(Operator.java:1032)
    at com.rapidminer.operator.execution.SimpleUnitExecutor.execute(SimpleUnitExecutor.java:77)
    at com.rapidminer.operator.ExecutionUnit$2.run(ExecutionUnit.java:812)
    at com.rapidminer.operator.ExecutionUnit$2.run(ExecutionUnit.java:807)
    at java.security.AccessController.doPrivileged(Native Method)
    at com.rapidminer.operator.ExecutionUnit.execute(ExecutionUnit.java:807)
    at com.rapidminer.operator.OperatorChain.doWork(OperatorChain.java:423)
    at com.rapidminer.operator.Operator.execute(Operator.java:1032)
    at com.rapidminer.Process.executeRoot(Process.java:1379)
    at com.rapidminer.Process.lambda$executeRootInPool$5(Process.java:1358)
    at com.rapidminer.studio.concurrency.internal.AbstractConcurrencyContext$AdaptedCallable.exec(AbstractConcurrencyContext.java:328)
    at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:289)
    at java.util.concurrent.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1056)
    at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1692)
    at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:157)
    Caused by: java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=reportdb.alfatrex.id)(port=3306)(type=master) : Socket fail to connect to host:reportdb.alfatrex.id, port:3306. reportdb.alfatrex.id
    at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:241)
    at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1241)
    at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:610)
    at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:142)
    at org.mariadb.jdbc.Driver.connect(Driver.java:86)
    at com.rapidminer.extension.jdbc.tools.jdbc.DriverAdapter.connect(DriverAdapter.java:51)
    at com.rapidminer.extension.jdbc.connection.JDBCConnectionHandler.connect(JDBCConnectionHandler.java:266)
    at com.rapidminer.extension.jdbc.tools.jdbc.DatabaseHandler.connect(DatabaseHandler.java:423)
    at com.rapidminer.extension.jdbc.tools.jdbc.DatabaseHandler.getConnectedDatabaseHandler(DatabaseHandler.java:305)
    at com.rapidminer.extension.jdbc.tools.jdbc.DatabaseHandler.getConnectedDatabaseHandler(DatabaseHandler.java:1204)
    at com.rapidminer.extension.jdbc.operator.io.DatabaseDataReader.getResultSet(DatabaseDataReader.java:115)
    ... 20 more
    Caused by: java.sql.SQLNonTransientConnectionException: Socket fail to connect to host:reportdb.alfatrex.id, port:3306. reportdb.alfatrex.id
    at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:241)
    at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.connException(ExceptionMapper.java:87)
    at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createSocket(AbstractConnectProtocol.java:218)
    at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:474)
    at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1236)
    ... 29 more
    Caused by: java.net.UnknownHostException: reportdb.alfatrex.id
    at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:184)
    at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
    at java.net.Socket.connect(Socket.java:606)
    at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createSocket(AbstractConnectProtocol.java:213)
    ... 31 more
    Apr 14, 2020 8:00:08 PM com.rapidminer.launcher.CommandLineLauncher runProcessAndQuit
    SEVERE: Here:           Process[1] (Process)
               subprocess 'Main Process'
                 +- Retrieve reportdb[1] (Retrieve)
           ==>   +- Read Database[1] (Read Database)
                 +- Write Excel[0] (Write Excel)
    Apr 14, 2020 8:00:08 PM com.rapidminer.launcher.CommandLineLauncher runProcessAndQuit
    SEVERE: Process not successful

    At first it says "
    RAPIDMINER_HOME is not set." but in the end it says "SEVERE: Process not successful".
    Does it mean it fixed my java problem?
    Because i haven't tried with shorter process yet so i'm not sure about it.

    Thanks,
  • rfuentealbarfuentealba Moderator, RapidMiner Certified Analyst, Member, University Professor Posts: 568 Unicorn
    Yes, you did.

    You can now check with a shorter process such as writing a dataset on disk or modify paths.

    Actually your problem is that your process couldn't connect to MySQL, apparently.
  • RyandaRyanda Member Posts: 3 Newbie
    it works just fine now.

    thank you so much for the help.
Sign In or Register to comment.