AnsweredAssumed Answered

BO Clarity Integration - Error while running a report

Question asked by Manish_Narang on Jun 27, 2012
Latest reply on Feb 18, 2015 by Colum
Hi All,

I Integrated BO and Clarity in dev and test environments today. For our Test environment, we have LDAP configured in Clarity as well as in BO. Integration worked all fine. I faced login errors in the beginning, but then i was missing shared secret key when i gave that and restarted the services, it went all fine.

BUT, In the dev environment, we don't have LDAP configured in Clarity (it is there in BO Dev though). I followed the same steps, the NSA configuration and all, shared key is OK.

Now i have created admin account in BO with the same username and password as it is in CLARITY. But when i run Budget Forecast analysis report, it gives an error saying

[color=#dd2a2a]"Sorry, you do not have the right to 'Edit objects' (ID: 6) for 'Budget Forecast Analysis' (ID: 1785). Please contact your administrator if you require this right. "[color]

I have given almost all the rights in BO CMC to admin user (which is trying to run the report from Clarity), but still getting this error.

LOGS have the following:

ERROR 2012-06-27 08:10:18,437 [http-8081-2] xql2.xbl (admin:29156784__18554D7D_1382DB6CF94_-7FFE:nmc.executeAvailReport) Sorry, you do not have the right to 'Edit objects' (ID: 6) for 'Budget Forecast Analysis' (ID: 1785). Please contact your administrator if you require this right.
::com.crystaldecisions.sdk.occa.infostore.internal.InfoStoreException: Sorry, you do not have the right to 'Edit objects' (ID: 6) for 'Budget Forecast Analysis' (ID: 1785). Please contact your administrator if you require this right.

cause:com.crystaldecisions.enterprise.ocaframework.idl.OCA.oca_abuse: IDL:img.seagatesoftware.com/OCA/oca_abuse:3.2
detail:Sorry, you do not have the right to 'Edit objects' (ID: 6) for 'Budget Forecast Analysis' (ID: 1785). Please contact your administrator if you require this right.

The server supplied the following details: Security right violation encountered


at com.crystaldecisions.sdk.occa.infostore.internal.InfoStoreException.map(InfoStoreException.java:71)

at com.crystaldecisions.sdk.occa.infostore.internal.CommitResultInfo.<init>(CommitResultInfo.java:37)

at com.crystaldecisions.sdk.occa.infostore.internal.CommitError.<init>(CommitError.java:11)

at com.crystaldecisions.sdk.occa.infostore.internal.InternalInfoStore.packageCommitOutParams(InternalInfoStore.java:458)

at com.crystaldecisions.sdk.occa.infostore.internal.InternalInfoStore.commitHelper(InternalInfoStore.java:834)

at com.crystaldecisions.sdk.occa.infostore.internal.InternalInfoStore.commit(InternalInfoStore.java:230)

at com.crystaldecisions.sdk.occa.infostore.internal.InternalInfoStore.commit(InternalInfoStore.java:224)

at com.crystaldecisions.sdk.occa.infostore.internal.InternalInfoStore.commit(InternalInfoStore.java:212)

at com.crystaldecisions.sdk.occa.infostore.internal.InfoObject.save(InfoObject.java:1398)

at com.niku.reporting.bo.BOReporting.setReportLogons(BOReporting.java:812)

at com.niku.reporting.bo.BOReporting.scheduleReport(BOReporting.java:300)

at com.niku.reporting.bo.BOReporting.executeReport(BOReporting.java:235)

at com.niku.reporting.xbl.handlers.ExecuteReportHandler.postProcess(ExecuteReportHandler.java:38)

at com.niku.xql2.XQLVisitor.postProcess(XQLVisitor.java:1355)

at com.niku.union.xml.dom.DOMWalker.postProcess(DOMWalker.java:210)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:94)

at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)

at com.niku.xql2.handlers.TryHandler.preProcess(TryHandler.java:50)

at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1342)

at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)

at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:36)

at com.niku.xql2.XQLProcessor.process(XQLProcessor.java:239)

at com.niku.xql2.XQLProcessor.process(XQLProcessor.java:280)

at com.niku.xql2.binding.ServiceControlBindingXql.processFile(ServiceControlBindingXql.java:412)

at com.niku.xql2.binding.ServiceControlBindingXql.getDocument(ServiceControlBindingXql.java:277)

at com.niku.xql2.binding.ServiceControlBindingXql.processRequest(ServiceControlBindingXql.java:161)

at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:760)

at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:214)

at com.niku.union.web.WebServiceAdapter.processRequest(WebServiceAdapter.java:196)

at com.niku.union.web.PortletController.processServiceRequest(PortletController.java:1371)

at com.niku.union.web.PortletController.processAuthorizedPortlet(PortletController.java:891)

at com.niku.union.web.PortletController.processPageActionRequest(PortletController.java:385)

at com.niku.union.web.PortletController.processRequest(PortletController.java:160)

at com.niku.union.web.WebActionController.processAction(WebActionController.java:1090)

at com.niku.union.web.WebActionController.processRequest(WebActionController.java:170)

at com.niku.union.web.WebControlServlet.service(WebControlServlet.java:322)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.niku.union.web.filter.GZIPResponseFilter.doFilter(GZIPResponseFilter.java:121)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.niku.union.web.filter.CharsetFilter.doFilter(CharsetFilter.java:29)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)

at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859)

at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)

at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555)

at java.lang.Thread.run(Thread.java:619)
Caused by: com.crystaldecisions.enterprise.ocaframework.idl.OCA.oca_abuse: IDL:img.seagatesoftware.com/OCA/oca_abuse:3.2

at com.crystaldecisions.enterprise.ocaframework.idl.OCA.oca_abuseHelper.read(oca_abuseHelper.java:106)

at com.crystaldecisions.enterprise.ocaframework.idl.OCA.oca_abuseHelper.extract(oca_abuseHelper.java:57)

at com.crystaldecisions.sdk.occa.infostore.internal.InternalInfoStore.packageCommitOutParams(InternalInfoStore.java:457)

... 55 more::

Looking forward to all your inputs :)

Outcomes