Message服务报错

Choerodon User Guide-Systerm Management
#1

  • Choerodon平台版本：0.25.0
    Choerodon-message服务版本： 0.25.4

  • 运行环境：自主搭建

  • 问题描述：

    提取消息信息时报错

  • 执行的操作：

点击 右上角图标，弹出通知消息边框。 也没报错

  • 报错信息(请尽量使用代码块或系统截图的形式展现)：

报错日志：

org.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'hzero_message.hpfm_tenant_tl' doesn't exist
### The error may exist in URL [jar:file:/choerodon/choerodon-message.jar!/BOOT-INF/lib/hzero-message-saas-1.6.1.RELEASE.jar!/mapper/UserMessageMapper.xml]
### The error may involve org.hzero.message.infra.mapper.UserMessageMapper.selectMessageList-Inline
### The error occurred while setting parameters
### SQL: SELECT count(0) FROM hmsg_user_message hum JOIN hpfm_tenant_tl ht ON ht.tenant_id = hum.tenant_id AND ht.lang = ? JOIN hmsg_message hm ON hm.message_id = hum.message_id AND hum.user_message_type_code = 'MSG' AND hm.message_type_code = ? WHERE hum.user_id = ? AND hum.user_message_type_code = ?
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'hzero_message.hpfm_tenant_tl' doesn't exist
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'hzero_message.hpfm_tenant_tl' doesn't exist
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:234) ~[spring-jdbc-5.0.10.RELEASE.jar!/:5.0.10.RELEASE]
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) ~[spring-jdbc-5.0.10.RELEASE.jar!/:5.0.10.RELEASE]
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91) ~[mybatis-spring-2.0.6.jar!/:2.0.6]
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) ~[mybatis-spring-2.0.6.jar!/:2.0.6]
	at com.sun.proxy.$Proxy178.selectList(Unknown Source) ~[na:na]
	at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224) ~[mybatis-spring-2.0.6.jar!/:2.0.6]
	at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147) ~[mybatis-3.5.6.jar!/:3.5.6]
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80) ~[mybatis-3.5.6.jar!/:3.5.6]
	at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:152) ~[mybatis-3.5.6.jar!/:3.5.6]
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:85) ~[mybatis-3.5.6.jar!/:3.5.6]
	at com.sun.proxy.$Proxy209.selectMessageList(Unknown Source) ~[na:na]
	at org.hzero.message.infra.repository.impl.UserMessageRepositoryImpl.lambda$selectMessageList$1(UserMessageRepositoryImpl.java:48) ~[hzero-message-saas-1.6.1.RELEASE.jar!/:1.6.1.RELEASE]
	at org.hzero.message.infra.repository.impl.UserMessageRepositoryImpl$$Lambda$1189/0x000000009007df80.doSelect(Unknown Source) ~[na:na]
	at io.choerodon.mybatis.pagehelper.PageHelper.doPageAndSort(PageHelper.java:47) ~[hzero-starter-mybatis-mapper-1.6.0.RELEASE.jar!/:1.6.0.RELEASE]
	at org.hzero.message.infra.repository.impl.UserMessageRepositoryImpl.selectMessageList(UserMessageRepositoryImpl.java:48) ~[hzero-message-saas-1.6.1.RELEASE.jar!/:1.6.1.RELEASE]
	at org.hzero.message.infra.repository.impl.UserMessageRepositoryImpl$$FastClassBySpringCGLIB$$d21a3d2f.invoke(<generated>) ~[hzero-message-saas-1.6.1.RELEASE.jar!/:1.6.1.RELEASE]
  • 建议：

    报错显示hpfm_tenant_tl表不存在，这个表是在platform库中的。

#2