error while schedling job server ( rapid mart)

dataservices rapidmarts
1

hi friends

iam new to bods we are using BODS 3.2 source r/3 and target is MYSQLSERVER . and we have installed rapidmarts
General_ledger_rapid mart during scheduling the job fails and got and
erorr

Transform EID_2_Rename_ConvertDateToChar Cannot convert string <1900.01.01 00:00:00> to date using format string .
(12.2) 02-11-12 04:59:09 (W) (1124:11052) RUN-053006: |Data flow DF_FinDocFactNewGL_SAP|Embedded Dataflow Copy_1_EDF_FinDocFact_SAP|Transform EID_2_Rename_ConvertDateToChar

please help how to rectify this step by step ( as iam new )

please

Thanks

liveinsap (BOB member since 2012-01-23)

2

The dataflow Copy_1_EDF_FinDocFact_SAP does have a query where a varchar is converted to a date. The varchar read seems to be in YYYY.MM.DD which is obviously different from the YYYY-MM-DD format.

Big question is why was the wrong format used…

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

3

Hi,

For anyone else who encounter this error :

This is a data flow used in GL RapidMart For SAP.

Since SAP can handle dates that have year 0001 (the first year ever?! :slight_smile: and SQL server can not handle dates before year 1900, all dates have to be validated before being inserted to SQL server.

And if some documents fail this test RapidMart converts those dates to character format (because they can not be stored as date) and inserts them into a table called “FINANCIAL_DOCUMENT_FACT_BAD”.

The problem is in the query, intending to convert dates to char, one of them is mistyped as to_date(BASELINE_DATE,‘YYYY-MM-DD’).

Correct it as to_char(BASELINE_DATE,‘YYYY-MM-DD’) and you are done.

PS : The reason that your financial documents contain dates before 1900 is probably typos on document date. it is a free date field intended to store the original date on the invoice or whichever financial document that is.

aderici (BOB member since 2012-01-13)

4

thanks dear

But I do not understand what the baseline

""Correct it as to_char(BASELINE_DATE,‘YYYY-MM-DD’) and you are done “”

could u help me

Thanks

liveinsap (BOB member since 2012-01-23)

5

Hello,

The above mentioned change can be made in the mapping tab by selecting that particular field which loads the converted date value to the target.

Regards,
Suneer

suneer333 :us: (BOB member since 2010-07-15)