ExecuteRequest failed java.lang.NullPointerException ErrorAfter Demantra Upgrade to 12.2.4.1 (Doc ID 2056801.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

Customer has upgraded from from 7.3.1.4 to 12.2.4. They have deployed the war file too. But while trying to access the demantra either from EBS or from direct URL, application page is not coming up and they are getting below error in Managed Server log file.

========================================
####<Sep 15, 2015 4:03:42 PM UTC> <Error> <Kernel> <dem-web-dv-02-l> <demf_server1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <8bb4126bc21e7bf2:22757946:14fd1ba633c:-8000-0000000000000559> <1442333022650> <BEA-000802> <ExecuteRequest failed
java.lang.NullPointerException.

  at com.demantra.common.translation.web.ServerTranslationUtility.getLoginLanguage(ServerTranslationUtility.java:98)
  at jsp_servlet._portal.__generalerrorpage._jspService(__generalerrorpage.java:133)
  at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
  at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
  at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
  at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
  at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:184)
  at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:526)
  at weblogic.servlet.internal.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:253)
  at weblogic.servlet.internal.ServletResponseImpl.sendError(ServletResponseImpl.java:731)
  at weblogic.servlet.internal.ServletResponseImpl.sendError(ServletResponseImpl.java:602)
  at weblogic.servlet.internal.ErrorManager.handleException(ErrorManager.java:195)
  at weblogic.servlet.internal.WebAppServletContext.handleThrowableFromInvocation(WebAppServletContext.java:2344)
  at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2186)
  at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
  at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
  at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
>


The upgrade logs show the following


2015-09-15 04:41:35,201 [INFO ] - Updating Default System Language: English
2015-09-15 04:41:35,201 [DEBUG] - Oracle JDBC connection URL: jdbc:oracle:thin:@xxxxxxxxxx
2015-09-15 04:41:35,264 [DEBUG] - Query Lang ID SQL: select lang_id from languages where lang_name = 'English'
2015-09-15 04:41:35,279 [DEBUG] - Query Lang ID SQL: select lang_id from languages where lang_name = ''
2015-09-15 04:41:35,279 [ERROR] - Failed to query Lang ID for language: ''.
java.sql.SQLException: Exhausted Resultset
at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:915)
at com.demantra.actions.SchemaLanguageUpdateAction.getLangID(SchemaLanguageUpdateAction.java:441)
at com.demantra.actions.SchemaLanguageUpdateAction.updateLanguage(SchemaLanguageUpdateAction.java:327)
at com.demantra.actions.SchemaLanguageUpdateAction.install(SchemaLanguageUpdateAction.java:226)
at com.zerog.ia.installer.actions.CustomAction.installSelf(DashoA10*..)
at ZeroGaeg.run(DashoA10*..)
2015-09-15 04:41:35,295 [DEBUG] - Failed SQL Statement: select lang_id from languages where lang_name = ''
2015-09-15 04:41:35,295 [ERROR] - updateLanguage failed.
java.sql.SQLException: Exhausted Resultset
at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:915)
at com.demantra.actions.SchemaLanguageUpdateAction.getLangID(SchemaLanguageUpdateAction.java:441)
at com.demantra.actions.SchemaLanguageUpdateAction.updateLanguage(SchemaLanguageUpdateAction.java:327)
at com.demantra.actions.SchemaLanguageUpdateAction.install(SchemaLanguageUpdateAction.java:226)
at com.zerog.ia.installer.actions.CustomAction.installSelf(DashoA10*..)
at ZeroGaeg.run(DashoA10*..)
2015-09-15 04:41:35,295 [INFO ] - Updating Supported Languages: English
2015-09-15 04:41:35,295 [INFO ] - Base Language 'English' is not refering to as a Supported one in case of translations.
2015-09-15 04:41:35,295 [DEBUG] - Oracle JDBC connection URL: jdbc:oracle:thin:@xxxxxxxxxxxxxxxxxxxx
2015-09-15 04:41:35,357 [DEBUG] - Query Text Key Translations SQL: SELECT dl.description, dl.application_id FROM dropdownlists dl
2015-09-15 04:41:37,092 [DEBUG] - Remove Unsupported Translations SQL: DELETE FROM i18n_data_dictionary d WHERE d.lang_id IN (SELECT l.lang_id FROM languages l WHERE (l.is_active = 0 OR l.is_base = 1))
2015-09-15 04:41:37,107 [DEBUG] - Done executing com.demantra.actions.SchemaLanguageUpdateAction.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms