Intercept Error on a datareader

Unknown
Unknown Active Partner
in Platform

Hello,

I know that we can check the option stop on error when we use a data reader. However, is there a way to intercept a data reader error, at least to be able to know that an error happened.

The point is to have a message when reading an ascii file with duplicate entity codes.

Thank you and best regards

Marcel

Answers

  • Sebastian Gurt
    Sebastian Gurt Employee
    Fourth Anniversary 100 Likes 10 Comments 25 Up Votes

    Hi Marcel Bila,

     

    for an actual error (discarded lines) you could load the log file after running the data reader and highlighting data readers that have discarded lines. But your example of multiple occurences of an entity code is not an error for BOARD. If you want to check for such a situation, you could load the file into a counter cube (set ETL =1 for the cube) (just dimensionend by the entity you want to check for multiple occurences) and check for values >1.

     

    Hope this helps.

     

    BR

    Sebastian

Categories