Oracle Communities

Oracle Analytics and AI

Child Item

Is is possible to invoke OIC (APP driven orchestration) from BIP report?

Arun Krishnan G S

Hi,

We have a requirement to invoke an OIC (APP driven orchestration) from an ESS job via BIP.

Please let me know if this is possible and anyone has achieved it.

Doc ID 2642375.1 says that Oracle doesn't support RESTful data sources.

I have tried this by following steps mentioned in this blog https://binarytechworld.com/blog/f/trigger-oic-using-custom-ess-job but it didnt work as all steps are not mentioned.

I have done below steps:

1. Created a new data source (Administration > Publisher > Manage Publisher > Data Sources > HTTP Connection) by entering the OIC instance url as the Server and the port. Username and password of a user having access to OIC instance was entered.

2. Created an OIC (APP driven orchestration) that returns status and message as response (xml schema sample file).

3. A BIP report data model with data set as 'HTTP (XMl Feed) was created.

Data source which was created in step 1 was selected as the Data Source.

OIC endpoint url after the port was entered as the URL Suffix.

Method was selected as POST. (Tried both GET and POST)

4. Received the error "HTTP Process error, no response returned" while trying to view the data.

5. OIC gets invoked but completed in error "Message processing failed with errors at Trigger GetData". (GetData was REST endpoint)

Thanks & Regards,

Arun

Find more posts tagged with

BIP

Integration

External Data Sources

Accepted answers

Elpi

@Mike Giffard Thanks! After I updated /ic/api/integration/v1/flows/rest to ic/api/integration/v1/flows/rest without the first forward slash it worked. We just upgraded to Gen3.

ravikiran goda-Oracle

Hi Suprit,

As per the documentation it supports only GET not the POST method

https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-admin/set-connection-http-data-source.html#TBIPA-GUID-C5F9A10D-1C1C-42B2-A64C-2E4DE05E45FB

BIP doesn't support HTTP POST method which doesn't return HTTP Status code 200. Here REST method responses with HTTP 202 Accepted status code

https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-design/create-dataset-http-xml-feed.html#GUID-005C3DE6-E60D-48F3-9A1D-E008C116F2D4

All comments

Mallikarjuna Kuppauru-Oracle

Hi @ Arun Krishnan G S

Below are the supported API calls .

REST API for Oracle Business Intelligence Publisher - All REST Endpoints

What is your BIP version? yes in older version its not supported.

Regards,

Arjun

Arun Krishnan G S

Thanks @Mallikarjuna Kuppauru-Oracle for your response.

My requirement was to invoke an OIC REST service from BIP report. But the link that you have shared has REST endpoints for creating/updating/deleting datamodel and templates for a BIP.

Ketan Prajapati

Hello @Arun Krishnan G S

https://docs.oracle.com/middleware/12212/bip/BIPDM/GUID-A8FAFEBA-E733-4AEA-A1D3-00AA4F1B4F40.htm#BIPDM195

Try the above link might it help to you. specific the complex scenarios.

User_6IJHY

@Arun Krishnan G S : In your step 3 use "Webservice" instead of 'HTTP (XMl Feed)

Lokesh_Gadde

Hi @Arun Krishnan G S ,

I was previously worked on this same type of requirement that time it able to trigger OIC through BIP, but now I'm also still facing issue "HTTP Process error, no response returned" . Did you get any resolution on this.

Regards,
Lokesh Gadde,

Mike Giffard

@Lokesh_Gadde I have found that since going to OIC GEN3 - the URL Suffix requires no preceding forward slash.

Hima_V

Hi @Mike Giffard / @Arun Krishnan G S

Im also trying to invoke OIC integration from BIP, its throwing exception as HTTP Process error, no response returned.

Can you please let me know what are the steps to resolve this issue

Pradeep Moganti

@Hima_V

Provide following screenshots

(1) HTTP Data Source Configuration

(2) DataModel Configuration

We can review and provide suggestions based on that.

Pradeep Moganti

@Hima_V

In most of the cases this could happen due to OIC access issue.

Please try to get View Engine Log from the BIP report Data Model and see if you can find any logs similar

[2024-10-18T17:23:31.312+00:00][dp id:996522795][sch info:]HTTPHandler.execute().response.getStatusCode():401 [2024-10-18T17:23:31.312+00:00][dp id:996522795][sch info:]HTTP response status code: 401 [2024-10-18T17:23:31.312+00:00][dp id:996522795][sch info:]HTTP Process Error: Unauthorized [2024-10-18T17:23:31.312+00:00][dp id:996522795][sch info:]oracle.xdo.dataengine.datasource.plugin.DataAccessException: HTTP Process error, no response returned at oracle.xdo.dataengine.diagnostic.ExceptionHandler.createExceptionMsg(ExceptionHandler.java:202) at oracle.xdo.dataengine.diagnostic.ExceptionHandler.createException(ExceptionHandler.java:210) at oracle.xdo.dataengine.datasource.http.HTTPHandler.execute(HTTPHandler.java:204) at oracle.xdo.dataengine.datasource.XMLStatement.executeHTTP(XMLStatement.java:251) at oracle.xdo.dataengine.datasource.ThreadExecutor.process(ThreadExecutor.java:92) at oracle.xdo.dataengine.datasource.ThreadExecutor.run(ThreadExecutor.java:62)

shrikardixit

Hello Pradeep,

The BIP Report which invokes OIC endpoint was working until recently. The report has stopped working since October 1st with the below error:

HTTPHandler.execute().response.getStatusCode():401

Is there a way to resolve this issue?

Thanks,

Shrikar Dixit