Unparseable date Error in Mapping in PI 7.1

[Former Member]

I am working on Proxy to SOAP in PI 7.1 version

I have input date as 2009-05-14T17:00:00-07:00 from ECC and I need to split the date as 2009-05-14 and time as 17:00

please find the error in mapping below

Compilation of MM_ECC_to_ISO_ClaimSearch_Req successful Unparseable date: "2009-05-14T17:00:00-07:00" com.sap.aii.mappingtool.tf7.FunctionException: Unparseable date: "2009-05-14T17:00:00-07:00" at com.sap.aii.mappingtool.flib7.DateTransformer.convertDate(DateTransformer.java:72) at com.sap.aii.mappingtool.flib7.DateTransformer.getValue(DateTransformer.java:37) at com.sap.aii.mappingtool.flib7.If.getValue(If.java:35)

Please let me know how can I get rid of this error

Thanks

PR

[Former Member]

Thanks

[Former Member]

Hi!

For the XI/PI this is not a valid date format. What is the type of your source field and your target fields?

When do you get this error?

You should split the string an ommit the "T".

Your string 2009-05-14T17:00:00-07:00 should be splitted with offset 0, length 10 into date target field and offset 11, length 5 into time field.

Regards,

Volker

[former_member200962]

I have input date as 2009-05-14T17:00:00-07:00 from ECC and I need to split the date as 2009-05-14 and time as 17:00

Have logic as below:

Source -- Substring(0...10) -- output will be 2009-05-14----------dateTransform(if needed)----------> Target

Source-- Substring(11...16)-- output will be 17:00 -------Target

[Former Member]

Source_Date ---> Substring (0..9) -> DateTrans(under properties set you desired pattern)-> Target_Date

[former_member200962]

>

> I am working on Proxy to SOAP in PI 7.1 version 
> 
> I have input date as  2009-05-14T17:00:00-07:00 from ECC and I need to split the date as 2009-05-14 and time as 17:00 
> 
> please find the error in mapping below 
> 
> Compilation of MM_ECC_to_ISO_ClaimSearch_Req successful Unparseable date: "2009-05-14T17:00:00-07:00" com.sap.aii.mappingtool.tf7.FunctionException: Unparseable date: "2009-05-14T17:00:00-07:00" at com.sap.aii.mappingtool.flib7.DateTransformer.convertDate(DateTransformer.java:72) at com.sap.aii.mappingtool.flib7.DateTransformer.getValue(DateTransformer.java:37) at com.sap.aii.mappingtool.flib7.If.getValue(If.java:35)
> 
> 
> Please let me know how can I get rid of this error 
> 
> Thanks 
> PR

You need to convert the source date format into that of target date format....you need to use standard DateTransform function available in Messaeg Mapping......

[Former Member]

Hello PR,

Use a "substring" function to cut the field into two then use the "dateTrans" function to transform each into the required output.

Regards,

Glenn