-
a1ex 小试身手Lv3
发表于2018-12-11 11:22
悬赏1
已解决
楼主
BI数据库连接池装载数据库视图异常,读取表正常。此数据库使用SQLserver连接一切正常读取。
什么原因?
什么原因?
最佳答案
a1ex 发表于 2018-12-11 11:46
BI: V4.2.2R25-build20160301203507
JDK: 1.7.0_25
Tomcat: 7
这个应该是兼容性导致的问题,jdk和tomcat版本对于BI422的版本都太高了,建议换成jdk1.6和tomcat5或者tomcat6.
12个回答
BI版本 中间件(类似tomcat、weblogic这种)版本、jdk、数据库版本多少?用的什么浏览器?
缱绻 发表于 2018-12-11 11:31
BI版本 中间件(类似tomcat、weblogic这种)版本、jdk、数据库版本多少?用的什么浏览器? ...
浏览器Chrome70,Tomcat中间件这些没有问题,因为其他数据库(sqlserv) 能正常读取。
a1ex 发表于 2018-12-11 11:33
浏览器Chrome70,Tomcat中间件这些没有问题,因为其他数据库(sqlserv) 能正常读取。 ...
您告诉我下版本 我看下是否兼容,不确定是否是兼容性导致的问题
缱绻 发表于 2018-12-11 11:38
您告诉我下版本 我看下是否兼容,不确定是否是兼容性导致的问题
BI: V4.2.2R25-build20160301203507
JDK: 1.7.0_25
Tomcat: 7
服务器: Windows Server 2008 R2
sqlserver: 10.50.1600
浏览器: Chrome-70
备注:sqlserver 11.00.3000, 10.00.1600 都正常
a1ex 发表于 2018-12-11 11:46
BI: V4.2.2R25-build20160301203507
JDK: 1.7.0_25
Tomcat: 7
不知道是不是chrome版本太高了,你换ie浏览器看看,就这一个库的视图装载不进来吗?后台有没有报错啊,有的话把日志文件贴上来下看看
缱绻 发表于 2018-12-11 11:56
不知道是不是chrome版本太高了,你换ie浏览器看看,就这一个库的视图装载不进来吗?后台有没有报错啊,有 ...
就是这个库视图无法装载,浏览器换为火狐也不行
缱绻 发表于 2018-12-11 13:39
清除中间件缓存,重启下服务器,后台有报错没,有的话把日志文件上传一下 ...
下面是异常信息
- 2018-12-11 13:53:40.712 [http-8080-1] WARN com.esen.weblib.action.Action_Js null
- java.lang.NullPointerException: null
- at com.esen.platform.resource.impl.ResourceIdDefault.listChildren(ResourceIdDefault.java:95) ~[ResourceIdDefault.class:na]
- at com.esen.platform.resource.impl.PlatFormResource.listChildren(PlatFormResource.java:57) ~[PlatFormResource.class:na]
- at com.esen.platform.resource.impl.PlatFormResource.listChildren(PlatFormResource.java:26) ~[PlatFormResource.class:na]
- at com.esen.weblib.tree.ActionTree_AbstractTree.listChildren(ActionTree_AbstractTree.java:407) ~[ActionTree_AbstractTree.class:na]
- at com.esen.platform.action.ActionResourceTree.recListChildren(ActionResourceTree.java:140) ~[ActionResourceTree.class:na]
- at com.esen.weblib.tree.ActionTree_AbstractTree.listChildrenDocument(ActionTree_AbstractTree.java:165) ~[ActionTree_AbstractTree.class:na]
- at com.esen.weblib.tree.ActionTree_AbstractTree.doListChildren(ActionTree_AbstractTree.java:122) ~[ActionTree_AbstractTree.class:na]
- at com.esen.weblib.tree.ActionTree_AbstractTree.jsexecute(ActionTree_AbstractTree.java:69) ~[ActionTree_AbstractTree.class:na]
- at com.esen.weblib.action.Action_Js.jsexecute(Action_Js.java:282) ~[Action_Js.class:na]
- at com.esen.weblib.action.Action_Js.execute(Action_Js.java:73) ~[Action_Js.class:na]
- at com.esen.weblib.action.Action.handle(Action.java:64) ~[Action.class:na]
- at sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source) ~[na:na]
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.7.0_25]
- at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.7.0_25]
- at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219) ~[spring-web-3.2.3.RELEASE.jar:3.2.3.RELEASE]
- at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132) ~[spring-web-3.2.3.RELEASE.jar:3.2.3.RELEASE]
- at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) ~[spring-webmvc-3.2.3.RELEASE.jar:3.2.3.RELEASE]
- at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745) ~[spring-webmvc-3.2.3.RELEASE.jar:3.2.3.RELEASE]
- at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686) ~[spring-webmvc-3.2.3.RELEASE.jar:3.2.3.RELEASE]
- at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80) ~[spring-webmvc-3.2.3.RELEASE.jar:3.2.3.RELEASE]
- at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925) ~[spring-webmvc-3.2.3.RELEASE.jar:3.2.3.RELEASE]
- at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856) ~[spring-webmvc-3.2.3.RELEASE.jar:3.2.3.RELEASE]
- at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936) ~[spring-webmvc-3.2.3.RELEASE.jar:3.2.3.RELEASE]
- at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:838) ~[spring-webmvc-3.2.3.RELEASE.jar:3.2.3.RELEASE]
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) ~[servlet-api.jar:na]
- at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812) ~[spring-webmvc-3.2.3.RELEASE.jar:3.2.3.RELEASE]
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) ~[servlet-api.jar:na]
- at com.esen.platform.web.ReleasabledServlet.service(ReleasabledServlet.java:93) ~[ReleasabledServlet.class:na]
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) ~[catalina.jar:6.0.36]
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) ~[catalina.jar:6.0.36]
- at com.esen.bi.jsp.filter.NoBackendActionFilter.doFilter(NoBackendActionFilter.java:40) ~[NoBackendActionFilter.class:na]
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) ~[catalina.jar:6.0.36]
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) ~[catalina.jar:6.0.36]
- at com.esen.bi.jsp.filter.EsmainActionFilter.doFilter(EsmainActionFilter.java:50) ~[EsmainActionFilter.class:na]
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) ~[catalina.jar:6.0.36]
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) ~[catalina.jar:6.0.36]
- at com.esen.platform.action.FilterLoginCheck.doFilter(FilterLoginCheck.java:94) ~[FilterLoginCheck.class:na]
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) ~[catalina.jar:6.0.36]
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) ~[catalina.jar:6.0.36]
- at com.esen.platform.web.PlatformLocaleContextFilter.doFilter(PlatformLocaleContextFilter.java:47) ~[PlatformLocaleContextFilter.class:na]
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) ~[catalina.jar:6.0.36]
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) ~[catalina.jar:6.0.36]
- at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) ~[spring-web-3.2.3.RELEASE.jar:3.2.3.RELEASE]
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-3.2.3.RELEASE.jar:3.2.3.RELEASE]
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) ~[catalina.jar:6.0.36]
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) ~[catalina.jar:6.0.36]
- at com.esen.platform.sso.SSODelegatingFilter.doFilter(SSODelegatingFilter.java:43) ~[SSODelegatingFilter.class:na]
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) ~[catalina.jar:6.0.36]
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) ~[catalina.jar:6.0.36]
- at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) ~[catalina.jar:6.0.36]
- at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) ~[catalina.jar:6.0.36]
- at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) ~[catalina.jar:6.0.36]
- at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) ~[catalina.jar:6.0.36]
- at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) ~[catalina.jar:6.0.36]
- at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) ~[catalina.jar:6.0.36]
- at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861) ~[tomcat-coyote.jar:6.0.36]
- at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606) ~[tomcat-coyote.jar:6.0.36]
- at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) ~[tomcat-coyote.jar:6.0.36]
- at java.lang.Thread.run(Unknown Source) ~[na:1.7.0_25]