OBIEE 11g User Interface (UI) Performance Is Extremely Slow With Internet Explorer 8


Bienvenue… Mes amis ..@ Welcome back …

…./// was struggling for last couple of weeks with OBIEE 11g (11.1.1.5) and IE 8 . The experience was awesome !! pathetic …  it is extremely slow starting from login page and browsing across reports/changing the reports views/layouts and while play with overall application ad-hoc basis.

The situation has been observed not for desktop/laptop standalone application users(at-least I don’t have issue in my personal desktop)  but for VPN or WAN users over the network 😦 😦

Initial assumption was that it is due to OBIEE 11g with its lot of junkies (animations ,flash plugin and special chart rendering engine etc..) .I thought it could be a database problem as for my case database was also not pretty strong. So overall performance issue could be for new OBIEE 11g. It was so irritating to develop a reports there which can pretty easily frustrating a developers . Even the console and EM window and other navigation options was pretty slow.

Later while install Mozilla Firefox we can see a significant performance improvement and the application is running cool like a charm !! So the main culprit for entire problem is the favorite “IE 8” browser !!  (Nowadays I didn’t even open my IE until a very specific needs) . So I switch to different browser at-least to make sure I didn’t spend my 20 minutes of time just for build a reports….huh… A shy of relief after spending my last painful weeks …

Now what is the reason behind IE 8 slowness while interacting via web server to OBIEE engine . There is no fighting game between two killer giants “Microsoft” and “Oracle”  , I believe… 🙂

As per Oracle “IE 8 generates many HTTP 304 return calls and this caused the 11g(11.1.1.3 and later) UI slower when compared to the Mozilla FireFox browser.”

Hmmm … so HTTP 304 error caused when the poor developer doesn’t respect the HTTP protocols completely … not bad … 🙂

So what is this HTTP 304 …let’s have a look ..

HTTP 304 doesn’t really indicate an error, but rather indicates that the resource for the requested URL has not changed since last accessed or cached. The 304 status code should only be returned if allowed by the client . The client specifies this in the HTTP data stream sent to the Web server e.g. via If_Modified_Since headers in the request.

Systems that cache or index Web resources (such as search engines) often use the 304 response to determine if the information they previously gathered for a particular URL is now out-of-date.

+++++++++++++++

§  304 errors in the HTTP cycle

Any client (e.g. your Web browser or our CheckUpDown robot) goes through the following cycle when it communicates with the Web server:

  • Obtain an IP address from the IP name of the site (the site URL without the leading ‘http://’). This lookup (conversion of IP name to IP address) is provided by domain name servers (DNSs).
  • Open an IP socket connection to that IP address.
  • Write an HTTP data stream through that socket.
  • Receive an HTTP data stream back from the Web server in response. This data stream contains status codes whose values are determined by the HTTP protocol. Parse this data stream for status codes and other useful information.

This error occurs in the final step above when the client receives an HTTP status code that it recognises as ‘304’.

§  Fixing HTTP 304 errors – General

You should never see this error in your Web browser. It should simply present the Web page from its cache – because it believes the page has not changed since it was last cached. If your client is not a Web browser, then it should equally be able to present the page from a cache. If unable to do so, it is not using the If_Modified_Since or related headers correctly.

§  Fixing HTTP 304 errors

You should never see this error at all for the CheckUpDown service. It indicates defective programming by us or the developers of the Web server software. Either we or they are not respecting HTTP protocols completely.

The 304 status code should only be returned if we allow it in the HTTP data stream we send to the Web server. Because we keep no records of the actual content of your URL Web page, we specifically disallow the 304 response in the HTTP data stream we send.

So if the Web server implements the HTTP protocol properly, it should never send an 304 status code back to us. This response is not what we expect, so we actively report it as an error even though it does not necessarily mean that the Web site is down.

Please contact us directly (email preferred) whenever you encounter 304 errors. Only we can resolve them for you. Unfortunately this may take some time, because we have to analyse the underlying HTTP data streams and may have to liaise with your ISP and the vendor of the Web server software to agree the exact source of the error.

++++++++++++++++

So enough fade up with HTTP 304… lets see how Oracle proposed to resolve the problem using “HTTP compression and caching” technique.

Why use Web Server Compression / Caching for OBIEE?

o       Bandwidth Savings: Enabling HTTP compression can have a dramatic improvement on the latency of responses. By compressing static files and dynamic application responses, it will significantly reduce the remote (high latency) user response time.

o       Improves request/response latency: Caching makes it possible to suppress the payload of the HTTP reply using the 304 status code.  Minimizing round trips over the Web to re-validate cached items can make a huge difference in browser page load times.

This screen shot depicts the flow and where the compression and decompression occurs.

The Solution:

1.      To implement HTTP compression / caching, install and configure Oracle HTTP Server (OHS) 11.1.1.x for the bi_serverN Managed Servers (refer to “OBIEE Enterprise Deployment Guide for Oracle Business Intelligence” document for details).

2.      On the OHS machine, open the file HTTP Server configuration file (httpd.conf) for editing.

This file is located in the OHS installation directory.
For example: ORACLE_HOME/Oracle_WT1/instances/instance1/config/OHS/ohs1

3.      In httpd.conf file, verify that the following directives are included and not commented out:

LoadModule expires_module “${ORACLE_HOME}/ohs/modules/mod_expires.so

LoadModule deflate_module “${ORACLE_HOME}/ohs/modules/mod_deflate.so

4.      Add the following lines in httpd.conf file below the directive LoadModule section and restart the OHS:

Note: For the Windows platform, you will need to enclose any paths in double quotes (“)

For example:

Alias /analytics “/ORACLE_HOME/bifoundation/web/app”

<Directory “/ORACLE_HOME/bifoundation/web/app”>

Alias /analytics ORACLE_HOME/bifoundation/web/app

#Pls replace the ORACLE_HOME with your actual BI ORACLE_HOME path
bifoundation/web/app>
#We don’t generate proper cross server ETags so disable them
FileETag none
SetOutputFilter DEFLATE
# Don’t compress images
SetEnvIfNoCase Request_URI \.(?:gif|jpe?g|png)$ no-gzip dont-vary
<FilesMatch “\.(gif|jpeg|png|js|x-javascript|javascript|css)$”>
#Enable future expiry of static files
ExpiresActive on
ExpiresDefault “access plus 1 week”
#1 week, this will stops the HTTP304 calls i.e. generated by IE 8
Header set Cache-Control “max-age=604800”
</FilesMatch>
DirectoryIndex default.jsp
</Directory>

#Restrict access to WEB-INF
<Location /analytics/WEB-INF>
Order Allow,Deny
Deny from all
</Location>

Note: Make sure you replace above placeholder “ORACLE_HOME” to your correct path for BI ORACLE_HOME. For example: my BI Oracle Home path is /Oracle/BIEE11g/Oracle_BI1/bifoundation/web/app

 Important Notes:

  • Above caching rules restricted to static files found inside the /analytics directory(/web/app).
  • This approach is safer instead of setting static file caching globally.
  • In some customer environments you may not get 100% performance gains in IE 8.0 browser. So in that case you need to extend caching rules to other directories with static files content.
  • If OHS is installed on separate dedicated machine, make sure static files in your BI ORACLE_HOME (../Oracle_BI1/bifoundation/web/app) is accessible to the OHS instance.

Summary

The following screen shot summarizes the before and after results and improvements in response times(in IE7 and IE8) after enabling compression and caching: 

So now get the enthusiasm back and play with OBIEE 11g … 😀

But as per my observation till now, OBIEE 11g is still pretty slow specially in developers mode when you are editing some views in compound layouts,playing with measures and switch across columns across different sections ! It is still not best bet in regard of performance and response time … !

The portion of the above information of the has been actually except  from Oracle Support ID (1312299.1) .

In the upcoming thread I will explain a loads of  OBIEE 11g related bug/issues and unpredictable behavior and couple of non-working and missing treasures …..

Stay tuned until then …..

Yours (:))> DxP

Working in OBIEE 10g/11g with Multidimensional OLAP Cube


Time to move into new topic always 🙂 ….a new BI era with OBIEE11g and again with Oracle’s so called emerging OLAP Cube  technology.My personal experience using OBIE11g  is pretty slow. Couple of the reasons have been already reported under Oracle Support web which will be put together later but just sharing my last report execution time comparing two version OBIEE 10g and OBIEE 11g  accessing the same database cube .

Below snapshot represent the difference of the execution timings for couple of my reports below (while fetching the cube data using OBIEE11g/10g) and it is substantial indeed !

My application server environment like below:

  • Oracle Database (11.2.0.1) with OLAP option pack
  • Oracle OLAP 11g- Analytic Workspace Manager 11.2.0.2.0A
  • OBIEE Repository OBIEE 11.1.1.5  
  • OBIEE Plug-in 11.2.0.2.0A – Revision 1
  • OS – Windows 2003 Enterprise Server 64 bit (Dedicated Virtual Env)
  • Intel Xeon CPU 2.67 Ghz, 8 GB RAM , 200GB HDD

Only thing that is different is that my Database environment hosted into a 32 bit Windows 2003 R2 platform and OBIEE 10g was in that same box but 11g in different box .But that doesn’t and shouldn’t make the huge difference !

Also my overall experience with OBIEE 11g and general opinion derived is that it is pretty slow.

What I can say now … Come on OBIEE 11g … Come on Oracle ..! Lets hope for the best !@

What is Web Analytics – The Benefit and Usefulness


Well …. ◊Web Analytics ◊ is an emerging strategic webtrend concept . Below information will detail out actual goals , enterprise wide benefits, key challenges of the implementation and the available modern technologies/tools to achieve the digital marketing objectives from technical implementation perspectives.

♦ What is Web Analytics

Web analytics is the practice of measuring, collecting, analyzing and reporting on Internet data for the purposes of understanding how a web site is used by its audience and how to optimize its usage.It is a kind of study of visitor, navigation and traffic patterns to determine the success of a hosted business sites just looking after the Web trends.

Kind of an analyses as below:

♦ Typical Example

A worldwide tour company customize the planning and booking of the travel based on customers interest.The key business challenges and the ultimate goald is to

  • Measure the effectiveness of search engine submission to determine which one generates more traffic
  • Increase the return visit to sites
  • Gain the understanding what converts the visitors to customers
  • Increase the newsletter recipient base
  • Provide a dynamically generated reports

♦ Key functional areas / Benefit and Usefulness

The key benefits are high marketing return on investment (ROI) as the business focus shifts on reality check and periodic review of the expectations.So final goal is the examination of bottom line of business using Key Performance Indications (KPI) measures.

  • Provide in-depth analysis and comparison of visitor data, referral data
  • Calculate the amount of traffic to evaluate bandwidth usages and server capabilities
  • Site navigation patterns can evaluate the usage and interests

I)  Technical Insights

Gathering the technical statistics is important to understand the website traffic, effectiveness of the same in respect of business performance and analyses them using web analytics solution for decision making.

1        Understanding SEO (Search Engine Optimization)

This is very important for the business to capture outbound web activities for below:

  • Top Search Phrases/Content groups
  • Top Search Engines
  • Top Referrers

2        Effective Navigation

The key area is to determine the activities performed in the hosted sites to leverage path analysis for effective optimization.

  • Top most visited contents
  • Content suitable for Homepage
  • Top most navigation paths
  • Top destination paths
  • Top exist/drop-off pages
  • Capture dynamic page errors or unwanted events
  • Fail over/Load balancing event counts

3        Supporting business objectives

This required determining the triggered page events and the outcome for the business benefits.This is to understand if you are successfully converting visitors to your desired actions

  • Capture On-click qualified visits
  • Count on desired actions on Post-click events
  • Qualified visitors conversion ratio (Qualified Visits / Total Visits)
  • Capture event on Physical object of interest
  • Change in activities with change in hosted sites

II)  Technical Details about popular techniques

Data collection is important to perform and procceed with the correct analysis and making any business decisions. The various tools that perform this analysis use below sources to complete the analysis after investigation

1        Analyse Data Sources

  • Server Logs (Hit analysis)
  • Browser tags
  • Cookie analysis
  • Visitor’s Data
  • Search Engine Data
  • Defined Conversion Funnels
  • Arriving method
  • Form Completion
  • Geographical Trending
  • Rankings
  • Sessions
  • Page views
  • Active Page stay Duration
  • Affinity and Banner
  • Market influence
  • Top search phrases/words
  • Low hit search phrases
  • Context
  • Errors
  • Completions
  • View only
  • Successful/unsuccessful attempts

2        Visitor Segmentation

3        Content Usage

4        Search Analytics

5        Web-forms and conversion

6        Navigational and Page effectiveness

7        Email metrics and optimisation

III) Key Market Challenges

1        Scalability

As data volumes increase, business analysts are becoming overwhelmed trying to understand how it all maps together.

2        Insight-to-Effort ratio

Enterprises are challenged that high-end solutions require so much effort. At the same time, entry-level solutions typically offer little in-depth reporting.

3        Technology Alignment

Technology is only part of the solution.However organizations must coordinate across departmental boundaries to be successful at utilizing web analytics.

4        Metrics Details

Key highlight on metrics like Hit , Page View, Session , Unique Visitors , Repeat Visitors , Bounce Rate, %Exit , Session Duration , Click etc .

IV)  Ultimate Goal

The post monitoring activities after looking the Web Trend will be classification of business areas and take necessary actions to focus on problem areas while optimising the results.

See you next time ….  Stay tuned @!

Lets think different … Do different …


Time to have some change as the change is the only constant …. I was thinking of to put something on the emerging topics on Analytic’s space …. No BI  analytic’s now and it’s only “Web”. 🙂 See how this can be think of :

So this is what I am going to cover for next couple of days ….  Stay tuned !!!

Yours … DxP

BEA-090892-The loading of OPSS java security policy provider failed due to exception


¡Hola Tous Les ,

Welcome back after long days…. and again starts with problem !! Yes one of my fellow co-worker installed OBIEE 11g  new release (11.1.1.5)  in a Windows Virtual Machine setup with his own credentials and once he logs out Weblogic server died .

When I logged in using my profile credentials to VM and trigger the Weblogic start-up, it throws me below errors in BI Weblogic server startup command line window:

<BEA-000365> <Server state changed to FAILED>

<BEA-000383> <A critical service failed. The server will shut itself down>

<BEA-000365> <Server state changed to FORCE_SHUTTING_DOWN>

So I jump into the AdminServer.log file located at below path an

..\OracleBI\user_projects\domains\bifoundation_domain\servers\AdminServer\logs

++++++++++++++

EDT><<WLS Kernel>> <> <> <1315383733801>

weblogic.security.SecurityInitializationException: The loading of OPSS java security policy provider failed due to exception, see the exception stack trace or the server log file for root cause. If still see no obvious cause, enable the debug flag -Djava.security.debug=jpspolicy to get more information. Error message: oracle.security.jps.JpsException: [PolicyUtil] Exception while getting default policy Provider

at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.loadOPSSPolicy(CommonSecurityServiceManagerDelegateImpl.java:1398)

at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.initialize(CommonSecurityServiceManagerDelegateImpl.java:1018)

at weblogic.security.service.SecurityServiceManager.initialize(SecurityServiceManager.java:873)

at weblogic.security.SecurityService.start(SecurityService.java:141)

at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)

at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)

Caused By: oracle.security.jps.JpsRuntimeException: oracle.security.jps.JpsException: [PolicyUtil] Exception while getting default policy Provider

at oracle.security.jps.internal.policystore.PolicyDelegationController.<init>(PolicyDelegationController.java:293)

at oracle.security.jps.internal.policystore.PolicyDelegationController.<init>(PolicyDelegationController.java:284)

at oracle.security.jps.internal.policystore.JavaPolicyProvider.<init>(JavaPolicyProvider.java:270)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

at java.lang.Class.newInstance0(Class.java:355)

at java.lang.Class.newInstance(Class.java:308)

at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.loadOPSSPolicy(CommonSecurityServiceManagerDelegateImpl.java:1339)

at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.initialize(CommonSecurityServiceManagerDelegateImpl.java:1018)

at weblogic.security.service.SecurityServiceManager.initialize(SecurityServiceManager.java:873)

at weblogic.security.SecurityService.start(SecurityService.java:141)

at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)

at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)

Caused By: oracle.security.jps.JpsException: [PolicyUtil] Exception while getting default policy Provider

at oracle.security.jps.internal.policystore.PolicyUtil.getDefaultPolicyStore(PolicyUtil.java:899)

at oracle.security.jps.internal.policystore.PolicyDelegationController.<init>(PolicyDelegationController.java:291)

at oracle.security.jps.internal.policystore.PolicyDelegationController.<init>(PolicyDelegationController.java:284)

at oracle.security.jps.internal.policystore.JavaPolicyProvider.<init>(JavaPolicyProvider.java:270)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

at java.lang.Class.newInstance0(Class.java:355)

at java.lang.Class.newInstance(Class.java:308)

at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.loadOPSSPolicy(CommonSecurityServiceManagerDelegateImpl.java:1339)

at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.initialize(CommonSecurityServiceManagerDelegateImpl.java:1018)

at weblogic.security.service.SecurityServiceManager.initialize(SecurityServiceManager.java:873)

at weblogic.security.SecurityService.start(SecurityService.java:141)

at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)

at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)

Caused By: java.security.PrivilegedActionException: oracle.security.jps.JpsException: [PolicyUtil] Unable to obtain default JPS Context!

at java.security.AccessController.doPrivileged(Native Method)

at oracle.security.jps.internal.policystore.PolicyUtil.getDefaultPolicyStore(PolicyUtil.java:844)

at oracle.security.jps.internal.policystore.PolicyDelegationController.<init>(PolicyDelegationController.java:291)

at oracle.security.jps.internal.policystore.PolicyDelegationController.<init>(PolicyDelegationController.java:284)

at oracle.security.jps.internal.policystore.JavaPolicyProvider.<init>(JavaPolicyProvider.java:270)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

at java.lang.Class.newInstance0(Class.java:355)

at java.lang.Class.newInstance(Class.java:308)

at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.loadOPSSPolicy(CommonSecurityServiceManagerDelegateImpl.java:1339)

at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.initialize(CommonSecurityServiceManagerDelegateImpl.java:1018)

at weblogic.security.service.SecurityServiceManager.initialize(SecurityServiceManager.java:873)

at weblogic.security.SecurityService.start(SecurityService.java:141)

at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)

at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)

Caused By: oracle.security.jps.JpsException: [PolicyUtil] Unable to obtain default JPS Context!

at oracle.security.jps.internal.policystore.PolicyUtil$1.run(PolicyUtil.java:860)

at oracle.security.jps.internal.policystore.PolicyUtil$1.run(PolicyUtil.java:844)

at java.security.AccessController.doPrivileged(Native Method)

at oracle.security.jps.internal.policystore.PolicyUtil.getDefaultPolicyStore(PolicyUtil.java:844)

at oracle.security.jps.internal.policystore.PolicyDelegationController.<init>(PolicyDelegationController.java:291)

at oracle.security.jps.internal.policystore.PolicyDelegationController.<init>(PolicyDelegationController.java:284)

at oracle.security.jps.internal.policystore.JavaPolicyProvider.<init>(JavaPolicyProvider.java:270)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

at java.lang.Class.newInstance0(Class.java:355)

at java.lang.Class.newInstance(Class.java:308)

at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.loadOPSSPolicy(CommonSecurityServiceManagerDelegateImpl.java:1339)

at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.initialize(CommonSecurityServiceManagerDelegateImpl.java:1018)

at weblogic.security.service.SecurityServiceManager.initialize(SecurityServiceManager.java:873)

at weblogic.security.SecurityService.start(SecurityService.java:141)

at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)

at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)

Caused By: oracle.security.jps.service.keystore.KeyStoreServiceException: JPS-06514: Opening of file based farm keystore failed.

at oracle.security.jps.internal.keystore.file.FileKeyStoreManager.openKeyStore(FileKeyStoreManager.java:351)

at oracle.security.jps.internal.keystore.file.FileKeyStoreServiceImpl.doInit(FileKeyStoreServiceImpl.java:101)

at oracle.security.jps.internal.keystore.file.FileKeyStoreServiceImpl.<init>(FileKeyStoreServiceImpl.java:73)

at oracle.security.jps.internal.keystore.file.FileKeyStoreServiceImpl.<init>(FileKeyStoreServiceImpl.java:63)

at oracle.security.jps.internal.keystore.KeyStoreProvider.getInstance(KeyStoreProvider.java:157)

at oracle.security.jps.internal.keystore.KeyStoreProvider.getInstance(KeyStoreProvider.java:64)

at oracle.security.jps.internal.core.runtime.ContextFactoryImpl.findServiceInstance(ContextFactoryImpl.java:139)

at oracle.security.jps.internal.core.runtime.ContextFactoryImpl.getContext(ContextFactoryImpl.java:170)

at oracle.security.jps.internal.core.runtime.ContextFactoryImpl.getContext(ContextFactoryImpl.java:191)

at oracle.security.jps.internal.core.runtime.JpsContextFactoryImpl.getContext(JpsContextFactoryImpl.java:132)

at oracle.security.jps.internal.core.runtime.JpsContextFactoryImpl.getContext(JpsContextFactoryImpl.java:127)

at oracle.security.jps.internal.policystore.PolicyUtil$1.run(PolicyUtil.java:850)

at oracle.security.jps.internal.policystore.PolicyUtil$1.run(PolicyUtil.java:844)

at java.security.AccessController.doPrivileged(Native Method)

at oracle.security.jps.internal.policystore.PolicyUtil.getDefaultPolicyStore(PolicyUtil.java:844)

at oracle.security.jps.internal.policystore.PolicyDelegationController.<init>(PolicyDelegationController.java:291)

at oracle.security.jps.internal.policystore.PolicyDelegationController.<init>(PolicyDelegationController.java:284)

at oracle.security.jps.internal.policystore.JavaPolicyProvider.<init>(JavaPolicyProvider.java:270)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

at java.lang.Class.newInstance0(Class.java:355)

at java.lang.Class.newInstance(Class.java:308)

at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.loadOPSSPolicy(CommonSecurityServiceManagerDelegateImpl.java:1339)

at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.initialize(CommonSecurityServiceManagerDelegateImpl.java:1018)

at weblogic.security.service.SecurityServiceManager.initialize(SecurityServiceManager.java:873)

at weblogic.security.SecurityService.start(SecurityService.java:141)

at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)

at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)

++++++++++++++++

So the root cause of the issue is:

OPSSjava security policy provider failed due to exception, see the exception stack trace or the server log file for root cause.

Reason: OBIEE 11g Weblogic server didn’t allow any user to startup the server without the proper privileges and hence most of the case the issue found while ‘User1’ installed the app and ‘User2’ try to do the start/stop of weblogic server .

Solution: Allow the bootstrap single sign-on file “cwallet.sso” to update your credentials to perform the weblogic Admin server start/stop activities automatically. The file located at :    ..\\OracleBI\user_projects\domains\bifoundation_domain\config\fmwconfig\bootstrap

I add my profile “Full control” access to that sso file from Windows File “Security” section and that works like charm !! and my Weblogic server is back on action now with OBIEE as well … 🙂