Date format is different in mapping test tab and run time

[former_member196519]

HI Expert,

I am having issue in production that date format in test tab is working fine as dd-MMM-yyyy but xml output in runtime shows different format as dd-MMM-yy. This cause an issue in data base.

My scenario is Proxy to JDBC. It is working fine in development and quality environment. I am using SAP PO 7.4 SP 4

Thanks,

Kumar

[former_member196519 · Accepted solution]

Hi Expert,

Thanks for you response!

Mapping is activated and I also try to take payload from run time message monitoring and in mapping testing tab it is giving correct date format dd-MMM-yyyy but during runtime it is showing dd-MMM-yy

Kumar

[Former Member · Accepted solution]

Hi Kumar,

Have you verified you are using same mapping in production and quality.

have you made any changes in mapping recently yet to be transported to production.

[former_member186851 · Accepted solution]

Hello Kumar,

Check whether cache is up to date.

[former_member196519]

Hi Experts,

I found out this. The issue was that operation mapping was referring old mapping but I was trying to change in new mapping which was not configured correctly in the operation mapping.

Thank you so much for you time and response!

Kumar

[former_member186851]

Nice to hear Kumar.

[former_member196519]

Hi Expert,

I have refreshed cache as well. I have applied same logic in both field END_DATE and CIRCA_END_DATE in the mapping but it is populating correct format at END_DATE but CIRCA_END_DATE is coming in wrong format in the runtime.

runtime output:

<START_DATE>10-Nov-15</START_DATE>

<END_DATE>31-Dec-9999</END_DATE>

<CIRCA_PRICE>0.00</CIRCA_PRICE>

<CIRCA_START_DATE>11-Nov-15</CIRCA_START_DATE>

<CIRCA_END_DATE>31-Dec-99</CIRCA_END_DATE>

Could you please advise.

Below one is from mapping tab with using same input payload:

          <CURRENCY>USD</CURRENCY>

            <LIST_PRICE>0.00</LIST_PRICE>

            <START_DATE>10-Nov-2015</START_DATE>

            <END_DATE>31-DEC-9999</END_DATE>

            <CIRCA_PRICE>0.00</CIRCA_PRICE>

            <CIRCA_START_DATE>11-Nov-2015</CIRCA_START_DATE>

            <CIRCA_END_DATE>31-DEC-9999</CIRCA_END_DATE>

CIRCA_END_DATE should also come as 31-DEC-9999 in run time.

Thanks.

Kumar

[Former Member]

Hi Kumar,

As Inaki mentioned, amke a dummy change in the mapping, else refresh the cache or restart the server. It will solve the problem. Sometimes in the back ground, the changes will not overwrite the old version, but in front end it will show the latest version. May be after the restart of the server will solve the problem.

[apu_das2]

Hi,

You might have used date transformation where target date structure is set as you are getting after mapping.

Please check and confirm

Thanks,

Apu

[former_member196519]

Hi Apu,

I have set any target date structure. Iit is simply data type is String.

Thanks,

Kumar

[iaki_vila]

Hi Kumar,

Do a dummy change in the mapping as change description, save and active the change.

Regards.

[former_member196519]

Hi Inaki,

I have also tried same but no luck

Thanks,

Kumar

[iaki_vila]

Hi Kumar,

Are you sure the endpoint tag type is not restricted in length?

Regards.

[former_member186851]

what is the scenario Kumar?

are you using FCC?

[former_member186851]

Hello Kumar,

Check whether the mapping program is activated.

[Former Member]

take the XML payload from moni and try to test it in mapping.

ru using datetrans function?? check it once.

[Former Member]

are you using datetrans fn in mapping? if not check your input payload from Proxy message... and compare with dev and prod.