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 JANUARY 30, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.5.0 BP3 and later
Business Intelligence Suite Enterprise Edition - Version 11.1.1.5.0 BP3 and later
Information in this document applies to any platform.

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

 

Cause

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