Custom Error Messages - system table with Validation info?

dataservices job design
1

We have to send back an exception file containing the records that failed the validation rules so that that file can be cleansed and resent.

Presently we get the colon separated column names for the rows that failed the validation using the DI_ERRORCOLUMNS field. But we want to use meaningful messages in the exception file that gets generated with failed records, like - Effective date is Null or Date format is incorrect or Value is greater than 15, instead of jus the column names.

–> One thought:
While defining validation rule, we can give name to that rule under properties. This name appears when we pull the data validation reports from management console. This name would be stored in some system table. Is there a way to get this name? If i can get this name, i will replace the column name i get in the DI_ERROROLUMN field by this name.

–> Another option would be to parse the DI_ERRORCOLUMN field value and replace the column names with the Error messages in a script. But i am looking for a better option.

Does anyone have any idea about the system table having the validation details? Or any suggestions on doing this in a better way?

Thanks for the help…

invincible (BOB member since 2009-08-07)

2

Any help? :roll_eyes:

invincible (BOB member since 2009-08-07)

3

I believe you are on the right track.
The only other thing is, if you turn on to collect samples, we show a screen like this in the Management Console.

875×168

So the information is stored in the repo or you simply grant people access to this page?

Details: https://wiki.sdn.sap.com/wiki/display/BOBJ/Data+Validation

Werner Daehn :de: (BOB member since 2004-12-17)