Hi Antony. We used to see the stuck thread behaviour on a daily basis in our old 11g environment. This caused reports to run forever and blocked new users from logging in. Sometimes a restart of the Admin server would free up the stuck threads other times we had to restart the weblogic BI servers. BI publisher / Embedded…

There are use cases where we would like to Embed the application and if the base domains are the same this greatly simplifies the integration.

For those who get this issue. This is related to the SEQUENCE table being out of sync with the the XMLP_SCHED_JOB table. If you look at the SEQUENCE table you will see that there are 4 sequences which link back to 4 different tables * JOB_ID_SEQ - This is used to find the next JOB_ID for XMLP_SCHED_JOB table. *…