how I can solved this problem? DataBase error occurred: incorrect column name

alvesddalvesdd Member Posts: 6 Contributor I
edited November 2018 in Help
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>

Answers

  • homburghomburg Moderator, Employee, Member Posts: 114  RM Data Scientist
    Hi alvesdd,

    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
Sign In or Register to comment.