cancel
Showing results for 
Search instead for 
Did you mean: 

Server error when requesting parameter info of Webi document

Former Member
0 Kudos
130

Hi,

We're writing an application on our BI4.1 SP02 environment in Java using the RESTful SDK and we're assumingly running into a security issue.

Using a user which is member of the administrators group, we can get all information. If on the other hand we use a user with limited rights, we get a 500 internal server error when we request the parameter information for a Webi document. Requesting the dataprovider information succeeds, but not the parameters or other detailed report information.

Can someone tell us on what and which rights the user needs to be able to get this document information?

We already tried giving full access on the documents and on the Webi application without success, please help us out or point to a group that might be able to help.

Regards

Guy

Accepted Solutions (1)

Accepted Solutions (1)

former_member197386
Active Contributor
0 Kudos

Hello Guy,

please, could you enable the "show stack trace" checkbox in WACS server properties, and copy the full stack trace you received?

Best regards,

Anthony

Former Member
0 Kudos

Hi Anthony,

This is the full stacktrace we get:

<error>

    <error_code>999</error_code>

    <message>Internal error (RaylightAction)</message>

    <stack_trace>com.sap.webi.raylight.RaylightException: Internal error (RaylightAction)&#13;

at com.sap.webi.raylight.context.Messenger.internalError(Messenger.java:83)&#13;

at com.sap.webi.raylight.actions.ActionDispatcher.handleUnexpectedError(ActionDispatcher.java:131)&#13;

at com.sap.webi.raylight.actions.ActionDispatcher.invoke(ActionDispatcher.java:117)&#13;

at com.sap.webi.raylight.RaylightServiceParameters.getParameters(RaylightServiceParameters.java:94)&#13;

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)&#13;

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)&#13;

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)&#13;

at java.lang.reflect.Method.invoke(Method.java:597)&#13;

at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:173)&#13;

at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:89)&#13;

at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:164)&#13;

at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:242)&#13;

at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:242)&#13;

at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:242)&#13;

at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:91)&#13;

at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)&#13;

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)&#13;

at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)&#13;

at java.util.concurrent.FutureTask.run(FutureTask.java:138)&#13;

at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)&#13;

at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106)&#13;

at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:255)&#13;

at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:113)&#13;

at org.apache.cxf.transport.servlet.ServletDestination.invoke(ServletDestination.java:102)&#13;

at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:464)&#13;

at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:149)&#13;

at com.sap.bip.rs.server.servlet.BIPServletController.invoke(BIPServletController.java:93)&#13;

at org.apache.cxf.transport.servlet.AbstractCXFServlet.invoke(AbstractCXFServlet.java:148)&#13;

at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:179)&#13;

at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doGet(AbstractHTTPServlet.java:108)&#13;

at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)&#13;

at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:159)&#13;

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)&#13;

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)&#13;

at com.businessobjects.sdk.actionfilter.WorkflowFilter.doFilter(WorkflowFilter.java:45)&#13;

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)&#13;

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)&#13;

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)&#13;

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)&#13;

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)&#13;

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)&#13;

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)&#13;

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)&#13;

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)&#13;

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)&#13;

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)&#13;

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)&#13;

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)&#13;

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)&#13;

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)&#13;

at java.lang.Thread.run(Thread.java:743)&#13;

Caused by: java.lang.reflect.InvocationTargetException&#13;

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)&#13;

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)&#13;

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)&#13;

at java.lang.reflect.Method.invoke(Method.java:597)&#13;

at com.sap.webi.raylight.actions.ActionInvoker.invokeWith(ActionInvoker.java:123)&#13;

at com.sap.webi.raylight.actions.ActionDispatcher.invoke(ActionDispatcher.java:105)&#13;

... 48 more&#13;

Caused by: com.businessobjects.sdk.core.server.CommunicationException$InvalidServerResponseException:  (Error: RWI 00200)&#13;

at com.businessobjects.sdk.core.exception.ExceptionBuilder.make(ExceptionBuilder.java:152)&#13;

at com.businessobjects.sdk.core.exception.ExceptionBuilder.make(ExceptionBuilder.java:109)&#13;

at com.businessobjects.rebean.wi.impl.engine.ReportEngineContext.initUserServer(ReportEngineContext.java:442)&#13;

at com.businessobjects.rebean.wi.impl.engine.ReportEngineContext.getUserFacade(ReportEngineContext.java:377)&#13;

at com.sap.webi.raylight.util.CmsRequestHelper.process(CmsRequestHelper.java:116)&#13;

at com.sap.webi.raylight.util.CmsRequestHelper.process(CmsRequestHelper.java:152)&#13;

at com.sap.webi.raylight.util.CmsRequestHelper.documentExist(CmsRequestHelper.java:57)&#13;

at com.sap.webi.raylight.context.RaylightContext.openDocument(RaylightContext.java:479)&#13;

at com.sap.webi.raylight.context.RaylightContext.getDocument(RaylightContext.java:416)&#13;

at com.sap.webi.raylight.context.RaylightContext.getDocument(RaylightContext.java:380)&#13;

at com.sap.webi.raylight.context.RaylightContext.getDocument(RaylightContext.java:114)&#13;

at com.sap.webi.raylight.business.ParameterHelper.&lt;init&gt;(ParameterHelper.java:147)&#13;

at com.sap.webi.raylight.actions.parameter.GetParametersAction.execute(GetParametersAction.java:26)&#13;

... 54 more&#13;

Caused by: com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException: IDL:CdzClusterMgmt/ClusterFacadeException:1.0&#13;

at com.businessobjects.sdk.core.exception.ExceptionBuilder.make(ExceptionBuilder.java:152)&#13;

at com.businessobjects.sdk.core.exception.ExceptionBuilder.make(ExceptionBuilder.java:109)&#13;

at com.businessobjects.sdk.core.server.internal.session.ConnectSessionCommand.execute(ConnectSessionCommand.java:108)&#13;

at com.businessobjects.sdk.core.server.internal.corba.CorbaServerImpl.doProcess(CorbaServerImpl.java:79)&#13;

at com.businessobjects.sdk.core.server.internal.AbstractServer.processIt(AbstractServer.java:171)&#13;

at com.businessobjects.sdk.core.server.internal.AbstractServer.process(AbstractServer.java:133)&#13;

at com.businessobjects.rebean.wi.impl.engine.ReportEngineContext.initUserServer(ReportEngineContext.java:405)&#13;

... 64 more&#13;

Caused by: com.businessobjects.common.CdzClusterMgmt.ClusterFacadeException: IDL:CdzClusterMgmt/ClusterFacadeException:1.0&#13;

at com.businessobjects.common.CdzClusterMgmt.ClusterFacadeExceptionHelper.read(Unknown Source)&#13;

at com.crystaldecisions.enterprise.ocaframework.idl.OCA.OCAcdz.WICDZServer._WICDZUserSessionStub.openSession(_WICDZUserSessionStub.java:69)&#13;

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)&#13;

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)&#13;

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)&#13;

at java.lang.reflect.Method.invoke(Method.java:597)&#13;

at com.crystaldecisions.enterprise.ocaframework.ManagedService.invoke(ManagedService.java:356)&#13;

at com.crystaldecisions.enterprise.ocaframework.idl.OCA.OCAcdz.WICDZServer._WICDZUserSessionProxy.openSession(_WICDZUserSessionProxy.java:753)&#13;

at com.businessobjects.rebean.wi.newserver.exec.WebiUserSessionExecutor.openSession(WebiUserSessionExecutor.java:23)&#13;

at com.businessobjects.sdk.core.server.internal.session.ConnectSessionCommand.execute(ConnectSessionCommand.java:94)&#13;

... 68 more&#13;

</stack_trace>

</error>

Regards

Guy

former_member197386
Active Contributor
0 Kudos

Could you send me your Webi server logs?

anthony.muller AT sap.com

Thanks and regards,

Anthony

Former Member
0 Kudos

Hello Anthony,

I continued my search and found out the problem was caused by the rights on the relational database connections. I've adapted the rights and now it works, thank you for the assistance and effort spend.

Kind regards

Guy


former_member197386
Active Contributor
0 Kudos

Thanks for sharing the resolution Guy!

Enjoy

Anthony

Answers (0)