Error Loading Security Account Obiee
up Presentation Services (sawserver): Error loading security privilege /system/privs/catalog/ChangePermissionsPrivilege. A quick search on the forums threw up two posts suggesting a corrupted WebCat. Since I'd got this webcat fresh out of the box I was puzzled how it could be corrupted. I did a bit more tinkering (including nosying around in the sawserver log), before realising it was indeed corrupt, and that I was indeed a muppet. Here's what happened after copying EnterpriseBusinessAnalytics.zip to my (unix) Presentation Services box: $unzip EnterpriseBusinessAnalytics.zip Archive: EnterpriseBusinessAnalytics.zip creating: root/ creating: root/ creating: root/shared/ creating: root/shared/automotive/ creating: root/shared/automotive/prompts/ inflating: root/shared/automotive/prompts/gf_model+model+year+trim inflating: root/shared/automotive/prompts/gf_model+model+year+trim.atr inflating: root/shared/automotive/prompts.atr [...] [ lots of files here ] [...] inflating: root.atr $ls -l total 110494 -rw------- 1 user group 37655058 Oct 7 03:44 EnterpriseBusinessAnalytics.zip drwx------ 5 user group 1024 Sep 18 01:06 root -rw------- 1 user group 60 Dec 6 2006 root.atr Huh? What gives? Where's my EnterpriseBusinessAnalytics web cat folder? Well, quite obviously it's unpacked it without a parent directory name. That's easily solved: $mkdir EnterpriseBusinessAnalytics $mv root EnterpriseBusinessAnalytics Then I started up Presentation Services and got the error "Error loading security privilege /system/privs/catalog/ChangePermissionsPrivilege." If you can spot my snafu at this point the my only defence is that there was quite a lot of other gumf in the catalog folder, not just the files illustrated above😀 The solution Whilst I'd moved the root folder into my webcat folder, I'd neglected to move root.atr - in effect corrupting the web catalog. So simple, but so frustating! The solution in this case was to move root.atr into the webcat folder, alongside root. It's worth noting that this may not be the solution in all occurrences of this error, it depends on where the corruption has occurred. Footnote The silver lining being a good chance to poke around inside sawserver a bit more and discover gems like this in the logging: The Oracle BI Presentation Server is proudly running under user: TODO_implement_this It's nice that it takes pride in its work, although shame we never get to find out the user's name😉 Share this:Twitte
error while trying to copy reports using the catalog manager over a network share. This was caused by the fact that the catalog manager didn't have full control over the catalog folder (read,write,create and delete).Till Next Time Posted by John Minkjan at 8/13/2008 03:14:00 PM Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: ALL POSTS, CATALOG, ERROR, OBIEE Reactions: No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Sociable My Other 101 Blogs MDX101 multiple first day of week 1 year ago SSIS101 Script with OLE DB connections 3 years ago Oracle Warehouse Builder 101 OWB site with nice info https://rnm1978.wordpress.com/2009/11/17/resolved-sawserver-error-loading-security-privilege-systemprivscatalogchangepermissionsprivilege/ 4 years ago OMB+ 101 OMB+/OWB Revoke a privilege 4 years ago Oracle Endeca Onformation Discovery Welcome to OEID 101 4 years ago Qlik View 101 QV: Hierarchy 5 years ago Java 101 JAVA FileLineCount 5 years ago Weblogic Scripting Tool 101 WLST OBIEE Bounce BI server 5 years ago ODI Oracle Data Integrator EE ODI-26017 Running Loadplan 5 years ago Weblogic 101 Welcome to Weblogic 101 5 years ago OBIEE11g 101 OBIEE11g http://obiee101.blogspot.com/2008/08/obiee-error-saving-security-account.html Upgrade from 10g 6 years ago Show 5 Show All Extra Pages Intressting Links OBIEE How to get started (UPDATE 13-Aug-2011) OBIEE Let's Get Professional (UPDATE 07-aug-2011) OBIEE 1000 wishes OBIEE Other / Off Topic Questions OBIEE101 as PDF Blog Archive ► 2013 (3) ► March (1) ► January (2) ► 2012 (11) ► May (1) ► April (2) ► March (1) ► February (5) ► January (2) ► 2011 (97) ► December (5) ► October (9) ► September (19) ► August (20) ► July (12) ► June (2) ► May (7) ► April (11) ► March (4) ► February (4) ► January (4) ► 2010 (99) ► November (3) ► October (2) ► August (17) ► July (15) ► June (10) ► May (19) ► April (1) ► March (8) ► February (10) ► January (14) ► 2009 (120) ► December (2) ► October (2) ► September (10) ► August (8) ► July (18) ► June (11) ► May (9) ► April (20) ► March (11) ► February (11) ► January (18) ▼ 2008 (159) ► December (20) ► November (19) ► October (17) ► September (18) ▼ August (25) OBIEE Forcing OC4J_BI shutdown OBIEE Conditional X-axis graph OBIEE scripting user into the repository OBIEE Change the password OBIEE Conditional Hyperlink OBIEE Back One Page OBIEE I
'forgetAccounts' (also referenced Doc ID 1390497.1). The http://aditya-kaushal.blogspot.com/2014/05/obiee-111170-best-practice-to-remove.html following is a Windows example based on information from Dev: First run fmwhome\instances\instance1\bifoundation\OracleBIApplication\coreapplication\setup\bi-init.cmd' to initiate all required OBIEE session variables. To see the 'forgetAccounts' options, run the following 'runcat' command: fmwhome\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalogmanager>runcat -cmd forgetAccounts -help To remove userID 'Joe' and his home directory from the catalog: error loading runcat.cmd/runcat.sh -cmd forgetAccounts -username XXX -cleanup -online http://localhost:9704/analytics/saw.dll -credentials c:\oracle\catmancredentials.properties or runcat.cmd/runcat.sh -cmd forgetAccounts -username XXX -cleanup -offline /path/to/catalog This process deletes both the user records and the Users folder from the PS Catalog. Posted by AK at 7:50 AM 2 comments: Srinivasan VaradarajanNovember error loading security 18, 2014 at 11:30 PMHi Aditya, I am seeing some intermittent login failures when I access web catalog in BI Workspace after I scaled out my installation. I see the following error in the sawlog0.log:[2014-11-18T22:59:22.000-08:00] [OBIPS] [ERROR:10] [] [saw.security.securityimpl.internaladdauthenticateduser] [ecid: 0000Kb6qIraDScGpIwK6yf1KQl6n0002Rh,0:1:1] [tid: 2096605504] The GUID for user weblogic has changed. The new GUID is 2BECB5106EFA11E4BFCBF39A8A04F272, while the existing GUID in the catalog is 84F2509021BB11E2BF8417F2E2C60AFC. This would result in catalog access issues. If the environment has recently changed to a new security backend, please run UpdateGUIDs and try again.If the environment has not been changed, please refer to the Catalog Manager 'forgetAccounts' command to delete all trace of user weblogic (index, data and home folder).[[File:securityimpl.cppLine:768Location: saw.security.securityimpl.internaladdauthenticateduser saw.security.securityimpl.addauthenticatedusernonproxy saw.securitysubsystem.authenticationutils.addauthenticatedusertocatalog saw.securitysubsystem.checkauthentication.runimpl saw.threadpool.asynclogon saw.threads]][2014-11-18T22:59:22.000-08:00] [OBIPS] [ERROR:31] [] [saw.security.securityimpl.internaladdauthenticateduser] [ecid: 0000Kb6qIraDScGpIwK6yf1KQl6n0002Rh,0:1:1] [tid: 2096605504] Authentication Failure.[[File:securityimpl.cppLine:772Location: saw.security.securityimpl.internaladdauthenticateduser saw.security.securityimpl.adda