OBIEE 11g External Table SQL Authentication Fails With Error: populateBIUserFromUserProfileUser 'username' Has Invalid GUID 'username'- Invalid Username Password (Doc ID 1550540.1)

Last updated on SEPTEMBER 04, 2015

Applies to:

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

Symptoms

Configuring external table authentication by following Oracle Documentation and encountering the following errors:

[2013-04-05T16:39:08.000+05:30] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 1efc6b4dd2a0eee4:7658dce7:13dd9de800b:-8000-0000000000000053] [tid: 285c] 
SecurityService::populateBIUserFromUserProfileUser usernamexxx has invalid guid usernamexxx [2013-04-05T16:39:08.000+05:30] [OracleBIServerComponent] 
[ERROR:1] [] [] [ecid: 1efc6b4dd2a0eee4:7658dce7:13dd9de800b:-8000-0000000000000053] [tid: 285c] [nQSError: 43126] Authentication failed: invalid user/password.

 

 

There are errors like the following reported in managed server log file

oracle.bi.security.service.InvalidUserGUIDException:
SecurityService::populateBIUserFromUserProfileUser usernamexxx has invalid guid usernamexxx777777    
 at
oracle.bi.security.service.SecurityServiceUtil.populateBIUserFromUserProfile(SecurityServiceUtil.java:647)

Changes

 Tested in 11.1.1.6.4, 6.8 & 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