OBIEE Error: '[nQSError: 43146] FMW_UPDATE_ROLE_AND_USER_REF_GUIDS inside NQSConfig.INI is set to Yes but the server failed to connect to BI"; Therefore Cannot Start Presentation Service After Setting FMW_UPDATE_ROLE_AND_USER_REF_GUIDS To YES (Doc ID 1628272.1)

Last updated on JULY 18, 2017

Applies to:

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

Symptoms

A new development environment has been created for OBIEE version 11.1.1.7.131017.

User is attempting to migrate the rpd, webcat and system-jazn-data.xml from their production environment which is at version 11.1.1.6.11.

When user tries to regenerate the GUIDs, the following happens:

[2014-02-17T10:51:13.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: ec21d720] [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.^M
[2014-02-17T10:51:13.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: ec21d720] 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.^M
and the presentation service does not start (or generate new GUIDs) plus the BI server service shuts down too.

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