Symptom
- After support package update of the SAP BW or BW/4HANA, import data connection is not functional anymore.
- Listing of the existing queries from the SAP BW backend is still possible via the BW connection.
- In the SAP Analytics Cloud Agent tomcat trace, the following exception is logged in <tomcat root folder>/logs/catalina.out (when running on linux):
-
10-Nov-2021 12:55:05.956 SEVERE [http-nio-8080-exec-3] com.sap.fpa.cloud.rest.BWRequestBroker.null Dereferencing of the NULL reference Program error in class SAPMSSY1 method : UNCAUGHT_EXCEPTION
<exception>
com.sap.ip.bi.base.application.exceptions.AbortMessageRuntimeException: Termination message sent ABEND RS_EXCEPTION (000): Dereferencing of the NULL reference MSGV1: Dereferencing of the NULL reference
at com.sap.ip.bi.base.application.message.impl.MessageManager.addMessageInternal(MessageManager.java:211)
at com.sap.ip.bi.base.application.message.impl.MessageManager.addMessageByListener(MessageManager.java:177)
at com.sap.ip.bi.base.application.message.impl.MessageManager.addMessage(MessageManager.java:130)
at com.sap.ip.bi.base.application.message.impl.MessageManager.addMessageInternal(MessageManager.java:207)
at com.sap.ip.bi.base.application.message.impl.MessageManager.addMessageByListener(MessageManager.java:177)
at com.sap.ip.bi.base.application.message.impl.MessageManager.addMessage(MessageManager.java:130)
at com.sap.ip.bi.base.application.service.RfcService.fillMessages(RfcService.java:369)
at com.sap.ip.bi.base.application.service.RfcService.doPostProcessing(RfcService.java:318)
at com.sap.ip.bi.base.application.service.rfcproxy.base.RfcFunction.execute(RfcFunction.java:97)
at com.sap.ip.bi.bics.dataaccess.resource.impl.bi.selector.variableprocessor.ProviderVariableContainer.submitVariables(ProviderVariableContainer.java:590)
at com.sap.ip.bi.bics.dataaccess.consumer.impl.selector.variableprocessor.VariableProcessor.submitVariables(VariableProcessor.java:550)
at com.sap.ip.bi.bics.dataaccess.consumer.impl.selector.SelectionObject.initializeState(SelectionObject.java:718)
at com.sap.ip.bi.bics.dataaccess.consumer.impl.queryview.QueryView.initializeState(QueryView.java:192)
at com.sap.ip.bi.bics.dataaccess.consumer.impl.selector.SelectionObject.getCharacteristicsExt(SelectionObject.java:954)
at com.sap.ip.bi.bics.dataaccess.consumer.impl.queryview.QueryView.getCharacteristicsExt(QueryView.java:560)
at com.sap.fpa.cloud.rest.bw.metadata.QueryMetaDataReader.readQueryMetaData(QueryMetaDataReader.java:31)
at com.sap.fpa.cloud.rest.BWRequestBroker.readQueryMetaData(BWRequestBroker.java:319)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:90)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
at java.lang.reflect.Method.invoke(Method.java:508)
at com.sap.fpa.cloud.service.EpmDispatcherServlet.handleRequest(EpmDispatcherServlet.java:267)
at com.sap.fpa.cloud.service.EpmDispatcherServlet.doPost(EpmDispatcherServlet.java:135)
at com.sap.fpa.cloud.service.EpmDispatcherServlet$$Lambda$39/00000000081FFF50.execute(Unknown Source)
at com.sap.fpa.cloud.service.EpmDispatcherServlet.doAndLog(EpmDispatcherServlet.java:92)
at com.sap.fpa.cloud.service.EpmDispatcherServlet.doPost(EpmDispatcherServlet.java:129)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:659)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1726)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:822)
<exception>
com.sap.ip.bi.base.application.exceptions.AbortMessageRuntimeException: Termination message sent ABEND RS_EXCEPTION (000): Dereferencing of the NULL reference MSGV1: Dereferencing of the NULL reference ABEND RSBOLAP (000): Program error in class SAPMSSY1 method : UNCAUGHT_EXCEPTION MSGV1: SAPMSSY1 MSGV3: UNCAUGHT_EXCEPTION
at com.sap.ip.bi.base.application.message.impl.MessageManager.addMessageInternal(MessageManager.java:211)
at com.sap.ip.bi.base.application.message.impl.MessageManager.addMessageByListener(MessageManager.java:177)
at com.sap.ip.bi.base.application.message.impl.MessageManager.addMessage(MessageManager.java:130)
at com.sap.ip.bi.base.application.message.impl.MessageManager.addMessageInternal(MessageManager.java:207)
at com.sap.ip.bi.base.application.message.impl.MessageManager.addMessageByListener(MessageManager.java:177)
at com.sap.ip.bi.base.application.message.impl.MessageManager.addMessage(MessageManager.java:130)
at com.sap.ip.bi.base.application.service.RfcService.fillMessages(RfcService.java:369)
at com.sap.ip.bi.base.application.service.RfcService.doPostProcessing(RfcService.java:318)
at com.sap.ip.bi.base.application.service.rfcproxy.base.RfcFunction.execute(RfcFunction.java:97)
at com.sap.ip.bi.bics.dataaccess.resource.impl.bi.selector.variableprocessor.ProviderVariableContainer.submitVariables(ProviderVariableContainer.java:590)
at com.sap.ip.bi.bics.dataaccess.consumer.impl.selector.variableprocessor.VariableProcessor.submitVariables(VariableProcessor.java:550)
at com.sap.ip.bi.bics.dataaccess.consumer.impl.selector.SelectionObject.initializeState(SelectionObject.java:718)
at com.sap.ip.bi.bics.dataaccess.consumer.impl.queryview.QueryView.initializeState(QueryView.java:192)
at com.sap.ip.bi.bics.dataaccess.consumer.impl.selector.SelectionObject.getCharacteristicsExt(SelectionObject.java:954)
at com.sap.ip.bi.bics.dataaccess.consumer.impl.queryview.QueryView.getCharacteristicsExt(QueryView.java:560)
at com.sap.fpa.cloud.rest.bw.metadata.QueryMetaDataReader.readQueryMetaData(QueryMetaDataReader.java:31)
at com.sap.fpa.cloud.rest.BWRequestBroker.readQueryMetaData(BWRequestBroker.java:319)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:90)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
at java.lang.reflect.Method.invoke(Method.java:508)
at com.sap.fpa.cloud.service.EpmDispatcherServlet.handleRequest(EpmDispatcherServlet.java:267)
at com.sap.fpa.cloud.service.EpmDispatcherServlet.doPost(EpmDispatcherServlet.java:135)
at com.sap.fpa.cloud.service.EpmDispatcherServlet$$Lambda$39/00000000081FFF50.execute(Unknown Source)
at com.sap.fpa.cloud.service.EpmDispatcherServlet.doAndLog(EpmDispatcherServlet.java:92)
at com.sap.fpa.cloud.service.EpmDispatcherServlet.doPost(EpmDispatcherServlet.java:129)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:659)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1726)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:822)
Read more...
Environment
- SAP Analytics Cloud 1.0
- SAP Analytics Cloud Agent
- SAP BW/4HANA 1.0
- SAP BW/4HANA 2.0
Product
Keywords
Catalina, sapjco, tomcat, cloudagent, RS_EXCEPTION (000) , KBA , LOD-ANA-AQU-BW , Data Acquisition from BW , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.