Error getting "error ocurred" while raising Request Access for Others - Multi User

[brijendra12]

Hi All,

While raising Request Access for Others - Multi User, I am getting error getting "error ocurred" on UI. It is working for Single User request.

[rushikeshvartak]

You have some dynamic attribute query which is breaking 

"2024-10-21T14:45:34.775+00:00","ecm","","null-xd6hn","","org.codehaus.groovy.grails.web.errors.GrailsWrappedRuntimeException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',142' at line 1	at grails.plugin.springsecurity.web.filter.GrailsAnonymousAuthenticationFilter.doFilter(GrailsAnonymousAuthenticationFilter.java:53)	at com.saviynt.webservice.SaviyntRestAuthenticationFilter.doFilter(SaviyntRestAuthenticationFilter.groovy:159)	at grails.plugin.springsecurity.web.authentication.logout.MutableLogoutFilter.doFilter(MutableLogoutFilter.java:62)	at grails.plugin.springsecurity.web.SecurityRequestHolderFilter.doFilter(SecurityRequestHolderFilter.java:59)	at com.mrhaki.grails.plugin.xframeoptions.web.XFrameOptionsFilter.doFilterInternal(XFrameOptionsFilter.java:69)	at com.brandseye.cors.CorsFilter.doFilter(CorsFilter.java:82)	at java.lang.Thread.run(Thread.java:750)Caused by: org.codehaus.groovy.grails.web.pages.exceptions.GroovyPagesException: Error processing GroovyPageView: Error executing tag <g:form>: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',142' at line 1	... 7 moreCaused by: org.codehaus.groovy.grails.web.taglib.exceptions.GrailsTagException: Error executing tag <g:form>: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',142' at line 1	at gsp_ECM_workflowmanagementhierachyentitlementbyendpointmulti_gsp.run(gsp_ECM_workflowmanagementhierachyentitlementbyendpointmulti_gsp.groovy:1033)	... 7 moreCaused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',142' at line 1	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)	at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1200)	at gsp_ECM_workflowmanagementhierachyentitlementbyendpointmulti_gsp$_run_closure2.doCall(gsp_ECM_workflowmanagementhierachyentitlementbyendpointmulti_gsp.groovy:790)	... 8 more"