0 Replies Latest reply on Nov 25, 2019 7:01 AM by Nataraj Nanjukutty

    Rest_Consumer transformation is not parsing JSON source data

    Nataraj Nanjukutty New Member

      Hi All,

       

      In Rest_Consumer transformation JSON output. Not able to parse the data.

      ERROR:

      [LDTMCMN_0029] The LDTM could not complete the request because of the following error: com.informatica.sdk.dtm.ExecutionException: [LDTM_0072] XML parsing component [Rest_Consumer0_Output] message code: [66017], message body: The following error occurred while running the XML processor: [m: Failed to read input document.- for more information see file:///home/Install/Informatica_10.2/DataTransformation/CMReports/Tmp/2019-11-25/Rest_Consumer0_Output_68_1_7194_U-_-0-5ddb83a3-1c1a/Events.cme].

       

       

      Informatica Version:10.2.0

       

      {"validation":{"status":{"name":"Ok","value":0,"category":0,"description":"","helpUrl":"For more reference visit http://Sample.un.org/data/dev/portal/"},"message":null,"count":{"value":541,"started":"2019-11-25T06:55:13.9553514+01:00","finished":"2019-11-25T06:55:14.9279447+01:00","durationSeconds":0.9725933},"datasetTimer":{"started":"2019-11-25T06:55:13.9553514+01:00","finished":"2019-11-25T06:55:15.8523516+01:00","durationSeconds":1.8970002}},"dataset":[{"Code":"AB","yr":2018,"period":2018,"periodDesc":"2018","aggrLevel":2,"IsLeaf":0,"srCode":1,"srDesc":"Data1","rtCode":0,"Title":"sample1","st01":"ARD","stCode":0,"StTitle":"Sample3","st3":"abc","stCode2":null,"stTitle2":"","st32":"","cstCode":"","Desc":"","mtCode":"","mtDesc":"","Code4":"11","cmdDescE":"sample5","qCode":1,"qDesc":"No Quantity","qtAltCode":null,"qtAltDesc":"","Quantity":0,"AltQuantity":null,"NetWeight":0,"GrossWeight":null,"Value":4956,"CIFValue":null,"FOBValue":null,"estCode":4},{"Code":"AB","yr":2018,"period":2018,"periodDesc":"2018","aggrLevel":2,"IsLeaf":0,"srCode":1,"srDesc":"Data1","rtCode":0,"Title":"sample1","st01":"ARD","stCode":0,"StTitle":"Sample3","st3":"abc","stCode2":null,"stTitle2":"","st32":"","cstCode":"","Desc":"","mtCode":"","mtDesc":"","Code4":"11","cmdDescE":"sample5","qCode":1,"qDesc":"No Quantity","qtAltCode":null,"qtAltDesc":"","Quantity":0,"AltQuantity":null,"NetWeight":0,"GrossWeight":null,"Value":4956,"CIFValue":null,"FOBValue":null,"estCode":4}]}