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

Last updated on SEPTEMBER 19, 2019

Applies to:

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/jdoe.; nested exception is: [[
javax.xml.ws.soap.SOAPFaultException: access denied for user to path /users/jdoe.
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/jdoe.
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: jdoe, 1E442DADAE1F11E2BFA275A8258E375B, /system/security/users/614/jdoe. Data: , 0, /system/security/accountids/312/1e442dadae1f11e2bfa275a8258e375b. Home: , 0, /users/jdoe. [[
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: jdoe, 0, /system/security/users/614/jdoe. Data: jdoe, 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 jdoe already exists in the catalog with username jdoe. 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/jdoe)[[
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

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