OBIEE 11G - User has invalid GUID
977486Dec 2 2012 — edited Mar 7 2013Hello,
We moved our files recently to another environment with the same configuration. However, we are experiencing issues when authenticating users through our LDAP setup. Whenever an LDAP user logs in, we get the following error in logs:
Error Message From BI Security Service: User '<user>' has an invalid GUID value: 'null'
<user> is the username of the person logging in with an LDAP account. Logging in using weblogic or any user created using the DefaultAuthenticator works. As I mentioned before we're moving from a DEV to a UAT environment. I've verified that we have the exact same settings in both environments and logging in with users in DEV works perfectly.
I've attempted to refresh the GUIDs in the BI Server and the presentation services using the official oracle guide for refreshing GUIDs. However, this particular error still comes up. This also seems to be an issue with the BI Server as I've tried deleting the user directories from the presentation services, refreshing GUIDs and restarting to no effect. This is what is in the presentation service webcatupgrade0.log file:
+[2012-12-02T14:36:51.000-05:00] [OBIPS] [ERROR:32] [] [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.+
Error Message From BI Security Service: User 'vchavez' has an invalid GUID value: 'null' (HY000)
Is there a location in the BI service file system that I can manually clear out the GUID cache? Or any other suggestions for resolving this?
Thanks!
Edited by: 974483 on Dec 2, 2012 12:09 PM
Edited by: 974483 on Dec 2, 2012 12:10 PM