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
how I can solved this problem? DataBase error occurred: incorrect column name
Contributor II
I read one file.txt and use to generate extratract.
Now a i want write the table in the database.
How i solved this?
Date:
12345 94567
94565 78932
Code:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<process version="5.3.013">
<context>
<input/>
<output/>
<macros/>
</context>
<operator activated="true" class="process" compatibility="5.3.013" expanded="true" name="Process">
<process expanded="true">
<operator activated="true" class="read_csv" compatibility="5.3.013" expanded="true" height="60" name="Read CSV" width="90" x="112" y="30">
<parameter key="csv_file" value="C:\Users\diego_alves\Documents\Rapid\Erro.txt"/>
<parameter key="first_row_as_names" value="false"/>
<list key="annotations"/>
<list key="data_set_meta_data_information">
<parameter key="0" value="Line.true.nominal.regular"/>
</list>
</operator>
<operator activated="true" class="text:generate_extract" compatibility="5.3.002" expanded="true" height="60" name="Generate Extract" width="90" x="246" y="30">
<parameter key="source_attribute" value="Line"/>
<parameter key="query_type" value="Indexed"/>
<list key="string_machting_queries">
<parameter key="nome" value="0.5"/>
<parameter key="outros" value="5.5"/>
<parameter key="nome2" value="10.5"/>
</list>
<list key="regular_expression_queries"/>
<list key="regular_region_queries"/>
<list key="xpath_queries"/>
<list key="namespaces"/>
<list key="index_queries">
<parameter key="name" value="0.5"/>
<parameter key="teste" value="5.5"/>
<parameter key="outros" value="10.15"/>
</list>
</operator>
<operator activated="true" class="write_database" compatibility="5.3.013" expanded="true" height="60" name="Write Database" width="90" x="380" y="30">
<parameter key="connection" value="Mailing"/>
<parameter key="table_name" value="teste3"/>
</operator>
<connect from_op="Read CSV" from_port="output" to_op="Generate Extract" to_port="Example Set"/>
<connect from_op="Generate Extract" from_port="Example Set" to_op="Write Database" to_port="input"/>
<portSpacing port="source_input 1" spacing="0"/>
<portSpacing port="sink_result 1" spacing="0"/>
</process>
</operator>
</process>
Now a i want write the table in the database.
How i solved this?
Date:
12345 94567
94565 78932
Code:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<process version="5.3.013">
<context>
<input/>
<output/>
<macros/>
</context>
<operator activated="true" class="process" compatibility="5.3.013" expanded="true" name="Process">
<process expanded="true">
<operator activated="true" class="read_csv" compatibility="5.3.013" expanded="true" height="60" name="Read CSV" width="90" x="112" y="30">
<parameter key="csv_file" value="C:\Users\diego_alves\Documents\Rapid\Erro.txt"/>
<parameter key="first_row_as_names" value="false"/>
<list key="annotations"/>
<list key="data_set_meta_data_information">
<parameter key="0" value="Line.true.nominal.regular"/>
</list>
</operator>
<operator activated="true" class="text:generate_extract" compatibility="5.3.002" expanded="true" height="60" name="Generate Extract" width="90" x="246" y="30">
<parameter key="source_attribute" value="Line"/>
<parameter key="query_type" value="Indexed"/>
<list key="string_machting_queries">
<parameter key="nome" value="0.5"/>
<parameter key="outros" value="5.5"/>
<parameter key="nome2" value="10.5"/>
</list>
<list key="regular_expression_queries"/>
<list key="regular_region_queries"/>
<list key="xpath_queries"/>
<list key="namespaces"/>
<list key="index_queries">
<parameter key="name" value="0.5"/>
<parameter key="teste" value="5.5"/>
<parameter key="outros" value="10.15"/>
</list>
</operator>
<operator activated="true" class="write_database" compatibility="5.3.013" expanded="true" height="60" name="Write Database" width="90" x="380" y="30">
<parameter key="connection" value="Mailing"/>
<parameter key="table_name" value="teste3"/>
</operator>
<connect from_op="Read CSV" from_port="output" to_op="Generate Extract" to_port="Example Set"/>
<connect from_op="Generate Extract" from_port="Example Set" to_op="Write Database" to_port="input"/>
<portSpacing port="source_input 1" spacing="0"/>
<portSpacing port="sink_result 1" spacing="0"/>
</process>
</operator>
</process>
Tagged:
0
Answers
can you please check the output of the "Generate Extract" operator (right click, set a breakpoint after the operator and run the process)? In order to write data to your database system all columns need to have a name that is supported by your dbs.
Cheers,
Helge