on 04-18-2014 9:12 PM
Hi
I'm getting below errors when I'm trying to connect thru UNX from Excel using "POWER QUERY" add-on.
I was successfully able to logon to BI Server and view all UNX universes in Navigator. But when I select the UNX file, it is giving me below error.
Could anyone help to resolve this issue.
I'm on BI 4.1 SP3: with MS Office 2013.
ERROR:
SapBusinessObjects: com.sap.sl.sdk.conso.StarLightException: An internal error occurred while calling 'getSessionInfosEx' API. (Error: ERR_WIS_30270)
at com.sap.sl.sdk.conso.SlActionDispatcher.handleUnexpectedError(SlActionDispatcher.java:17)
at com.sap.webi.raylight.actions.ActionDispatcher.invoke(ActionDispatcher.java:117)
at com.sap.sl.sdk.conso.SlConsoUniverse.getUniverse(SlConsoUniverse.java:57)
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:597)
at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:173)
at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:89)
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:164)
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:242)
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:242)
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:91)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106)
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:255)
at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:113)
at org.apache.cxf.transport.servlet.ServletDestination.invoke(ServletDestination.java:102)
at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:464)
at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:149)
at com.sap.bip.rs.server.servlet.BIPServletController.invoke(BIPServletController.java:93)
at org.apache.cxf.transport.servlet.AbstractCXFServlet.invoke(AbstractCXFServlet.java:148)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:179)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doGet(AbstractHTTPServlet.java:108)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:159)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at com.businessobjects.sdk.actionfilter.WorkflowFilter.doFilter(WorkflowFilter.java:45)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:761)
Caused by: java.lang.reflect.InvocationTargetException
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:597)
at com.sap.webi.raylight.actions.ActionInvoker.invokeWith(ActionInvoker.java:123)
at com.sap.webi.raylight.actions.ActionDispatcher.invoke(ActionDispatcher.java:105)
... 47 more
Caused by: com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException: An internal error occurred while calling 'getSessionInfosEx' API. (Error: ERR_WIS_30270)
at com.businessobjects.sdk.core.exception.ExceptionBuilder.make(ExceptionBuilder.java:152)
at com.businessobjects.sdk.core.exception.ExceptionBuilder.make(ExceptionBuilder.java:109)
at com.businessobjects.sdk.core.server.common.CommonRequestHandler.afterProcessing(CommonRequestHandler.java:127)
at com.businessobjects.sdk.core.server.internal.AbstractServer.processIt(AbstractServer.java:178)
at com.businessobjects.sdk.core.server.internal.AbstractServer.process(AbstractServer.java:133)
at com.businessobjects.sdk.core.server.internal.InstanceServer.process(InstanceServer.java:94)
at com.sap.sl.sdk.services.util.ServerRequestProcessor.processServerRequest(ServerRequestProcessor.java:49)
at com.sap.sl.sdk.workspace.service.internal.WorkspaceLoadingService.processWorkspaceRequest(WorkspaceLoadingService.java:99)
at com.sap.sl.sdk.datasource.service.internal.DataSourceLoadingService.loadDataSourceFromServer(DataSourceLoadingService.java:221)
at com.sap.sl.sdk.dataprovider.service.DataProviderServiceImpl.loadDataSource(DataProviderServiceImpl.java:167)
at com.sap.sl.sdk.dataprovider.service.DataProviderServiceImpl.getDataSource(DataProviderServiceImpl.java:92)
at com.sap.sl.sdk.conso.SlSdkHelper.getDataSource(SlSdkHelper.java:227)
at com.sap.sl.sdk.conso.GetUniverseByIdAction.execute(GetUniverseByIdAction.java:49)
... 53 more
Caused by: com.businessobjects.sdk.core.server.ServerException: An internal error occurred while calling 'getSessionInfosEx' API. (Error: ERR_WIS_30270)
at com.businessobjects.sdk.core.server.common.CommonRequestHandler.newServerException(CommonRequestHandler.java:260)
at com.businessobjects.sdk.core.server.common.CommonRequestHandler.createAllServerExceptions(CommonRequestHandler.java:238)
at com.businessobjects.sdk.core.server.common.CommonRequestHandler.afterProcessing(CommonRequestHandler.java:121)
... 63 more
Thanks
Venkat
HI
Please check the below links and Note’s
http://www.upenn.edu/computing/da/bo/webi/qna/iv_webi_ERR_WIS_30270.html
Note 1497849 - "An internal error occured while calling 'executeDrillAction' API. (Error: ERR_WIS_30270)" when drilling up on a dimension of a webi report based on BW
Note 1290720 - Error: An Internal error occured while calling 'SubmitReport' API (Error: ERR_WIS_30270) while refreshing migrated WebIntelligence reports in edit mode
Note 1436964 - An internal error occured while calling 'processDPCommands' API. (Error: ERR_WIS_30270)
how to increase swap timeout:
https://bosap-support.wdf.sap.corp/sap/support/notes/1308143
https://bosap-support.wdf.sap.corp/sap/support/notes/1417838
I think it's related to server connectivity error. please check with basis team or Finally try to new installation
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Thank you Srinivasulu.
But I don't have problem with connectivity. I was able to connect to BI server on port :6405/biprws and available to see unx universes from EXCEL Navigator.
But I couldn't see the classes and objects in UNX from EXCEL.
I don't have any issues from connecting to BI Platform thru Java Code using RESTFul Webservices and browse the universes or reports.
Can anyone help me to fix this issue.
Thanks
Venkat
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.