Refreshing GUIDs Doesn't Work After Upgrading to OBIEE 11.1.1.7.1

(Doc ID 1579546.1)

Last updated on FEBRUARY 23, 2015

Applies to:

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

Symptoms

After upgrading from OBIEE 11.1.1.6.x to 11.1.1.7.1, you receive the following message after attempting to sync/refresh the GUIDs:

[nQSError: 43146] FMW_UPDATE_ROLE_AND_USER_REF_GUIDS inside NQSConfig.INI is set to Yes but the server failed to connect to BI Security Service.

 

The nqserver.log shows the following errors:

[2013-08-21T09:18:21.000-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 004t7K1uL_hCGv85zjDCiW0001Zr000025,0] [tid: 4893b940]  [14056] Finished loading subject area: Oracle Warehouse ETL.
[2013-08-21T09:18:21.000-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 004t7K1trdDCGv85zjDCiW0001Zr000021,0] [tid: 4883a940]  [14056] Finished loading subject area: FEAST.
[2013-08-21T09:18:21.000-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 004t7K1uOZUCGv85zjDCiW0001Zr000026,0] [tid: 48739940]  [14056] Finished loading subject area: FEAST Planning.
[2013-08-21T09:18:23.000-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 004t7K1trT5CGv85zjDCiW0001Zr00001v,0] [tid: 48638940]  [14056] Finished loading subject area: Core.
[2013-08-21T09:18:23.000-04:00] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 5732dce0]  [47038] Warning: The total number of server connections to backend data sources is currently 1058 and exceeds the recommended limit of 800.
[2013-08-21T09:18:23.000-04:00] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 5732dce0]  [47045] NQSConfig.INI warning: The value of MAX_EXPANDED_SUBQUERY_PREDICATES is currently 50000 and exceeds the recommended limit of 16384.
[2013-08-21T09:18:23.000-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 004t7K21qEhCGv85zjDCiW0001Zr00002C,0] [tid: 414a6940]  [16020] Metadata Database Type: Oracle Exadata [[
Data Source Name: smam
Data Source Type: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64b
]]
[2013-08-21T09:18:23.000-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 004t7K22O8zCGv85zjDCiW0001Zr00002F,0] [tid: 4580a940]  [16020] Metadata Database Type: Oracle 11g [[
Data Source Name: festest.na.jmsmucker.com
Data Source Type: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64b
]]
[2013-08-21T09:18:31.000-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 5732dce0]  [85003] MDX Member Name Cache subsystem started successfully.
[2013-08-21T09:18:31.000-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 5732dce0]  [85004] MDX Member Name Cache subsystem recovered entries: 0, size: 0 bytes.
[2013-08-21T09:18:31.000-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 5732dce0] An error message was received from the BI Security Service: [nQSError: 46164] HTTP Server returned 404 (Not Found) for URL .
[2013-08-21T09:18:31.000-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 5732dce0]  [13026] Error in getting roles from BI Security Service:  'An error message was received from the BI Security Service: [nQSError: 46164] HTTP Server returned 404 (Not Found) for URL .'
[2013-08-21T09:18:31.000-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 5732dce0]  [85008] MDX Member Name Cache subsystem statistics - Entries: 0, Sizes: 0 bytes, Overall Queries: 0, Hits: 0(0%), Misses: 0(0%).
[2013-08-21T09:18:31.000-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 5732dce0]  [85007] MDX Member Name Cache subsystem stopped.
[2013-08-21T09:18:34.000-04:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 5732dce0]  [14058] Unloaded all subject areas.
[2013-08-21T09:18:34.000-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 5732dce0]  [nQSError: 43146] FMW_UPDATE_ROLE_AND_USER_REF_GUIDS inside NQSConfig.INI is set to Yes but the server failed to connect to BI Security Service.
[2013-08-21T09:18:34.000-04:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 5732dce0] Server start up failed: [nQSError: 43146] FMW_UPDATE_ROLE_AND_USER_REF_GUIDS inside NQSConfig.INI is set to Yes but the server failed to connect to BI Security Service.

 

The following steps were performed to refresh the GUIDs:

1. Stop obiee services (opmnctl stopall)

2. Edit the presentation server instanceconfig.xml with the following and put it inside the catalog tag:

               <UpdateAccountGUIDs>UpdateAndExit</UpdateAccountGUIDs>

3. Edit the obiee server NQSconfig.INI file with the following:

              FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES;

4. Start OBIEE services (opmnctl startall)

5. Wait until presentation services are listed as down (opmnctl status)

6. Stop OBIEE services (opmnctl stopall)

7. Edit presentation server instanceconfig.xml with the following:
           <UpdateAccountGUIDs>none</UpdateAccountGUIDs>

8. Edit OBIEE server NQSconfig.INI file with the following:
         FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = NO;

9. Start OBIEE services (opmnctl startall)

10. Verify OBIEE services are up (opmnctl status)

Changes

Upgraded OBIEE from previous release to OBIEE 11.1.1.7.1 and performed the procedures listed above for refreshing GUIDs.

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