BI Publisher bursting issues in 12c

Adam Wickes

Hi all,

We have just upgraded from OBIEE 11g to 12c and noticed a huge increase in time spent while bursting.
For example, reports bursting to file location (on local server) increasing from 4 minutes to 40 minutes.
After turning on xdo.log, I have noticed the following lines:

[042320_094520283][][STATEMENT]  ======== BurstingDataprocessor.DataFileHandler.updateSubJob :: after update sub job properties: jobId=8048
[042320_094520283][][PROCEDURE]  == BurstingDataprocessor.DataFileHandler.insertSubJob :: end
[042320_094544799][oracle.xdo.servlet.security.BieeKeepAliveTimerTask][STATEMENT] Keep alive for obieeadmin, sessionID = [******gd572m1mmqcnqu4his1upphoaaqlc02hmn499dh4n5r]
[042320_094644800][oracle.xdo.servlet.security.BieeKeepAliveTimerTask][STATEMENT] Keep alive for obieeadmin, sessionID = [******gd572m1mmqcnqu4his1upphoaaqlc02hmn499dh4n5r]
[042320_094744801][oracle.xdo.servlet.security.BieeKeepAliveTimerTask][STATEMENT] Keep alive for obieeadmin, sessionID = [******gd572m1mmqcnqu4his1upphoaaqlc02hmn499dh4n5r]
[042320_094844802][oracle.xdo.servlet.security.BieeKeepAliveTimerTask][STATEMENT] Keep alive for obieeadmin, sessionID = [******gd572m1mmqcnqu4his1upphoaaqlc02hmn499dh4n5r]
[042320_094944804][oracle.xdo.servlet.security.BieeKeepAliveTimerTask][STATEMENT] Keep alive for obieeadmin, sessionID = [******gd572m1mmqcnqu4his1upphoaaqlc02hmn499dh4n5r]
[042320_095044805][oracle.xdo.servlet.security.BieeKeepAliveTimerTask][STATEMENT] Keep alive for obieeadmin, sessionID = [******gd572m1mmqcnqu4his1upphoaaqlc02hmn499dh4n5r]
[042320_095144806][oracle.xdo.servlet.security.BieeKeepAliveTimerTask][STATEMENT] Keep alive for obieeadmin, sessionID = [******gd572m1mmqcnqu4his1upphoaaqlc02hmn499dh4n5r]
[042320_095213729][][PROCEDURE]  == BurstingDataprocessor.DataFileHandler.insertSubJob :: begin
[042320_095213729][][STATEMENT]  ======== BurstingDataprocessor.DataFileHandler.insertSubJob :: after insert sub job: jobId=8049

These lines account for 7 minutes of the total time (in this case, it was 15 minutes total job) where the server is seemingly doing nothing?
During this time however, the CPU is working hard but nothing is being written to xdo.log except for the above.

Anyone have any ideas?

Thanks,
Adam

Joel

Hi @Adam Wickes

Probably best to post this in the BI Publisher (MOSC) forum

User_42NHB

Hi Team

I am also facing similar issue.

Thanks,

Mari