Error in New Discussions Channel

Hi experts,

We are facing a error with new discussion channel, that shows the massage "The query can not be executed. Contact your system administrator." in the Home page. We are facing this error for a specific user only. Rest users are able to see the discussions list.

Can anyone point out this error?

SAP Managed Tags:
SAP Sourcing and SAP Contract Lifecycle Management

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (1)

Hello,

If the query doesn’t work only certain users, it could be an access issue. I would check if there are any access restrictions on the report itself. You can find it on the Access List tab of the report. I believe the report you are referring to is FCI-DiscChannel.

Regards,

Vikram

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Vikram

The Access List tab is empty for all reports. Comparing the user accounts, I can't see differences between who can see and who cannot see.

Regards,

Adilson

Based on the description of the problem, I still think it is some type of access issue. If you are sure there is nothing in the Access List tab, then the next step would be look at the Sourcing debug logs and look at the error message. Also, for this specific user, does other reports in the system work?

Regards,

Vikram

I've checked the access, but I can't see problems.. simulating reports combination, I changed the Report from FCI-DiscChannel to FCI-DiscChannelAdv and the Detailed Report from FCI-DiscChannelAdv to FCI-DiscChannel and now the user can see the list, but I don't think that this is the correct list.

Vikram,

I got the log details, is it?

Log Record Details

Message: Facility=local4;sessionid=83s8At0C8tuvDbNODSzhYUdxfjJqPgGK_rcA_SAP;tenantid=#tenant.votorantim#;username=M3FRANCIELLE [XGLCARGA];exception=com.sap.odp.api.common.exception.ApplicationException: The query can not be executed. Contact your system administrator.;stacktrace=com.sap.odp.api.common.exception.ApplicationException: The query can not be executed. Contact your system administrator.

at com.sap.odp.comp.query.QueryDefinitionBo.substituteSqlException(QueryDefinitionBo.java:3285)

at com.sap.odp.comp.query.QueryDefinitionBo.executeSQLQuery(QueryDefinitionBo.java:3074)

at com.sap.odp.comp.query.QueryDefinitionBo.execute(QueryDefinitionBo.java:1909)

at com.sap.odp.comp.query.limbo.StandardFilterQueryLIMBO.initialize(StandardFilterQueryLIMBO.java:741)

at com.sap.odp.comp.query.limbo.StandardFilterQueryLIMBO.initialize(StandardFilterQueryLIMBO.java:347)

at com.sap.odp.comp.query.limbo.StandardFilterQueryLIMBO.initialize(StandardFilterQueryLIMBO.java:341)

at com.sap.odp.comp.query.limbo.ChartQueryLIMBO.initialize(ChartQueryLIMBO.java:160)

at com.sap.odp.comp.query.imbo.AbsMultiQueryIMBO.initializeHook(AbsMultiQueryIMBO.java:685)

at com.sap.odp.doc.display.imbo.AbsIMBO.initialize(AbsIMBO.java:305)

at com.sap.odp.display.util.IMBOTransformer.executeIMBO(IMBOTransformer.java:436)

at com.sap.odp.display.util.IMBOTransformer.processNode(IMBOTransformer.java:223)

at com.sap.odp.display.util.IMBOTransformer.processNode(IMBOTransformer.java:275)

at com.sap.odp.display.util.IMBOTransformer.getTransformedXML(IMBOTransformer.java:161)

at com.sap.odp.display.util.IMBOTransactionThread.processRequest(IMBOTransactionThread.java:352)

at com.sap.odp.display.util.IMBOFrameworkProcessor.processRequest(IMBOFrameworkProcessor.java:354)

at com.sap.odp.display.servlet.IMBOFrameworkServlet.doPost(IMBOFrameworkServlet.java:79)

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

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

at com.sap.engine.services.servlets_jsp.server.Invokable.invoke(Invokable.java:140)

at com.sap.engine.services.servlets_jsp.server.runtime.RequestDispatcherImpl.doCached(RequestDispatcherImpl.java:517)

at com.sap.engine.services.servlets_jsp.server.runtime.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:356)

at com.sap.odp.display.util.IMBOTransactionThread.postProcess(IMBOTransactionThread.java:869)

at com.sap.odp.display.util.IMBOFrameworkProcessor.processRequest(IMBOFrameworkProcessor.java:397)

at com.sap.odp.display.servlet.IMBOFrameworkServlet.doPost(IMBOFrameworkServlet.java:79)

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

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

at com.sap.engine.services.servlets_jsp.server.Invokable.invoke(Invokable.java:140)

at com.sap.engine.services.servlets_jsp.server.Invokable.invoke(Invokable.java:37)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:494)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:299)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:399)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:388)

at com.sap.engine.services.servlets_jsp.filters.DSRWebContainerFilter.process(DSRWebContainerFilter.java:48)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.servlets_jsp.filters.ServletSelector.process(ServletSelector.java:84)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.servlets_jsp.filters.ApplicationSelector.process(ApplicationSelector.java:244)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.WebContainerInvoker.process(WebContainerInvoker.java:78)

at com.sap.engine.services.httpserver.chain.HostFilter.process(HostFilter.java:9)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.ResponseLogWriter.process(ResponseLogWriter.java:60)

at com.sap.engine.services.httpserver.chain.HostFilter.process(HostFilter.java:9)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.DefineHostFilter.process(DefineHostFilter.java:27)

at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.MonitoringFilter.process(MonitoringFilter.java:29)

at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.MemoryStatisticFilter.process(MemoryStatisticFilter.java:43)

at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.filters.DSRHttpFilter.process(DSRHttpFilter.java:42)

at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

at com.sap.engine.services.httpserver.server.Processor.chainedRequest(Processor.java:428)

at com.sap.engine.services.httpserver.server.Processor$FCAProcessorThread.process(Processor.java:247)

at com.sap.engine.services.httpserver.server.rcm.RequestProcessorThread.run(RequestProcessorThread.java:45)

at com.sap.engine.core.thread.execution.Executable.run(Executable.java:122)

at com.sap.engine.core.thread.execution.Executable.run(Executable.java:101)

at com.sap.engine.core.thread.execution.CentralExecutor$SingleThread.run(CentralExecutor.java:327)

;New Discussions

com.sap.odp.api.common.exception.ApplicationException: The query can not be executed. Contact your system administrator.