cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to publish in IE with BEx Query Designer

Former Member
0 Kudos
88

We have a new BI system (ABAP+JAVA WAS 7 NW2004s SP9) and have followed the install and config guide for BI and BEx now when I try to publish a query into IE I get the error message at the end of this entry.

We have changed the client from 001 to 100 and tried to change the entries at the global level in the config tool from 001 to 100 but when we do that J2EE will not start (-11113 error).

Can anyone please help?

com.sap.mw.jco.JCO$Exception: (101) RFC_ERROR_PROGRAM: 'user' missing at com.sap.mw.jco.MiddlewareJRfc.generateJCoException(MiddlewareJRfc.java:457) at com.sap.mw.jco.MiddlewareJRfc$Client.connect(MiddlewareJRfc.java:989) at com.sap.mw.jco.JCO$Client.connect(JCO.java:3193) at com.sapportals.connectors.SAPCFConnector.connection.SAPCFConnectorManagedConnection.connectWithJCO(SAPCFConnectorManagedConnection.java:411) at com.sapportals.connectors.SAPCFConnector.connection.SAPCFConnectorManagedConnection.establishInitialConnection(SAPCFConnectorManagedConnection.java:209) at com.sapportals.connectors.SAPCFConnector.connection.SAPCFConnectorManagedConnection.init(SAPCFConnectorManagedConnection.java:188) at com.sapportals.connectors.SAPCFConnector.connection.SAPCFConnectorManagedConnectionFactory.createManagedConnection(SAPCFConnectorManagedConnectionFactory.java:129) at com.sap.engine.services.connector.jca.ConnectionHashSet.match(ConnectionHashSet.java:320) at com.sap.engine.services.connector.jca.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:189) at com.sapportals.connectors.SAPCFConnector.connection.SAPCFConnectorConnectionFactory.getConnectionEx(SAPCFConnectorConnectionFactory.java:155) at com.sap.portal.ivs.internalconnector.ConnectionProvider.getConnection(ConnectionProvider.java:302) at com.sap.portal.ivs.internalconnector.ConnectionProvider.getConnection(ConnectionProvider.java:259) at com.sapportals.portal.ivs.cg.ConnectorService.getConnection(ConnectorService.java:458) at com.sapportals.portal.ivs.cg.ConnectorService.getConnection(ConnectorService.java:87) at com.sap.ip.bi.base.portal.connection.PortalConnectionPool.getConnection(PortalConnectionPool.java:172) at com.sap.ip.bi.base.service.connection.impl.GenericConnectionPool.getMasterSystemConnection(GenericConnectionPool.java:64) at com.sap.ip.bi.base.application.impl.Application.createService(Application.java:406) at com.sap.ip.bi.base.application.impl.Application.getProperty(Application.java:596) at com.sap.ip.bi.base.application.impl.Application.initialization(Application.java:227) at com.sap.ip.bi.base.application.ApplicationFactory.createApplication(ApplicationFactory.java:132) at com.sap.ip.bi.base.application.ApplicationFactory.createApplication(ApplicationFactory.java:63) at com.sap.ip.bi.webapplications.runtime.impl.Page.constructPage(Page.java:650) at com.sap.ip.bi.webapplications.runtime.impl.Page.<init>(Page.java:606) at com.sap.ip.bi.webapplications.runtime.controller.impl.Controller.createPage(Controller.java:548) at com.sap.ip.bi.webapplications.runtime.controller.impl.Controller.doProcessRequest(Controller.java:922) at com.sap.ip.bi.webapplications.runtime.controller.impl.Controller.processRequest(Controller.java:868) at com.sap.ip.bi.webapplications.runtime.jsp.portal.services.BIRuntimeService.handleRequest(BIRuntimeService.java:328) at com.sap.ip.bi.webapplications.runtime.jsp.portal.components.LauncherComponent.doContent(LauncherComponent.java:21) at com.sapportals.portal.prt.component.AbstractPortalComponent.serviceDeprecated(AbstractPortalComponent.java:209) at com.sapportals.portal.prt.component.AbstractPortalComponent.service(AbstractPortalComponent.java:114) at com.sapportals.portal.prt.core.PortalRequestManager.callPortalComponent(PortalRequestManager.java:328) at com.sapportals.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:136) at com.sapportals.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:189) at com.sapportals.portal.prt.component.PortalComponentResponse.include(PortalComponentResponse.java:215) at com.sapportals.portal.prt.pom.PortalNode.service(PortalNode.java:646) at com.sapportals.portal.prt.core.PortalRequestManager.callPortalComponent(PortalRequestManager.java:328) at com.sapportals.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:136) at com.sapportals.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:189) at com.sapportals.portal.prt.core.PortalRequestManager.runRequestCycle(PortalRequestManager.java:753) at com.sapportals.portal.prt.connection.ServletConnection.handleRequest(ServletConnection.java:240) at com.sapportals.portal.prt.dispatcher.Dispatcher$doService.run(Dispatcher.java:522) at java.security.AccessController.doPrivileged(Native Method) at com.sapportals.portal.prt.dispatcher.Dispatcher.service(Dispatcher.java:405) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.sap.engine.services.servlets_jsp.server.servlet.InvokerServlet.service(InvokerServlet.java:156) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:390) at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:264) at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:347) at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:325) at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:887) at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:241) at com.sap.engine.services.httpserver.server.Client.handle(Client.java:92) at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:148) at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33) at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41) at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37) at java.security.AccessController.doPrivileged(Native Method) at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:100) at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:170)

-


Message:

No connection possible to BI master system BI_DEV

Stack trace:

com.sap.ip.bi.base.service.connection.ConnectionException: No connection possible to BI master system BI_DEV at com.sap.ip.bi.base.service.connection.impl.GenericConnectionPool.getMasterSystemConnection(GenericConnectionPool.java:68) at com.sap.ip.bi.base.application.impl.Application.createService(Application.java:406) at com.sap.ip.bi.base.application.impl.Application.getProperty(Application.java:596) at com.sap.ip.bi.base.application.impl.Application.initialization(Application.java:227) at com.sap.ip.bi.base.application.ApplicationFactory.createApplication(ApplicationFactory.java:132) at com.sap.ip.bi.base.application.ApplicationFactory.createApplication(ApplicationFactory.java:63) at com.sap.ip.bi.webapplications.runtime.impl.Page.constructPage(Page.java:650) at com.sap.ip.bi.webapplications.runtime.impl.Page.<init>(Page.java:606) at com.sap.ip.bi.webapplications.runtime.controller.impl.Controller.createPage(Controller.java:548) at com.sap.ip.bi.webapplications.runtime.controller.impl.Controller.doProcessRequest(Controller.java:922) at com.sap.ip.bi.webapplications.runtime.controller.impl.Controller.processRequest(Controller.java:868) at com.sap.ip.bi.webapplications.runtime.jsp.portal.services.BIRuntimeService.handleRequest(BIRuntimeService.java:328) at com.sap.ip.bi.webapplications.runtime.jsp.portal.components.LauncherComponent.doContent(LauncherComponent.java:21) at com.sapportals.portal.prt.component.AbstractPortalComponent.serviceDeprecated(AbstractPortalComponent.java:209) at com.sapportals.portal.prt.component.AbstractPortalComponent.service(AbstractPortalComponent.java:114) at com.sapportals.portal.prt.core.PortalRequestManager.callPortalComponent(PortalRequestManager.java:328) at com.sapportals.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:136) at com.sapportals.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:189) at com.sapportals.portal.prt.component.PortalComponentResponse.include(PortalComponentResponse.java:215) at com.sapportals.portal.prt.pom.PortalNode.service(PortalNode.java:646) at com.sapportals.portal.prt.core.PortalRequestManager.callPortalComponent(PortalRequestManager.java:328) at com.sapportals.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:136) at com.sapportals.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:189) at com.sapportals.portal.prt.core.PortalRequestManager.runRequestCycle(PortalRequestManager.java:753) at com.sapportals.portal.prt.connection.ServletConnection.handleRequest(ServletConnection.java:240) at com.sapportals.portal.prt.dispatcher.Dispatcher$doService.run(Dispatcher.java:522) at java.security.AccessController.doPrivileged(Native Method) at com.sapportals.portal.prt.dispatcher.Dispatcher.service(Dispatcher.java:405) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.sap.engine.services.servlets_jsp.server.servlet.InvokerServlet.service(InvokerServlet.java:156) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:390) at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:264) at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:347) at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:325) at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:887) at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:241) at com.sap.engine.services.httpserver.server.Client.handle(Client.java:92) at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:148) at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33) at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41) at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37) at java.security.AccessController.doPrivileged(Native Method) at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:100) at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:170)Caused by: com.sap.ip.bi.base.service.connection.ConnectionException: No connection exists for system "BI_DEV" at com.sap.ip.bi.base.portal.connection.PortalConnectionPool.getConnection(PortalConnectionPool.java:216) at com.sap.ip.bi.base.service.connection.impl.GenericConnectionPool.getMasterSystemConnection(GenericConnectionPool.java:64) ... 44 moreCaused by: com.sap.mw.jco.JCO$Exception: (101) RFC_ERROR_PROGRAM: 'user' missing at com.sap.mw.jco.MiddlewareJRfc.generateJCoException(MiddlewareJRfc.java:457) at com.sap.mw.jco.MiddlewareJRfc$Client.connect(MiddlewareJRfc.java:989) at com.sap.mw.jco.JCO$Client.connect(JCO.java:3193) at com.sapportals.connectors.SAPCFConnector.connection.SAPCFConnectorManagedConnection.connectWithJCO(SAPCFConnectorManagedConnection.java:411) at com.sapportals.connectors.SAPCFConnector.connection.SAPCFConnectorManagedConnection.establishInitialConnection(SAPCFConnectorManagedConnection.java:209) at com.sapportals.connectors.SAPCFConnector.connection.SAPCFConnectorManagedConnection.init(SAPCFConnectorManagedConnection.java:188) at com.sapportals.connectors.SAPCFConnector.connection.SAPCFConnectorManagedConnectionFactory.createManagedConnection(SAPCFConnectorManagedConnectionFactory.java:129) at com.sap.engine.services.connector.jca.ConnectionHashSet.match(ConnectionHashSet.java:320) at com.sap.engine.services.connector.jca.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:189) at com.sapportals.connectors.SAPCFConnector.connection.SAPCFConnectorConnectionFactory.getConnectionEx(SAPCFConnectorConnectionFactory.java:155) at com.sap.portal.ivs.internalconnector.ConnectionProvider.getConnection(ConnectionProvider.java:302) at com.sap.portal.ivs.internalconnector.ConnectionProvider.getConnection(ConnectionProvider.java:259) at com.sapportals.portal.ivs.cg.ConnectorService.getConnection(ConnectorService.java:458) at com.sapportals.portal.ivs.cg.ConnectorService.getConnection(ConnectorService.java:87) at com.sap.ip.bi.base.portal.connection.PortalConnectionPool.getConnection(PortalConnectionPool.java:172) ... 45 more

Thanks,

Sharon Bartlet.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Sharon,

have you checked your installation? You can see the installation status in the support desk tool:

http://<servername>/irj/servlet/prt/portal/prtroot/com.sap.ip.bi.supportdesk.default

Notes:

917950: SAP NetWeaver 2004s: Setting Up BEx? Web (Overview)

888687: BEx Web Java: Analysis of communication/logon problems (Details)

937697: Usage of SAP NetWeaver BI Diagnostics & Support Desk Tool (Dump Comm. Settings plus Traces)

Best regards,

Marco

Former Member
0 Kudos

Presume doing se38 > RS_TEMPLATE_MAINTAIN > 0ANALYSIS_PATTERN > test web sheds no light.

The oss note is very good, 917950.

Cheers,

Pom

Former Member
0 Kudos

Hi Pom,

thanks for the reply. I tried to execute 0ANALYSIS_PATTERN and it came back with this error:

Technical Information for Message:

Error loading template 0ANALYSIS_PATTERN

Notification Number BRAIN 276

Any ideas?

Many thanks,

Sharon.

Former Member
0 Kudos

This talks abt your error ,however its in german

Hinweis 1014795 - Fehler BRAIN 276 beim Ausführen eines Web Templates

Hope it Helps

Chetan

@CP..