Table ‘xxxxxx.expressi_expression_define’ doesn’t exist

利江 错误处理 285

版本号:

镜像版本harbor.oinone.top/oinone/oinone-designer-full-v5.1:5.1.6

错误信息:

在设计器对对象字段选择显示字段的时候,会报错

WechatIMG575

报错日志:

Caused by: org.springframework. jdbc.BadSqlGrammarException:
<h3>Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table 'xxxxxx.expressi_expression_define' doesn't exist</h3>
<h3>The error may exist in pro/shushi/pamirs/framework/connectors/data/mapp trappers 5)</h3>
<h3>The error may involve pro.shushi.pamirs.framework.connectors.data.mapper.GenericMapper.selectOneByEntity-Inline</h3>
<h3>The error occurred while setting parameters</h3>
<h3>SQL: SELECT ‘code<em> AS ‘code</em>,‘write_uid’ AS ‘writeUid’,‘id‘ AS ‘id‘,<em>create_date’ AS ‘createDate’,‘model</em> AS ‘model*,‘row_list’ AS ‘rowList</h3>
‘expression_type’ AS ‘expressionType’, ‘write_date’ AS ‘writeDate’,‘create_uid’ AS ‘createUid‘,‘expression_display’ AS ‘expressionDisplay<em>, ‘key</em>
S ‘key’, ‘field’ AS ‘field’ FROM expressi_expression_define WHERE ‘is_deleted<em> = © AND ‘model</em> = ? AND ‘key’ = ? AND ‘field’ = ?
<h3>Cause: java.sql.SQLSyntaxErrorException: Table 'business.expressi_expression_define' doesn't exist</h3>
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Table 'business.expressi_expression_define' doesn't exist
at org.springframework. jdbc. support . SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator. java: 239)
at org.springframework. jdbc. support . AbstractFallbackSQLExceptionTranslator. translate(AbstractFallbackSQLExceptionTranslator. java: 72)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator. java:91)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor. invoke(SqlSessionTemplate. java: 441)
at com.sun. proxy. $Proxy207.selectOne(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate. java:160)
at com.baomidou.mybatisplus.core. override .MybatisMapperMethod .execute(MybatisMapperMethod. java:90)
at com. baomidou.mvbatisplus. core. override. MybatisMapperProxv$PlainMethodInvoker. invoke(MvbatisMapperProxy. java:148)

你的期望:

能够正常操作

如何重现问题:

  1. 在页面设计器里选中模型
  2. 选中相关字段

回复

共1条回复 我来回复
  • 利江的头像
    利江
    数式Oinone用户
    评论

    这是设计器的表,用来定义模型设计器表达式

    1. 检查设计器是否加入expression模块
    2. 设计器服务与本地服务的配置项 pamirs.mapper.global.table-pattern是否一致,不一致会产生删表的行为
    2个月前 0条评论