BIP Schedule triggers generate many BI sessions which stay open
Last updated on SEPTEMBER 28, 2016
Applies to:Business Intelligence Suite Enterprise Edition - Version 18.104.22.168.131017 and later
Information in this document applies to any platform.
BIP schedule triggers generate many bi sessions which do not close.
It increases up to available limit.
1. Using sample; in BIP Create a Data Model
2. Create an Event Trigger.
Type = Schedule
Language = SQL query
Data Source= Oracle BI EE
For the test case set up a sql query that always return 0 rows.
3. Create a BIP report and schedule it
Every 2 minutes
Start Date= set date
End date= set date
Define schedule trigger
Use Trigger checked
Retry limit = 1
Use data model specified in the request
Trigger = test_ET
the result is that the job execute every 2 minutes with status Skipped.
In OBIEE > admintool online > manage sessions you can see a new session
opened for the user BISystemUser every two minutes.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms