BODS job failed due to Invalid value for date <01042012>

[Former Member]

hi team,

I recently joined this BO DS project and I am just a beginner with this.

Actually I need to know from where and how can I check data from source to validate error.

one of the DS job failed due to below errors:-

Invalid value <Month: 20> for date <01042012>. Context: Column <>.

I need to find the root cause it seems record in the source system caused this error.

But I don't know how to proceed.

please help!

[former_member198401 · Accepted solution]

First of all check the Date format in the Source system and then try to find in which date format do you want the date in the target system. You might need to use date conversion function to get the date in the desired format.

Regards

Arun Sasi

[Former Member · Accepted solution]

Hi ,

I got the source table of failed Data flow job but I need to take dump of data from source to check the date format.

How can I check ?

[former_member198401 · Accepted solution]

Check the datatype of the column which contains the date format. Why do you want to take the dump of the Source table? There is no need to change the format in the Source table. All you need to do is convert the date in the appropriate format in the Query transform so that the date is outputted in the correct format(e.g. Source Date format is MMDDYYYY and the required Target Date needed is DD-MM-YYYY)

Refer to_date() function in the reference guide

http://help.sap.com/businessobject/product_guides/sbods42/en/ds_42_reference_en.pdf

Regards

Arun Sasi

[Former Member · Accepted solution]

Hi arun,

thanks Arun. this would be helpful...but I want to find the corrupted data. not all the date related data are failing..yesterday I found that DF which was failed and checked that source is ECC that means the source table is coming from BI  so now i am confuse whether the data in source is in wrong format or after being fetched by DS job and transformation applied on that, it is going in wrong format in target table..how can I know that date issue is coming wrong from source table or target table.

DF is like:- Source -> Transformation -> Target

[former_member208363 · Accepted solution]

Hi,

Can you give the screenshot of Date column in "Transformation"?

[Former Member · Accepted solution]

yea..i checked the data type as you said..in source table for each date column type is "date" but after qury application type is converted to "datetime". can it be a problem?

[Former Member · Accepted solution]

Hello Silpi

This is very common problem with SAP tables

To get the data which has this date issue you can make use of Error Handling, which you can find inside SOURCE tab when you click on a source table

It will look like this:

Select the file where you want to extract and keep the issue records.

This will also help you to execute the JOB successfully and will not have erroneous records.

Regards

Sandy