The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
rapidminer-batch.sh on mac error
Learner I
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 
Unicorn
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.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/HomeRapidMiner 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.