im running a process from console in windows,it successfully runs the process in cmd but not on RM
idk why is that happening,plz help
here is the xml:
here is the xml:
<?xml version="1.0" encoding="UTF-8"?><process version="9.2.000">
<context>
<input/>
<output/>
<macros/>
</context>
<operator activated="true" class="process" compatibility="9.2.000" expanded="true" name="Process">
<parameter key="logverbosity" value="init"/>
<parameter key="random_seed" value="2001"/>
<parameter key="send_mail" value="never"/>
<parameter key="notification_email" value=""/>
<parameter key="process_duration_for_mail" value="30"/>
<parameter key="encoding" value="SYSTEM"/>
<process expanded="true">
<operator activated="true" class="jdbc_connectors:read_database" compatibility="9.2.000" expanded="true" height="68" name="Read Database" width="90" x="45" y="34">
<parameter key="define_connection" value="predefined"/>
<parameter key="connection" value="SQL Server Connection"/>
<parameter key="database_system" value="MySQL"/>
<parameter key="define_query" value="table name"/>
<parameter key="use_default_schema" value="true"/>
<parameter key="table_name" value="diabetes_dataset"/>
<parameter key="prepare_statement" value="false"/>
<enumeration key="parameters"/>
<parameter key="datamanagement" value="double_array"/>
<parameter key="data_management" value="auto"/>
</operator>
<operator activated="true" class="set_role" compatibility="9.2.000" expanded="true" height="82" name="Set Role" width="90" x="179" y="34">
<parameter key="attribute_name" value="Outcome"/>
<parameter key="target_role" value="label"/>
<list key="set_additional_roles"/>
</operator>
<operator activated="true" class="select_attributes" compatibility="9.2.000" expanded="true" height="82" name="Select Attributes" width="90" x="313" y="34">
<parameter key="attribute_filter_type" value="single"/>
<parameter key="attribute" value="CNIC"/>
<parameter key="attributes" value=""/>
<parameter key="use_except_expression" value="false"/>
<parameter key="value_type" value="attribute_value"/>
<parameter key="use_value_type_exception" value="false"/>
<parameter key="except_value_type" value="time"/>
<parameter key="block_type" value="attribute_block"/>
<parameter key="use_block_type_exception" value="false"/>
<parameter key="except_block_type" value="value_matrix_row_start"/>
<parameter key="invert_selection" value="true"/>
<parameter key="include_special_attributes" value="false"/>
</operator>
<operator activated="true" class="neural_net" compatibility="9.2.000" expanded="true" height="82" name="Neural Net" width="90" x="514" y="85">
<list key="hidden_layers"/>
<parameter key="training_cycles" value="200"/>
<parameter key="learning_rate" value="0.01"/>
<parameter key="momentum" value="0.9"/>
<parameter key="decay" value="false"/>
<parameter key="shuffle" value="true"/>
<parameter key="normalize" value="true"/>
<parameter key="error_epsilon" value="1.0E-4"/>
<parameter key="use_local_random_seed" value="false"/>
<parameter key="local_random_seed" value="1992"/>
</operator>
<operator activated="true" class="jdbc_connectors:read_database" compatibility="9.2.000" expanded="true" height="68" name="Read Database (2)" width="90" x="45" y="187">
<parameter key="define_connection" value="predefined"/>
<parameter key="connection" value="SQL Server Connection"/>
<parameter key="database_system" value="MySQL"/>
<parameter key="define_query" value="table name"/>
<parameter key="use_default_schema" value="true"/>
<parameter key="table_name" value="testing_dataset"/>
<parameter key="prepare_statement" value="false"/>
<enumeration key="parameters"/>
<parameter key="datamanagement" value="double_array"/>
<parameter key="data_management" value="auto"/>
</operator>
<operator activated="true" class="select_attributes" compatibility="9.2.000" expanded="true" height="82" name="Select Attributes (2)" width="90" x="246" y="187">
<parameter key="attribute_filter_type" value="single"/>
<parameter key="attribute" value="CNIC"/>
<parameter key="attributes" value=""/>
<parameter key="use_except_expression" value="false"/>
<parameter key="value_type" value="attribute_value"/>
<parameter key="use_value_type_exception" value="false"/>
<parameter key="except_value_type" value="time"/>
<parameter key="block_type" value="attribute_block"/>
<parameter key="use_block_type_exception" value="false"/>
<parameter key="except_block_type" value="value_matrix_row_start"/>
<parameter key="invert_selection" value="true"/>
<parameter key="include_special_attributes" value="false"/>
</operator>
<operator activated="true" class="apply_model" compatibility="9.2.000" expanded="true" height="82" name="Apply Model" width="90" x="648" y="187">
<list key="application_parameters"/>
<parameter key="create_view" value="false"/>
</operator>
<operator activated="true" class="jdbc_connectors:write_database" compatibility="9.2.000" expanded="true" height="68" name="Write Database" width="90" x="782" y="34">
<parameter key="define_connection" value="predefined"/>
<parameter key="connection" value="SQL Server Connection"/>
<parameter key="database_system" value="MySQL"/>
<parameter key="use_default_schema" value="true"/>
<parameter key="table_name" value="Prediction_Results"/>
<parameter key="overwrite_mode" value="overwrite"/>
<parameter key="set_default_varchar_length" value="false"/>
<parameter key="default_varchar_length" value="128"/>
<parameter key="add_generated_primary_keys" value="false"/>
<parameter key="db_key_attribute_name" value="generated_primary_key"/>
<parameter key="batch_size" value="1"/>
</operator>
<connect from_op="Read Database" from_port="output" to_op="Set Role" to_port="example set input"/>
<connect from_op="Set Role" from_port="example set output" to_op="Select Attributes" to_port="example set input"/>
<connect from_op="Select Attributes" from_port="example set output" to_op="Neural Net" to_port="training set"/>
<connect from_op="Neural Net" from_port="model" to_op="Apply Model" to_port="model"/>
<connect from_op="Read Database (2)" from_port="output" to_op="Select Attributes (2)" to_port="example set input"/>
<connect from_op="Select Attributes (2)" from_port="example set output" to_op="Apply Model" to_port="unlabelled data"/>
<connect from_op="Apply Model" from_port="labelled data" to_op="Write Database" to_port="input"/>
<connect from_op="Write Database" from_port="through" to_port="result 1"/>
<portSpacing port="source_input 1" spacing="0"/>
<portSpacing port="sink_result 1" spacing="0"/>
<portSpacing port="sink_result 2" spacing="0"/>
</process>
</operator>
</process>
and here is the command im running from cmd:
C:\Users\Rapidminer\RapidMiner Studio\scripts>Rapidminer-batch.bat "//FYP Repository/Process/fyp_prediction_neuralnetwork"
C:\Users\Rapidminer\RapidMiner Studio\scripts>Rapidminer-batch.bat "//FYP Repository/Process/fyp_prediction_neuralnetwork"
Find more posts tagged with
Sort by:
1 - 3 of
31
hello @varunm1
here is the console commands:
here is the console commands:
C:\Users\Rapidminer\RapidMiner Studio>cd C:\Users\Rapidminer\RapidMiner Studio\scripts
C:\Users\Rapidminer\RapidMiner Studio\scripts>Rapidminer-batch.bat "//FYP Repository/Process/fyp_prediction_neuralnetwork"
RAPIDMINER_HOME environment variable is not set. Trying the directory 'C:\Users\Rapidminer\RapidMiner Studio'...
Using local jre: C:\Users\Rapidminer\RapidMiner Studio\jre\bin\java.exe...
Java Version: 1.8.0_181
C:\Users\komal\AppData\Roaming\check_rm_java_version
Access is denied.
Gathering launch settings...
Done.
Launching RapidMiner Studio BATCH now...
RapidMiner Studio version 9.2.000, Copyright (C) 2001-2019 RapidMiner GmbH
See End User License Agreement information in the file named EULA.
Apr 07, 2019 6:32:41 PM com.rapidminer.tools.I18N <clinit>
INFO: Set locale to en.
Apr 07, 2019 6:32:41 PM com.rapidminer.tools.PlatformUtilities logInfo
INFO: rapidminer.home is 'C:\Users\Rapidminer\RapidMiner Studio'.
Apr 07, 2019 6:32:42 PM com.rapidminer.core.license.ProductConstraintManager initialize
INFO: Initializing license manager.
Apr 07, 2019 6:32:42 PM com.rapidminer.core.license.ProductConstraintManager initialize
INFO: Using default license location.
Apr 07, 2019 6:32:42 PM com.rapidminer.core.license.ProductConstraintManager initialize
INFO: Registering default product.
Apr 07, 2019 6:32:58 PM com.rapidminer.tools.plugin.Plugin registerPlugins
INFO: Register plugin: Cloud Connectivity
Apr 07, 2019 6:32:58 PM com.rapidminer.tools.plugin.Plugin registerPlugins
INFO: Register plugin: Cloud Execution
Apr 07, 2019 6:32:58 PM com.rapidminer.tools.plugin.Plugin registerPlugins
INFO: Register plugin: Data Editor
Apr 07, 2019 6:32:58 PM com.rapidminer.tools.plugin.Plugin registerPlugins
INFO: Register plugin: H2O
Apr 07, 2019 6:32:58 PM com.rapidminer.tools.plugin.Plugin registerPlugins
INFO: Register plugin: Model Simulator
Apr 07, 2019 6:32:58 PM com.rapidminer.tools.plugin.Plugin registerPlugins
INFO: Register plugin: Operator Recommender
Apr 07, 2019 6:32:58 PM com.rapidminer.tools.plugin.Plugin registerPlugins
INFO: Register plugin: Process Scheduling
Apr 07, 2019 6:32:58 PM com.rapidminer.tools.plugin.Plugin registerPlugins
INFO: Register plugin: Advanced File Connectors
Apr 07, 2019 6:32:58 PM com.rapidminer.tools.plugin.Plugin registerPlugins
INFO: Register plugin: Blending
Apr 07, 2019 6:32:58 PM com.rapidminer.tools.plugin.Plugin registerPlugins
INFO: Register plugin: Browser
Apr 07, 2019 6:32:58 PM com.rapidminer.tools.plugin.Plugin registerPlugins
INFO: Register plugin: Concurrency
Apr 07, 2019 6:32:58 PM com.rapidminer.tools.plugin.Plugin registerPlugins
INFO: Register plugin: HTML5 Charts
Apr 07, 2019 6:32:58 PM com.rapidminer.tools.plugin.Plugin registerPlugins
INFO: Register plugin: JDBC Connectors
Apr 07, 2019 6:32:58 PM com.rapidminer.tools.plugin.Plugin registerPlugins
INFO: Register plugin: Legacy Result Access
Apr 07, 2019 6:32:58 PM com.rapidminer.tools.plugin.Plugin registerPlugins
INFO: Register plugin: Productivity
Apr 07, 2019 6:32:58 PM com.rapidminer.tools.plugin.Plugin registerPlugins
INFO: Register plugin: Professional
Apr 07, 2019 6:32:58 PM com.rapidminer.tools.plugin.Plugin registerPlugins
INFO: Register plugin: Remote Repository
Apr 07, 2019 6:32:58 PM com.rapidminer.tools.plugin.Plugin registerPlugins
INFO: Register plugin: Utility
Apr 07, 2019 6:32:58 PM com.rapidminer.tools.plugin.Plugin registerPlugins
INFO: Register plugin: Social Media
Apr 07, 2019 6:32:58 PM com.rapidminer.tools.plugin.Plugin registerPlugins
INFO: Register plugin: Time Series
Apr 07, 2019 6:32:59 PM com.rapidminer.tools.config.ConfigurationManager register
INFO: Registered configurator Twitter Connection.
Apr 07, 2019 6:33:01 PM com.rapidminer.tools.config.ConfigurationManager register
INFO: Registered configurator Salesforce Connection.
Apr 07, 2019 6:33:01 PM com.rapidminer.tools.config.ConfigurationManager register
INFO: Registered configurator Amazon S3 Connection.
Apr 07, 2019 6:33:01 PM com.rapidminer.tools.config.ConfigurationManager register
INFO: Registered configurator Azure Blob Storage Connection.
Apr 07, 2019 6:33:01 PM com.rapidminer.tools.config.ConfigurationManager register
INFO: Registered configurator Azure Data Lake Storage Gen1 Connection.
Apr 07, 2019 6:33:01 PM com.rapidminer.tools.config.ConfigurationManager register
INFO: Registered configurator Google Cloud Storage Connection.
Apr 07, 2019 6:33:01 PM com.rapidminer.tools.config.ConfigurationManager register
INFO: Registered configurator Dropbox Connection.
Apr 07, 2019 6:33:05 PM com.rapidminer.extension.jdbc.tools.jdbc.JDBCProperties <init>
WARNING: Missing database driver class name for ODBC Bridge (e.g. Access)
Apr 07, 2019 6:33:05 PM com.rapidminer.extension.jdbc.tools.jdbc.JDBCProperties <init>
WARNING: Missing database driver class name for Ingres
Apr 07, 2019 6:33:09 PM com.rapidminer.repository.RepositoryManager registerExtensionSamples
INFO: Registered 'Time Series' as sample folder.
Apr 07, 2019 6:33:10 PM com.rapidminer.tools.plugin.Plugin initAll
INFO: Extension Utility was loaded in 266ms.
Apr 07, 2019 6:33:10 PM com.rapidminer.tools.plugin.Plugin initAll
INFO: Extension Professional was loaded in 281ms.
Apr 07, 2019 6:33:10 PM com.rapidminer.tools.plugin.Plugin initAll
INFO: Extension Operator Recommender was loaded in 297ms.
Apr 07, 2019 6:33:10 PM com.rapidminer.tools.plugin.Plugin initAll
INFO: Extension Remote Repository was loaded in 298ms.
Apr 07, 2019 6:33:10 PM com.rapidminer.tools.plugin.Plugin initAll
INFO: Extension Data Editor was loaded in 313ms.
Apr 07, 2019 6:33:10 PM com.rapidminer.tools.plugin.Plugin initAll
INFO: Extension Productivity was loaded in 327ms.
Apr 07, 2019 6:33:10 PM com.rapidminer.tools.plugin.Plugin initAll
INFO: Extension Concurrency was loaded in 344ms.
Apr 07, 2019 6:33:10 PM com.rapidminer.tools.plugin.Plugin initAll
INFO: Extension Social Media was loaded in 344ms.
Apr 07, 2019 6:33:10 PM com.rapidminer.tools.plugin.Plugin initAll
INFO: Extension Blending was loaded in 359ms.
Apr 07, 2019 6:33:10 PM com.rapidminer.tools.plugin.Plugin initAll
INFO: Extension Process Scheduling was loaded in 375ms.
Apr 07, 2019 6:33:10 PM com.rapidminer.tools.plugin.Plugin initAll
INFO: Extension HTML5 Charts was loaded in 390ms.
Apr 07, 2019 6:33:10 PM com.rapidminer.tools.plugin.Plugin initAll
INFO: Extension Browser was loaded in 454ms.
Apr 07, 2019 6:33:10 PM com.rapidminer.tools.plugin.Plugin initAll
INFO: Extension Advanced File Connectors was loaded in 470ms.
Apr 07, 2019 6:33:10 PM com.rapidminer.tools.plugin.Plugin initAll
INFO: Extension Model Simulator was loaded in 485ms.
Apr 07, 2019 6:33:10 PM com.rapidminer.tools.plugin.Plugin initAll
INFO: Extension Legacy Result Access was loaded in 609ms.
Apr 07, 2019 6:33:10 PM com.rapidminer.tools.plugin.Plugin initAll
INFO: Extension Cloud Execution was loaded in 671ms.
Apr 07, 2019 6:33:10 PM com.rapidminer.tools.plugin.Plugin initAll
INFO: Extension Time Series was loaded in 827ms.
Apr 07, 2019 6:33:10 PM com.rapidminer.tools.plugin.Plugin initAll
INFO: Extension Cloud Connectivity was loaded in 1047ms.
Apr 07, 2019 6:33:10 PM com.rapidminer.tools.plugin.Plugin initAll
INFO: Extension H2O was loaded in 1234ms.
Apr 07, 2019 6:33:10 PM com.rapidminer.tools.plugin.Plugin initAll
INFO: Extension JDBC Connectors was loaded in 3156ms.
Apr 07, 2019 6:33:35 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration
INFO: Load configuration for Amazon S3 Connection.
Apr 07, 2019 6:33:35 PM com.rapidminer.tools.config.ClientConfigurationManager loadAllParameters
INFO: No configuration file found for Amazon S3 Connection
Apr 07, 2019 6:33:35 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration
INFO: Loaded configurations for 0 objects of type Amazon S3 Connection.
Apr 07, 2019 6:33:35 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration
INFO: Load configuration for Azure Blob Storage Connection.
Apr 07, 2019 6:33:35 PM com.rapidminer.tools.config.ClientConfigurationManager loadAllParameters
INFO: No configuration file found for Azure Blob Storage Connection
Apr 07, 2019 6:33:35 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration
INFO: Loaded configurations for 0 objects of type Azure Blob Storage Connection.
Apr 07, 2019 6:33:35 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration
INFO: Load configuration for Azure Data Lake Storage Gen1 Connection.
Apr 07, 2019 6:33:35 PM com.rapidminer.tools.config.ClientConfigurationManager loadAllParameters
INFO: No configuration file found for Azure Data Lake Storage Gen1 Connection
Apr 07, 2019 6:33:35 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration
INFO: Loaded configurations for 0 objects of type Azure Data Lake Storage Gen1 Connection.
Apr 07, 2019 6:33:35 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration
INFO: Load configuration for Dropbox Connection.
Apr 07, 2019 6:33:35 PM com.rapidminer.tools.config.ClientConfigurationManager loadAllParameters
INFO: No configuration file found for Dropbox Connection
Apr 07, 2019 6:33:35 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration
INFO: Loaded configurations for 0 objects of type Dropbox Connection.
Apr 07, 2019 6:33:35 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration
INFO: Load configuration for Salesforce Connection.
Apr 07, 2019 6:33:35 PM com.rapidminer.tools.config.ClientConfigurationManager loadAllParameters
INFO: No configuration file found for Salesforce Connection
Apr 07, 2019 6:33:35 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration
INFO: Loaded configurations for 0 objects of type Salesforce Connection.
Apr 07, 2019 6:33:35 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration
INFO: Load configuration for Google Cloud Storage Connection.
Apr 07, 2019 6:33:35 PM com.rapidminer.tools.config.ClientConfigurationManager loadAllParameters
INFO: No configuration file found for Google Cloud Storage Connection
Apr 07, 2019 6:33:35 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration
INFO: Loaded configurations for 0 objects of type Google Cloud Storage Connection.
Apr 07, 2019 6:33:35 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration
INFO: Load configuration for Twitter Connection.
Apr 07, 2019 6:33:35 PM com.rapidminer.tools.config.ClientConfigurationManager loadAllParameters
INFO: No configuration file found for Twitter Connection
Apr 07, 2019 6:33:35 PM com.rapidminer.tools.config.ConfigurationManager loadConfiguration
INFO: Loaded configurations for 0 objects of type Twitter Connection.
Apr 07, 2019 6:33:36 PM com.rapidminer.tools.ResultService init
INFO: No filename given for result file, using stdout for logging results!
Apr 07, 2019 6:33:36 PM com.rapidminer.Process execute
INFO: Process //FYP Repository/Process/fyp_prediction_neuralnetwork starts
Apr 07, 2019 6:33:37 PM com.rapidminer.extension.jdbc.tools.jdbc.DatabaseHandler executeStatement
INFO: Executing query: 'SELECT * FROM "diabetes_dataset"'
Apr 07, 2019 6:33:39 PM com.rapidminer.extension.jdbc.tools.jdbc.DatabaseHandler executeStatement
INFO: Executing query: 'SELECT * FROM "testing_dataset"'
Apr 07, 2019 6:33:41 PM com.rapidminer.Process execute
INFO: Process //FYP Repository/Process/fyp_prediction_neuralnetwork finished successfully after 4 s
Apr 07, 2019 6:33:41 PM com.rapidminer.launcher.CommandLineLauncher run
INFO: Process finished successfully
Its not giving any error anymore,but after it runs and says process finished successfully, it makes no change in database. As what im doing is, reading data from database twice, once for training and once for testing, and then im using neural network and after running the process, it writes the results generated back in the database
Im so worried, this process automation is a part of my fyp and whole of my fyp depends on it
Im sorry, couldnt reply earlier, i thot no one was gonna reply
Im so worried, this process automation is a part of my fyp and whole of my fyp depends on it
Im sorry, couldnt reply earlier, i thot no one was gonna reply
Just trying to understand the issue. Are you saying that the XML process given above is not running when you open rapidminer? If so, Can you post any error you are encountering here? You can see that in rapidminer studio log that is available in View --> Show Panel --> Log.
I can visualize your process in my RM, but as I am not having your database connection settings I guess its asking me to fill those.
Thanks