Unable to load data in to Database table

girish_526

• January 31, 2018 00:00

• Answered

Follow

Hi Team,

I am trying to load the data in to data base table from CSV file. The process struck at the DBOutput component for hours.

Attaching the graph.

Appreciate your help.

Thanks,
Girish.

• Test.grf

• 

  Pedro Vazquez Rosario

  • February 07, 2018 17:14

  0

  Comment actions Permalink

  Hi girish_526
  
  After closer inspection of the graph that you sent me, it appears that the metadata datatypes that was being used from the CSV file were inconsistent from the database tables you are inserting to. For example, you are using RAW datatype on one of your columns in this case the metadata datatype that you are inserting should be a byte. I have taken the liberty of updating the Test graph you sent me (while removing any sensitive data).
  
  TestUpdated.grf

  • TestUpdated.grf

Please sign in to leave a comment.