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

Last updated on OCTOBER 06, 2022

Applies to:

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> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <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.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.