图表小部件添加至画布时会报OracleDatabaseException: ORA-00932: 数据类型不一致: 应为 -, 但却获得 CLOB

运行环境
java11
oracle 10g
jmix 1.4.1

报错信息

Error Code: 932
Call: SELECT DISTINCT t1.ID, t1.CODE, t1.CREATE_TS, t1.CREATED_BY, t1.DELETE_TS, t1.DELETED_BY, t1.DESCRIPTION, t1.INPUT_ENTITY_TYPES_IDX, t1.LOCALE_NAMES, t1.NAME, t1.REPORT_TYPE, t1.REST_ACCESS, t1.ROLES_IDX, t1.SCREENS_IDX, t1.SYS_TENANT_ID, t1.IS_SYSTEM, t1.UPDATE_TS, t1.UPDATED_BY, t1.VERSION, t1.XML, t1.GROUP_ID, t1.DEFAULT_TEMPLATE_ID, t0.ID, t0.IS_ALTERABLE_OUTPUT, t0.CODE, t0.CONTENT, t0.CREATE_TS, t0.CREATED_BY, t0.IS_CUSTOM, t0.CUSTOM_DEFINED_BY, t0.CUSTOM_CLASS, t0.DELETE_TS, t0.DELETED_BY, t0.IS_GROOVY, t0.NAME, t0.OUTPUT_NAME_PATTERN, t0.OUTPUT_TYPE, t0.UPDATE_TS, t0.UPDATED_BY, t0.VERSION, t0.REPORT_ID, t2.ID, t2.CODE, t2.CREATE_TS, t2.CREATED_BY, t2.DELETE_TS, t2.DELETED_BY, t2.LOCALE_NAMES, t2.SYS_TENANT_ID, t2.TITLE, t2.UPDATE_TS, t2.UPDATED_BY, t2.VERSION FROM REPORT_REPORT t1 LEFT OUTER JOIN REPORT_TEMPLATE t0 ON (t0.ID = t1.DEFAULT_TEMPLATE_ID) LEFT OUTER JOIN REPORT_GROUP t2 ON (t2.ID = t1.GROUP_ID), REPORT_TEMPLATE t3 WHERE (((t3.OUTPUT_TYPE = ?) AND (t1.DELETE_TS IS NULL)) AND (((t3.REPORT_ID = t1.ID) AND (t3.DELETE_TS IS NULL)) AND (t3.DELETE_TS IS NULL)))
bind => [70]
Query: ReadAllQuery(referenceClass=Report sql=“SELECT DISTINCT t1.ID, t1.CODE, t1.CREATE_TS, t1.CREATED_BY, t1.DELETE_TS, t1.DELETED_BY, t1.DESCRIPTION, t1.INPUT_ENTITY_TYPES_IDX, t1.LOCALE_NAMES, t1.NAME, t1.REPORT_TYPE, t1.REST_ACCESS, t1.ROLES_IDX, t1.SCREENS_IDX, t1.SYS_TENANT_ID, t1.IS_SYSTEM, t1.UPDATE_TS, t1.UPDATED_BY, t1.VERSION, t1.XML, t1.GROUP_ID, t1.DEFAULT_TEMPLATE_ID, t0.ID, t0.IS_ALTERABLE_OUTPUT, t0.CODE, t0.CONTENT, t0.CREATE_TS, t0.CREATED_BY, t0.IS_CUSTOM, t0.CUSTOM_DEFINED_BY, t0.CUSTOM_CLASS, t0.DELETE_TS, t0.DELETED_BY, t0.IS_GROOVY, t0.NAME, t0.OUTPUT_NAME_PATTERN, t0.OUTPUT_TYPE, t0.UPDATE_TS, t0.UPDATED_BY, t0.VERSION, t0.REPORT_ID, t2.ID, t2.CODE, t2.CREATE_TS, t2.CREATED_BY, t2.DELETE_TS, t2.DELETED_BY, t2.LOCALE_NAMES, t2.SYS_TENANT_ID, t2.TITLE, t2.UPDATE_TS, t2.UPDATED_BY, t2.VERSION FROM REPORT_REPORT t1 LEFT OUTER JOIN REPORT_TEMPLATE t0 ON (t0.ID = t1.DEFAULT_TEMPLATE_ID) LEFT OUTER JOIN REPORT_GROUP t2 ON (t2.ID = t1.GROUP_ID), REPORT_TEMPLATE t3 WHERE (((t3.OUTPUT_TYPE = ?) AND (t1.DELETE_TS IS NULL)) AND (((t3.REPORT_ID = t1.ID) AND (t3.DELETE_TS IS NULL)) AND (t3.DELETE_TS IS NULL)))”)
FetchGroup(){inputEntityTypesIdx, localeNames, restAccess, code, updatedBy, templates => {class java.lang.Object=FetchGroup(templates){code, updatedBy, customDefinedBy, custom, version, content, deletedBy, outputNamePattern, deleteTs, reportOutputType, groovy, createdBy, customDefinition, name, report => {class java.lang.Object=FetchGroup(report){inputEntityTypesIdx, localeNames, restAccess, code, updatedBy, templates, defaultTemplate, description, rolesIdx, version, deletedBy, reportType, deleteTs, system, createdBy, xml, name, createTs, sysTenantId, id, screensIdx, updateTs, group}}, createTs, id, alterable, updateTs}}, defaultTemplate => {class java.lang.Object=FetchGroup(defaultTemplate){code, updatedBy, customDefinedBy, custom, version, content, deletedBy, outputNamePattern, deleteTs, reportOutputType, groovy, createdBy, customDefinition, name, report => {class java.lang.Object=FetchGroup(report){inputEntityTypesIdx, localeNames, restAccess, code, updatedBy, templates, defaultTemplate, description, rolesIdx, version, deletedBy, reportType, deleteTs, system, createdBy, xml, name, createTs, sysTenantId, id, screensIdx, updateTs, group}}, createTs, id, alterable, updateTs}}, description, rolesIdx, version, deletedBy, reportType, deleteTs, system, createdBy, xml, name, createTs, sysTenantId, id, screensIdx, updateTs, group => {class java.lang.Object=FetchGroup(group){deleteTs, localeNames, code, updatedBy, createdBy, createTs, sysTenantId, id, title, updateTs, version, deletedBy}}}
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:342) ~[org.eclipse.persistence.core-2.7.9-6-jmix.jar:na]
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:722) ~[org.eclipse.persistence.core-2.7.9-6-jmix.jar:na]
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:564) ~[org.eclipse.persistence.core-2.7.9-6-jmix.jar:na]
at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2102) ~[org.eclipse.persistence.core-2.7.9-6-jmix.jar:na]
at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:603) ~[org.eclipse.persistence.core-2.7.9-6-jmix.jar:na]
at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:265) ~[org.eclipse.persistence.core-2.7.9-6-jmix.jar:na]
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:277) ~[org.eclipse.persistence.core-2.7.9-6-jmix.jar:na]
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.executeCall(ExpressionQueryMechanism.java:2938) ~[org.eclipse.persistence.core-2.7.9-6-jmix.jar:na]
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:263) ~[org.eclipse.persistence.core-2.7.9-6-jmix.jar:na]
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:334) ~[org.eclipse.persistence.core-2.7.9-6-jmix.jar:na]
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:746) ~[org.eclipse.persistence.core-2.7.9-6-jmix.jar:na]
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2826) ~[org.eclipse.persistence.core-2.7.9-6-jmix.jar:na]
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2779) ~[org.eclipse.persistence.core-2.7.9-6-jmix.jar:na]
at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:584) ~[org.eclipse.persistence.core-2.7.9-6-jmix.jar:na]
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1229) ~[org.eclipse.persistence.core-2.7.9-6-jmix.jar:na]
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:911) ~[org.eclipse.persistence.core-2.7.9-6-jmix.jar:na]
at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1188) ~[org.eclipse.persistence.core-2.7.9-6-jmix.jar:na]
at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:485) ~[org.eclipse.persistence.core-2.7.9-6-jmix.jar:na]
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1276) ~[org.eclipse.persistence.core-2.7.9-6-jmix.jar:na]
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:3043) ~[org.eclipse.persistence.core-2.7.9-6-jmix.jar:na]
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1895) ~[org.eclipse.persistence.core-2.7.9-6-jmix.jar:na]
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1877) ~[org.eclipse.persistence.core-2.7.9-6-jmix.jar:na]
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1842) ~[org.eclipse.persistence.core-2.7.9-6-jmix.jar:na]
at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:262) ~[org.eclipse.persistence.jpa-2.7.9-6-jmix.jar:na]
… 144 common frames omitted

你好,欢迎使用 Jmix!

这个场景不是很明确,能否提供一个可重现的小项目?

在仪表盘编辑界面添加图表小部件时会报这个错

你看看英文论坛的帖子:ORA-00932 when running report on Oracle - #11 by t.rusiaikina - Support - Jmix
是不是你描述的场景?没能重现这个问题。或者你可以上传一个能重现问题的小项目吗?

01
就是将chart拖拽到画布时,报出错误,数据库是oracle 10g

这个相关的实体方便贴一下吗?再可以看看 报表插件 oracle数据库报错ORA-00932: 数据类型不一致: 应为 -, 但却获得 CLOB - Jmix - jmix.cn 这个帖子,是哪个字段是 CLOB 类型?