VC Error while executing query - "no specific exception"

[Former Member]

Hi,

I am trying to execute a query in BW 3.5 from VC. I have tested the SAP_BW connector fine within the portal. When i try executing the query from BI query Wizard i get error stating

Error -30210: Cannot execute query. No result returned or XML returned in the result contains an error. no specific exception.

Please advice on this

Regards

Message was edited by: Unni Krishnan

server log displayed an error

Error#1#/System/Server#Java###null

[EXCEPTION]

#1#java.lang.ClassCastException

at com.sap.portal.guimachine.bikit.query.resultset.QueryView.<init>(QueryView.java:73)

at com.sap.portal.guimachine.bikit.designtime.BexOpenDialog.execute(BexOpenDialog.java:266)

at com.sap.portal.guimachine.bikit.designtime.BIConnectionDiscover.getConnectorData(BIConnectionDiscover.java:106)

at com.sap.portal.guimachine.bikit.designtime.BIConnectionDiscover.discoverBI(BIConnectionDiscover.java:68)

at com.sap.portal.guimachine.bikit.designtime.CommandHandlerImpl.doBidiscovery(CommandHandlerImpl.java:30)

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

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

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

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

at com.sap.guimachine.portalconnector.commandhandler.AbstractCommandService.invoke(AbstractCommandService.java:84)

at com.sap.guimachine.portalconnector.dispatcher.Dispatcher.handleCommandHandler(Dispatcher.java:197)

at com.sap.guimachine.portalconnector.dispatcher.Dispatcher.doContent(Dispatcher.java:122)

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:95)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:160)

#

Message was edited by: Unni Krishnan

[Former Member]

Hi All,

This was resolved.. It was the order of applying the patch which caused the problem

com.sap.visualcomposer.sda

com.sap.visualcomposer.BIKit.sda

com.sap.visualcomposer.BIKitQV.ear

com.sap.visualcomposer.portalcontent.sda

Thanks all...

[Former Member]

Hi Unni,

Have you deployed the BIKit in the portal?

Moreover try this step also...........

Open your VC Storyboard.

Go to Tools -> Options.

Go to Portal tab in the option box.

Set the url of : BW Query ViewWS URL Suffix same as that in the BW Server, for eg:- /sap/bw/xml/soap/queryview

Thanks in advance,

Deep

[Former Member]

Hi Deep.

Yes i have deployed the BUIKit in portal also checked the BW Query ViewWS URL Suffix , which is same as in the BW server.

One thing i was trying was undeployemnt of BUIKit.ear & redeploying the latest from the V.C 6.0 patch. But while undeployment i saw an error

#3#sap.com/com.sap.visualcomposer.BIKitQV#com.sap.engine.frame.core.configuration.NameNotFoundException#A configuration with the path "webservices/services/sap.com/com.sap.visualcomposer.BIKitQV" does not exist.#

#1.5#00132165329D003F000000360000347800040F8EFB9CA932#1143006688075#com.sap.engine.services.security##com.sap.engine.services.security#Administrator#903####e73289f1b96711dac57a00132165329d#SAPEngine_Application_Thread[impl:3]_24##0#0#Error#1#/System/Security#Plain### [permissions_collection_operator]: domain[apps//sap.com/com.sap.visualcomposer.BIKitQV/webservices_container/wsClients/app_jars/_NWBIKit_Queryview.jar] not removed, because is not registered#

#1.5#00132165329D003F000000390000347800040F8EFB9CB1FD#1143006688075#com.sap.engine.services.security##com.sap.engine.services.security#Administrator#903####e73289f1b96711dac57a00132165329d#SAPEngine_Application_Thread[impl:3]_24##0#0#Error#1#/System/Security#Plain### [permissions_collection_operator]: domain[apps//sap.com/com.sap.visualcomposer.BIKitQV/webservices_container/wsClients/ws_cl_0/jars/com.sap.portal.guimachine.bikit.queryview.BWQueryview.jar] not removed, because is not registered#

#1.5#00132165329D003F0000003C0000347800040F8EFB9CB464#1143006688075#com.sap.engine.services.security##com.sap.engine.services.security#Administrator#903####e73289f1b96711dac57a00132165329d#SAPEngine_Application_Thread[impl:3]_24##0#0#Error#1#/System/Security#Plain### [permissions_collection_operator]: domain[sap.com/com.sap.visualcomposer.BIKitQV] not removed, because is not registered#

Regards