Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
rapidminer-batch.sh on mac error
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.rmand 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,
0
Best Answer
-
rfuentealba RapidMiner Certified Analyst, Member, University Professor Posts: 568 UnicornHello.
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.1
Answers
After i check the java environment it was pointing to JDK 14 that i have.
/Library/Java/JavaVirtualMachines/jdk1.8.0_241.jdk/Contents/Home
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".
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.