请选择 进入手机版 | 继续访问电脑版
麦粉社区
>
建议征集
>
帖子详情

知识库升级失败

建议征集 发表于 2020-3-11 11:05
发表于 2020-3-11 11:05:48
469345e6854b224947.png



849425e6854c0d5bbb.png

795205e68553256133.png

437735e68547bed38a.png

----------------------------------------------------
03-11 10:58:55  INFO startUpgrade(root:2174) - Start Upgrade

03-11 10:58:55 ERROR doUpgrade(smartbi.macro.upgrade.UpgradeTask_0_0_43:95) - Upgrade module 'smartbi.macro.upgrade' to 0.0.44 fail.

java.sql.SQLException: Incorrect string value: '\xB9\xFD\xB2\xE3\xBC\xB6...' for column 'c_script' at row 1
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
        at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1399)
        at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:857)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2460)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2377)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2361)
        at smartbi.macro.upgrade.UpgradeTask_0_0_43.doUpgrade(UpgradeTask_0_0_43.java:91)
        at smartbi.repository.RepositoryUpgradeHelper.doUpgrade(RepositoryUpgradeHelper.java:316)
        at smartbi.repository.RepositoryUpgradeHelper.upgradeRepository(RepositoryUpgradeHelper.java:253)
        at smartbi.repository.RepositoryUpgradeHelper.doUpgrade(RepositoryUpgradeHelper.java:428)
        at smartbi.config.BIConfigService.startUpgrade(BIConfigService.java:2177)
        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.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:650)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
        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 smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:160)
        at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:149)
        at smartbi.security.patch.PatchFilter.doFilter(PatchFilter.java:69)
        at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:149)
        at smartbi.extension.ExtensionFilter.doFilterInternal(ExtensionFilter.java:172)
        at smartbi.extension.ExtensionFilter.doFilter(ExtensionFilter.java:62)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at smartbi.framework.rmi.TransactionFilter.doFilter(Smartbi:106)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at smartbi.freequery.filter.GZIPFilter.doFilter(GZIPFilter.java:185)
        at smartbi.freequery.filter.Filter.doFilter(Filter.java:36)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at smartbi.freequery.filter.CheckIsLoggedFilter.doFilter(CheckIsLoggedFilter.java:186)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at smartbi.freequery.filter.TraceFilter.doFilter(TraceFilter.java:56)
        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:219)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1137)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
        at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2575)
        at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2564)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:748)
03-11 10:58:55 FATAL addOperationLog(smartbi.repository.RepositoryUpgradeHelper:345) - Upgraded module 'smartbi.macro' fail from UpgradeTask_0_0_43 to 0.0.44

03-11 10:58:55 ERROR invoke0(smartbi.config.BIConfigService:?) - 升级知识库失败

升级知识库失败:smartbi.macro.upgrade.UpgradeTask_0_0_43
        at smartbi.repository.RepositoryUpgradeHelper.upgradeRepository(RepositoryUpgradeHelper.java:254)
        at smartbi.repository.RepositoryUpgradeHelper.doUpgrade(RepositoryUpgradeHelper.java:428)
        at smartbi.config.BIConfigService.startUpgrade(BIConfigService.java:2177)
        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.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:650)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
        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 smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:160)
        at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:149)
        at smartbi.security.patch.PatchFilter.doFilter(PatchFilter.java:69)
        at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:149)
        at smartbi.extension.ExtensionFilter.doFilterInternal(ExtensionFilter.java:172)
        at smartbi.extension.ExtensionFilter.doFilter(ExtensionFilter.java:62)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at smartbi.framework.rmi.TransactionFilter.doFilter(Smartbi:106)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at smartbi.freequery.filter.GZIPFilter.doFilter(GZIPFilter.java:185)
        at smartbi.freequery.filter.Filter.doFilter(Filter.java:36)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at smartbi.freequery.filter.CheckIsLoggedFilter.doFilter(CheckIsLoggedFilter.java:186)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at smartbi.freequery.filter.TraceFilter.doFilter(TraceFilter.java:56)
        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:219)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1137)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
        at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2575)
        at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2564)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:748)


发表于 2020-3-16 10:25:45
知识库字符集不匹配导致的,最简单的处理方式就是使用可以指定数据库数据集的工具新建一个是GBK字符集的知识库,然后在config配置界面也同时选定GBK字符集,保证数据库和smartbi配置界面的字符集两边一致
回复

使用道具 举报

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

本版积分规则

1回帖数 0关注人数 3048浏览人数
最后回复于:2020-3-16 10:25
快速回复 返回顶部 返回列表