解决生成的saiku文件读取中文乱码的问题

不念不忘少年蓝@ 2022-06-01 02:56 247阅读 0赞

![SouthEast][]

javax.ws.rs.WebApplicationException: org.saiku.service.util.exception.SaikuServiceException: org.saiku.service.util.exception.SaikuServiceException: Cannot get native cube for cube ( \[pda\].\[pdaTest\].\[pdaTest\].\[鑽簵鍒嗘瀽\] )

at org.saiku.web.rest.resources.Query2Resource.createQuery(Query2Resource.java:167)  
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)  
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  
at java.lang.reflect.Method.invoke(Method.java:606)  
at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)  
at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker.\_dispatch(AbstractResourceMethodDispatchProvider.java:185)  
at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)  
at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)  
at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)  
at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)  
at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)  
at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)  
at com.sun.jersey.server.impl.application.WebApplicationImpl.\_handleRequest(WebApplicationImpl.java:1542)  
at com.sun.jersey.server.impl.application.WebApplicationImpl.\_handleRequest(WebApplicationImpl.java:1473)  
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419)  
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409)  
at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409)  
at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558)  
at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733)  
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)  
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)  
at org.saiku.web.rest.resources.CORSFilter.doFilter(CORSFilter.java:21)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)  
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:316)  
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)  
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)  
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)  
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)  
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)  
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:122)  
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)  
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)  
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)  
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:168)  
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)  
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:48)  
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)  
at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158)  
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)  
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)  
at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:162)  
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)  
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:205)  
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)  
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:120)  
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)  
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)  
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)  
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)  
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:53)  
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)  
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)  
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:91)  
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)  
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:213)  
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:176)  
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:344)  
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:261)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)  
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:85)  
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)  
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)  
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)  
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503)  
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)  
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)  
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)  
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)  
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)  
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)  
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)  
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)  
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)  
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)  
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)  
at java.lang.Thread.run(Thread.java:745)  
Caused by: org.saiku.service.util.exception.SaikuServiceException: org.saiku.service.util.exception.SaikuServiceException: Cannot get native cube for cube ( \[pda\].\[pdaTest\].\[pdaTest\].\[鑽簵鍒嗘瀽\] )  
at org.saiku.service.olap.OlapDiscoverService.getProperties(OlapDiscoverService.java:224)  
at org.saiku.service.olap.ThinQueryService.createQuery(ThinQueryService.java:131)  
at org.saiku.web.rest.resources.Query2Resource.createQuery(Query2Resource.java:164)  
... 84 more  
Caused by: org.saiku.service.util.exception.SaikuServiceException: Cannot get native cube for cube ( \[pda\].\[pdaTest\].\[pdaTest\].\[鑽簵鍒嗘瀽\] )  
at org.saiku.service.olap.OlapDiscoverService.getNativeCube(OlapDiscoverService.java:97)  
at org.saiku.service.olap.OlapDiscoverService.getProperties(OlapDiscoverService.java:212)  
... 86 more  
Caused by: org.saiku.olap.util.exception.SaikuOlapException: 无法获取本地多维数据集 ( \[pda\].\[pdaTest\].\[pdaTest\].\[鑽簵鍒嗘瀽\] )  
at org.saiku.olap.discover.OlapMetaExplorer.getNativeCube(OlapMetaExplorer.java:193)  
at org.saiku.service.olap.OlapDiscoverService.getNativeCube(OlapDiscoverService.java:95)

... 87 more

解决方法：首先给你的查看你的schema文件cube里面的name属性是否是中文，如果是修改成英文，如果想显示中文添加

<Cube name="xxx" caption="xxx">即可caption里面最好是把中文转成Unicode码！！

1、然后找到Query2Resource类，找到createQuery方法

修改filecontent = new String( (byte\[\]) f.getEntity());

成 filecontent = new String( (byte\[\]) f.getEntity(),"utf-8");

2、找到类QueryResource的createQuery方法

修改 xml = new String( (byte\[\]) f.getEntity());

成 xml = new String( (byte\[\]) f.getEntity(),"utf-8");

3、找到类QueryDeserializer的getFakeCube方法，

修改 InputSource source = new InputSource( ( new ByteArrayInputStream( xml.getBytes() ) ) );

成 InputSource source = new InputSource( ( new ByteArrayInputStream( xml.getBytes("UTF-8") ) ) );

4、找到类BasicRepositoryResource2的saveResource方法

修改

String resp = datasourceService.saveFile(content, file, username, roles);

成 byte\[\] resp = new byte\[0\];  
 try \{  
resp = datasourceService.saveFile(content, file, username, roles).getBytes("UTF-8");  
\} catch (UnsupportedEncodingException e) \{  
e.printStackTrace();  
\}

5、找到类BasicRepositoryResource2的getResource方法

修改

String data = datasourceService.getFileData(file, username, roles);

成 byte\[\] data = new byte\[0\];  
try \{  
  data = datasourceService.getFileData(file, username, roles).getBytes("UTF-8");  
\} catch (UnsupportedEncodingException e) \{  
  log.error("Error reading file encoding",e);  
\}

[SouthEast]: /images/20220601/7eab962fb0354ed698e8dcbcb50489bd.png