Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

nqsserver crash

Received Response
264
Views
9
Comments
3679742
3679742 Rank 2 - Community Beginner
edited Aug 13, 2024 5:31PM in Oracle Analytics Cloud and Server

Recently upgraded from OBIEE 12.2.1.2 to 12.2.1.4. Downloaded a number of patches as part of the upgrade as there are so many disconnected parts which have not been well bundled in this upgrade. Down to the last few errors to resolve.

a) nqsserver crashes as soon as I try accessing data from planning data source.

Does anyone know of any patch or solution to this issue?

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    Do your BI Server log files have any errors that may assist in pinpointing the root cause of the crash?

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    3679742 wrote:Recently upgraded from OBIEE 12.2.1.2 to 12.2.1.4. Downloaded a number of patches as part of the upgrade as there are so many disconnected parts which have not been well bundled in this upgrade.

    Which patches?

    3679742 wrote:a) nqsserver crashes as soon as I try accessing data from planning data source.

    What do the logs say?

    Is your "planning source" correctly registered in the RPD?

    HOW is it exactly registered in the RPD?

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    3679742 wrote:Recently upgraded from OBIEE 12.2.1.2 to 12.2.1.4. Downloaded a number of patches as part of the upgrade as there are so many disconnected parts which have not been well bundled in this upgrade.

    Which patches?

    3679742 wrote:a) nqsserver crashes as soon as I try accessing data from planning data source.

    What do the logs say?

    Is your "planning source" correctly registered in the RPD?

    HOW is it exactly registered in the RPD?

  • 3679742
    3679742 Rank 2 - Community Beginner

    Patches that were recommended as part of the upgrade

    Patch 27823500: REGRESSION BUG WHICH INTRODUCED BY THE BUG FIXING OF 27678101

    Patch 27401639: DOMAIN BASED UA[.BAT] -READINESS CHECK FAILS FOR PS4 UPGRADE

    Patch 27479453: NodeManager doesn't work with non-Oracle database

    Instanceconfig.xml change - reports/dashboards with html cannot be saved and needed a fix.

    As soon as I open a dashboard containing planning data, I get the message nqsserver has stopped working. All further subsequent dashboards/reports hang. I stopped and restarted all services. Removed the planning data from the dashboard and it all works fine. Dashboards have reports from essbase and these work without any issues.

    No changes were made to the RPD from verion obiee 12.2.1.2 in terms of the database setup or connection pool.

  • 3679742
    3679742 Rank 2 - Community Beginner

    I have extracted the following 3 error messages from bi_server1.log file

    1)

    <28-Dec-2018 10:01:41,112 o'clock GMT> <Warning> <HTTP> <BEA-101162> <User defined listener org.apache.myfaces.trinidadinternal.webapp.TrinidadListenerImpl failed: java.lang.NoClassDefFoundError: javax/faces/context/ExternalContextWrapper.

    java.lang.NoClassDefFoundError: javax/faces/context/ExternalContextWrapper

    at java.lang.ClassLoader.defineClass1(Native Method)

    at java.lang.ClassLoader.defineClass(ClassLoader.java:763)

    at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)

    at weblogic.utils.classloaders.GenericClassLoader.defineClassInternal(GenericClassLoader.java:1113)

    at weblogic.utils.classloaders.GenericClassLoader.defineClass(GenericClassLoader.java:1046)

    Truncated. see log file for complete stacktrace

    Caused By: java.lang.ClassNotFoundException: javax.faces.context.ExternalContextWrapper

    at weblogic.utils.classloaders.GenericClassLoader.findLocalClass(GenericClassLoader.java:1029)

    at weblogic.utils.classloaders.GenericClassLoader.findClass(GenericClassLoader.java:990)

    at weblogic.utils.classloaders.ChangeAwareClassLoader.findClass(ChangeAwareClassLoader.java:104)

    at weblogic.utils.classloaders.GenericClassLoader.doFindClass(GenericClassLoader.java:611)

    at weblogic.utils.classloaders.GenericClassLoader.loadClass(GenericClassLoader.java:543)

    Truncated. see log file for complete stacktrace

    2)

    <28-Dec-2018 10:06:03,531 o'clock GMT> <Warning> <HTTP> <BEA-101342> <bipublisher [Version=11.1.1]: Error(s) encountered while precompiling JSP jspURI

    reportaction.jsp:485:32: The method getToolResource(String) is undefined for the type ConfigProvider

            Resource tb = provider.getToolResource("/BIPublisherDesktop32.exe");

                                   ^------------^

    reportaction.jsp:509:32: The method getToolResource(String) is undefined for the type ConfigProvider

            Resource tb = provider.getToolResource("/BIPublisherDesktop64.exe");

                                   ^------------^

    reportaction.jsp:533:32: The method getToolResource(String) is undefined for the type ConfigProvider

            Resource ae = provider.getToolResource("/ExcelAnalyzer.exe");

                                   ^------------^

    >

    3)

    Dec 28, 2018 10:07:04 AM oracle.lbs.util.ServerInitListener$CatalogsUpgradeInfo copyCatalogFiles

    INFO: Copying /catalogs using overwrite list...

    <28-Dec-2018 10:07:06,706 o'clock GMT> <Error> <HTTP> <BEA-101165> <Could not load user defined filter in web.xml: oracle.lbs.util.ProxySecurityFilter.

    java.lang.RuntimeException: Couldn't get system user credentials.

    at oracle.lbs.util.ProxySecurityFilter.init(ProxySecurityFilter.java:93)

    at weblogic.servlet.internal.FilterManager$FilterInitAction.run(FilterManager.java:400)

    at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:326)

    at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197)

    at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203)

    Truncated. see log file for complete stacktrace

    Caused By: java.security.PrivilegedActionException: java.lang.reflect.InvocationTargetException

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

    at oracle.lbs.util.ProxySecurityFilter.init(ProxySecurityFilter.java:90)

    at weblogic.servlet.internal.FilterManager$FilterInitAction.run(FilterManager.java:400)

    at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:326)

    at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197)

    Truncated. see log file for complete stacktrace

    Caused By: java.lang.reflect.InvocationTargetException

    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

    at java.lang.reflect.Method.invoke(Method.java:498)

    at oracle.lbs.util.ProxySecurityFilter$1.run(ProxySecurityFilter.java:82)

    Truncated. see log file for complete stacktrace

    Caused By: java.security.AccessControlException: access denied ("oracle.security.jps.service.credstore.CredentialAccessPermission" "context=SYSTEM,mapName=oracle.bi.system,keyName=system.user" "read")

    at java.security.AccessControlContext.checkPermission(AccessControlContext.java:472)

    at java.security.AccessController.checkPermission(AccessController.java:884)

    at oracle.security.jps.util.JpsAuth$AuthorizationMechanism$3.checkPermission(JpsAuth.java:527)

    at oracle.security.jps.util.JpsAuth.checkPermission(JpsAuth.java:587)

    at oracle.security.jps.util.JpsAuth.checkPermission(JpsAuth.java:626)

    Truncated. see log file for complete stacktrace

    >

  • Madasamy -Oracle
    Madasamy -Oracle Rank 6 - Analytics Lead

    I can see that these are from bi_server1.logs.

    How do you confirm that the nqsserver is crashing? Do you see that the PIDs are killed OR changing? OR Do you see that the obis1-diagnostic.log do show nothing and the nqsserver process does not exist?

    You could try to create a core dump and stack trace and log a Service Request if its really a crash issue.

    OBIEE 10-12c: Steps To Generate Stack Trace Output To Debug Core Dump Or Hang On Linux / Unix (Doc ID 1382369.1)

  • 3679742
    3679742 Rank 2 - Community Beginner

    As soon as I access a Dashboard with Planning Reports, I get a message nqsserver has stopped working.

    I have been told that after the upgrade to 12.2.1.4 I need to re-do the configuration using "OBIEE 12c: How To Configure Hyperion Financial Management (HFM) 11.1.2.4.x as a Data Source for OBIEE 12c (Doc ID 2158975.1)". I am a bit confused.

    Or do I need to only copy the 3 jar files? Question - I am copying these jar files from the planning server. Is this correct?

  • 3679742
    3679742 Rank 2 - Community Beginner

    Hi Christian,

    When you say is your source correctly registered in the RPD? what do I need to check? I am using the same RPD from 12.2.1.2.

  • 3679742
    3679742 Rank 2 - Community Beginner

    Slight improvement -

    1) I have re-copied the 3 jar files from our planning server and restarted the services. The server doesn't crash anymore.

    I still get the following error when I access reports based on planning

    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)

    State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)

    State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)

    State: HY000. Code: 60001. [nQSError: 60001] Connection failed for: RemoteService-JavaHost-ADMService with message: (HY000)

    State: HY000. Code: 77027. [nQSError: 77027] Unexpected end of file encountered. 4 bytes were requested and 0 bytes were read. Error Codes: KUWODMKH occurs inside SAW RPC modules when calling ADMService.. (HY000)

    2) Admin tool - import metadata from a planning connection gives the following error

    2019-01-03T10:42:42.591+00:00] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: service1] [tid: 690]  [nQSError: 60001] Connection failed for: RemoteService-JavaHost-ADMImportService with message: [nQSError: 77027] Unexpected end of file encountered. 4 bytes were requested and 0 bytes were read. [[

    file: server\Utility\JavaIntegration\Src\SUJIRemoteService.cpp; line: 158

    Error Codes: KUWODMKH

    occurs inside SAW RPC modules when calling ADMImportService..

    ]]