Capturing Warning Records

[Former Member]

Hi,

I have a Excel source that loads data into BW PSA. During the job execution i see a warning message which says,

Cannot convert Text data into type Integer.Column A

Now, how can i capture the record that's causing the Warning message.

Thanks

[former_member187605 · Accepted solution]

You can write it to an error file by checking Log Errors to File:

[Former Member · Accepted solution]

i tired using this option , but the error file is created with 0 records.Not sure if i have done something wrong.

[former_member187605 · Accepted solution]

Yes, you should get a line for every record in error:

Documents/CDC/VBAK1.xlsx|1|11|ERROR|

800,4969,02.01.2012,10:30:12,CURA,00.00.0000,00.00.0000,02.01.2012,C,0,TA

Documents/CDC/VBAK1.xlsx|2|11|ERROR|

800,4970,03.01.2012,12:52:54,CURA,00.00.0000,00.00.0000,03.01.2012,C,0,TA

Documents/CDC/VBAK1.xlsx|3|11|ERROR|

800,4971,07.01.2012,19:14:59,CURA,00.00.0000,00.00.0000,07.01.2012,C,0,TA

...

[Former Member · Accepted solution]

Thanks Dirk.

i cleaned up and created new Error File, now am able to record the culprit.

Thanks again.