OBIEE 12c: Users Can Not Login After Migrating from OBIEE 11g To OBIEE 12c

(Doc ID 2362763.1)

Last updated on FEBRUARY 19, 2018

Applies to:

Business Intelligence Suite Enterprise Edition - Version 12.2.1.2.0 and later
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

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