Skip to Content
0

HCI : Content prolog error in Hana Cloud Integration

May 10, 2017 at 07:11 AM

117

avatar image

Dear Experts,

We have requirment, where we need to fetch the .CSV files which contain clock-in and clock-outs from SFTP server.And needs to be integrated to Successfactors using costomized MDF objects.

We have developed sender .xsd structure and mapping using SAP PI.Now we have imported the mapping into Hana Cloud Integration environment by using Eclipse as attached in the screenshot,so why deploying this iflow we are getting the error "Content prolog is not not allowed".Please find the attached screenshot.

Regatds,

Giridhar Vegi.content-prolog-is-not-allowed-error-in-hci.jpgiflow.jpg

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Sriprasad Shivaram Bhat May 11, 2017 at 06:14 AM
1

Hello Giridhar,

You need to convert .CSV to XML before sending the data to Message Mapping.

Use the Convertor Step to Convert CSV into XML.

1) Converts CSV to XML.

2) Message Mapping to produce the XML structure as per SF generated Schema.

Below will give more details about CSV to XML Convertor.

https://archive.sap.com/discussions/thread/3840352

Regards,

Sriprasad Shivaram Bhat


Share
10 |10000 characters needed characters left characters exceeded
Santosh Giridhar vegi May 11, 2017 at 11:18 AM
0

Dear prasad ,

Thanks prasad for your support . Could you please provide the information about how to generate the xsd for the attached structure.structure.jpg and i have tried to generate the xsd by using pi but it has not worked . when i tried to use the generated pi xsd file i am getting the warning as WARNING: SFTP Sender may not pass Text message to CSV To XML Converter. CSV To XML Converter supports Text input only.

The fields are as follows

[OPERATOR]

externalCode

effectiveStartDate

cust_SwipeinOutDetails.externalCode

cust_SwipeinOutDetails.cust_date

cust_SwipeinOutDetails.externalName

cust_SwipeinOutDetails.cust_Login_Terminal_ID

cust_SwipeinOutDetails.cust_Logout_Time

cust_SwipeinOutDetails.cust_Logout_Termina_ID

Please help me as i have strucked due to this.

Regards

Giridhar Vegi.


structure.jpg (120.0 kB)
Share
10 |10000 characters needed characters left characters exceeded
Sriprasad Shivaram Bhat May 11, 2017 at 12:59 PM
0

Hello Giridhar,

You can leverage free online tools like freeformatter.com to build XSD very easily.

First you just need to form Dummy or original XML and create a XSD[ Note: If you want to set occurrence at field level you have to change manually post XSD is created].

XML I have taken:

<Root>
    <Record>
        <externalCode>E</externalCode>
        <effectiveStartDate>RR</effectiveStartDate>
        <cust_SwipeinOutDetails.externalCode>LL</cust_SwipeinOutDetails.externalCode>
        <cust_SwipeinOutDetails.cust_date>PP</cust_SwipeinOutDetails.cust_date>
        <cust_SwipeinOutDetails.externalName>OO</cust_SwipeinOutDetails.externalName>
        <cust_SwipeinOutDetails.cust_Login_Terminal_ID>OO</cust_SwipeinOutDetails.cust_Login_Terminal_ID>
        <cust_SwipeinOutDetails.cust_Logout_Time>PP</cust_SwipeinOutDetails.cust_Logout_Time>
        <cust_SwipeinOutDetails.cust_Logout_Termina_ID>PPP</cust_SwipeinOutDetails.cust_Logout_Termina_ID>
    </Record>
    <Record>
        <externalCode>E</externalCode>
        <effectiveStartDate>RR</effectiveStartDate>
        <cust_SwipeinOutDetails.externalCode>LL</cust_SwipeinOutDetails.externalCode>
        <cust_SwipeinOutDetails.cust_date>PP</cust_SwipeinOutDetails.cust_date>
        <cust_SwipeinOutDetails.externalName>OO</cust_SwipeinOutDetails.externalName>
        <cust_SwipeinOutDetails.cust_Login_Terminal_ID>OO</cust_SwipeinOutDetails.cust_Login_Terminal_ID>
        <cust_SwipeinOutDetails.cust_Logout_Time>PP</cust_SwipeinOutDetails.cust_Logout_Time>
        <cust_SwipeinOutDetails.cust_Logout_Termina_ID>PPP</cust_SwipeinOutDetails.cust_Logout_Termina_ID>
    </Record>    
</Root>

Relevant XSD:

<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
    <xs:element name="Root">
        <xs:complexType>
            <xs:sequence>
                <xs:element name="Record" maxOccurs="unbounded" minOccurs="0">
                    <xs:complexType>
                        <xs:sequence>
                            <xs:element type="xs:string" name="externalCode"/>
                            <xs:element type="xs:string" name="effectiveStartDate"/>
                            <xs:element type="xs:string" name="cust_SwipeinOutDetails.externalCode"/>
                            <xs:element type="xs:string" name="cust_SwipeinOutDetails.cust_date"/>
                            <xs:element type="xs:string" name="cust_SwipeinOutDetails.externalName"/>
                            <xs:element type="xs:string" name="cust_SwipeinOutDetails.cust_Login_Terminal_ID"/>
                            <xs:element type="xs:string" name="cust_SwipeinOutDetails.cust_Logout_Time"/>
                            <xs:element type="xs:string" name="cust_SwipeinOutDetails.cust_Logout_Termina_ID"/>
                        </xs:sequence>
                    </xs:complexType>
                </xs:element>
            </xs:sequence>
        </xs:complexType>
    </xs:element>
</xs:schema>

And as I told earlier you can ignore those warning ( its just a reminder that Message Mapping accepts only XML as input ).

Regards,

Sriprasad Shivaram Bhat

Share
10 |10000 characters needed characters left characters exceeded
Santosh Giridhar vegi May 15, 2017 at 09:25 AM
0

Dear prasad ,

i have tried as specified by you. but i am not able to view deployed process in HCI message monitoring . if possible could you please provide the step by step for the converter configuration . and i have used your xsd on sender side and mdf xsd on receiver side for mapping . when i execute it is showing as it is successfully deployed and when i am checking in message monitor i am not able to view that .

Regards

Giridhar Vegi.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hello Giridhar,

Could you please share your IFLow screenshot and convertor details.

Also could you please check in Task Overview and Component status overview if project is up and running.

If it is in error please navigate to Tail Log Overview and share the those details.

Regards,

Sriprasad Shivaram Bhat

0