麦粉社区
>
帖子详情

[问题求助]电子表格接入项目后出现报错

电子表格 发表于 2022-3-17 13:48
发表于 2022-3-17 13:48:59

将三张不同的电子表格嵌入到一个页面的不同tab下时出现报错,错误只要刷新一次就会消失,请问有什么解决方法嘛?

发表于 2022-3-17 13:52:31
你那边有做单点登陆吗?这个提示一般是没有做单点登录,同时打开了多个报表资源,并且每个资源的url中都拼接了user和password参数导致的~
你截图点开栈信息看看呢~
  •   clay
    version:	2020-11-06 20:54:14
    packageinfo:	Hotfix_Primeton_iData_20201104 
    
    
    参数面板ClientID错误:Iff808081017f90219021894f017f964f37ea526a
    	at smartbi.param.ParameterPanelService.getParameterPanel(ParameterPanelService.java:595)
    	at smartbi.param.ParameterPanelService.setParamValue(ParameterPanelService.java:114)
    	at sun.reflect.GeneratedMethodAccessor1015.invoke(Unknown Source)
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    	at java.lang.reflect.Method.invoke(Method.java:497)
    	at smartbi.framework.rmi.ClientService.execute(Smartbi:118)
    	at smartbi.framework.rmi.RMIServlet.processExecute(RMIServlet.java:223)
    	at smartbi.framework.rmi.RMIServlet.doPost(RMIServlet.java:161)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:178)
    	at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:167)
    	at smartbi.security.patch.PatchFilter.doFilter(PatchFilter.java:77)
    	at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:167)
    	at smartbi.extension.ExtensionFilter.doFilterInternal(ExtensionFilter.java:190)
    	at smartbi.extension.ExtensionFilter.doFilter(ExtensionFilter.java:76)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at smartbi.framework.rmi.TransactionFilter.doFilter(Smartbi:126)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at smartbi.freequery.filter.GZIPFilter.doFilter(GZIPFilter.java:189)
    	at smartbi.freequery.filter.Filter.doFilter(Filter.java:36)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at smartbi.freequery.filter.CheckIsLoggedFilter.doFilter(CheckIsLoggedFilter.java:215)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at smartbi.freequery.filter.CheckRefererFilter.doFilter(CheckRefererFilter.java:40)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at smartbi.freequery.filter.CheckHttpMethodFilter.doFilter(CheckHttpMethodFilter.java:57)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at smartbi.freequery.filter.TraceFilter.doFilter(TraceFilter.java:61)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at smartbi.framework.RedisSessionFilter.doFilter(Smartbi:106)
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:196)
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
    	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
    	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:698)
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:364)
    	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:624)
    	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
    	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831)
    	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1650)
    	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
    	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
    	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
    	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    	at java.lang.Thread.run(Thread.java:745)
    栈信息里是这样的。
    2022-3-17 13:54| 回复
  •   茶语
     回复 clay
    这个你看看是否有写宏的呢?若是有禁用宏再打开报表看看~
    2022-3-17 14:10| 回复
  •   clay
     回复 茶语
    禁用宏之后 每个报表页面都是不同的错误 一个是空白 一个是内部错误 还有一个请重新登录 同样只要刷新一次就正常了
    2022-3-17 14:18| 回复
  •   clay
     回复 茶语
    又尝试使用了另一个浏览器 还是之前一样的ClientId错误
    2022-3-17 14:20| 回复

回复

使用道具 举报

发表于 2022-3-17 15:46:17
可以把具体如何嵌入到同个页面的方式具体截图看看
  •   clay
    就是通过iframe嵌入的
    2022-3-17 16:57| 回复
  •   茶语
     回复 clay
    这样设置是会存在问题的,这三个请求第一次访问时可能会存在会话冲突导致重新登录,建议先通过一个请求获取和smartbi的会话,再进行打开报表的请求~
    2022-3-17 17:49| 回复
  •   clay
     回复 茶语
    你好!现在是通过第一个地址传递的用户名密码 在我们系统的测试环境上是没有问题的,但是导入到正式环境之后又出现了类似的问题,也是只需要刷新一下就没有问题了 详细的情况见截图
    2022-3-23 10:15| 回复

回复

使用道具 举报

高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

9回帖数 0关注人数 2200浏览人数
最后回复于:2022-3-17 15:46
快速回复 返回顶部 返回列表