2015 Year automatic conversion to 1915 in HANA tables

[Former Member]

Dear Hana Gurus,

My Scenario : Loading data to HANA from BODS.

• I'm loading Flat File which has  2013, 2014 and 2015 year records to SAP HANA through BODS JOB.
• Data is loaded successfully ,

• When I come to SAP HANA table the year 2015 is being converted to 1915 as shown in the attached screenshot , the other years 2014 and 2013 y is loaded perfectly fine.

I've checked the date format in excel and everything is fine.

Not sure if there's any hidden conversion routine in the HANA which is converting the current year to 1915 (going back 100 years )

Any helps is highly appreciated.

Regards,

-Baseer

[Former Member · Accepted solution]

While inserting Flat file data have you used some date conversion functions?

Like todate or tochar?

[Former Member · Accepted solution]

Hi Swapnil,

Yes , we're using the date conversion functions (ToDate & ToChar)  in BODS to load the data , if we remove this function it's loading fine.

Regards,

-Baseer

[Former Member · Accepted solution]

What do you think is the proper solution to this ??

[Former Member · Accepted solution]

actually I was also getting same error while using conversion functions.

There is issue with oracle conversion function..

I had resolved the issue by simply removing to_char function from date.

Thanks,

Swapnil

[Former Member · Accepted solution]

Hi Sawpnil,

Thanks , yes this is bug exist in To_Date & To_Char, please refer to the following SAP NOTE :  2134992

http://service.sap.com/sap/support/notes/2134992

Appreciate your help.

Regards,

-Baseer

[Former Member · Accepted solution]

Yes man!

Thank a lot for your help even.

[Former Member · Accepted solution]

The Data Services function to_date with YEAR value 2015 generates an incorrect result; for example, to_date('01-JAN-15','DD-MON-YY') returns as 01/02/1915 (wrong century).

Other Terms

Environment:

This affects all SAP Data Services versions.

This issue is tracked in Corrective Measure 4912 2015.

Reason and Prerequisites

This issue occurs because of a programming error.

Solution

Workaround

As a workaround, perform the following steps:

1. On the job server machine, save a backup of the DSConfig.txt file.
2. Edit Century_Year in the AL_Engine section to 'Century_Year = 99'.

OR

        If the job server is Windows, in the Designer, select Tools > Options > Data > General and change Century Change Year to 99.

This affects years such as 1999. All 20th century years are fine.

           YY as 99 will be 1999.

           YY as 15 will be 2015.

  3.   Test all clients to verify that they pick up the change on the job server that they are associated with via the local repository.

Fix

This correction is delivered in the release(s) listed in the Support Packages and Patches section of this SAP Note.