Multi Approve - Error generating the data list

Confluence User - 09 Mar, 2023

Hello,


I've tried to config "Multi Approve" as Map Activities to Form.

After "Submitted" I got this error message.

Error generating the data list

org.hibernate.QueryException: could not resolve property: customProperties.activityId of: app_fd_gd_hr_apprv_trail_pd [SELECT e FROM app_fd_gd_hr_apprv_trail_pd e where e.customProperties.activityId = ? and e.customProperties.statusKey <> '' ORDER BY cast(e.dateCreated as string) DESC]

org.hibernate.QueryException: could not resolve property: customProperties.activityId of: app_fd_gd_hr_apprv_trail_pd [SELECT e FROM app_fd_gd_hr_apprv_trail_pd e where e.customProperties.activityId = ? and e.customProperties.statusKey <> '' ORDER BY cast(e.dateCreated as string) DESC]
	at org.hibernate.QueryException.generateQueryException(QueryException.java:137)
	at org.hibernate.QueryException.wrapWithQueryString(QueryException.java:120)
	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:234)
	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:158)
	at org.hibernate.engine.query.spi.HQLQueryPlan.(HQLQueryPlan.java:131)

,
I've checked columns of "app_fd_gd_hr_apprv_trail_pd" table was generated at the first running process likely uncompleted.


Thanks

approval;multirow;process;database;activity

1


13 Mar, 2023
confluenceUser
1
confluenceUser

Hi, the error message "could not resolve property: customProperties.activityId" indicates that there is a missing property column "activityId" in the table. Try checking the form or table to make sure that there is such a property column.

RELATED QUESTIONS

Your answer


To answer a question you'll need an account.

Print