BODS recurring job failed repeatedly with same error

[SibaP]

Hi All

A BODS recurring job failed repeatedly with same error: PFA

Any suggestion regarding this error ?

BR

Siba

[Anurag004]

Dear siba_pkd21, 

Can you please consult the below note for the same?

https://userapps.support.sap.com/sap/support/knowledge/en/2688936

Thanks and Regards
Anurag

[SibaP]

Hello Anurag,

I have this link but I don't have sap credentials to see the contents, could you please share me the respective content either here or to my mail id: siba.pkd21@gmail.com

Regards, Siba

[Anurag004]

Dear Siba

I'm sorry for not getting back to you sooner


This is what you will find in the note 2688936

Cause
The issue may occur when comparing timestamp datatypes. The problem can also happen if some or all of the date fields are left blank.
Resolution

To workaround this issue, use one of the following:

1. Declare the global variables of datatype Date/Datetime/Decimal(x,x). This is depended on which datatype is used in SAPsystem.
2. Use the Cast or to_date() function to change the datatype to Date/Datetime/Decimal(x,x).

Thanks and Regards
Anurag