BI Publisher Bursting issues in 12c

Adam Wickes

Summary

BI Publisher Bursting issues in 12c

Content

Hi all, 

First time posting here so hopefully this is in the correct spot.
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

Version

OBIEE 12c