Resolution:
Description:
============

BW is unable to parse a valid date time value while using the mapper activity and “parse-date” function.


Environment:
===========

BW 5.11

Symptoms:
========

The following exception stack trace will be printed.

Input data invalid
        at com.tibco.pe.core.TaskImpl.eval(Unknown Source)
        at com.tibco.pe.core.Job.a(Unknown Source)
        at com.tibco.pe.core.Job.k(Unknown Source)
        at com.tibco.pe.core.JobDispatcher$JobCourier.a(Unknown Source)
        at com.tibco.pe.core.JobDispatcher$JobCourier.run(Unknown Source)
caused by: org.xml.sax.SAXException: validation error: data "" is not a valid date.  A valid example is "1999-05-31".   ({com.tibco.xml.validation}SIMPLE_E_INVALID_VALUE_FOR_TYPE) at /root[1]/pfx7:ProductEvent[1]/pfx7:Departments[1]/pfx7:Department[1]/pfx7:PrivateBrandCostFactors[1]/pfx7:PrivateBrandCostFactor[1]/pfx7:EffectiveBeginDate[1]
com.tibco.xml.validation.exception.ValueParseException: data "" is not a valid date.  A valid example is "1999-05-31".
        at com.tibco.xml.validation.state.glue.LegacySimpleValidator.string(LegacySimpleValidator.java:67)
        at com.tibco.xml.validation.state.driver.ValidationJazz.d(ValidationJazz.java:1149)
        at com.tibco.xml.validation.state.driver.ValidationJazz.endElement(ValidationJazz.java:498)
        at com.tibco.xml.validation.state.glue.XmlContentValidationDriver.endElement(XmlContentValidationDriver.java:126)
        at com.tibco.xml.transform.impl.expr.h.a(XslConditioningFilter3.java:635)
This issue can be found only with JVM 1.7. It doesn't happen in 1.6 & below.

Cause:
=====

The reported error does not have complete details about the failure. This is caused by insufficient date time format. When you specify the hour in A.M./P.M. (1~12)  (small hh) in the date time format, it parses with out knowing the AM PM part.

Sample format:  yyyy-MM-dd hh:mm:ss
Sample value :  2012-11-11 00:00:00


Resolution:
==========

Change the date time format to accommodate the incoming date time value.

Example:

Format yyyy-MM-dd HH:mm:ss for 2012-11-11 00:00:00