Oracle Communities

Oracle Analytics and AI

Child Item

SQL code runs fine in SplashBI SQL Connect tool but times out in Oracle BIP Data Model

Hi all - I have a SQL query that runs within a few seconds in my Splash BI (SQL Connect) query tool, however when I use this same code in the Oracle Data Model in BIP it runs for a long time and then eventually times out.

I am honestly stumped by this and would appreciate any insight as to why this is happening. I have attached the code for reference.

SQL_invoice_approver_termed.txt

Thanks in advance!

Find more posts tagged with

SQL

BI Publisher Data Models

Accepted answers

Mallikarjuna Kuppauru-Oracle

Hi @KDR

We have an SQL Query timeout for scheduled reports (seconds) ,refer below and we can't increase the limits you need to tune the query.

Processing Limits (Classic Pixel-Perfect Reports)

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acoci/what-sizing-options-are-available-you.html#GUID-7D6DB4EE-8DD5-44C5-9B6E-9FA847463A5F__TABLE7

Regards,

Arjun

All comments

Mallikarjuna Kuppauru-Oracle

Hi @KDR

We have an SQL Query timeout for scheduled reports (seconds) ,refer below and we can't increase the limits you need to tune the query.

Processing Limits (Classic Pixel-Perfect Reports)

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acoci/what-sizing-options-are-available-you.html#GUID-7D6DB4EE-8DD5-44C5-9B6E-9FA847463A5F__TABLE7

Regards,

Arjun

KDR

@Mallikarjuna Kuppauru-Oracle I appreciate the feedback, however I still am confused why an external (non-Oracle) tool can query the same data much quicker than the Oracle Data Model can?

I should clarify that this is our BIP within Oracle Fusion.

Mallikarjuna Kuppauru-Oracle

Hi @KDR

This is an Tool Limitation i.e how BIP has been designed. Look like your external tool don't have any timeout limitation.

You can apply some filters to reduce the running/execution time .

Regards,

Arjun