九月上旬更新速递丨 AI赋能、技术实战与智能探索

AI浪潮席卷,九月更新携智能发布会、实战经验与开发进阶强势登场!助您紧跟技术前沿,玩转数据智能!

重点推荐AI发布会火热预热!Agent BI是什么?Smartbi AIChat 全新升级发布会为您揭晓!

现有预热活动【智能体降临,未来已来!】解锁Smartbi AIChat V4超能力,参与即有机会赢专属好礼,抢先体验AI新纪元!更推出全新《十分钟完整体验AIchat》课程视频,仅需10分钟,即可使用本地数据快速体验AIChat全部功能,轻松入门智能分析!

一、任务持续上线

特征工程和数据预处理有什么区别?强化记忆,巩固学习成果。
SmartBI玩转Top N分析,轻松揪出数据》→检验分析能力,突破业务洞察瓶颈。

二、实战技巧分享

SmartBI同比环比分析大揭秘:让数据“笑”出真相!》→让数据不再沉闷,让趋势跃然纸上!

SmartBI玩转Top N分析,轻松揪出数据"尖子生"!》→面对海量数据,如何高效地提取最有价值的信息,快速识别关键数据项

、开发技能突破

扩展包简介→通过了解扩展包的实现原理和作用,让我们对扩展包有大致的认知。

四、AI每日一学

LLM 中的 Token 和 Embedding 到底是啥?》→深入浅出解析自然语言处理中的基础概念,夯实AI理解基石。

特征工程和数据预处理有什么区别?→厘清特征处理与数据清洗的边界,为模型训练铺平道路。

注意力机制、自注意力机制、多头注意力揭秘Transformer核心机制,助力理解现代AI模型架构。


为进一步提升认证服务的质量与体验,我们对认证业务进行全面优化升级。更多详情请看→Smartbi认证考试优化升级公告



麦粉社区
>
帖子详情

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关注人数 2313浏览人数
最后回复于:2022-11-25 14:32
快速回复 返回顶部 返回列表