cancel
Showing results for 
Search instead for 
Did you mean: 

BODS recurring job failed repeatedly with same error

siba_pkd21
Participant
0 Kudos

Hi All

A BODS recurring job failed repeatedly with same error: PFA

Any suggestion regarding this error ?

 

BR

Siba

 

View Entire Topic
Anurag004
Discoverer
0 Kudos

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

siba_pkd21
Participant
0 Kudos

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
Discoverer
0 Kudos

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