Email Attachement Reading and inserting into Oracle database

sgaddam

• September 07, 2011 00:00

• Answered

Follow

Hii,

I am reading an CSV file attachment using Email Reader and using Universal Data Reader am trying to insert data into DB Output Table. Here am able to read the email content and the attachment is also being saved into the data-tmp directory, but the data is NOT getting inserted into the db table which displays following errors. please help me in resolving the issue.

INFO [WatchDog] - Successfully started all nodes in phase!
ERROR [WatchDog] - Graph execution finished with error
ERROR [WatchDog] - Node DATA_READER0 finished with status: ERROR caused by: The field 'null' contain unsupported null value.
ERROR [WatchDog] - Node DATA_READER0 error details:
org.jetel.exception.JetelException: The field 'null' contain unsupported null value.
at org.jetel.util.ReadableChannelIterator.next(ReadableChannelIterator.java:219)
at org.jetel.util.MultiFileReader.nextSource(MultiFileReader.java:272)
at org.jetel.util.MultiFileReader.initializeDataDependentSource(MultiFileReader.java:457)
at org.jetel.util.MultiFileReader.checkRowAndPrepareSource(MultiFileReader.java:374)
at org.jetel.util.MultiFileReader.getNext(MultiFileReader.java:408)
at org.jetel.component.DataReader.execute(DataReader.java:261)
at org.jetel.graph.Node.run(Node.java:425)
at java.lang.Thread.run(Unknown Source)
INFO [WatchDog] - [Clover] Post-execute phase finalization: 0
INFO [WatchDog] - [Clover] phase: 0 post-execute finalization successfully.
INFO [WatchDog] - Execution of phase [0] finished with error - elapsed time(sec): 3
ERROR [WatchDog] - !!! Phase finished with error - stopping graph run !!!
INFO [WatchDog] - Post-execute finalization of connection:
INFO [WatchDog] - DBConnection driver[org.jetel.connection.jdbc.driver.JdbcDriver@b1cd0]:jndi[]:url[jdbc:oracle:thin:@202.65.147.216:1521:xe]:user[sammgr] ... OK
INFO [WatchDog] - -----------------------** Summary of Phases execution **---------------------
INFO [WatchDog] - Phase# Finished Status RunTime(sec) MemoryAllocation(KB)
INFO [WatchDog] - 0 ERROR 3 5784
INFO [WatchDog] - ------------------------------** End of Summary **---------------------------
INFO [WatchDog] - WatchDog thread finished - total execution time: 3 (sec)
INFO [main] - Freeing graph resources.
ERROR [main] - Execution of graph failed !

• 

  ranusuri

  • September 08, 2011 07:51

  0

  Comment actions Permalink

  1. Please check your input file for the Email reader
  2. The edge metadata from reading data from the email attachment should use UTF-16 charset and also the delimiter in basic property should be empty. EOF as delimiter should be true.
• 

  avackova

  • September 08, 2011 10:47

  0

  Comment actions Permalink

  Hello,
  this message suggests, that null value comes in AttachmentRaw field. Try to set ExtFilter component before the Reader, that checks for null values:
  

  //#CTL2
  !isnull($0.AttachmentRaw)

Please sign in to leave a comment.