一月下旬新内容速递丨地理智能、函数实战与新春启航

年末将至,智慧不停!一月下旬更新聚焦地理智能、函数实战、二次开发与新春趣味活动,助你在数据探索中持续突破!

一、图表应用精选

【地图】GIS地图:告别平面报表,激活你的业务“地理智能”》→学习GIS地图应用,实现业务数据与地理信息的深度融合。
【散点图】商业世界的“关系侦探”》→掌握散点图在商业分析中的实战应用,洞察变量间的隐藏关系。

二、二次开发视频更新

Excel导入模板扩展数据处理类》→如何让导入的“1”和“0”自动变成“是”和“否”

三、函数应用进阶

【函数课堂】Fixed :数据计算中的“定海神针”》→系统讲解Fixed函数的使用场景与技巧,助你掌握数据计算的稳定性关键。

四、插件更新

离线导出功能集成阿里云OSS》→新增离线导出至阿里云OSS功能,提升数据导出安全性与存储灵活性。

五、新年活动进行中

新年第②弹|新春知识擂台:智慧解码,喜迎新年!》→新春特别活动,智慧解码挑战,喜迎新年好运!

六、任务持续上线

【图表应用】GIS地图诊断市场盈亏,制定精准策略》→掌握GIS地图分析技能,精准诊断市场表现,助力策略制定。
【函数】Fixed函数实战任务》→深入Fixed函数实战应用,提升数据计算稳定性和精准度。
【图表应用】散点图:你的“广告效果侦查局”已上线!》→运用散点图分析广告效果,成为数据驱动的“侦查高手”。
【新年活动】智慧解码擂台:挑战你的数据脑力!》→参与数据解码挑战,激活你的逻辑思维与分析能力。


地理智能赋能业务,函数实战夯实基础,新春活动智趣相融——一月下旬,与数据共赴新年新征程!

麦粉社区
>
帖子详情

升级失败,恢复备份失败

安装指导 发表于 2022-8-17 12:13
发表于 2022-8-17 12:13:12

进去主页就强制升级,升级不成功,又回复不了备份

发表于 2022-8-17 15:04:16
后台报错信息可以发一下
可能config界面没配置好信息,升级先连一个空的知识库测试通过保存重启服务
  •   BI_WTH
    我不想升级,为什么没有取消升级的选项啊,
    
    升级报错
    08-17 15:44:52  INFO startUpgrade(:3007) - Start Upgrade
    08-17 15:44:52 DEBUG doUpgrade(smartbix.dao.upgrade.RepositoryUpgradeHandler:92) - [smartbix.dao, smartbix.datamining, smartbix.jobflow, smartbix.augmenteddataset.repository, smartbix.dataprocess, smartbix.dataset, smartbix.datasource, smartbix.fileresource, smartbix.material, smartbix.modelquery, smartbix.page, smartbix.smartbi.service, smartbix.smartbi]
    08-17 15:44:52 DEBUG upgradeRepository(smartbi.repository.RepositoryUpgradeHelper:298) - dryRun=false, taskSize=40
    08-17 15:44:52 ERROR doUpgrade(smartbi.usermanager.upgrade.UpgradeTask_0_0_41:87) - Upgrade module 'smartbi.usermanager.upgrade' to 0.0.42 fail.
    java.sql.SQLException: Incorrect string value: 'xAF u00...' for column 'c_long' 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.executeUpdateInternal(PreparedStatement.java:2133) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
    	at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2067) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
    	at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5175) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
    	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2052) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
    	at smartbi.usermanager.upgrade.UpgradeTask_0_0_41.doUpgrade(UpgradeTask_0_0_41.java:84) [smartbi-UserManager.jar:?]
    	at smartbi.repository.RepositoryUpgradeHelper.doUpgrade(RepositoryUpgradeHelper.java:413) [smartbi-DAO.jar:?]
    	at smartbi.repository.RepositoryUpgradeHelper.upgradeRepository(RepositoryUpgradeHelper.java:306) [smartbi-DAO.jar:?]
    	at smartbi.repository.RepositoryUpgradeHelper.doUpgrade(RepositoryUpgradeHelper.java:451) [smartbi-DAO.jar:?]
    	at smartbi.config.BIConfigService.startUpgrade(BIConfigService.java:3012) [smartbi-BIConfig.jar:?]
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_202-ea]
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_202-ea]
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_202-ea]
    	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_202-ea]
    	at smartbi.framework.rmi.ClientService.executeInternal(ClientService.java:138) [smartbi-IndexServer.jar:?]
    	at smartbi.framework.rmi.ClientService.execute(ClientService.java:120) [smartbi-IndexServer.jar:?]
    	at smartbi.framework.rmi.RMIServlet.processExecute(RMIServlet.java:206) [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.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-websocket.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:285) [smartbi-ExtensionManager.jar:?]
    	at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:266) [smartbi-ExtensionManager.jar:?]
    	at smartbi.security.patch.PatchFilter.doFilter(PatchFilter.java:77) [classes/:?]
    	at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:266) [smartbi-ExtensionManager.jar:?]
    	at smartbi.extension.ExtensionFilter.doFilterInternal(ExtensionFilter.java:298) [smartbi-ExtensionManager.jar:?]
    	at smartbi.extension.ExtensionFilter.doFilter(ExtensionFilter.java:119) [smartbi-ExtensionManager.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	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.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.GZIPFilter.doFilter(GZIPFilter.java:237) [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.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.ExceptionResponseFilter.doFilter(ExceptionResponseFilter.java:85) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.CheckIsLoggedFilter.doFilter(CheckIsLoggedFilter.java:236) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	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.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	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.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.TraceFilter.doFilter(TraceFilter.java:57) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.framework.RedisSessionFilter.doFilter(RedisSessionFilter.java:122) [smartbi-IndexServer.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [catalina.jar:8.5.81]
    	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) [catalina.jar:8.5.81]
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [catalina.jar:8.5.81]
    	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:698) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [catalina.jar:8.5.81]
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:367) [catalina.jar:8.5.81]
    	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:639) [tomcat-coyote.jar:8.5.81]
    	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:8.5.81]
    	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:882) [tomcat-coyote.jar:8.5.81]
    	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1691) [tomcat-coyote.jar:8.5.81]
    	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:8.5.81]
    	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) [tomcat-util.jar:8.5.81]
    	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) [tomcat-util.jar:8.5.81]
    	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.5.81]
    	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202-ea]
    08-17 15:44:52 FATAL addOperationLog(smartbi.repository.RepositoryUpgradeHelper:468) - Upgraded module 'smartbi.usermanager' fail from UpgradeTask_0_0_41 to 0.0.42
    08-17 15:44:52 DEBUG startUpgrade(smartbi.config.BIConfigService:3036) - Upgrade failed
    08-17 15:44:52 ERROR (smartbi.config.BIConfigService:) - 升级知识库失败
    smartbi.SmartbiException: 升级知识库失败
    	at smartbi.repository.RepositoryUpgradeHelper.upgradeRepository(RepositoryUpgradeHelper.java:307) ~[smartbi-DAO.jar:?]
    	at smartbi.repository.RepositoryUpgradeHelper.doUpgrade(RepositoryUpgradeHelper.java:451) ~[smartbi-DAO.jar:?]
    	at smartbi.config.BIConfigService.startUpgrade(BIConfigService.java:3012) [smartbi-BIConfig.jar:?]
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_202-ea]
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_202-ea]
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_202-ea]
    	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_202-ea]
    	at smartbi.framework.rmi.ClientService.executeInternal(ClientService.java:138) [smartbi-IndexServer.jar:?]
    	at smartbi.framework.rmi.ClientService.execute(ClientService.java:120) [smartbi-IndexServer.jar:?]
    	at smartbi.framework.rmi.RMIServlet.processExecute(RMIServlet.java:206) [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.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-websocket.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:285) [smartbi-ExtensionManager.jar:?]
    	at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:266) [smartbi-ExtensionManager.jar:?]
    	at smartbi.security.patch.PatchFilter.doFilter(PatchFilter.java:77) [classes/:?]
    	at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:266) [smartbi-ExtensionManager.jar:?]
    	at smartbi.extension.ExtensionFilter.doFilterInternal(ExtensionFilter.java:298) [smartbi-ExtensionManager.jar:?]
    	at smartbi.extension.ExtensionFilter.doFilter(ExtensionFilter.java:119) [smartbi-ExtensionManager.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	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.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.GZIPFilter.doFilter(GZIPFilter.java:237) [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.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.ExceptionResponseFilter.doFilter(ExceptionResponseFilter.java:85) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.CheckIsLoggedFilter.doFilter(CheckIsLoggedFilter.java:236) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	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.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	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.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.TraceFilter.doFilter(TraceFilter.java:57) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.framework.RedisSessionFilter.doFilter(RedisSessionFilter.java:122) [smartbi-IndexServer.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [catalina.jar:8.5.81]
    	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) [catalina.jar:8.5.81]
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [catalina.jar:8.5.81]
    	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:698) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [catalina.jar:8.5.81]
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:367) [catalina.jar:8.5.81]
    	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:639) [tomcat-coyote.jar:8.5.81]
    	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:8.5.81]
    	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:882) [tomcat-coyote.jar:8.5.81]
    	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1691) [tomcat-coyote.jar:8.5.81]
    	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:8.5.81]
    	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) [tomcat-util.jar:8.5.81]
    	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) [tomcat-util.jar:8.5.81]
    	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.5.81]
    	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202-ea]
    
    
    
    2022-8-17 15:50| 回复
  •   BI_WTH
    我不想升级,为什么没有取消升级的选项啊,
    
    升级报错
    08-17 15:44:52  INFO startUpgrade(:3007) - Start Upgrade
    08-17 15:44:52 DEBUG doUpgrade(smartbix.dao.upgrade.RepositoryUpgradeHandler:92) - [smartbix.dao, smartbix.datamining, smartbix.jobflow, smartbix.augmenteddataset.repository, smartbix.dataprocess, smartbix.dataset, smartbix.datasource, smartbix.fileresource, smartbix.material, smartbix.modelquery, smartbix.page, smartbix.smartbi.service, smartbix.smartbi]
    08-17 15:44:52 DEBUG upgradeRepository(smartbi.repository.RepositoryUpgradeHelper:298) - dryRun=false, taskSize=40
    08-17 15:44:52 ERROR doUpgrade(smartbi.usermanager.upgrade.UpgradeTask_0_0_41:87) - Upgrade module 'smartbi.usermanager.upgrade' to 0.0.42 fail.
    java.sql.SQLException: Incorrect string value: 'xAF u00...' for column 'c_long' 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.executeUpdateInternal(PreparedStatement.java:2133) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
    	at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2067) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
    	at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5175) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
    	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2052) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
    	at smartbi.usermanager.upgrade.UpgradeTask_0_0_41.doUpgrade(UpgradeTask_0_0_41.java:84) [smartbi-UserManager.jar:?]
    	at smartbi.repository.RepositoryUpgradeHelper.doUpgrade(RepositoryUpgradeHelper.java:413) [smartbi-DAO.jar:?]
    	at smartbi.repository.RepositoryUpgradeHelper.upgradeRepository(RepositoryUpgradeHelper.java:306) [smartbi-DAO.jar:?]
    	at smartbi.repository.RepositoryUpgradeHelper.doUpgrade(RepositoryUpgradeHelper.java:451) [smartbi-DAO.jar:?]
    	at smartbi.config.BIConfigService.startUpgrade(BIConfigService.java:3012) [smartbi-BIConfig.jar:?]
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_202-ea]
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_202-ea]
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_202-ea]
    	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_202-ea]
    	at smartbi.framework.rmi.ClientService.executeInternal(ClientService.java:138) [smartbi-IndexServer.jar:?]
    	at smartbi.framework.rmi.ClientService.execute(ClientService.java:120) [smartbi-IndexServer.jar:?]
    	at smartbi.framework.rmi.RMIServlet.processExecute(RMIServlet.java:206) [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.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-websocket.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:285) [smartbi-ExtensionManager.jar:?]
    	at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:266) [smartbi-ExtensionManager.jar:?]
    	at smartbi.security.patch.PatchFilter.doFilter(PatchFilter.java:77) [classes/:?]
    	at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:266) [smartbi-ExtensionManager.jar:?]
    	at smartbi.extension.ExtensionFilter.doFilterInternal(ExtensionFilter.java:298) [smartbi-ExtensionManager.jar:?]
    	at smartbi.extension.ExtensionFilter.doFilter(ExtensionFilter.java:119) [smartbi-ExtensionManager.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	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.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.GZIPFilter.doFilter(GZIPFilter.java:237) [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.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.ExceptionResponseFilter.doFilter(ExceptionResponseFilter.java:85) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.CheckIsLoggedFilter.doFilter(CheckIsLoggedFilter.java:236) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	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.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	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.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.TraceFilter.doFilter(TraceFilter.java:57) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.framework.RedisSessionFilter.doFilter(RedisSessionFilter.java:122) [smartbi-IndexServer.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [catalina.jar:8.5.81]
    	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) [catalina.jar:8.5.81]
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [catalina.jar:8.5.81]
    	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:698) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [catalina.jar:8.5.81]
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:367) [catalina.jar:8.5.81]
    	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:639) [tomcat-coyote.jar:8.5.81]
    	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:8.5.81]
    	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:882) [tomcat-coyote.jar:8.5.81]
    	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1691) [tomcat-coyote.jar:8.5.81]
    	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:8.5.81]
    	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) [tomcat-util.jar:8.5.81]
    	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) [tomcat-util.jar:8.5.81]
    	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.5.81]
    	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202-ea]
    08-17 15:44:52 FATAL addOperationLog(smartbi.repository.RepositoryUpgradeHelper:468) - Upgraded module 'smartbi.usermanager' fail from UpgradeTask_0_0_41 to 0.0.42
    08-17 15:44:52 DEBUG startUpgrade(smartbi.config.BIConfigService:3036) - Upgrade failed
    08-17 15:44:52 ERROR (smartbi.config.BIConfigService:) - 升级知识库失败
    smartbi.SmartbiException: 升级知识库失败
    	at smartbi.repository.RepositoryUpgradeHelper.upgradeRepository(RepositoryUpgradeHelper.java:307) ~[smartbi-DAO.jar:?]
    	at smartbi.repository.RepositoryUpgradeHelper.doUpgrade(RepositoryUpgradeHelper.java:451) ~[smartbi-DAO.jar:?]
    	at smartbi.config.BIConfigService.startUpgrade(BIConfigService.java:3012) [smartbi-BIConfig.jar:?]
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_202-ea]
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_202-ea]
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_202-ea]
    	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_202-ea]
    	at smartbi.framework.rmi.ClientService.executeInternal(ClientService.java:138) [smartbi-IndexServer.jar:?]
    	at smartbi.framework.rmi.ClientService.execute(ClientService.java:120) [smartbi-IndexServer.jar:?]
    	at smartbi.framework.rmi.RMIServlet.processExecute(RMIServlet.java:206) [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.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-websocket.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:285) [smartbi-ExtensionManager.jar:?]
    	at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:266) [smartbi-ExtensionManager.jar:?]
    	at smartbi.security.patch.PatchFilter.doFilter(PatchFilter.java:77) [classes/:?]
    	at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:266) [smartbi-ExtensionManager.jar:?]
    	at smartbi.extension.ExtensionFilter.doFilterInternal(ExtensionFilter.java:298) [smartbi-ExtensionManager.jar:?]
    	at smartbi.extension.ExtensionFilter.doFilter(ExtensionFilter.java:119) [smartbi-ExtensionManager.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	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.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.GZIPFilter.doFilter(GZIPFilter.java:237) [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.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.ExceptionResponseFilter.doFilter(ExceptionResponseFilter.java:85) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.CheckIsLoggedFilter.doFilter(CheckIsLoggedFilter.java:236) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	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.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	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.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.TraceFilter.doFilter(TraceFilter.java:57) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.framework.RedisSessionFilter.doFilter(RedisSessionFilter.java:122) [smartbi-IndexServer.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [catalina.jar:8.5.81]
    	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) [catalina.jar:8.5.81]
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [catalina.jar:8.5.81]
    	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:698) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [catalina.jar:8.5.81]
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:367) [catalina.jar:8.5.81]
    	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:639) [tomcat-coyote.jar:8.5.81]
    	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:8.5.81]
    	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:882) [tomcat-coyote.jar:8.5.81]
    	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1691) [tomcat-coyote.jar:8.5.81]
    	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:8.5.81]
    	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) [tomcat-util.jar:8.5.81]
    	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) [tomcat-util.jar:8.5.81]
    	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.5.81]
    	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202-ea]
    
    
    
    2022-8-17 15:50| 回复
  •   真的人
     回复 BI_WTH
    好像是乱码,看看这个文档https://wiki.smartbi.com.cn/pages/viewpage.action?pageId=76679856
    2022-8-17 16:03| 回复

回复

使用道具 举报

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

4回帖数 0关注人数 1872浏览人数
最后回复于:2022-8-17 15:04

社区

指南

快速回复 返回顶部 返回列表