麦粉社区
>
帖子详情

V10数据模型预览数据时报错 连接多维查询引擎失败,请联系管理

数据准备 发表于 2022-11-25 12:32
发表于 2022-11-25 12:32:03

V10数据模型预览数据时报错 如下:  这个需要怎么解决


version:    2022-11-08 16:12:40
packageinfo:    Hotfix_SmartbiV10_5_8_20221102 



连接多维查询引擎失败,请联系管理员:I/O error on POST request for "http://localhost:18081/smartbiolap/smartbiquery": Connection refused: connect; nested exception is java.net.ConnectException: Connection refused: connect
    at smartbix.augmenteddataset.util.AugmentedDataSetException.create(AugmentedDataSetException.java:34)
    at smartbix.augmenteddataset.olap.impl.OlapQueryService.createException(OlapQueryService.java:588)
    at smartbix.augmenteddataset.olap.impl.OlapQueryService.executeQuery(OlapQueryService.java:517)
    at smartbix.augmenteddataset.olap.impl.OlapQueryService$$FastClassBySpringCGLIB$$d01e6225.invoke()
    at smartbixlibs.org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
    at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
    at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
    at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
    at smartbixlibs.org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
    at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
    at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
    at smartbix.augmenteddataset.olap.impl.OlapQueryService$$EnhancerBySpringCGLIB$$d421eebd.executeQuery()
    at smartbix.augmenteddataset.query.mondrian.MondrianQueryExecutor.getData(MondrianQueryExecutor.java:33)
    at smartbix.augmenteddataset.handler.DefaultAugmentedDataSetHandler.getDataSetData(DefaultAugmentedDataSetHandler.java:91)
    at smartbix.augmenteddataset.service.AugmentedDataSetQueryService.getDataSetData(AugmentedDataSetQueryService.java:224)
    at smartbix.augmenteddataset.service.AugmentedDataSetQueryService$$FastClassBySpringCGLIB$$3c7d00ce.invoke()
    at smartbixlibs.org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
    at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
    at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
    at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
    at smartbixlibs.org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
    at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
    at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
    at smartbix.augmenteddataset.service.AugmentedDataSetQueryService$$EnhancerBySpringCGLIB$$33e4e4a1.getDataSetData()
    at smartbix.smartbi.AugmentedDataSetForVModule.getDataSetData(AugmentedDataSetForVModule.java:695)
    at smartbix.smartbi.AugmentedDataSetForVModule.getPreviewDataSetData(AugmentedDataSetForVModule.java:672)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at smartbi.framework.rmi.ClientService.executeInternal(ClientService.java:138)
    at smartbi.framework.rmi.ClientService.execute(ClientService.java:120)
    at smartbi.framework.rmi.RMIServlet.processExecute(RMIServlet.java:207)
    at smartbi.framework.rmi.RMIServlet.doPost(RMIServlet.java:132)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:682)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:765)
    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:283)
    at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:264)
    at smartbi.security.patch.PatchFilter.doFilter(PatchFilter.java:77)
    at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:264)
    at smartbi.extension.ExtensionFilter.doFilterInternal(ExtensionFilter.java:296)
    at smartbi.extension.ExtensionFilter.doFilter(ExtensionFilter.java:117)
    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:71)
    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:237)
    at smartbi.freequery.filter.Filter.doFilter(Filter.java:33)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at smartbi.freequery.filter.ExceptionResponseFilter.doFilter(ExceptionResponseFilter.java:85)
    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:236)
    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:45)
    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:62)
    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:62)
    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(RedisSessionFilter.java:122)
    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:197)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
    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:367)
    at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:639)
    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:882)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1693)
    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:748)
    Suppressed: smartbixlibs.org.springframework.web.client.ResourceAccessException: I/O error on POST request for "http://localhost:18081/smartbiolap/smartbiquery": Connection refused: connect; nested exception is java.net.ConnectException: Connection refused: connect
        at smartbixlibs.org.springframework.web.client.RestTemplate.doExecute(RestTemplate.java:785)
        at smartbixlibs.org.springframework.web.client.RestTemplate.execute(RestTemplate.java:751)
        at smartbixlibs.org.springframework.web.client.RestTemplate.postForObject(RestTemplate.java:459)
        at smartbix.augmenteddataset.olap.impl.OlapQueryService.getOlapQueryResponse(OlapQueryService.java:861)
        at smartbix.augmenteddataset.olap.impl.OlapQueryService$$FastClassBySpringCGLIB$$d01e6225.invoke()
        at smartbixlibs.org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
        at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
        at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
        at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
        at smartbixlibs.org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:102)
        at smartbix.smartbi.service.OlapQueryServiceHandler.getOlapQueryResponse(OlapQueryServiceHandler.java:66)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at smartbixlibs.org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:634)
        at smartbixlibs.org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:624)
        at smartbixlibs.org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:72)
        at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
        at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
        at smartbixlibs.org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
        at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
        at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
        at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
        at smartbix.augmenteddataset.olap.impl.OlapQueryService$$EnhancerBySpringCGLIB$$d421eebd.getOlapQueryResponse()
        at smartbix.augmenteddataset.olap.impl.OlapQueryService.executeQuery(OlapQueryService.java:507)
        ... 90 more
    Caused by: java.net.ConnectException: Connection refused: connect
        at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
        at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85)
        at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
        at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
        at java.net.Socket.connect(Socket.java:589)
        at sun.net.NetworkClient.doConnect(NetworkClient.java:175)
        at sun.net.www.http.HttpClient.openServer(HttpClient.java:463)
        at sun.net.www.http.HttpClient.openServer(HttpClient.java:558)
        at sun.net.www.http.HttpClient.(HttpClient.java:242)
        at sun.net.www.http.HttpClient.New(HttpClient.java:339)
        at sun.net.www.http.HttpClient.New(HttpClient.java:357)
        at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:1220)
        at sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1156)
        at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:1050)
        at sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:984)
        at smartbixlibs.org.springframework.http.client.SimpleBufferingClientHttpRequest.executeInternal(SimpleBufferingClientHttpRequest.java:76)
        at smartbixlibs.org.springframework.http.client.AbstractBufferingClientHttpRequest.executeInternal(AbstractBufferingClientHttpRequest.java:48)
        at smartbixlibs.org.springframework.http.client.AbstractClientHttpRequest.execute(AbstractClientHttpRequest.java:66)
        at smartbixlibs.org.springframework.http.client.BufferingClientHttpRequestWrapper.executeInternal(BufferingClientHttpRequestWrapper.java:63)
        at smartbixlibs.org.springframework.http.client.AbstractBufferingClientHttpRequest.executeInternal(AbstractBufferingClientHttpRequest.java:48)
        at smartbixlibs.org.springframework.http.client.AbstractClientHttpRequest.execute(AbstractClientHttpRequest.java:66)
        at smartbixlibs.org.springframework.http.client.InterceptingClientHttpRequest$InterceptingRequestExecution.execute(InterceptingClientHttpRequest.java:109)
        at smartbix.augmenteddataset.interceptor.LoggingClientHttpRequestInterceptor.intercept(LoggingClientHttpRequestInterceptor.java:31)
        at smartbixlibs.org.springframework.http.client.InterceptingClientHttpRequest$InterceptingRequestExecution.execute(InterceptingClientHttpRequest.java:93)
        at smartbixlibs.org.springframework.http.client.InterceptingClientHttpRequest.executeInternal(InterceptingClientHttpRequest.java:77)
        at smartbixlibs.org.springframework.http.client.AbstractBufferingClientHttpRequest.executeInternal(AbstractBufferingClientHttpRequest.java:48)
        at smartbixlibs.org.springframework.http.client.AbstractClientHttpRequest.execute(AbstractClientHttpRequest.java:66)
        at smartbixlibs.org.springframework.web.client.RestTemplate.doExecute(RestTemplate.java:776)
        ... 115 more

发表于 2022-11-25 12:32:04
一般是多维引擎没有启动成功,或者没有部署多维引擎导致
如果你是exe一键安装的,可以参考排查:
1、服务下检查Smartbi_OLAP_Server启动没有,没有就启一下
70712638060a781d24.png
2、如果还是报错,可以在安装目录下以管理员身份执行startup_olap.cmd脚本
6688638060db110e1.png
3、进入http://IP:端口/smartbiolap/manager/index.jsp页面,改一下ip端口,看能不能访问成功
305686380617a637d8.png

回复

使用道具 举报

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

本版积分规则

2回帖数 1关注人数 1253浏览人数
最后回复于:2022-11-25 14:32
快速回复 返回顶部 返回列表