Skip to Content
avatar image
Former Member

Date Mapping Error

Hi

I am having Start Date(Element) as date Type field on the Source message and Effective date(element) string type on the target side,

I mapped the fields by using Date Trans (Function) however I am still receing the error as

Unparseable date: ""

com.sap.aii.mappingtool.tf7.FunctionException: Unparseable date: ""

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.tf7.AMappingProgram.processNode(AMappingProgram.java:366)

at com.sap.aii.mappingtool.tf7.AMappingProgram.processNode(AMappingProgram.java:395)

at com.sap.aii.mappingtool.tf7.AMappingProgram.processNode(AMappingProgram.java:395)

at com.sap.aii.mappingtool.tf7.AMappingProgram.processNode(AMappingProgram.java:395)

at com.sap.aii.mappingtool.tf7.AMappingProgram.start(AMappingProgram.java:482)

at com.sap.aii.mappingtool.tf7.Transformer.start(Transformer.java:133)

Runtime exception when processing target-field mapping /ClaimInvestigationAddRq/Policy/ContractTerm/EffectiveDt; root message: Unparseable date: ""

19:49:46 End of test

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

Thanks

PR

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Mar 19, 2009 at 03:22 AM

    Hi

    It is problem because Date from in / out set to u r DateFormat is wrong

    1) yyyy/dd/MM (Input) -> ( yyyy/dd/MM - MM/dd/yyyy) DateTrans -> MM/dd/yyyy (Output) --> Correct way

    2)dd/yyyy/MM (Input) -> ( yyyy/dd/MM - MM/dd/yyyy) DateTrans -> MM/dd/yyyy (Output) -->

    Above error of u r s would be given

    check u r function input and function logic date format

    rgds

    srini

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 19, 2009 at 03:24 AM

    in source strcuture you are getting empty value for Start Date Element.

    Pass some date value in the structure and then check.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 19, 2009 at 03:33 AM

    Hi,

    Check your input date format .. i think fromat of your input value is deffrent from requred format .

    Regards,

    Amit

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 19, 2009 at 04:55 AM

    Hi PR,

    Unparseable date: ""

    com.sap.aii.mappingtool.tf7.FunctionException: Unparseable date: ""

    The error you are getting is because of a blank value from the source field that you have used your DateTrans function. For the mapping to post, you would need to have a value of YYYY/MM/dd in your source field.

    Hope this helps,

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi PR,

      Can you just directly map the input field to the output field and then check, just a try, without doing any date transformation.

      Regards,

      Nithiyanandam

  • avatar image
    Former Member
    Mar 19, 2009 at 05:36 AM

    Hi,

    The error is due to empty value in input date field.

    Please verify in which format the date field is coming into XI server and provide exactly the same format in input format of "DateTrans" function.

    Also, try to modify the message mapping using if-then-else function taking in consideration two options:

    1) When input date field is empty

    2) When input date field is not empty

    Thanks,

    Subhajit.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 20, 2009 at 01:47 AM

    Thanks

    Add comment
    10|10000 characters needed characters exceeded