OBIEE 11g: Error: "Account inconsistent - index file is missing" When Re-creating a Deleted User (Doc ID 1625080.1)

Last updated on MAY 28, 2015

Applies to:

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

Symptoms

You have deleted a BI Publisher user in LDAP.  You then recreated the user and added it to roles.  But you see the following warning message when you try to log in to BI Publisher as this user:

You are able to login to BI Publisher as xxxx user but don't get all the privileges.

The bipublisher.log file shows the following errors:

[2013-12-30T22:04:23.209-05:00] [bi_server1] [WARNING] [] [oracle.xdo] [tid: 83] [userId: ] [ecid: 527ee5935816da1b:37adebbb:1428b3154a7:-8000-0000000000118ab9,0] [APP: bipublisher#11.1.1] java.rmi.RemoteException: access denied for user to path /users/apex.; nested exception is: [[
javax.xml.ws.soap.SOAPFaultException: access denied for user to path /users/apex.
at oracle.xdo.service.report.saw.wrapper.v7.AbstractSawSessionService.getSessionEnvironment(AbstractSawSessionService.java:158)
at oracle.xdo.service.report.saw.wrapper.v7.SawSessionServiceImpl.getSessionEnvironment(SawSessionServiceImpl.java:128)
...
Caused by: javax.xml.ws.soap.SOAPFaultException: access denied for user to path /users/apex.
at com.siebel.analytics.web.jaxwsutils.DirectSoapCaller.invokeSoapMethod(DirectSoapCaller.java:222)
at com.siebel.analytics.web.jaxwsutils.SAWSOAPTcpConnector.invokeSoapMethod(SAWSOAPTcpConnector.java:77)

In the sawlog.log file, you see the following errors:

[2014-01-17T17:38:41.000-05:00] [OBIPS] [ERROR:10] [] [saw.security.validate.users] [ecid: ] [tid: ] Account inconsistent -- data file is missing. Index: apex, 1E442DADAE1F11E2BFA275A8258E375B, /system/security/users/614/apex. Data: , 0, /system/security/accountids/312/1e442dadae1f11e2bfa275a8258e375b. Home: , 0, /users/apex. [[
File:validatecatalog.cpp
Line:242
Location:
saw.security.validate.users
saw.security.securityimpl.initialize
saw.catalog.local.loadCatalog
saw.subsystems.catalogbootstrapper.loadcatalog
saw.webextensionbase.init
saw.sawserver
saw.sawserver.initializesawserver
saw.sawserver
ecid:  
]]

[2014-01-17T17:38:41.000-05:00] [OBIPS] [ERROR:10] [] [saw.security.validate.accountids] [ecid: ] [tid: ] Account inconsistent -- index file is missing. Index: apex, 0, /system/security/users/614/apex. Data: apex, 93C609406F2111E38F449585C4D7164F, /system/security/accountids/787/93c609406f2111e38f449585c4d7164f. Home: , 0, . [[
File:validatecatalog.cpp
Line:242
Location:
saw.security.validate.accountids
saw.security.securityimpl.initialize
saw.catalog.local.loadCatalog
saw.subsystems.catalogbootstrapper.loadcatalog
saw.webextensionbase.init
saw.sawserver
saw.sawserver.initializesawserver
saw.sawserver

[2014-01-06T21:23:52.000-05:00] [OBIPS] [ERROR:10] [] [saw.security.securityimpl.internaladdauthenticateduser] [ecid: da504707147c67aa:-59e74fc5:1436a7b95d8:-8000-0000000000000797,0:1:1] [tid: 9088] The GUID (93C609406F2111E38F449585C4D7164F) for user apex already exists in the catalog with username apex. The user and its home dir will be renamed now in the catalog.
This will not rename or update any home dir path references in reports or dashboards. Please use Catalog Manager for this operation.[[
File:securityimpl.cpp
Line:615
Location:
saw.security.securityimpl.internaladdauthenticateduser
saw.security.securityimpl.addauthenticatedusernonproxy
saw.securitysubsystem.authenticationutils.addauthenticatedusertocatalog
saw.securitysubsystem.checkauthentication.runimpl
saw.threadpool.asynclogon
saw.threads
ecid: da504707147c67aa:-59e74fc5:1436a7b95d8:-8000-0000000000000797,0:1:1
ThreadID: 9088
]]
[2014-01-06T21:23:52.000-05:00] [OBIPS] [TRACE:1] [] [saw.catalog.local.readObject] [ecid: da504707147c67aa:-59e74fc5:1436a7b95d8:-8000-0000000000000797,0:1:1] [tid: 9088] Path not found (/system/security/groups/614/apex)[[
File:localwebcatalog.cpp
Line:1255
Location:
saw.catalog.local.readObject
saw.security.securityimpl.internaladdauthenticateduser
saw.security.securityimpl.addauthenticatedusernonproxy
saw.securitysubsystem.authenticationutils.addauthenticatedusertocatalog
saw.securitysubsystem.checkauthentication.runimpl
saw.threadpool.asynclogon
saw.threads
ecid: da504707147c67aa:-59e74fc5:1436a7b95d8:-8000-0000000000000797,0:1:1
ThreadID: 9088
]]

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