Posted: 28 Jul 2016 5:00 EDT Last activity: 8 Aug 2016 7:36 EDT
ParseXML problem parsing date type with timezone
I faced with problem parsing date with ParseXML rule in Pega 7.1.9. Third-party SOAP service returns a date in format like '2001-10-26+02:00'. In parseXML rule for this element XSD Base Type is set to 'date' on Type tab. Property to map is also Date type. As a result this element is not parsed at all. I applied Hfix-28202 but it didn't help.
I suppose that a date with a time zone makes some sense. As I write this it is tomorrow in Japan. If you show that this is working in 6.2 SP2, then this may be a regression. Lets see if we get further reponse from an engineer on this. If not then we should create an SR to address it.
New details abount this issue. I've reproduced this situation on two other servers - Hfix-28202 really works. So, the problem is in one particular server instance. But I've noticed one odd thing - parsed value is date minus one day - e.g. '2001-10-26+02:00' became '20011025'. Not sure this is correct. In 6.2SP2 behaviour is the same (date minus one day). Also tried Pega 7.2.1 PE - it can't parse this format OOTB as well. Unfortunately I have no HotFix for this version to check.