SAP PI Date time stamp handling for JDBC Receiver

[Former Member]

Hi Experts,

Could you pls. help us to resolve timestamp issue (one datafeed is dropping data  in batches hence multiple timestamps though difference is in milliseconds) and advice how can it be fixed from PI side to keep the fixed timestamp.

the scenario is RFC-TO-JDBC and its live in production. this is the production issue frequently occurring at receiver sql staging table while writing the data.

Regards,

Krushi.

[madhusudana_reddy2]

Hi,

Using user defined function make seconds and milliseconds to zero in mapping and send to target system. so that each record will have same hours and minutes and zeros in seconds and milliseconds.

Regards, Madhu

[Former Member]

hi,

thank you for your response. i could not able to generate correct udf for the above.

will you please send me UDF code for condition each record will have same hours and minutes and zeros in seconds and milliseconds.

regards,

Krushi.

[Former Member]

Hi Krushi

You can use the standard date transformation function to achieve this.

just give 00 instead of ss in the properties.

Hours and minutes will be same that is coming from the source, only the seconds value will be replaced by 00

Regards

Osman

[naveen_chichili]

Hi Krushi,

Sugestion would  be to use BPM and make wait fer few mins untill all the messages arrive and then you cal push the messages in to your Database.

Thanks and Regards,

Naveen