mysql5.7新表，服务启动起来了，访问页面报服务启动不成功

10-14 09:55:55 ERROR doUpgrade(smartbi.module.socialcontactshare.upgrade.UpgradeTask_0_0_11:34) [] - com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Can't DROP 'index_sharerecord_userid_relateid'; check that column/key exists

 

10-14 09:56:29 ERROR doUpgrade(smartbi.workflow.upgrade.UpgradeTask_0_0_13:35) [] - com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'smartbi.act_hi_dec_in' doesn't exist

 

10-14 09:56:29 ERROR doUpgrade(smartbi.workflow.upgrade.UpgradeTask_0_0_13:35) [] - com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'smartbi.act_hi_detail' doesn't exist

10-14 09:56:29 ERROR doUpgrade(smartbi.workflow.upgrade.UpgradeTask_0_0_13:35) [] - com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'smartbi.act_ru_authorization' doesn't exist

 

10-14 09:56:29 ERROR doUpgrade(smartbi.workflow.upgrade.UpgradeTask_0_0_13:35) [] - com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'smartbi.act_ru_job' doesn't exist

 

10-14 10:00:42 ERROR load(smartbi.repository.AbstractDAO:206) [] - org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [smartbi.catalogtree.Permission#AGENT_GRAPHS]

10-14 10:00:42 ERROR load(smartbi.repository.AbstractDAO:206) [] - org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [smartbi.catalogtree.Permission#AGENT_NODES]

 

10-14 10:00:43 ERROR logExceptions(smartbixlibs.org.hibernate.engine.jdbc.spi.SqlExceptionHelper:142) [] - Incorrect string value: '\x93??......' for column 'c_define' at row 1

 

10-14 10:00:45 ERROR activate(smartbi.framework.Framework:289) [] - smartbixlibs.javax.persistence.PersistenceException: smartbixlibs.org.hibernate.exception.GenericJDBCException: could not execute statement
smartbixlibs.javax.persistence.PersistenceException: smartbixlibs.org.hibernate.exception.GenericJDBCException: could not execute statement

 

看起来是知识库少了库表，你是啥时候的版本呀，直接新建一个空库再启动看看，确认你连的就是新建的空库，或者要拿一下完整的系统日志，就是smartbi.log找官方支持了

日志.docx (144.39 K)上传失败:上传格式错误,只允许:doc,docx,xls,xlsx,ppt,pptx,htm,html,txt,zip,rar,gz,bz2,pdf,ext,jar - smartbi.log (841.7 K)

日志.docx (144.39 K)

日志.docx (346.43 K)好像还是不行，访问页面报服务启动不成功 ，登录上去之后还是跳转到config,jsp

看起来还是知识库编码的问题，要不参考这个文档设置编码试试

https://wiki.smartbi.com.cn/pages/viewpage.action?smt_poid=43&pageId=76677806

线上数据库已经是gbk

这个在线的没有字符集设置的地方

  有设置