OBIEE 11g: Error: "[nQSError: 10018] Access for the requested connection is refused." when Using Bursting Delivery in BI Publisher (Doc ID 1599456.1)

Last updated on MARCH 10, 2023

Applies to:

Symptoms

You are using BI Publisher integrated with OBIEE 11g.  You have a BI Publisher report of a single simple SQL query, no parameters, no lists-of-values and one definition of bursting.  The bursting divides the report with a single key and 1:1 sends an email for each key . So if, for example, there are a hundred distinct keys , BI Publisher sends one hundred e-mails.

If you manually run this report, it is working correctly.  The XML data is correct and the Template is correct.

If you plan the report with the bursting, some of the sub-divisions go wrong.  You tried to decrease and increase the subdivisions but the problem is not systematic, because sometimes it fails with two sub-divisions, and sometimes with fifty. This problem only occurs when OBIEE has some connected users.  If you plan this report when OBIEE is not used, the job terminates correctly with success. But the query, the data and the template are the same.
You see the following error message:

Output failed.
[INSTANCE_ID=1346844207415] [SUBJOB_ID=8330]
Document generation failed
[INSTANCE_ID=1346844207415] [OUTPUT_ID=10387]BIEE: User: weblogic, message: nulljava.lang.RuntimeException: BIEE: User: weblogic, message: null
at oracle.xdo.service.report.saw.SawUtil.getTenantId(SawUtil.java:873)
at oracle.xdo.servlet.resources.StructuredSawMtomResourceProvider.getCatalogObjects(StructuredSawMtomResourceProvider.java:1030)
at oracle.xdo.servlet.resources.StructuredSawMtomResourceProvider._getResource(StructuredSawMtomResourceProvid

The sawlog.log file, contains the following error:

[2013-10-31T14:58:47.000+01:00] [OBIPS] [ERROR:16] [] [saw.soap.makesession] [ecid: 7a1d39a9491c6b05:-441ff226:141cae910e1:-8000-000000000000f0e3,1:32866:737] [tid: 17760] Invalid session ID
An error occurred during authentication. Try again later or contact your system administrator.
Odbc driver returned an error (SQLDriverConnectW).
State: 08004. Code: 10018. [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection is refused.
[nQSError: 43113] Message returned from OBIS.
[nQSError: 43023] Number of sessions exceeded the limit. (08004)[[
File:soapservicesimpl.cpp
Line:185
Location:
saw.soap.makesession
saw.soap.sessionrequesthandler
saw.SOAP
saw.httpserver.request.soaprequest
saw.rpc.server.responder
saw.rpc.server
saw.rpc.server.handleConnection
saw.rpc.server.dispatch
saw.threadpool
saw.threads
ecid: 7a1d39a9491c6b05:-441ff226:141cae910e1:-8000-000000000000f0e3,1:32866:737

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.