About Me

Anjum Ara I am a technology enthusiast, an ardent reader. My latest interest is virtualization. In my free time, I love understanding child nutrition, child holistic development. I bake, read, paint, and do whatever it takes to improve myself every day.

Saturday, October 19, 2013

Re-configure Essbase

If you have tried re-configuring Essbase you would notice that it is not able to connect to Shared Service anymore. Authentication error is thrown every time you connect to Essbase from different clients.

Reason: The reason is Essbase is not able to connect with Shared Services. It is unable to create "EssbaseCluster-1" Application group and neither add new application to it as it already exists.
Following error is seen in Essbase_ODL.log files

Failed to create Essbase project [EssbaseCluster-1] at Shared Services with Error [Application group already exist.]
[2013-10-18T05:48:09.953-05:00] [ESSBASE0] [WARNING:1] [AGENT-6822] [] [ecid: 138209328157,0] [tid: 4140] Failed to migrate Essbase to HSS security mode during startup. Check SharedServices_Security_client.log. May need to remove essbase.sec and any of the newly migrated Essbase applications from HSS, then rerun configuration tool.
[2013-10-18T05:48:09.953-05:00] [ESSBASE0] [NOTIFICATION:16] [AGENT-6800] [] [ecid: 138209328157,0] [tid: 4140] Validation of back up file [D:\Oracle\Middleware\user_projects\epmsystem1\EssbaseServer\essbaseserver1\bin\ESSBASETS_1382093289.BAK] completed with status 0
[2013-10-18T05:48:30.96-05:00] [ESSBASE0] [NOTIFICATION:16] [TCP-59] [] [ecid: 138209328157,0] [tid: 3028] Connected from [2002:adcc:7c91::adcc:7c91]


Solution
1. Delete the EssbaseCluster-1 from the application group in shared service.
2. Re configure Essbase (If you already have ignore)
3. Go to this location D:\Oracle\Middleware\user_projects\epmsystem1\EssbaseServer\essbaseserver1\bin (appropriately)
4. Cut the files like Essbase.SEC, ESSBASE.BAK_postUPM, ESSBASE.BAK_preUPM and paste it in some other location
5. Restart Essbase
6. It automatically creates and connects to Shared Service.

Share:

2 comments:

Unknown said...

wont the above approach remove all the sec and will provide sec for only sample applications that come by default with installation??

thanks

Anjum Ara said...

Yes. In my case it was a internal server so we did not have much security setup. Moreover one more thing is that it even removed subsitution variables. The developers were after me with this but I had a backup of it and we just restored it. It worked fine.
Even security import should not be much of an ordeal. Isn't it?