cancel
Showing results for 
Search instead for 
Did you mean: 

Error in oDATA connection from Excel to UNX

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member4998
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi, Venkat!

I have similar problem nowadays.. and I don't have the right answer.

I understand that it was last year problem, but may be you have solved you problem and could share your solution?

Thanks in advance!

Regards,

Alena