Error: 103: Unexpected Essbase error 1051293 Error: 1051293: Login fails due to invalid login credentials Error(1051223) Single Sign On function call [css_init] failed with error [CSS Error: CSS method invocation error: getInstance: Failed to get CSSSystem instance, please check SharedServices_Security_Client.log for more information

 

Essbase Server: test-hyp1.inc.com:9799 com.essbase.eas.essbase.defs.ServerCommands.Connect
Error: 103: Unexpected Essbase error 1051293
Error: 1051293: Login fails due to invalid login credentials 

Error(1051223)
Single Sign On function call [css_init] failed with error [CSS Error: CSS method invocation error: getInstance: Failed to get CSSSystem instance, please check SharedServices_Security_Client.log for more information

 This is a version of Essbase bundled with OBIEE.
 
 The security is managed by WebLogic
  
rather than Shared Services.
Essbase Server: test-hyp1.inc.com:9799com.essbase.eas.essbase.defs.ServerCommands.
Error: 103: Unexpected Essbase error 1051293
Error: 1051293: Login fails due to invalid login credentials 
This is a version of Essbase bundled with OBIEE.
 
  
The security is managed by WebLogic
 
 rather than Shared Services.
Ref - WebLogic Server throws java.lang.NumberFormatException: null from the Embedded LDAP (Doc ID 861633.1)
Issue – started due to space crunch 
Steps followed – to resolve the issue 
Stop the WebLogic server – 
[essbase@test-hyp1 ~]$ ./stop_obiee.sh
As per note#861633.1
[essbase@test-hyp1 conf]$ pwd
/Middleware/user_projects/domains/bifoundation_domain/servers/AdminServer/data/ldap/conf
[essbase@test-hyp1 conf]$ ls -ltr
total 4
-rw-r----- 1 essbase essbase 568 Jul  2  2016 vde.prop
-rw-r----- 1 essbase essbase   0 Jul  2  2016 mapping.cfg
-rw-r----- 1 essbase essbase   0 Sep 25 20:03 replicas.prop

[essbase@test-hyp1 conf]$ cp replicas.prop replicas.prop1012019
[essbase@test-hyp1 conf]$ vi replicas.prop

Alter the replicas.prop file and add 'replica.num=0' to it.


Verify the sec files under ESSBASE – these .sec file was copied from /test/essbase.sec09262019 (this file is fetched from 26th September 2019 backup file - test_INC_Essbase20190926.tgz).
[essbase@test-hyp1 bin]$ pwd
/Middleware/instances/instance1/Essbase/essbaseserver1/bin
-rw-r----- 1 essbase essbase  6834 Oct  1 11:20 essbase.sec
-rw-r----- 1 essbase essbase     0 Oct  1 11:35 essbase.lck
-rw-r----- 1 essbase essbase  6834 Oct  1 11:35 essbase_1569954951.bak
lrwxrwxrwx 1 essbase essbase    91 Oct  1 11:35 essbase.bak -> /Middleware/instances/instance1/Essbase/essbaseserver1/bin/essbase_1569954951.bak
Start the web logic – 
[essbase@test-hyp1 ~]$ ./start_obiee.sh

Verify the WebLogic server and EM consoles – 
opmnctl startall: starting opmn and all managed processes...
Processes in Instance: instance1
---------------------------------+--------------------+---------+---------
ias-component                    | process-type       |     pid | status
---------------------------------+--------------------+---------+---------
essbasestudio1                   | EssbaseStudio      |    8023 | Alive
essbaseserver1                   | Essbase            |    8024 | Alive
coreapplication_obiccs1          | OracleBIClusterCo~ |    8021 | Alive
coreapplication_obisch1          | OracleBIScheduler~ |    8022 | Alive
coreapplication_obijh1           | OracleBIJavaHostC~ |    8019 | Alive
coreapplication_obips1           | OracleBIPresentat~ |    8020 | Alive
coreapplication_obis1            | OracleBIServerCom~ |    8018 | Alive


Verify the ESSBASE login – command line to check 
[essbase@test-hyp1 bin]$ cd /Middleware/instances/instance1/Essbase/essbaseserver1/bin

[essbase@test-hyp1 bin]$ ./startESSCMD.sh
Essbase Command Mode Interface 64-bit - Release 11.1.2 (ESB11.1.2.3.004B031)
Copyright (c) 1991, 2014, Oracle and/or its affiliates. All rights reserved.
U.S. Patent Number 
U.S. Patent Number 


[Tue Oct  1 11:38:51 2019]Local////Warning(1040132)
Opening a wallet(/Middleware/instances/instance1/Essbase/essbaseserver1/bin/wallet) failed(28759)

[Tue Oct  1 11:38:51 2019]Local////Warning(1040156)
SSL initialization failed with error code [1040132].
:::[0]->login
Login:
Host Node >test-hyp1.inc.com
User >weblogic
Password >******** 
[Tue Oct  1 11:39:31 2019]Local////Info(1051034)
Logging in user [weblogic]

Available Application Database:
INC_EBS                       ==> FPA
INC_FPA                       ==> INC_FPA
INCFPAbk                      ==> INCFPAbk

test-hyp1.inc.com:::weblogic[1]->exit
Exit:

[Tue Oct  1 11:40:10 2019]test-hyp1.inc.com///weblogic/Info(1051037)
Logging out user [weblogic], active for 0 minutes
[essbase@test-hyp1 bin]$