Friday, October 20, 2023

Oracle "Hyperion EPMA Server" service is not coming online

Recently I have encountered this issue with Oracle Hyperion. When we restarted Hyperion server, the “Hyperion EPMA Server” service is not coming online and application is down.

Here are the Errors from event.log

EPMA_Server
[EPMA Server Startup] ERROR SVR_ERR_PROCESSMGR_CANT_INIT_SESSIONMGR:Cannot initialize the Session Manager.Hyperion.DimensionServer.Interface.Exceptions.EPMAServiceException: Cannot initialize the Session Manager. ---> Hyperion.CommonServices.Exceptions.SessionManagerException: An error was encountered by the CAS Security Provider: Class: java.lang.NullPointerException
StackTrace:

at Hyperion.DimensionServer.SessionManager.CasSecurityProvider.GetDataBaseDetails(String& vendor, String& serverName, Int32& dbPort, String& dbName, String& username, String& password, String& jdbcUrl)
at Hyperion.DimensionServer.SessionManager.SessionManager.InitializeSqlConnectionString()
at Hyperion.DimensionServer.SessionManager.SessionManager.Initialize(String configFileName, Boolean restorePastInstanceSessions, Boolean enableCaching)
--- End of inner exception stack trace ---


Hyperion EPMA DimmensionServer
Service cannot be started. Hyperion.DimensionServer.Interface.Exceptions.EPMAServiceException: Cannot initialize the Session Manager. ---> Hyperion.CommonServices.Exceptions.SessionManagerException: An error was encountered by the CAS Security Provider: Class: java.lang.NullPointerException
StackTrace:
at Hyperion.DimensionServer.SessionManager.CasSecurityProvider.GetDataBaseDetails(String& vendor, String& serverName, Int32& dbPort, String& dbName, String& username, String& password, String& jdbcUrl)
at Hyperion.DimensionServer.SessionManager.SessionManager.InitializeSqlConnectionString()
at Hyperion.DimensionServer.SessionManager.SessionManager.Initialize(String configFileName, Boolean restorePastInstanceSessions, Boolean enableCaching)
--- End of inner exception stack trace ---

The event log is no much helpful. But note that the Hyperion EPMA Service will not come up if you have any issues with database. Check the logs to see any “ORA- “errors .

I found below error in EssbaseAdminServices0.log
#### <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1329242417925> ORA-28001: the password has expired

Now it’s clear that Database user password expired.

SQL> select USERNAME, ACCOUNT_STATUS from dba_users where USERNAME = ‘SHARED_SERVICES’;

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
SHARED_SERVICES EXPIRED(GRACE)

Do not change the password. If you change the password then you need to re-configure the Hyperion service in order to use the new password.

If you know the password then set the using below command.
SQL> Alter user SHARED_SERVICES identified by ‘xxxxxx’;

If you don’t know the password then reset the password following below steps
SQL> select password from sys.user$ where name='SHARED_SERVICES';

PASSWORD
------------------------------
61266722B44D5BG418

SQL> alter user QWERTY identified by values '61266722B44D5BG418’;
User altered.

Also make sure to modify PASSWORD_LIFE_TIME to “UNLIMITED” for DEFAULT or User profile that you are using

SQL> alter profile default limit PASSWORD_LIFE_TIME unlimited;
Profile altered.

Regards,
Satishbabu Gunukula
http://www.oracleracexpert.com

18 comments:

  1. Starting a server is something that only a programmer can do. If you are a humanities, then I do not advise you to intervene in such matters. I advise you to develop in the sphere of writing papers that is possible with the use of services such as the best sociology essay writing service https://proessaywritings.com/sociology-essay.html (it is the essay writing service that has rewards as "The best sociology essay writing service" and as "The best sociology paper writing company") which helps to learn how to write papers and not only provide cheating services.

    ReplyDelete
  2. I used to think assignment help was just sketchy copy-paste stuff until I started working with Native Assignment Help the work we do is more like behind-the-scenes coaching. We help with structure, referencing, and even getting tricky technical content right. People forget how much better their work can be with just a little outside input

    ReplyDelete
  3. I’ve used various academic services in the past, but Assignment Writing Services provided the best Assignment Help by far. I had a very specific topic for my finance assignment, and they assigned it to someone who clearly knew the subject. The paper included detailed analysis, well-explained graphs, and accurate referencing. They delivered it a day early, and everything was exactly as I’d requested. The customer service team was responsive and professional throughout. I ended up getting a First for that paper. I now use them regularly and recommend them to friends who need help managing their university workload.

    ReplyDelete
  4. Carl had been searching for reliable support with academic content for one of his continuing education courses when he stumbled upon this platform. He opted for their Project Management Assignment Help after reading some good reviews and was pleased with the quality. The writers demonstrated a deep understanding of real-world project management concepts, including frameworks like PRINCE2 and Agile. What really helped was their clear, concise writing style that didn’t require heavy edits. They also followed all the guidelines provided without missing out on any major points. Carl appreciated the open communication throughout the process and the professionalism the team showed. He now considers them a dependable option for anyone needing academic assistance in project-based subjects.

    ReplyDelete
  5. Your article provides a precise and actionable solution to a common Oracle Hyperion EPMA server issue, which is especially useful for IT professionals dealing with server configuration errors. The clear identification of the problem and the logical steps to resolve it reflect a deep understanding of enterprise-level software troubleshooting. Just as this technical guidance is invaluable in solving server-related issues, detailed support like this is equally beneficial in academic contexts such as Human Resource Assignment Help , where structured analysis and step-by-step reasoning are essential for mastering HR concepts.

    ReplyDelete
  6. Psychology projects were complex, but Assignment Help UK made them easier. Their advice on research methods and critical analysis helped me craft compelling work. The personalized feedback ensured my projects met academic standards, improving my grades. These services are invaluable for students tackling tough assignments. I highly recommend them!

    ReplyDelete
  7. Getting stuck on a Python project just days before the deadline is more common than you think. Students often resort to last-minute fixes that lower their grades. An effective alternative is Python Assignment Help UK, a service specifically tailored to help UK-based students with their coding coursework. Whether it's a simple loop problem or a complex application involving APIs or libraries like Pandas, they handle everything with professionalism. Their attention to detail and clarity in writing have made them a go-to resource. Plus, they’re familiar with what UK universities require. With their support, you’ll not only get better grades but also improve your Python knowledge in the process.

    ReplyDelete
  8. Honestly, I thought I could handle all my CIPD Level 5 work on my own… until I hit Unit 5HRF. Between work, family, and deadlines, I was completely overwhelmed. Getting a bit of CIPD level 5 Assignment Help gave me the direction I needed. It wasn’t about someone doing it for me—it was about learning how to do it better. I finally understood what the brief was really asking, and my grades improved because of that clarity

    ReplyDelete
  9. The Free Grammar Checker Tool goes beyond error correction by offering detailed explanations for each suggestion, helping users learn and improve their writing skills over time. This educational aspect is particularly valuable for non-native English speakers or students mastering complex grammar rules. Additionally, its AI-driven engine ensures context-aware corrections, avoiding unnecessary changes that could alter your intended meaning. Trusted by millions, this Best free grammar checker online empowers users to communicate confidently across various contexts, from crafting professional emails to perfecting academic essays. Its ability to streamline the editing process with one-click fixes saves time and enhances productivity. Whether you're polishing a resume or posting on social media, the Free Grammar Checker Tool ensures your writing is impactful and error-free, making it an indispensable companion for effective communication in today’s fast-paced digital world.

    ReplyDelete
  10. Thanks for this! I was having issues with the tiktok login on my browser — it kept redirecting. Your step-by-step tips were clear and helped me get back into my account. Really appreciate the simple solutions without needing to reinstall the app.

    ReplyDelete
  11. As a student balancing part-time work and evening classes, managing deadlines can be demanding. I’ve had to become more organized and intentional with how I use my time.
    I recently came across CIPD Level 3 Assignment Help and found it incredibly valuable for structuring my research and ideas. It guided me in aligning my answers with the assessment criteria and helped me focus on key learning outcomes. This approach made a noticeable difference in my confidence when submitting assignments.

    ReplyDelete
  12. During the final year of university, balancing research, presentations, and job applications has been intense. To stay ahead, I created a detailed plan to Write My Dissertation without letting distractions interfere. I learned that writing consistently—even just 300 words a day—builds momentum. Keeping an annotated bibliography helped me stay organized, and writing summaries of each source saved time during revisions. I made sure to review one section each weekend and polish it with fresh eyes. This rhythm kept the workload manageable and helped me stay connected with my research objectives from start to finish

    ReplyDelete
  13. I’m Edwin, offering expert Project Management Assignment Help to make your assignments manageable and precise. I focus on clear explanations, well-structured content, and plagiarism-free work. My goal is to help you understand concepts while meeting deadlines. Count on me for quality support and better grades. Let’s work together for success.

    ReplyDelete
  14. I’m Carl, and I help students struggling with Can Someone Help Me Write My Dissertation? assignments. I provide guidance from topic selection to final editing, ensuring every dissertation is original and well-structured. My support focuses on clarity, research quality, and timely delivery. I aim to make the dissertation process stress-free while helping students achieve top grades. Count on me for professional academic assistance.

    ReplyDelete