Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

REST WebService Consumer transformation failing to parse the data when the response is very large or contains special multi-byte characters
Problem Description
When REST WSC is configured to return JSON data and the response is huge (20,000,000 characters) or includes special multi-byte characters, transformation fails to parse the response to the output ports. 

From the mapping verbose data log, you can see the following message, which clearly states that the transformation is unable to convert the JSON to XML:

2017-10-13 16:10:50 <TASK_26388-TRANSF_1_1_1> FINER: [PMREST_EN_33039] HTTP Response Body: JSON
2017-10-13 16:10:53 <TASK_26388-TRANSF_1_1_1> FINER: [PMREST_EN_33039] HTTP Response Body: <Rest_Consumer_output>No xml String returned</Rest_Consumer_output>
Cause
This is a known issue in 10.1.x for which we already have a CR (PLAT-18714) submitted to address it in future releases.
Solution
To resolve this issue, apply the EBF patch available on 10.2.2, 10.2 HotFix 2 by contacting Informatica Global Customer Support.

OR use the following workaround:

Workaround steps:

  1. Use REST WebService Consumer transformation just to make the HTTP call to endpoint URL and get the response.
  2. Use Data Processor transformation to parse the above response.
More Information
Applies To
Product: Data Quality; PowerCenter; Big Data Management
Problem Type: Product Feature
User Type: Developer; Business Analyst
Project Phase: Implement; Onboard
Product Version: Data Quality 10.0; Data Quality 10.1; Data Quality 10.1.1; Big Data Management 10.2.2 Service Pack 1
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:9/20/2019 6:01 AMID:520252
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)