My Oracle Support Banner

OBIEE 11g: Error While Generating Reports (Doc ID 2244238.1)

Last updated on AUGUST 20, 2018

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.9.0 to 12.2.1.2.0 [Release 11g to 12c]
Information in this document applies to any platform.

Symptoms

On : Oracle Business Intelligence Enterprise Edition

Error while generating reports in OBIEE 11g

The error message displayed while accessing reports/Answers tab.Some users are able to access while some are facing the issue with the same browsers.

 saw.log
======

[2017-01-26T12:03:14.000+01:00] [OBIPS] [WARNING:16] [] [saw.security.userpopulationmanagerimpl.searchidentities] [ecid: b048f00b8c27c1a0:2d85d8c:159d1db36e3:-8000-000000000000de85,0:1:1] [tid: 4180] NAME XX IT Area Manager for Account Type Catalog Groups not found in cache or backend, marking as unknown[[

File:userpopulationmanagerimpl.cpp 
Line:1012 
Location: 
saw.security.userpopulationmanagerimpl.searchidentities 
saw.security.userpopulationmanagerimpl.getmultipleaccountdetails 
saw.securitysubsystem.authenticationutils.addauthenticatedusertocatalog 
saw.securitysubsystem.checkauthentication.runimpl 

Sometimes below error will also be noted in the Saw.log:

"Error loading XML Document from saw.dll/answers/saw.selections.xml?fmapId=S95f4Q"

bi_server1-diagnostic.log               
===============                  
Caused by: weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool mds-owsm is Suspended, cannot allocate resources to applications.. 
at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:251)


This is happening after upgrading the version of IIS from 7.0 to 7.5.

OBIEE version:- 11.1.1.9.0
OS version:- 2008 R2

New Web server details:-
IIS:- 7.5
OS version:- 2008 R2

Old web server details:-
IIS 7.0
OS Version :- 2008

Changes

Issues occurs after upgrading the version of IIS from 7.0 to 7.5.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.