How can I find which fields are causing a problem?

David Paras

• February 21, 2013 18:18

I am getting this error while importing data into SQL Server. How can I find which fields is giving problem? The format looks ok to me.

Error in execution for activity DatabaseTarget:Test_Target:192168016049135957394329500450[Error in record , aborting activity Data is not in proper format.]

 

0

• 

  David Paras

  • February 21, 2013 18:19

  It seems that in Process Flow designer the "Error Records" level is set to abort of Database Target Activity due to which whenever an error is generated while insertion the Process Flow instantly aborts. You can change it to File then whenever an error will be generated it will be saved in an Error Record file in repository(Refer attached screenshot). The reason behind that error can be seen in the repository file itself.

   

  

  0
• 

  David Paras

  • February 21, 2013 18:19

  Will I still get error immediate event if I set to File? I changed to abort because it was not generating the event and going to the next activity.

  0
• 

  David Paras

  • February 21, 2013 18:21

  If you want to view the error records as well after inserting the error records then you have to follow the below steps for achieving this scenario:

  1) In Process Flow designer set the "Error Records" level to Process of Database Target Activity.
  2) Change the Generate Stream to True of Database target activity.

  

  
  3) Right Click on the DB Target activity and Create a Multiple Stream. Check on error stream and Map this stream to any activity say mail notification or File Target.

  

  Then you will get the error records as well in that activity where that error stream is mapped.

   

  0

Please sign in to leave a comment.