Unable to Deploy to BIP using Oracle SOAP Services

Shrujal Patel

Unable to use /analystics-ws SOAP Service to deploy a BIP Report (catalog file).

We use pasteItem2 operation of https://<HOSTNAME>/analytics-ws/saw.dll?SoapImpl=webCatalogService and it does

1. at times create the report folder using the catalog file but while trying to open it we get access denied
2. at other times it doesn't even create the folders on BIP for the catalog file being uploaded.

Did anyone had any luck trying to upload a catalog file using SOAP Service?

Hassan El Bouihi-Oracle

Hello Shrujal,

Please share the payload request you are using for review.

Thank you

Hassan

Madasamy -Oracle

Hi,

I tested the scenario and I can see that the copyitem() and unarchive() methods work fine on OAC. If you are using latest OA* versions, it should be available to you as well.

Note: in the below examples, i am using v12 wsdl.

Input Sample for the copyitem()

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v12="urn://oracle.bi.webservices/v12">
  <soapenv:Header/>
  <soapenv:Body>
   <v12:copyItem2>
     <!--1 or more repetitions:-->
     <v12:path>/shared/Donations Projects/test report</v12:path>
     <v12:recursive>false</v12:recursive>
     <v12:permissions>false</v12:permissions>
     <v12:timestamps>false</v12:timestamps>
     <v12:useMtom>false</v12:useMtom>
     <!--Zero or more repetitions:-->
     <!--v12:skipPath>?</v12:skipPath Modified-->
     <v12:options>
      <v12:sourceApplication>?</v12:sourceApplication>
     </v12:options>
     <v12:sessionID>sessionID</v12:sessionID>
   </v12:copyItem2>
  </soapenv:Body>
</soapenv:Envelope>

This gives you an output of the archived value in an encoded format such as below

<sawsoap:archive xsi:type="xsd:base64Binary">value</sawsoap:archive>

Use the same to the unarchive() and you can paste it to a different directory such as below.

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v12="urn://oracle.bi.webservices/v12">
  <soapenv:Header/>
  <soapenv:Body>
   <v12:unarchive>
     <v12:archive></v12:archive>
     <v12:replacePath>path_where_unarchive_should_happen</v12:replacePath>
     <v12:flagACL>false</v12:flagACL>
     <v12:flagOverwrite>false</v12:flagOverwrite>
     <v12:flagReplaceReferences>false</v12:flagReplaceReferences>
     <v12:sessionID></v12:sessionID>
   </v12:unarchive>
  </soapenv:Body>
</soapenv:Envelope>

Shrujal Patel

Thanks for your inputs @Madasamy-Oracle

Can you help elaborate significance of "sourceApplication" attribute in copyItem2 operation, I couldn't find any details about it in documentation.

If I ignore that attribute in copyItem2, I get same value in copyItem2Result.archive irrespective of path provided in request.

Madasamy -Oracle

sourceApplication -> I believe that its just a free text that could be added to distinguish where the SOAP call is originated from

Shrujal Patel

I have a report in Catalog in /shared/Custom/ABC Custom/Extensions/EXT_CICD_TEST_FLAT, this folder has DataModel file and a Report file.

No matter what path I give I get exact same response.

HostName: {{bip_host}}/analytics-ws/saw.dll?SoapImpl=webCatalogService and I am using urn://oracle.bi.webservices/v12 as well