SXMB_MONI Date error, showing 2 Dates one interface

[Former Member]

Hi Guys,

I need convert the Date. but here one problem.

my XI system it is successful processed and date is showing 5th - Feb but FI side it is showing 7th-Feb.

what is problem. why it is variations from my side and FI side.

Find the below screen

<SAP:TimeSent>2015-02-05T11:59:53Z</SAP:TimeSent>

<CreationDateTime>2015-02-07T06:59:08</CreationDateTime>

why it is showing 2 dates. any body help me.

Thanks,

Soma

[Former Member · Accepted solution]

Can you provide more details like mapping in XI and also how are the data getting populated in FI. It might be that FI is not using the <SAP:TimeSent>2015-02-05T11:59:53Z</SAP:TimeSent> to populate <CreationDateTime>2015-02-07T06:59:08</CreationDateTime>

[iaki_vila]

Hi Soma,

Is it your scenario asynchronous?, if the tags are not in the data and they are retrieving from monitoring in PI side, and with for example sy-datum in ECC-FI side you can have a delay or simpler one day the messages were stuck in PI and two days later automatically or manually anybody resend them from PI.

Regards.

[Former Member]

Hi Inaki,

Thanks for your replay, find the below screen shot.

this is Synchronous. This interface some are the showing same date, some are the one day plus and some are the two days plus from Timesent to creationDate.

why this variation. what is the problem. can you please explain.

Thanks,

Soma

[Former Member]

Hello,

can you give the mapping details the date transformation you have done.

if few messages have correct date stamp and few have 1 day diff and few have two day diff.

then better u priorities the queue.

[Former Member]

Hi Phani,

Thanks for your mail. Find the below screen shot. this is the mapping.

Thanks,

Soma

[former_member182412]

Hi Soma,

You mapping CreationDateTime field from source field DTSERVER so you need to check the values of this field for different payloads, may be this field contains different values for different messages?

Regards,

Praveen.

[former_member184619]

Hi Soma,

Probably your ECC and PI system are running in different timezone.

The time at which FI data is created is creation date time and the data sent from FI is a batch job which might be running at different time. So, Sent time is different.

Regards,

Sachin Dhingra