How to Use Web Service Method updateScheduleActivitiesV2 With sheetXML To Avoid Status Code 712

Last updated on MAY 18, 2018

Applies to:

Goal

In Unifier Integration Guide, there is a method named as Update Schedule Sheet Activities V2 from Oracle® Primavera™ P6 XML, and there is a required parameter sheetXML,in our document it is described as
“Content of activities to import. This is obtained from the Primavera P5/P6 xml content. The Primavera XML content should be generated by exporting the full Primavera project.”,
while the tricky part is that if you try to directly use the content from a P6 Project XML Export file, it will fail with status code 712 in response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Header/>
<soapenv:Body>
<ns1:updateScheduleActivitiesV2Response xmlns:ns1="http://general.service.webservices.skire.com">
<ns1:return>
<ax21:statusCode xmlns:ax21="http://xml.util.webservices.skire.com/xsd">712</ax21:statusCode>
<ax21:xmlcontents xmlns:ax21="http://xml.util.webservices.skire.com/xsd"/>
<ax21:errorStatus xmlns:ax21="http://xml.util.webservices.skire.com/xsd">Import of Schedule activities failed reason :</ax21:errorStatus>
<ax21:errorStatus xmlns:ax21="http://xml.util.webservices.skire.com/xsd">Error occured :Error in parsing XML data.</ax21:errorStatus>
</ns1:return>
</ns1:updateScheduleActivitiesV2Response>
</soapenv:Body>
</soapenv:Envelope>

This KM Doc explained how to avoid this error by preparing the correct sheetXML content from an existing Primavera P6 Project XML Export file.

Solution