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.
SAP Knowledge Base Article - Preview