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 and later
Information in this document applies to any platform.


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
SecurityService::populateBIUserFromUserProfileUser usernamexxx has invalid guid usernamexxx777777    


 Tested in, 6.8 &


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