im running a process from console in windows,it successfully runs the process in cmd but not on RM

Hina99
Hina99 New Altair Community Member
edited November 2024 in Community Q&A
idk why is that happening,plz help
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"

Tagged:

Answers

  • varunm1
    varunm1 New Altair Community Member
    edited April 2019
    Hello @Hina99

    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
  • Hina99
    Hina99 New Altair Community Member
    hello @varunm1
    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

  • Hina99
    Hina99 New Altair Community Member
    here is the pic of my process:


    just asking Varun, is it even possible that i run my this process in cmd and actually reads data from database and then writes back? 

Categories