nqsserver crash

3679742

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?

Joel

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

[Deleted User]

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]

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

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

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

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

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

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

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..

]]