OBIEE 11g: Error: "[ERROR:31] [] [saw.subsystem.catalog.initialize.upgrade] [ecid: ] [tid: ] Failed while trying to update Account GUIDs" when Updating Account GUIDs (Doc ID 1559988.1)

Last updated on NOVEMBER 18, 2015

Applies to:

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

Symptoms

You are attempting to do a GUID refresh, following the instructions in section 3.8 - Refreshing User GUIDs - of the Oracle® Fusion Middleware Security Guide for Oracle Business Intelligence Enterprise Edition 11g Release 1.  But you get the following error:

[2013-06-02T23:39:36.000-07:00] [OBIPS] [ERROR:31] [] [saw.subsystem.catalog.initialize.upgrade] [ecid: ] [tid: ] Failed while trying to update Account GUIDs
Error occurred while collecting map of new GUIDs from back end
Error retrieving user/group data from Oracle BI Server's User Population API.
Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
[nQSError: 43113] Message returned from OBIS.
An error message was received from the BI Security Service: SecurityService::executeIdentity store provider error (HY000)
SQL Issued: {call NQSSearchIdentities('USERS','NAME=kkarakoulka ,kkouchnirenko,kmcbrien,ksenia,lho,lhoward,lindajferguson,lorelup,mlevine,mlin,moneil,pbrooks#1,pieink,pkolachoor,portal,pquigley,qlix_hs,randerson,reltherington,rkhoung,sbutler,scampbell,ssingh,tcheli_hqh,vchopkar')}[[

 

Changes

You have upgraded OBIEE from 11.1.1.6.0 to 11.1.1.7.0.

 

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