OBIEE 11g: Error: "[nQSError: 10018] Access for the requested connection is refused." when Using Bursting Delivery in BI Publisher
Last updated on JANUARY 30, 2017
Applies to:Business Intelligence Server Enterprise Edition - Version 22.214.171.124.0 BP3 and later
Business Intelligence Suite Enterprise Edition - Version 126.96.36.199.0 BP3 and later
Information in this document applies to any platform.
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:
Document generation failed
[INSTANCE_ID=1346844207415] [OUTPUT_ID=10387]BIEE: User: weblogic, message: nulljava.lang.RuntimeException: BIEE: User: weblogic, message: null
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)[[
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