麦粉社区
>
帖子详情

V10安装好后直接让升级服务, 还报错, 有碰到这样情况的吗

系统运维 发表于 2021-11-8 21:33
发表于 2021-11-8 21:33:53
报错内容:
11-08 21:19:21  INFO startUpgrade(:2909) - Start Upgrade
11-08 21:19:21 DEBUG doUpgrade(smartbix.dao.upgrade.RepositoryUpgradeHandler:92) - [smartbix.augmenteddataset.repository, smartbix.smartbi.service, smartbix.smartbi, smartbix.dao, smartbix.datamining, smartbix.jobflow, smartbix.dataprocess, smartbix.dataset, smartbix.datasource, smartbix.fileresource, smartbix.material, smartbix.page]
11-08 21:19:21  INFO upgrade(smartbix.dao.upgrade.UpgradeTask:1485) - upgrade smartbix.page.upgrade.UpgradeTask_1
11-08 21:19:21 DEBUG createTable(smartbix.page.upgrade.UpgradeTask_1:707) - table tx_maparea is exist
11-08 21:19:21 DEBUG insert(smartbix.page.upgrade.UpgradeTask_1:1042) - insert into tx_maparea(c_id,c_name,c_namemap,c_longitude,c_latitude,c_parentid,c_filetype,c_filepath,c_filecontent) values(?,?,?,?,?,?,?,?,?)
11-08 21:19:21 FATAL addOperationLog(smartbi.repository.RepositoryUpgradeHelper:461) - Upgraded module 'smartbix.page' fail from UpgradeTask_1 to 2
11-08 21:19:21 DEBUG startUpgrade(smartbi.config.BIConfigService:2938) - Upgrade failed
11-08 21:19:21 ERROR (smartbi.config.BIConfigService - SQL错误 -> Incorrect string value: '\xD6\xD0\xB9\xFA' for column 'c_name' at row 1
smartbix.SmartbiXException: SQL错误 -> Incorrect string value: '\xD6\xD0\xB9\xFA' for column 'c_name' at row 1
        at smartbix.SmartbiXException.create(SmartbiXException.java:64) ~[?:?]
        at smartbix.dao.upgrade.RepositoryUpgradeHandler.doUpgrade(RepositoryUpgradeHandler.java:256) ~[?:?]
        at smartbix.smartbi.SmartbiXConfigHandler$1.beforeUpgrade(SmartbiXConfigHandler.java:153) ~[?:?]
        at smartbi.repository.RepositoryUpgradeHelper.doUpgrade(RepositoryUpgradeHelper.java:439) ~[smartbi-DAO.jar:?]
        at smartbi.config.BIConfigService.startUpgrade(BIConfigService.java:2914) [smartbi-BIConfig.jar:?]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_251]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_251]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_251]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_251]
        at smartbi.framework.rmi.ClientService.executeInternal(Smartbi:138) [smartbi-Framework.jar:?]
        at smartbi.framework.rmi.ClientService.execute(Smartbi:120) [smartbi-Framework.jar:?]
        at smartbi.framework.rmi.RMIServlet.processExecute(RMIServlet.java:202) [smartbi-FrameworkRMI.jar:?]
        at smartbi.framework.rmi.RMIServlet.doPost(RMIServlet.java:131) [smartbi-FrameworkRMI.jar:?]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:681) [servlet-api.jar:?]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) [servlet-api.jar:?]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [catalina.jar:8.5.72]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.72]
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-websocket.jar:8.5.72]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.72]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.72]
        at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:271) [smartbi-ExtensionManager.jar:?]
        at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:253) [smartbi-ExtensionManager.jar:?]
        at smartbi.security.patch.PatchFilter.doFilter(PatchFilter.java:77) [classes/:?]
        at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:253) [smartbi-ExtensionManager.jar:?]
        at smartbi.extension.ExtensionFilter.doFilterInternal(ExtensionFilter.java:284) [smartbi-ExtensionManager.jar:?]
        at smartbi.extension.ExtensionFilter.doFilter(ExtensionFilter.java:112) [smartbi-ExtensionManager.jar:?]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.72]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.72]
        at smartbi.framework.rmi.TransactionFilter.doFilter(Smartbi:71) [smartbi-Framework.jar:?]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.72]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.72]
        at smartbi.freequery.filter.GZIPFilter.doFilter(GZIPFilter.java:236) [smartbi-FreeQuery.jar:?]
        at smartbi.freequery.filter.Filter.doFilter(Filter.java:33) [smartbi-FreeQuery.jar:?]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.72]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.72]
        at smartbi.freequery.filter.ExceptionResponseFilter.doFilter(ExceptionResponseFilter.java:79) [smartbi-FreeQuery.jar:?]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.72]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.72]
        at smartbi.freequery.filter.CheckIsLoggedFilter.doFilter(CheckIsLoggedFilter.java:219) [smartbi-FreeQuery.jar:?]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.72]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.72]
        at smartbi.freequery.filter.CheckRefererFilter.doFilter(CheckRefererFilter.java:45) [smartbi-FreeQuery.jar:?]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.72]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.72]
        at smartbi.freequery.filter.CheckHttpMethodFilter.doFilter(CheckHttpMethodFilter.java:62) [smartbi-FreeQuery.jar:?]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.72]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.72]
        at smartbi.freequery.filter.TraceFilter.doFilter(TraceFilter.java:56) [smartbi-FreeQuery.jar:?]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.72]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.72]
        at smartbi.framework.RedisSessionFilter.doFilter(Smartbi:137) [smartbi-Framework.jar:?]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.72]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.72]
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:196) [catalina.jar:8.5.72]
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [catalina.jar:8.5.72]
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) [catalina.jar:8.5.72]
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) [catalina.jar:8.5.72]
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) [catalina.jar:8.5.72]
        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:698) [catalina.jar:8.5.72]
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [catalina.jar:8.5.72]
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:364) [catalina.jar:8.5.72]
        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:624) [tomcat-coyote.jar:8.5.72]
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:8.5.72]
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831) [tomcat-coyote.jar:8.5.72]
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1650) [tomcat-coyote.jar:8.5.72]
        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:8.5.72]
        at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) [tomcat-util.jar:8.5.72]
        at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) [tomcat-util.jar:8.5.72]
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.5.72]
        at java.lang.Thread.run(Thread.java:748) [?:1.8.0_251]
Caused by: java.sql.SQLException: Incorrect string value: '\xD6\xD0\xB9\xFA' for column 'c_name' at row 1
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
        at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1281) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
        at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:787) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1251) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
        at smartbix.dao.upgrade.UpgradeTask.insert(UpgradeTask.java:1063) ~[?:?]
        at smartbix.page.upgrade.UpgradeTask_1.upgradeInternal(UpgradeTask_1.java:26) ~[?:?]
        at smartbix.dao.upgrade.UpgradeTask.upgrade(UpgradeTask.java:1486) ~[?:?]
        at smartbix.dao.upgrade.RepositoryUpgradeHandler.doUpgrade(RepositoryUpgradeHandler.java:196) ~[?:?]
        ... 68 more

发表于 2021-11-9 15:41:22
回复

使用道具 举报

发表于 2021-11-10 09:04:14
DANY 发表于 2021-11-9 15:41
参考wiki文档:https://wiki.smartbi.com.cn/pages/viewpage.action?pageId=76679856

感谢
回复

使用道具 举报

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

本版积分规则

2回帖数 0关注人数 4030浏览人数
最后回复于:2021-11-10 09:04
快速回复 返回顶部 返回列表