In this blog we are fetching the error message and other details of the failed iflows.
Step1: Create the iflow with desired iflow name.
Step2: Connect the Sender and integration process with the HTTP Adapter and in the Address field give the desired endpoint address like as shown below(/Fetching_ the_Error_Msg).
Step3:Add Content Modifier with two properties as given below.
Name Source Type Source Value Data Type
LogEndDate Expression ${date:now:yyyy-MM-dd'T'HH:mm:ss.SSS} java.lang.String
LogStartDate Xpath /Root/StartDate java.lang.String
Step4: Now add Request reply and connect with receiver with the OData V2 Adapter.
Do the following configurations in Connection and processing tab in the V2 OData Adapter.
Follow the below configuration to fetch the MPL logs from the MessageProcessingLogs API using OData V2 adapter.
In Connection tab:
Address : https://<<TenentURL>>/api/v1
Authentication : Basic
Credential Name: (Deploy the CPI log Credentials with a particular name in the security Material in monitoring section as User credentials type).Give that particular name in the Credential Name field.
In Processing Tab:
Resource Path : MessageProcessingLogs
Query Option: $select=MessageGuid,CorrelationId,ApplicationMessageId,ApplicationMessageType,LogStart,LogEnd,Sender,Receiver,IntegrationFlowName,Status,AlternateWebLink,IntegrationArtifact,LogLevel,CustomStatus,TransactionId,PreviousComponentName&$filter=LogStart ge datetime'${property.LogStartDate}' and LogEnd le datetime'${property.LogEndDate}'.
Step5:Add the iterating Splitter with the below given Xpath Expression(//MessageProcessingLog).
Step6:Now create one Local Integration Process and Add one Content Modifier.
After adding the content modifier create one property as shown below.
Name : MessageId Source Type : XPath Source Value : /MessageProcessingLog/MessageGuid
DataType : java.lang.String
Step7:Add the groovy Script element and create groovy script with the below script.
import com.sap.gateway.ip.core.customdev.util.Message;
import java.util.HashMap;
def Message processData(Message message) {
def body = message.getBody(String);
body = body.replaceAll("<MessageProcessingLog>","").trim();
body = body.replaceAll("</MessageProcessingLog>","").trim();
//body = body.replaceAll(" <?xml version="1.0" encoding="UTF-8"?>","").trim();
body = body.replaceAll("\\\t|\\\n|\\\r","");
message.setBody(body);
return message;
}
Step8:Add one more content modifier to store the entire body with the help of property.
Name : MessageInfo Source Type : Expression Source Value : ${in.body}
DataType : java.lang.String
Step9: Now add one Request reply and receiver with the HTTP Adapter.
In Connection Tab:
Address : https://<<TenentURL>>/api/v1//MessageProcessingLogs('${property.MessageId}')/ErrorInformation/$value
Authencation : Basic
Credential Name : (Deploy the CPI log Credentials with a particular name in the security Material in monitoring section as User credentials type).Give that particular name in the Credential Name field.
Step10:Add content modifier to set the content-type in the Header
Name : Content-Type Source-Type : Constant Source Value : application/xml
And set the body in the context Modifier as given below.
<MessageProcessingLog>
${property.MessageInfo}
<ErrorDetails>${in.body}</ErrorDetails>
</MessageProcessingLog>
Step11: Define one process call in the main integration process as shown below and select the created local integration process.
Step12: Next add the Gather and set the following fields as below:
Incoming Format : Plain Text
Aggregation Algorithm:Concatentate
Step13: Now add one XML modifier and check the remove xml declaration.
Step14: Add content modifier to set the content-type in the Header
Name:Content-Type Source-Type:Constant Source Value:application/xml
And set the body in the context Modifier as given below.
<MessageProcessingLogs>
${in.body}
</MessageProcessingLogs>
Step15: Add one Message Mapping element and create Mapping as shown below.
After creating the Mapping Upload the Source and Target XSD files with below given xsd Codes.
Source XSD:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="MessageProcessingLogs">
<xs:complexType>
<xs:sequence
<xs:element minOccurs="1" maxOccurs="unbounded" name="MessageProcessingLog">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:string" nillable="false" maxOccurs="unbounded" name="MessageGuid" xmlns=""/>
<xs:element type="xs:string" nillable="true" minOccurs="0" maxOccurs="unbounded" name="CorrelationId" xmlns=""/>
<xs:element type="xs:string" nillable="true" minOccurs="0" maxOccurs="unbounded" name="ApplicationMessageId" xmlns=""/>
<xs:element type="xs:string" nillable="true" minOccurs="0" maxOccurs="unbounded" name="ApplicationMessageType" xmlns=""/>
<xs:element type="xs:dateTime" nillable="true" minOccurs="0" maxOccurs="unbounded" name="LogStart" xmlns=""/>
<xs:element type="xs:dateTime" nillable="true" minOccurs="0" maxOccurs="unbounded" name="LogEnd" xmlns=""/>
<xs:element type="xs:string" nillable="true" minOccurs="0" maxOccurs="unbounded" name="Sender" xmlns=""/>
<xs:element type="xs:string" nillable="true" minOccurs="0" maxOccurs="unbounded" name="Receiver" xmlns=""/>
<xs:element type="xs:string" nillable="true" minOccurs="0" maxOccurs="unbounded" name="IntegrationFlowName" xmlns=""/>
<xs:element type="xs:string" nillable="true" minOccurs="0" maxOccurs="unbounded" name="Status" xmlns=""/>
<xs:element type="xs:string" nillable="true" minOccurs="0" maxOccurs="unbounded" name="AlternateWebLink" xmlns=""/>
<xs:element nillable="false" maxOccurs="unbounded" name="IntegrationArtifact">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:string" nillable="true" minOccurs="0" maxOccurs="unbounded" name="Id" xmlns=""/>
<xs:element type="xs:string" nillable="true" minOccurs="0" maxOccurs="unbounded" name="Name" xmlns=""/>
<xs:element type="xs:string" nillable="true" minOccurs="0" maxOccurs="unbounded" name="Type" xmlns=""/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element type="xs:string" nillable="true" minOccurs="0" maxOccurs="unbounded" name="LogLevel" xmlns=""/>
<xs:element type="xs:string" nillable="true" minOccurs="0" maxOccurs="unbounded" name="CustomStatus" xmlns=""/>
<xs:element type="xs:string" nillable="true" minOccurs="0" maxOccurs="unbounded" name="TransactionId" xmlns=""/>
<xs:element type="xs:string" nillable="true" minOccurs="0" maxOccurs="unbounded" name="ErrorDetails" xmlns=""/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
Target XSD:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="MessageProcessingLogs">
<xs:complexType>
<xs:sequence>
<xs:element minOccurs="1" maxOccurs="unbounded" name="MessageProcessingLog">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:string" nillable="true" minOccurs="0" maxOccurs="unbounded" name="IntegrationFlowName" xmlns=""/>
<xs:element type="xs:string" nillable="true" minOccurs="0" maxOccurs="unbounded" name="PackageName" xmlns=""/>
<xs:element type="xs:string" nillable="false" maxOccurs="unbounded" name="MessageGuid" xmlns=""/>
<xs:element type="xs:dateTime" nillable="true" minOccurs="0" maxOccurs="unbounded" name="LogStart" xmlns=""/>
<xs:element type="xs:dateTime" nillable="true" minOccurs="0" maxOccurs="unbounded" name="LogEnd" xmlns=""/>
<xs:element type="xs:string" nillable="true" minOccurs="0" maxOccurs="unbounded" name="Status" xmlns=""/>
<xs:element type="xs:string" nillable="true" minOccurs="0" maxOccurs="unbounded" name="LogLevel" xmlns=""/>
<xs:element type="xs:string" nillable="true" minOccurs="0" maxOccurs="unbounded" name="TransactionId" xmlns=""/>
<xs:element type="xs:string" nillable="true" minOccurs="0" maxOccurs="unbounded" name="ErrorDetails" xmlns=""/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
After uploading the XSD files do the one to one Mapping with all the elements in the Target XSD.
Step16: After doing the message Mapping add the xml to csv convertor with
path to source element in xsd field : /MessageProcessingLogs/MessageProcessingLog
and check the include field name as header.
After xml to csv convertor save and deploy the iflow and fetch the endpoints from the message monitoring.
After deploying the Iflow test the iflow in postman as shown below with below body.
<Root>
<StartDate>2023-12-09T9:15:00.000</StartDate>
</Root>
After giving the body click on the send icon.
After click on the send save the response into the file .So, we can view the file in the csv format.
- SAP Managed Tags:
