Options
im running a process from console in windows,it successfully runs the process in cmd but not on RM
Learner I
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"
0
Answers
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
Varun
https://www.varunmandalapu.com/
Be Safe. Follow precautions and Maintain Social Distancing
here is the console commands:
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 asking Varun, is it even possible that i run my this process in cmd and actually reads data from database and then writes back?