OBIEE 12c: Users Can Not Login After Migrating from OBIEE 11g To OBIEE 12c
(Doc ID 2362763.1)
Last updated on FEBRUARY 01, 2024
Applies to:
Business Intelligence Suite Enterprise Edition - Version 12.2.1.2.0 to 12.2.1.4.0 [Release 12c to 12g]Information in this document applies to any platform.
Symptoms
You have fresh installation of OBIEE 12.2.1.2 and then you migrate OBIEE from 11g to this 12c version by following below document
Fusion Middleware Migration Guide for Oracle Business Intelligence
2 Migrating from Oracle BI 11g to 12c
After your migration, you are not able to login analytics 12c,but able to login to console,em without any issue.
The following error is recorded in the latest saw log when you try to login:
[2018-02-19T07:15:38Z] [OBIPS] [ERROR:1] [] [saw.securitysubsystem.checkauthentication.runimpl] [ecid: ] [tid: 1232] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: ] Odbc driver returned an error (SQLDriverConnectW).[[
File:checkauthentication.cpp
Line:1595
Location:
saw.securitysubsystem.checkauthentication.runimpl
saw.threadpool.asynclogon
saw.threads
]]
[2018-02-19T07:15:40Z] [OBIPS] [ERROR:16] [] [saw.soap.makesession] [ecid: ] [tid: 5088] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: ] Authentication error. Invalid session ID or session expired (session ID ending with '')
An error occurred during authentication. Try again later or contact your system administrator.
Odbc driver returned an error (SQLDriverConnectW).[[
File:soapservicesimpl.cpp
Line:207
Location:
saw.soap.makesession
saw.soap.sessionrequesthandler
saw.SOAP
saw.httpserver.request.soaprequest
saw.rpc.server.responder
saw.rpc.server
saw.rpc.server.handleConnection
saw.rpc.server.dispatch
saw.threadpool.socketrpcserver
saw.threads
]]
Changes
Migrate OBIEE from 11g to 12c
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |