2023-01-24/06:55:24.816 [{}] [https-jsse-nio-443-exec-27] DEBUG workflow.WorkflowmanagementController - Enter entitlementmap : [epid:, id:946531, pagenumber:0, newacc:, manageserviceaccount:, firsttime:1, systemname:, showdynamic:1, userkey:946531, accountname:1000541143, endpoint:366, readonlyattrs:readonlyattrs, _:1674543322527] 2023-01-24/06:55:24.821 [{}] [https-jsse-nio-443-exec-27] DEBUG workflow.WorkflowmanagementController - uparam= [:] 2023-01-24/06:55:24.825 [{}] [https-jsse-nio-443-exec-27] DEBUG workflow.WorkflowmanagementController - Exit entitlementmap 2023-01-24/06:55:24.847 [{}] [https-jsse-nio-443-exec-27] DEBUG workflow.WorkflowmanagementController - existingQuery: select distinct rua.rolekey from Role_user_account rua where rua.rolekey.endpointkey=366 and rua.userkey=946531 and rua.rolekey.requestable=true and rua.rolekey.status=1 and rua.accountkey.status in ('1', 'Manually Provisioned', 'ACTIVE') 2023-01-24/06:55:24.847 [{}] [https-jsse-nio-443-exec-27] DEBUG workflow.WorkflowmanagementController - temp size: 0 2023-01-24/06:55:25.237 [{}] [https-jsse-nio-443-exec-3] DEBUG println.PrintlnToLogger - Println :: [sEcho:1, iColumns:3, sColumns:, iDisplayStart:0, iDisplayLength:5, mDataProp_0:role_name, mDataProp_1:description, mDataProp_2:action, sSearch:, bRegex:false, sSearch_0:, bRegex_0:false, bSearchable_0:true, sSearch_1:, bRegex_1:false, bSearchable_1:true, sSearch_2:, bRegex_2:false, bSearchable_2:true, iSortCol_0:0, sSortDir_0:asc, iSortingCols:1, bSortable_0:true, bSortable_1:true, bSortable_2:false, endpoint:366, all:ALL, multi:null, roleType:4, requestFrom:2, userkey:946531, accountname:1000541143, jsontype:datatable, role_name:, description:, displayname:, glossary:, customproperty1:, customproperty2:, customproperty3:, controller:workflowmanagement, action:applicationRoleMapjson, max:5, offset:0, sort:role_name, order:asc] 2023-01-24/06:55:25.241 [{}] [https-jsse-nio-443-exec-42] DEBUG workflow.WorkflowmanagementController - listQry:select r from Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id in(0) 2023-01-24/06:55:25.251 [{}] [https-jsse-nio-443-exec-3] DEBUG workflow.WorkflowmanagementController - listQry:select r from Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = '' and r.customproperty7 in () and r.customproperty19 = '' and r.customproperty20 IN ()) order by r.role_name asc 2023-01-24/06:55:25.264 [{}] [pool-5-thread-3] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:25.268 [{}] [https-jsse-nio-443-exec-3] ERROR hql.PARSER - :0:0: unexpected end of subtree 2023-01-24/06:55:25.269 [{}] [https-jsse-nio-443-exec-3] ERROR hql.PARSER - :0:0: unexpected end of subtree 2023-01-24/06:55:25.273 [{}] [https-jsse-nio-443-exec-3] ERROR errors.GrailsExceptionResolver - QuerySyntaxException occurred when processing request: [POST] /ECM/workflowmanagement/applicationRoleMapjson unexpected end of subtree [select r from com.saviynt.ecm.identitywarehouse.domain.Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = '' and r.customproperty7 in () and r.customproperty19 = '' and r.customproperty20 IN ()) order by r.role_name asc]. Stacktrace follows: org.hibernate.hql.ast.QuerySyntaxException: unexpected end of subtree [select r from com.saviynt.ecm.identitywarehouse.domain.Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = '' and r.customproperty7 in () and r.customproperty19 = '' and r.customproperty20 IN ()) order by r.role_name asc] at com.saviynt.ecm.workflow.WorkflowmanagementController$_closure344.doCall(WorkflowmanagementController.groovy:20554) at grails.plugin.springsecurity.web.filter.GrailsAnonymousAuthenticationFilter.doFilter(GrailsAnonymousAuthenticationFilter.java:53) at com.saviynt.webservice.SaviyntRestAuthenticationFilter.doFilter(SaviyntRestAuthenticationFilter.groovy:145) 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.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) 2023-01-24/06:55:25.276 [{}] [https-jsse-nio-443-exec-3] ERROR error.ErrorController - Exception org.codehaus.groovy.grails.web.errors.GrailsWrappedRuntimeException: unexpected end of subtree [select r from com.saviynt.ecm.identitywarehouse.domain.Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = '' and r.customproperty7 in () and r.customproperty19 = '' and r.customproperty20 IN ()) order by r.role_name asc] at grails.plugin.springsecurity.web.filter.GrailsAnonymousAuthenticationFilter.doFilter(GrailsAnonymousAuthenticationFilter.java:53) at com.saviynt.webservice.SaviyntRestAuthenticationFilter.doFilter(SaviyntRestAuthenticationFilter.groovy:145) 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.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: org.hibernate.hql.ast.QuerySyntaxException: unexpected end of subtree [select r from com.saviynt.ecm.identitywarehouse.domain.Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = '' and r.customproperty7 in () and r.customproperty19 = '' and r.customproperty20 IN ()) order by r.role_name asc] at com.saviynt.ecm.workflow.WorkflowmanagementController$_closure344.doCall(WorkflowmanagementController.groovy:20554) ... 9 more 2023-01-24/06:55:25.294 [{}] [https-jsse-nio-443-exec-50] DEBUG workflow.WorkflowmanagementController - Enter entitlementmap : [userkey:946531, accountkey:1000541143, accountname:1000541143, endpoint:366, attributeEndpoint315: , attributeEndpoint318: , attributeEndpoint316: , attributeEndpoint317: , attributeEndpoint319:, muteemail:, undefined:, number:0, controller:workflowmanagement, action:entitlementmap] 2023-01-24/06:55:25.301 [{}] [https-jsse-nio-443-exec-50] DEBUG workflow.WorkflowmanagementController - uparam= [:] 2023-01-24/06:55:25.311 [{}] [https-jsse-nio-443-exec-50] DEBUG workflow.WorkflowmanagementController - Exit entitlementmap 2023-01-24/06:55:25.330 [{}] [pool-5-thread-5] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:25.332 [{}] [https-jsse-nio-443-exec-50] DEBUG workflow.WorkflowmanagementController - existingQuery: select distinct rua.rolekey from Role_user_account rua where rua.rolekey.endpointkey=366 and rua.userkey=946531 and rua.rolekey.requestable=true and rua.rolekey.status=1 and rua.accountkey.status in ('1', 'Manually Provisioned', 'ACTIVE') 2023-01-24/06:55:25.332 [{}] [https-jsse-nio-443-exec-50] DEBUG workflow.WorkflowmanagementController - temp size: 0 2023-01-24/06:55:25.587 [{}] [https-jsse-nio-443-exec-38] DEBUG println.PrintlnToLogger - Println :: [sEcho:1, iColumns:3, sColumns:, iDisplayStart:0, iDisplayLength:5, mDataProp_0:role_name, mDataProp_1:description, mDataProp_2:action, sSearch:, bRegex:false, sSearch_0:, bRegex_0:false, bSearchable_0:true, sSearch_1:, bRegex_1:false, bSearchable_1:true, sSearch_2:, bRegex_2:false, bSearchable_2:true, iSortCol_0:0, sSortDir_0:asc, iSortingCols:1, bSortable_0:true, bSortable_1:true, bSortable_2:false, endpoint:366, all:ALL, multi:null, roleType:4, requestFrom:2, userkey:946531, accountname:1000541143, jsontype:datatable, role_name:, description:, displayname:, glossary:, customproperty1:, customproperty2:, customproperty3:, controller:workflowmanagement, action:applicationRoleMapjson, max:5, offset:0, sort:role_name, order:asc] 2023-01-24/06:55:25.587 [{}] [https-jsse-nio-443-exec-38] DEBUG workflow.WorkflowmanagementController - listQry:select r from Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = '' and r.customproperty7 in () and r.customproperty19 = '' and r.customproperty20 IN ()) order by r.role_name asc 2023-01-24/06:55:25.594 [{}] [https-jsse-nio-443-exec-44] DEBUG workflow.WorkflowmanagementController - listQry:select r from Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id in(0) 2023-01-24/06:55:25.604 [{}] [https-jsse-nio-443-exec-38] ERROR hql.PARSER - :0:0: unexpected end of subtree 2023-01-24/06:55:25.604 [{}] [https-jsse-nio-443-exec-38] ERROR hql.PARSER - :0:0: unexpected end of subtree 2023-01-24/06:55:25.608 [{}] [https-jsse-nio-443-exec-38] ERROR errors.GrailsExceptionResolver - QuerySyntaxException occurred when processing request: [POST] /ECM/workflowmanagement/applicationRoleMapjson unexpected end of subtree [select r from com.saviynt.ecm.identitywarehouse.domain.Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = '' and r.customproperty7 in () and r.customproperty19 = '' and r.customproperty20 IN ()) order by r.role_name asc]. Stacktrace follows: org.hibernate.hql.ast.QuerySyntaxException: unexpected end of subtree [select r from com.saviynt.ecm.identitywarehouse.domain.Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = '' and r.customproperty7 in () and r.customproperty19 = '' and r.customproperty20 IN ()) order by r.role_name asc] at com.saviynt.ecm.workflow.WorkflowmanagementController$_closure344.doCall(WorkflowmanagementController.groovy:20554) at grails.plugin.springsecurity.web.filter.GrailsAnonymousAuthenticationFilter.doFilter(GrailsAnonymousAuthenticationFilter.java:53) at com.saviynt.webservice.SaviyntRestAuthenticationFilter.doFilter(SaviyntRestAuthenticationFilter.groovy:145) 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.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) 2023-01-24/06:55:25.611 [{}] [https-jsse-nio-443-exec-38] ERROR error.ErrorController - Exception org.codehaus.groovy.grails.web.errors.GrailsWrappedRuntimeException: unexpected end of subtree [select r from com.saviynt.ecm.identitywarehouse.domain.Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = '' and r.customproperty7 in () and r.customproperty19 = '' and r.customproperty20 IN ()) order by r.role_name asc] at grails.plugin.springsecurity.web.filter.GrailsAnonymousAuthenticationFilter.doFilter(GrailsAnonymousAuthenticationFilter.java:53) at com.saviynt.webservice.SaviyntRestAuthenticationFilter.doFilter(SaviyntRestAuthenticationFilter.groovy:145) 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.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: org.hibernate.hql.ast.QuerySyntaxException: unexpected end of subtree [select r from com.saviynt.ecm.identitywarehouse.domain.Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = '' and r.customproperty7 in () and r.customproperty19 = '' and r.customproperty20 IN ()) order by r.role_name asc] at com.saviynt.ecm.workflow.WorkflowmanagementController$_closure344.doCall(WorkflowmanagementController.groovy:20554) ... 9 more 2023-01-24/06:55:33.351 [{}] [https-jsse-nio-443-exec-42] DEBUG workflow.WorkflowmanagementController - enter recreatedyna attrid = 315 2023-01-24/06:55:33.351 [{}] [https-jsse-nio-443-exec-42] DEBUG workflow.WorkflowmanagementController - attrToHide = [] 2023-01-24/06:55:33.352 [{}] [https-jsse-nio-443-exec-42] DEBUG services.JbpmWorkflowService - Enter fetchHiddentAttrs 2023-01-24/06:55:33.352 [{}] [https-jsse-nio-443-exec-42] DEBUG services.JbpmWorkflowService - hetre 1 2023-01-24/06:55:33.352 [{}] [https-jsse-nio-443-exec-42] DEBUG services.JbpmWorkflowService - hetre 1 2023-01-24/06:55:33.352 [{}] [https-jsse-nio-443-exec-42] DEBUG services.JbpmWorkflowService - hetre 1 2023-01-24/06:55:33.352 [{}] [https-jsse-nio-443-exec-42] DEBUG services.JbpmWorkflowService - hetre 1 2023-01-24/06:55:33.352 [{}] [https-jsse-nio-443-exec-42] DEBUG services.JbpmWorkflowService - Exit fetchHiddentAttrs , hiddenSet = [] 2023-01-24/06:55:33.356 [{}] [https-jsse-nio-443-exec-42] DEBUG workflow.WorkflowmanagementController - processing attribute role 2023-01-24/06:55:33.356 [{}] [https-jsse-nio-443-exec-42] DEBUG workflow.WorkflowmanagementController - attribute role need to be displayed 2023-01-24/06:55:33.356 [{}] [https-jsse-nio-443-exec-42] DEBUG workflow.WorkflowmanagementController - dynamicAttributeMap11=====[company:, entity:, environment:, role:, roleType:] 2023-01-24/06:55:33.356 [{}] [https-jsse-nio-443-exec-42] DEBUG workflow.WorkflowmanagementController - tempVal======'Veeva QMS Contributor' 2023-01-24/06:55:33.356 [{}] [https-jsse-nio-443-exec-42] DEBUG workflow.WorkflowmanagementController - bindingMap====before ==[VAL:'Veeva QMS Contributor', role:'', ROLE_unquoted:, ENVIRONMENT:'', roleType:'Veeva QMS Contributor', company_unquoted:, ENVIRONMENT_unquoted:, userkey:'946531', ROLE:'', environment_unquoted:, ?1:'1', USERKEY:'946531', ENTITY:'', action:'recreatedyna', company:'', roletype:'Veeva QMS Contributor', id:'315', ID:'315', ROLETYPE:'Veeva QMS Contributor', ROLETYPE_unquoted:Veeva QMS Contributor, val:'Veeva QMS Contributor', controller:'workflowmanagement', role_unquoted:, ACCOUNTS:'0', REQUESTOR:946531, requestor:946531, COMPANY:'', COMPANY_unquoted:, environment:'', requestee:946531, CONTROLLER:'workflowmanagement', ACTION:'recreatedyna', roleType_unquoted:Veeva QMS Contributor, entity_unquoted:, ENTITY_unquoted:, roletype_unquoted:Veeva QMS Contributor, REQUESTEE:946531, accounts:'0', entity:''] 2023-01-24/06:55:33.356 [{}] [https-jsse-nio-443-exec-42] DEBUG println.PrintlnToLogger - Println :: bindingMap======[VAL:'Veeva QMS Contributor', role:'', ROLE_unquoted:, ENVIRONMENT:'', roleType:'Veeva QMS Contributor', company_unquoted:, ENVIRONMENT_unquoted:, userkey:'946531', ROLE:'', environment_unquoted:, ?1:'1', USERKEY:'946531', ENTITY:'', action:'recreatedyna', company:'', roletype:'Veeva QMS Contributor', id:'315', ID:'315', ROLETYPE:'Veeva QMS Contributor', ROLETYPE_unquoted:Veeva QMS Contributor, val:'Veeva QMS Contributor', controller:'workflowmanagement', role_unquoted:, ACCOUNTS:'0', REQUESTOR:946531, requestor:946531, COMPANY:'', COMPANY_unquoted:, environment:'', requestee:946531, CONTROLLER:'workflowmanagement', ACTION:'recreatedyna', roleType_unquoted:Veeva QMS Contributor, entity_unquoted:, ENTITY_unquoted:, roletype_unquoted:Veeva QMS Contributor, REQUESTEE:946531, accounts:'0', entity:''] 2023-01-24/06:55:33.356 [{}] [https-jsse-nio-443-exec-42] DEBUG workflow.WorkflowmanagementController - binding map is [VAL:'Veeva QMS Contributor', role:'', ROLE_unquoted:, ENVIRONMENT:'', roleType:'Veeva QMS Contributor', company_unquoted:, ENVIRONMENT_unquoted:, userkey:'946531', ROLE:'', environment_unquoted:, ?1:'1', USERKEY:'946531', ENTITY:'', action:'recreatedyna', company:'', roletype:'Veeva QMS Contributor', id:'315', ID:'315', ROLETYPE:'Veeva QMS Contributor', ROLETYPE_unquoted:Veeva QMS Contributor, val:'Veeva QMS Contributor', controller:'workflowmanagement', role_unquoted:, ACCOUNTS:'0', REQUESTOR:946531, requestor:946531, COMPANY:'', COMPANY_unquoted:, environment:'', requestee:946531, CONTROLLER:'workflowmanagement', ACTION:'recreatedyna', roleType_unquoted:Veeva QMS Contributor, entity_unquoted:, ENTITY_unquoted:, roletype_unquoted:Veeva QMS Contributor, REQUESTEE:946531, accounts:'0', entity:''] 2023-01-24/06:55:33.356 [{}] [https-jsse-nio-443-exec-42] DEBUG println.PrintlnToLogger - Println :: SQL query is select distinct customproperty19 as id from roles where customproperty19 in ('Contributor','NC/DP Coordinator','CAPA Coordinator','Change Mgt Coordinator','Change Mgt Regulatory Approver') and 'Veeva QMS Contributor' = 'Veeva QMS Contributor' and endpointkey=366 union select distinct customproperty19 as id from roles where customproperty19 in ('Document Contributor','Document Controller','Quality Assurance') and 'Veeva QMS Contributor' = 'Veeva DMS Quality Contributor' and endpointkey=366 union select distinct customproperty19 as id from roles where customproperty19='NA' and 'Veeva QMS Contributor' = 'Veeva General Quality Viewer' and endpointkey=366 union select distinct customproperty19 as id from roles where customproperty19 in ('Record Contributor','Record Controller','Quality Assurance') and 'Veeva QMS Contributor' = 'Veeva RMS Quality Contributor' 2023-01-24/06:55:33.356 [{}] [https-jsse-nio-443-exec-42] DEBUG workflow.WorkflowmanagementController - SQL query is select distinct customproperty19 as id from roles where customproperty19 in ('Contributor','NC/DP Coordinator','CAPA Coordinator','Change Mgt Coordinator','Change Mgt Regulatory Approver') and 'Veeva QMS Contributor' = 'Veeva QMS Contributor' and endpointkey=366 union select distinct customproperty19 as id from roles where customproperty19 in ('Document Contributor','Document Controller','Quality Assurance') and 'Veeva QMS Contributor' = 'Veeva DMS Quality Contributor' and endpointkey=366 union select distinct customproperty19 as id from roles where customproperty19='NA' and 'Veeva QMS Contributor' = 'Veeva General Quality Viewer' and endpointkey=366 union select distinct customproperty19 as id from roles where customproperty19 in ('Record Contributor','Record Controller','Quality Assurance') and 'Veeva QMS Contributor' = 'Veeva RMS Quality Contributor' 2023-01-24/06:55:33.450 [{}] [https-jsse-nio-443-exec-42] DEBUG workflow.WorkflowmanagementController - attribute role need to be displayed done.. 2023-01-24/06:55:33.450 [{}] [https-jsse-nio-443-exec-42] DEBUG println.PrintlnToLogger - Println :: returnMap= [318:] 2023-01-24/06:55:33.450 [{}] [https-jsse-nio-443-exec-42] DEBUG workflow.WorkflowmanagementController - exit recreatedyna attrid = 315 2023-01-24/06:55:33.561 [{}] [pool-5-thread-5] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:33.645 [{}] [https-jsse-nio-443-exec-3] DEBUG workflow.WorkflowmanagementController - enter recreatedyna attrid = 318 2023-01-24/06:55:33.645 [{}] [https-jsse-nio-443-exec-3] DEBUG workflow.WorkflowmanagementController - attrToHide = [] 2023-01-24/06:55:33.650 [{}] [https-jsse-nio-443-exec-3] DEBUG workflow.WorkflowmanagementController - processing attribute company 2023-01-24/06:55:33.650 [{}] [https-jsse-nio-443-exec-3] DEBUG workflow.WorkflowmanagementController - attribute company need to be displayed 2023-01-24/06:55:33.650 [{}] [https-jsse-nio-443-exec-3] DEBUG workflow.WorkflowmanagementController - dynamicAttributeMap11=====[company:, entity:, environment:, role:, roleType:] 2023-01-24/06:55:33.650 [{}] [https-jsse-nio-443-exec-3] DEBUG workflow.WorkflowmanagementController - tempVal======'' 2023-01-24/06:55:33.650 [{}] [https-jsse-nio-443-exec-3] DEBUG workflow.WorkflowmanagementController - bindingMap====before ==[role:'', ROLE_unquoted:, ENVIRONMENT:'', roleType:'Veeva QMS Contributor', company_unquoted:, ENVIRONMENT_unquoted:, userkey:'946531', ROLE:'', environment_unquoted:, ?1:'1', USERKEY:'946531', ENTITY:'', action:'recreatedyna', company:'', roletype:'Veeva QMS Contributor', id:'318', ID:'318', ROLETYPE:'Veeva QMS Contributor', ROLETYPE_unquoted:, controller:'workflowmanagement', role_unquoted:, ACCOUNTS:'0', REQUESTOR:946531, requestor:946531, COMPANY:'', COMPANY_unquoted:, environment:'', requestee:946531, CONTROLLER:'workflowmanagement', ACTION:'recreatedyna', roleType_unquoted:, entity_unquoted:, ENTITY_unquoted:, roletype_unquoted:, REQUESTEE:946531, accounts:'0', entity:''] 2023-01-24/06:55:33.650 [{}] [https-jsse-nio-443-exec-3] DEBUG println.PrintlnToLogger - Println :: bindingMap======[role:'', ROLE_unquoted:, ENVIRONMENT:'', roleType:'Veeva QMS Contributor', company_unquoted:, ENVIRONMENT_unquoted:, userkey:'946531', ROLE:'', environment_unquoted:, ?1:'1', USERKEY:'946531', ENTITY:'', action:'recreatedyna', company:'', roletype:'Veeva QMS Contributor', id:'318', ID:'318', ROLETYPE:'Veeva QMS Contributor', ROLETYPE_unquoted:, controller:'workflowmanagement', role_unquoted:, ACCOUNTS:'0', REQUESTOR:946531, requestor:946531, COMPANY:'', COMPANY_unquoted:, environment:'', requestee:946531, CONTROLLER:'workflowmanagement', ACTION:'recreatedyna', roleType_unquoted:, entity_unquoted:, ENTITY_unquoted:, roletype_unquoted:, REQUESTEE:946531, accounts:'0', entity:''] 2023-01-24/06:55:33.650 [{}] [https-jsse-nio-443-exec-3] DEBUG workflow.WorkflowmanagementController - binding map is [role:'', ROLE_unquoted:, ENVIRONMENT:'', roleType:'Veeva QMS Contributor', company_unquoted:, ENVIRONMENT_unquoted:, userkey:'946531', ROLE:'', environment_unquoted:, ?1:'1', USERKEY:'946531', ENTITY:'', action:'recreatedyna', company:'', roletype:'Veeva QMS Contributor', id:'318', ID:'318', ROLETYPE:'Veeva QMS Contributor', ROLETYPE_unquoted:, controller:'workflowmanagement', role_unquoted:, ACCOUNTS:'0', REQUESTOR:946531, requestor:946531, COMPANY:'', COMPANY_unquoted:, environment:'', requestee:946531, CONTROLLER:'workflowmanagement', ACTION:'recreatedyna', roleType_unquoted:, entity_unquoted:, ENTITY_unquoted:, roletype_unquoted:, REQUESTEE:946531, accounts:'0', entity:''] 2023-01-24/06:55:33.650 [{}] [https-jsse-nio-443-exec-3] DEBUG println.PrintlnToLogger - Println :: SQL query is select distinct customproperty18 as id from roles where customproperty18 in ('PMI','VFPh','Otitopic') and 'Veeva QMS Contributor' = 'Veeva QMS Contributor' and endpointkey=366 union select distinct customproperty18 as id from roles where customproperty18 in ('PMI','VFPh','Otitopic') and 'Veeva QMS Contributor' = 'Veeva DMS Quality Contributor' and endpointkey=366 union select distinct customproperty18 as id from roles where customproperty18 in ('PMI','VFPh','Otitopic') and 'Veeva QMS Contributor' = 'Veeva RMS Quality Contributor' 2023-01-24/06:55:33.650 [{}] [https-jsse-nio-443-exec-3] DEBUG workflow.WorkflowmanagementController - SQL query is select distinct customproperty18 as id from roles where customproperty18 in ('PMI','VFPh','Otitopic') and 'Veeva QMS Contributor' = 'Veeva QMS Contributor' and endpointkey=366 union select distinct customproperty18 as id from roles where customproperty18 in ('PMI','VFPh','Otitopic') and 'Veeva QMS Contributor' = 'Veeva DMS Quality Contributor' and endpointkey=366 union select distinct customproperty18 as id from roles where customproperty18 in ('PMI','VFPh','Otitopic') and 'Veeva QMS Contributor' = 'Veeva RMS Quality Contributor' 2023-01-24/06:55:33.743 [{}] [https-jsse-nio-443-exec-3] DEBUG workflow.WorkflowmanagementController - attribute company need to be displayed done.. 2023-01-24/06:55:33.743 [{}] [https-jsse-nio-443-exec-3] DEBUG workflow.WorkflowmanagementController - processing attribute environment 2023-01-24/06:55:33.743 [{}] [https-jsse-nio-443-exec-3] DEBUG workflow.WorkflowmanagementController - attribute environment need to be displayed 2023-01-24/06:55:33.743 [{}] [https-jsse-nio-443-exec-3] DEBUG workflow.WorkflowmanagementController - dynamicAttributeMap11=====[company:, entity:, environment:, role:, roleType:] 2023-01-24/06:55:33.743 [{}] [https-jsse-nio-443-exec-3] DEBUG workflow.WorkflowmanagementController - tempVal======'' 2023-01-24/06:55:33.743 [{}] [https-jsse-nio-443-exec-3] DEBUG workflow.WorkflowmanagementController - bindingMap====before ==[role:'', ROLE_unquoted:, ENVIRONMENT:'', roleType:'Veeva QMS Contributor', company_unquoted:, ENVIRONMENT_unquoted:, userkey:'946531', ROLE:'', environment_unquoted:, ?1:'1', USERKEY:'946531', ENTITY:'', action:'recreatedyna', company:'', roletype:'Veeva QMS Contributor', id:'318', ID:'318', ROLETYPE:'Veeva QMS Contributor', ROLETYPE_unquoted:, controller:'workflowmanagement', role_unquoted:, ACCOUNTS:'0', REQUESTOR:946531, requestor:946531, COMPANY:'', COMPANY_unquoted:, environment:'', requestee:946531, CONTROLLER:'workflowmanagement', ACTION:'recreatedyna', roleType_unquoted:, entity_unquoted:, ENTITY_unquoted:, roletype_unquoted:, REQUESTEE:946531, accounts:'0', entity:''] 2023-01-24/06:55:33.744 [{}] [https-jsse-nio-443-exec-3] DEBUG println.PrintlnToLogger - Println :: bindingMap======[role:'', ROLE_unquoted:, ENVIRONMENT:'', roleType:'Veeva QMS Contributor', company_unquoted:, ENVIRONMENT_unquoted:, userkey:'946531', ROLE:'', environment_unquoted:, ?1:'1', USERKEY:'946531', ENTITY:'', action:'recreatedyna', company:'', roletype:'Veeva QMS Contributor', id:'318', ID:'318', ROLETYPE:'Veeva QMS Contributor', ROLETYPE_unquoted:, controller:'workflowmanagement', role_unquoted:, ACCOUNTS:'0', REQUESTOR:946531, requestor:946531, COMPANY:'', COMPANY_unquoted:, environment:'', requestee:946531, CONTROLLER:'workflowmanagement', ACTION:'recreatedyna', roleType_unquoted:, entity_unquoted:, ENTITY_unquoted:, roletype_unquoted:, REQUESTEE:946531, accounts:'0', entity:''] 2023-01-24/06:55:33.744 [{}] [https-jsse-nio-443-exec-3] DEBUG workflow.WorkflowmanagementController - binding map is [role:'', ROLE_unquoted:, ENVIRONMENT:'', roleType:'Veeva QMS Contributor', company_unquoted:, ENVIRONMENT_unquoted:, userkey:'946531', ROLE:'', environment_unquoted:, ?1:'1', USERKEY:'946531', ENTITY:'', action:'recreatedyna', company:'', roletype:'Veeva QMS Contributor', id:'318', ID:'318', ROLETYPE:'Veeva QMS Contributor', ROLETYPE_unquoted:, controller:'workflowmanagement', role_unquoted:, ACCOUNTS:'0', REQUESTOR:946531, requestor:946531, COMPANY:'', COMPANY_unquoted:, environment:'', requestee:946531, CONTROLLER:'workflowmanagement', ACTION:'recreatedyna', roleType_unquoted:, entity_unquoted:, ENTITY_unquoted:, roletype_unquoted:, REQUESTEE:946531, accounts:'0', entity:''] 2023-01-24/06:55:33.744 [{}] [https-jsse-nio-443-exec-3] DEBUG println.PrintlnToLogger - Println :: SQL query is select distinct customproperty20 as id from roles where customproperty19 = '' and endpointkey=366 2023-01-24/06:55:33.744 [{}] [https-jsse-nio-443-exec-3] DEBUG workflow.WorkflowmanagementController - SQL query is select distinct customproperty20 as id from roles where customproperty19 = '' and endpointkey=366 2023-01-24/06:55:33.842 [{}] [https-jsse-nio-443-exec-3] DEBUG workflow.WorkflowmanagementController - attribute environment need to be displayed done.. 2023-01-24/06:55:33.842 [{}] [https-jsse-nio-443-exec-3] DEBUG println.PrintlnToLogger - Println :: returnMap= [316:, 319:] 2023-01-24/06:55:33.842 [{}] [https-jsse-nio-443-exec-3] DEBUG workflow.WorkflowmanagementController - exit recreatedyna attrid = 318 2023-01-24/06:55:34.094 [{}] [https-jsse-nio-443-exec-50] DEBUG workflow.WorkflowmanagementController - enter recreatedyna attrid = 316 2023-01-24/06:55:34.094 [{}] [https-jsse-nio-443-exec-50] DEBUG workflow.WorkflowmanagementController - attrToHide = [] 2023-01-24/06:55:34.099 [{}] [https-jsse-nio-443-exec-50] DEBUG workflow.WorkflowmanagementController - processing attribute entity 2023-01-24/06:55:34.099 [{}] [https-jsse-nio-443-exec-50] DEBUG workflow.WorkflowmanagementController - attribute entity need to be displayed 2023-01-24/06:55:34.099 [{}] [https-jsse-nio-443-exec-50] DEBUG workflow.WorkflowmanagementController - dynamicAttributeMap11=====[company:, entity:, environment:, role:, roleType:] 2023-01-24/06:55:34.099 [{}] [https-jsse-nio-443-exec-50] DEBUG workflow.WorkflowmanagementController - tempVal======'' 2023-01-24/06:55:34.099 [{}] [https-jsse-nio-443-exec-50] DEBUG workflow.WorkflowmanagementController - bindingMap====before ==[role:'', ROLE_unquoted:, ENVIRONMENT:'', roleType:'Veeva QMS Contributor', company_unquoted:, ENVIRONMENT_unquoted:, userkey:'946531', ROLE:'', environment_unquoted:, ?1:'1', USERKEY:'946531', ENTITY:'', action:'recreatedyna', company:'', roletype:'Veeva QMS Contributor', id:'316', ID:'316', ROLETYPE:'Veeva QMS Contributor', ROLETYPE_unquoted:, controller:'workflowmanagement', role_unquoted:, ACCOUNTS:'0', REQUESTOR:946531, requestor:946531, COMPANY:'', COMPANY_unquoted:, environment:'', requestee:946531, CONTROLLER:'workflowmanagement', ACTION:'recreatedyna', roleType_unquoted:, entity_unquoted:, ENTITY_unquoted:, roletype_unquoted:, REQUESTEE:946531, accounts:'0', entity:''] 2023-01-24/06:55:34.100 [{}] [https-jsse-nio-443-exec-50] DEBUG println.PrintlnToLogger - Println :: bindingMap======[role:'', ROLE_unquoted:, ENVIRONMENT:'', roleType:'Veeva QMS Contributor', company_unquoted:, ENVIRONMENT_unquoted:, userkey:'946531', ROLE:'', environment_unquoted:, ?1:'1', USERKEY:'946531', ENTITY:'', action:'recreatedyna', company:'', roletype:'Veeva QMS Contributor', id:'316', ID:'316', ROLETYPE:'Veeva QMS Contributor', ROLETYPE_unquoted:, controller:'workflowmanagement', role_unquoted:, ACCOUNTS:'0', REQUESTOR:946531, requestor:946531, COMPANY:'', COMPANY_unquoted:, environment:'', requestee:946531, CONTROLLER:'workflowmanagement', ACTION:'recreatedyna', roleType_unquoted:, entity_unquoted:, ENTITY_unquoted:, roletype_unquoted:, REQUESTEE:946531, accounts:'0', entity:''] 2023-01-24/06:55:34.100 [{}] [https-jsse-nio-443-exec-50] DEBUG workflow.WorkflowmanagementController - binding map is [role:'', ROLE_unquoted:, ENVIRONMENT:'', roleType:'Veeva QMS Contributor', company_unquoted:, ENVIRONMENT_unquoted:, userkey:'946531', ROLE:'', environment_unquoted:, ?1:'1', USERKEY:'946531', ENTITY:'', action:'recreatedyna', company:'', roletype:'Veeva QMS Contributor', id:'316', ID:'316', ROLETYPE:'Veeva QMS Contributor', ROLETYPE_unquoted:, controller:'workflowmanagement', role_unquoted:, ACCOUNTS:'0', REQUESTOR:946531, requestor:946531, COMPANY:'', COMPANY_unquoted:, environment:'', requestee:946531, CONTROLLER:'workflowmanagement', ACTION:'recreatedyna', roleType_unquoted:, entity_unquoted:, ENTITY_unquoted:, roletype_unquoted:, REQUESTEE:946531, accounts:'0', entity:''] 2023-01-24/06:55:34.100 [{}] [https-jsse-nio-443-exec-50] DEBUG println.PrintlnToLogger - Println :: SQL query is select distinct customproperty7 as id from roles where customproperty18 = '' and customproperty7 is not null and endpointkey=366 ORDER BY customproperty7 ASC 2023-01-24/06:55:34.100 [{}] [https-jsse-nio-443-exec-50] DEBUG workflow.WorkflowmanagementController - SQL query is select distinct customproperty7 as id from roles where customproperty18 = '' and customproperty7 is not null and endpointkey=366 ORDER BY customproperty7 ASC 2023-01-24/06:55:34.198 [{}] [https-jsse-nio-443-exec-50] DEBUG workflow.WorkflowmanagementController - attribute entity need to be displayed done.. 2023-01-24/06:55:34.199 [{}] [https-jsse-nio-443-exec-50] DEBUG println.PrintlnToLogger - Println :: returnMap= [317:] 2023-01-24/06:55:34.199 [{}] [https-jsse-nio-443-exec-50] DEBUG workflow.WorkflowmanagementController - exit recreatedyna attrid = 316 2023-01-24/06:55:34.276 [{}] [pool-5-thread-4] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:34.390 [{}] [https-jsse-nio-443-exec-44] DEBUG workflow.WorkflowmanagementController - enter recreatedyna attrid = 317 2023-01-24/06:55:34.390 [{}] [https-jsse-nio-443-exec-44] DEBUG workflow.WorkflowmanagementController - attrToHide = [] 2023-01-24/06:55:34.395 [{}] [https-jsse-nio-443-exec-44] DEBUG workflow.WorkflowmanagementController - exit recreatedyna attrid = 317 2023-01-24/06:55:34.609 [{}] [https-jsse-nio-443-exec-52] DEBUG workflow.WorkflowmanagementController - enter recreatedyna attrid = 319 2023-01-24/06:55:34.609 [{}] [https-jsse-nio-443-exec-52] DEBUG workflow.WorkflowmanagementController - attrToHide = [] 2023-01-24/06:55:34.613 [{}] [https-jsse-nio-443-exec-52] DEBUG workflow.WorkflowmanagementController - exit recreatedyna attrid = 319 2023-01-24/06:55:34.884 [{}] [https-jsse-nio-443-exec-38] DEBUG workflow.WorkflowmanagementController - Enter entitlementmap : [userkey:946531, accountkey:1000541143, accountname:1000541143, endpoint:366, attributeEndpoint315: Veeva QMS Contributor, attributeEndpoint318: , attributeEndpoint316: , attributeEndpoint317: , attributeEndpoint319:, muteemail:, undefined:, number:0, controller:workflowmanagement, action:entitlementmap] 2023-01-24/06:55:34.890 [{}] [https-jsse-nio-443-exec-38] DEBUG workflow.WorkflowmanagementController - uparam= [:] 2023-01-24/06:55:34.900 [{}] [https-jsse-nio-443-exec-38] DEBUG workflow.WorkflowmanagementController - Exit entitlementmap 2023-01-24/06:55:34.922 [{}] [https-jsse-nio-443-exec-38] DEBUG workflow.WorkflowmanagementController - existingQuery: select distinct rua.rolekey from Role_user_account rua where rua.rolekey.endpointkey=366 and rua.userkey=946531 and rua.rolekey.requestable=true and rua.rolekey.status=1 and rua.accountkey.status in ('1', 'Manually Provisioned', 'ACTIVE') 2023-01-24/06:55:34.922 [{}] [https-jsse-nio-443-exec-38] DEBUG workflow.WorkflowmanagementController - temp size: 0 2023-01-24/06:55:35.173 [{}] [https-jsse-nio-443-exec-15] DEBUG println.PrintlnToLogger - Println :: [sEcho:1, iColumns:3, sColumns:, iDisplayStart:0, iDisplayLength:5, mDataProp_0:role_name, mDataProp_1:description, mDataProp_2:action, sSearch:, bRegex:false, sSearch_0:, bRegex_0:false, bSearchable_0:true, sSearch_1:, bRegex_1:false, bSearchable_1:true, sSearch_2:, bRegex_2:false, bSearchable_2:true, iSortCol_0:0, sSortDir_0:asc, iSortingCols:1, bSortable_0:true, bSortable_1:true, bSortable_2:false, endpoint:366, all:ALL, multi:null, roleType:4, requestFrom:2, userkey:946531, accountname:1000541143, jsontype:datatable, role_name:, description:, displayname:, glossary:, customproperty1:, customproperty2:, customproperty3:, controller:workflowmanagement, action:applicationRoleMapjson, max:5, offset:0, sort:role_name, order:asc] 2023-01-24/06:55:35.173 [{}] [https-jsse-nio-443-exec-15] DEBUG workflow.WorkflowmanagementController - listQry:select r from Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = '' and r.customproperty7 in () and r.customproperty19 = '' and r.customproperty20 IN ()) order by r.role_name asc 2023-01-24/06:55:35.186 [{}] [https-jsse-nio-443-exec-22] DEBUG workflow.WorkflowmanagementController - listQry:select r from Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id in(0) 2023-01-24/06:55:35.195 [{}] [https-jsse-nio-443-exec-15] ERROR hql.PARSER - :0:0: unexpected end of subtree 2023-01-24/06:55:35.196 [{}] [https-jsse-nio-443-exec-15] ERROR hql.PARSER - :0:0: unexpected end of subtree 2023-01-24/06:55:35.197 [{}] [https-jsse-nio-443-exec-33] DEBUG workflow.WorkflowmanagementController - session.hideAttributeMap=========[366:[]] 2023-01-24/06:55:35.200 [{}] [https-jsse-nio-443-exec-15] ERROR errors.GrailsExceptionResolver - QuerySyntaxException occurred when processing request: [POST] /ECM/workflowmanagement/applicationRoleMapjson unexpected end of subtree [select r from com.saviynt.ecm.identitywarehouse.domain.Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = '' and r.customproperty7 in () and r.customproperty19 = '' and r.customproperty20 IN ()) order by r.role_name asc]. Stacktrace follows: org.hibernate.hql.ast.QuerySyntaxException: unexpected end of subtree [select r from com.saviynt.ecm.identitywarehouse.domain.Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = '' and r.customproperty7 in () and r.customproperty19 = '' and r.customproperty20 IN ()) order by r.role_name asc] at com.saviynt.ecm.workflow.WorkflowmanagementController$_closure344.doCall(WorkflowmanagementController.groovy:20554) at grails.plugin.springsecurity.web.filter.GrailsAnonymousAuthenticationFilter.doFilter(GrailsAnonymousAuthenticationFilter.java:53) at com.saviynt.webservice.SaviyntRestAuthenticationFilter.doFilter(SaviyntRestAuthenticationFilter.groovy:145) 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.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) 2023-01-24/06:55:35.203 [{}] [https-jsse-nio-443-exec-15] ERROR error.ErrorController - Exception org.codehaus.groovy.grails.web.errors.GrailsWrappedRuntimeException: unexpected end of subtree [select r from com.saviynt.ecm.identitywarehouse.domain.Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = '' and r.customproperty7 in () and r.customproperty19 = '' and r.customproperty20 IN ()) order by r.role_name asc] at grails.plugin.springsecurity.web.filter.GrailsAnonymousAuthenticationFilter.doFilter(GrailsAnonymousAuthenticationFilter.java:53) at com.saviynt.webservice.SaviyntRestAuthenticationFilter.doFilter(SaviyntRestAuthenticationFilter.groovy:145) 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.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: org.hibernate.hql.ast.QuerySyntaxException: unexpected end of subtree [select r from com.saviynt.ecm.identitywarehouse.domain.Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = '' and r.customproperty7 in () and r.customproperty19 = '' and r.customproperty20 IN ()) order by r.role_name asc] at com.saviynt.ecm.workflow.WorkflowmanagementController$_closure344.doCall(WorkflowmanagementController.groovy:20554) ... 9 more 2023-01-24/06:55:35.237 [{}] [pool-5-thread-5] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:35.304 [{}] [pool-5-thread-1] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:35.390 [{}] [https-jsse-nio-443-exec-18] DEBUG workflow.WorkflowmanagementController - session.hideAttributeMap=========[366:[]] 2023-01-24/06:55:35.593 [{}] [https-jsse-nio-443-exec-17] DEBUG workflow.WorkflowmanagementController - session.hideAttributeMap=========[366:[]] 2023-01-24/06:55:35.878 [{}] [https-jsse-nio-443-exec-4] INFO services.UsersService - starting to process roles auditing 2023-01-24/06:55:35.880 [{}] [https-jsse-nio-443-exec-4] INFO services.UsersService - Auditing for role_dynamic_attribute action 2023-01-24/06:55:35.881 [{}] [https-jsse-nio-443-exec-46] DEBUG workflow.WorkflowmanagementController - session.hideAttributeMap=========[366:[]] 2023-01-24/06:55:35.882 [{}] [https-jsse-nio-443-exec-4] INFO services.UsersService - Auditing process completed for entitlement 2023-01-24/06:55:36.077 [{}] [https-jsse-nio-443-exec-40] INFO services.UsersService - starting to process roles auditing 2023-01-24/06:55:36.079 [{}] [https-jsse-nio-443-exec-40] INFO services.UsersService - Auditing for dynamicattributesjson action 2023-01-24/06:55:36.079 [{}] [https-jsse-nio-443-exec-40] INFO services.UsersService - Auditing process completed for entitlement 2023-01-24/06:55:36.238 [{}] [pool-5-thread-3] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:36.305 [{}] [pool-5-thread-5] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:37.237 [{}] [pool-5-thread-2] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:37.304 [{}] [pool-5-thread-3] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:37.477 [{}] [https-jsse-nio-443-exec-36] INFO domain.JobcontrolController - Auditing for list of JobControl 2023-01-24/06:55:37.477 [{}] [https-jsse-nio-443-exec-36] INFO domain.JobcontrolController - Auditing process completed for JobControl 2023-01-24/06:55:38.240 [{}] [pool-5-thread-4] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:38.313 [{}] [pool-5-thread-2] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:39.237 [{}] [pool-5-thread-1] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:39.303 [{}] [pool-5-thread-4] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:39.665 [{}] [https-jsse-nio-443-exec-49] DEBUG workflow.WorkflowmanagementController - enter recreatedyna attrid = 318 2023-01-24/06:55:39.666 [{}] [https-jsse-nio-443-exec-49] DEBUG workflow.WorkflowmanagementController - attrToHide = [] 2023-01-24/06:55:39.670 [{}] [https-jsse-nio-443-exec-49] DEBUG workflow.WorkflowmanagementController - processing attribute company 2023-01-24/06:55:39.670 [{}] [https-jsse-nio-443-exec-49] DEBUG workflow.WorkflowmanagementController - attribute company need to be displayed 2023-01-24/06:55:39.670 [{}] [https-jsse-nio-443-exec-49] DEBUG workflow.WorkflowmanagementController - dynamicAttributeMap11=====[company:, entity:, environment:, role:, roleType:Veeva QMS Contributor] 2023-01-24/06:55:39.670 [{}] [https-jsse-nio-443-exec-49] DEBUG workflow.WorkflowmanagementController - tempVal======'NC/DP Coordinator' 2023-01-24/06:55:39.670 [{}] [https-jsse-nio-443-exec-49] DEBUG workflow.WorkflowmanagementController - bindingMap====before ==[VAL:'NC/DP Coordinator', role:'NC/DP Coordinator', ROLE_unquoted:NC/DP Coordinator, ENVIRONMENT:'', roleType:'Veeva QMS Contributor', company_unquoted:, ENVIRONMENT_unquoted:, userkey:'946531', ROLE:'NC/DP Coordinator', environment_unquoted:, ?1:'1', USERKEY:'946531', ENTITY:'', action:'recreatedyna', company:'', roletype:'Veeva QMS Contributor', id:'318', ID:'318', ROLETYPE:'Veeva QMS Contributor', ROLETYPE_unquoted:Veeva QMS Contributor, val:'NC/DP Coordinator', controller:'workflowmanagement', role_unquoted:NC/DP Coordinator, ACCOUNTS:'0', REQUESTOR:946531, requestor:946531, COMPANY:'', COMPANY_unquoted:, environment:'', requestee:946531, CONTROLLER:'workflowmanagement', ACTION:'recreatedyna', roleType_unquoted:Veeva QMS Contributor, entity_unquoted:, ENTITY_unquoted:, roletype_unquoted:Veeva QMS Contributor, REQUESTEE:946531, accounts:'0', entity:''] 2023-01-24/06:55:39.670 [{}] [https-jsse-nio-443-exec-49] DEBUG println.PrintlnToLogger - Println :: bindingMap======[VAL:'NC/DP Coordinator', role:'NC/DP Coordinator', ROLE_unquoted:NC/DP Coordinator, ENVIRONMENT:'', roleType:'Veeva QMS Contributor', company_unquoted:, ENVIRONMENT_unquoted:, userkey:'946531', ROLE:'NC/DP Coordinator', environment_unquoted:, ?1:'1', USERKEY:'946531', ENTITY:'', action:'recreatedyna', company:'', roletype:'Veeva QMS Contributor', id:'318', ID:'318', ROLETYPE:'Veeva QMS Contributor', ROLETYPE_unquoted:Veeva QMS Contributor, val:'NC/DP Coordinator', controller:'workflowmanagement', role_unquoted:NC/DP Coordinator, ACCOUNTS:'0', REQUESTOR:946531, requestor:946531, COMPANY:'', COMPANY_unquoted:, environment:'', requestee:946531, CONTROLLER:'workflowmanagement', ACTION:'recreatedyna', roleType_unquoted:Veeva QMS Contributor, entity_unquoted:, ENTITY_unquoted:, roletype_unquoted:Veeva QMS Contributor, REQUESTEE:946531, accounts:'0', entity:''] 2023-01-24/06:55:39.670 [{}] [https-jsse-nio-443-exec-49] DEBUG workflow.WorkflowmanagementController - binding map is [VAL:'NC/DP Coordinator', role:'NC/DP Coordinator', ROLE_unquoted:NC/DP Coordinator, ENVIRONMENT:'', roleType:'Veeva QMS Contributor', company_unquoted:, ENVIRONMENT_unquoted:, userkey:'946531', ROLE:'NC/DP Coordinator', environment_unquoted:, ?1:'1', USERKEY:'946531', ENTITY:'', action:'recreatedyna', company:'', roletype:'Veeva QMS Contributor', id:'318', ID:'318', ROLETYPE:'Veeva QMS Contributor', ROLETYPE_unquoted:Veeva QMS Contributor, val:'NC/DP Coordinator', controller:'workflowmanagement', role_unquoted:NC/DP Coordinator, ACCOUNTS:'0', REQUESTOR:946531, requestor:946531, COMPANY:'', COMPANY_unquoted:, environment:'', requestee:946531, CONTROLLER:'workflowmanagement', ACTION:'recreatedyna', roleType_unquoted:Veeva QMS Contributor, entity_unquoted:, ENTITY_unquoted:, roletype_unquoted:Veeva QMS Contributor, REQUESTEE:946531, accounts:'0', entity:''] 2023-01-24/06:55:39.670 [{}] [https-jsse-nio-443-exec-49] DEBUG println.PrintlnToLogger - Println :: SQL query is select distinct customproperty18 as id from roles where customproperty18 in ('PMI','VFPh','Otitopic') and 'Veeva QMS Contributor' = 'Veeva QMS Contributor' and endpointkey=366 union select distinct customproperty18 as id from roles where customproperty18 in ('PMI','VFPh','Otitopic') and 'Veeva QMS Contributor' = 'Veeva DMS Quality Contributor' and endpointkey=366 union select distinct customproperty18 as id from roles where customproperty18 in ('PMI','VFPh','Otitopic') and 'Veeva QMS Contributor' = 'Veeva RMS Quality Contributor' 2023-01-24/06:55:39.670 [{}] [https-jsse-nio-443-exec-49] DEBUG workflow.WorkflowmanagementController - SQL query is select distinct customproperty18 as id from roles where customproperty18 in ('PMI','VFPh','Otitopic') and 'Veeva QMS Contributor' = 'Veeva QMS Contributor' and endpointkey=366 union select distinct customproperty18 as id from roles where customproperty18 in ('PMI','VFPh','Otitopic') and 'Veeva QMS Contributor' = 'Veeva DMS Quality Contributor' and endpointkey=366 union select distinct customproperty18 as id from roles where customproperty18 in ('PMI','VFPh','Otitopic') and 'Veeva QMS Contributor' = 'Veeva RMS Quality Contributor' 2023-01-24/06:55:39.671 [{}] [https-jsse-nio-443-exec-49] DEBUG workflow.WorkflowmanagementController - attribute company need to be displayed done.. 2023-01-24/06:55:39.671 [{}] [https-jsse-nio-443-exec-49] DEBUG workflow.WorkflowmanagementController - processing attribute environment 2023-01-24/06:55:39.671 [{}] [https-jsse-nio-443-exec-49] DEBUG workflow.WorkflowmanagementController - attribute environment need to be displayed 2023-01-24/06:55:39.672 [{}] [https-jsse-nio-443-exec-49] DEBUG workflow.WorkflowmanagementController - dynamicAttributeMap11=====[company:, entity:, environment:, role:, roleType:Veeva QMS Contributor] 2023-01-24/06:55:39.672 [{}] [https-jsse-nio-443-exec-49] DEBUG workflow.WorkflowmanagementController - tempVal======'NC/DP Coordinator' 2023-01-24/06:55:39.672 [{}] [https-jsse-nio-443-exec-49] DEBUG workflow.WorkflowmanagementController - bindingMap====before ==[VAL:'NC/DP Coordinator', role:'NC/DP Coordinator', ROLE_unquoted:NC/DP Coordinator, ENVIRONMENT:'', roleType:'Veeva QMS Contributor', company_unquoted:, ENVIRONMENT_unquoted:, userkey:'946531', ROLE:'NC/DP Coordinator', environment_unquoted:, ?1:'1', USERKEY:'946531', ENTITY:'', action:'recreatedyna', company:'', roletype:'Veeva QMS Contributor', id:'318', ID:'318', ROLETYPE:'Veeva QMS Contributor', ROLETYPE_unquoted:Veeva QMS Contributor, val:'NC/DP Coordinator', controller:'workflowmanagement', role_unquoted:NC/DP Coordinator, ACCOUNTS:'0', REQUESTOR:946531, requestor:946531, COMPANY:'', COMPANY_unquoted:, environment:'', requestee:946531, CONTROLLER:'workflowmanagement', ACTION:'recreatedyna', roleType_unquoted:Veeva QMS Contributor, entity_unquoted:, ENTITY_unquoted:, roletype_unquoted:Veeva QMS Contributor, REQUESTEE:946531, accounts:'0', entity:''] 2023-01-24/06:55:39.672 [{}] [https-jsse-nio-443-exec-49] DEBUG println.PrintlnToLogger - Println :: bindingMap======[VAL:'NC/DP Coordinator', role:'NC/DP Coordinator', ROLE_unquoted:NC/DP Coordinator, ENVIRONMENT:'', roleType:'Veeva QMS Contributor', company_unquoted:, ENVIRONMENT_unquoted:, userkey:'946531', ROLE:'NC/DP Coordinator', environment_unquoted:, ?1:'1', USERKEY:'946531', ENTITY:'', action:'recreatedyna', company:'', roletype:'Veeva QMS Contributor', id:'318', ID:'318', ROLETYPE:'Veeva QMS Contributor', ROLETYPE_unquoted:Veeva QMS Contributor, val:'NC/DP Coordinator', controller:'workflowmanagement', role_unquoted:NC/DP Coordinator, ACCOUNTS:'0', REQUESTOR:946531, requestor:946531, COMPANY:'', COMPANY_unquoted:, environment:'', requestee:946531, CONTROLLER:'workflowmanagement', ACTION:'recreatedyna', roleType_unquoted:Veeva QMS Contributor, entity_unquoted:, ENTITY_unquoted:, roletype_unquoted:Veeva QMS Contributor, REQUESTEE:946531, accounts:'0', entity:''] 2023-01-24/06:55:39.672 [{}] [https-jsse-nio-443-exec-49] DEBUG workflow.WorkflowmanagementController - binding map is [VAL:'NC/DP Coordinator', role:'NC/DP Coordinator', ROLE_unquoted:NC/DP Coordinator, ENVIRONMENT:'', roleType:'Veeva QMS Contributor', company_unquoted:, ENVIRONMENT_unquoted:, userkey:'946531', ROLE:'NC/DP Coordinator', environment_unquoted:, ?1:'1', USERKEY:'946531', ENTITY:'', action:'recreatedyna', company:'', roletype:'Veeva QMS Contributor', id:'318', ID:'318', ROLETYPE:'Veeva QMS Contributor', ROLETYPE_unquoted:Veeva QMS Contributor, val:'NC/DP Coordinator', controller:'workflowmanagement', role_unquoted:NC/DP Coordinator, ACCOUNTS:'0', REQUESTOR:946531, requestor:946531, COMPANY:'', COMPANY_unquoted:, environment:'', requestee:946531, CONTROLLER:'workflowmanagement', ACTION:'recreatedyna', roleType_unquoted:Veeva QMS Contributor, entity_unquoted:, ENTITY_unquoted:, roletype_unquoted:Veeva QMS Contributor, REQUESTEE:946531, accounts:'0', entity:''] 2023-01-24/06:55:39.672 [{}] [https-jsse-nio-443-exec-49] DEBUG println.PrintlnToLogger - Println :: SQL query is select distinct customproperty20 as id from roles where customproperty19 = 'NC/DP Coordinator' and endpointkey=366 2023-01-24/06:55:39.672 [{}] [https-jsse-nio-443-exec-49] DEBUG workflow.WorkflowmanagementController - SQL query is select distinct customproperty20 as id from roles where customproperty19 = 'NC/DP Coordinator' and endpointkey=366 2023-01-24/06:55:39.770 [{}] [https-jsse-nio-443-exec-49] DEBUG workflow.WorkflowmanagementController - attribute environment need to be displayed done.. 2023-01-24/06:55:39.770 [{}] [https-jsse-nio-443-exec-49] DEBUG println.PrintlnToLogger - Println :: returnMap= [316:, 319:] 2023-01-24/06:55:39.770 [{}] [https-jsse-nio-443-exec-49] DEBUG workflow.WorkflowmanagementController - exit recreatedyna attrid = 318 2023-01-24/06:55:39.955 [{}] [https-jsse-nio-443-exec-24] DEBUG workflow.WorkflowmanagementController - enter recreatedyna attrid = 316 2023-01-24/06:55:39.955 [{}] [https-jsse-nio-443-exec-24] DEBUG workflow.WorkflowmanagementController - attrToHide = [] 2023-01-24/06:55:39.960 [{}] [https-jsse-nio-443-exec-24] DEBUG workflow.WorkflowmanagementController - processing attribute entity 2023-01-24/06:55:39.960 [{}] [https-jsse-nio-443-exec-24] DEBUG workflow.WorkflowmanagementController - attribute entity need to be displayed 2023-01-24/06:55:39.960 [{}] [https-jsse-nio-443-exec-24] DEBUG workflow.WorkflowmanagementController - dynamicAttributeMap11=====[company:, entity:, environment:, role:, roleType:Veeva QMS Contributor] 2023-01-24/06:55:39.960 [{}] [https-jsse-nio-443-exec-24] DEBUG workflow.WorkflowmanagementController - tempVal======'' 2023-01-24/06:55:39.960 [{}] [https-jsse-nio-443-exec-24] DEBUG workflow.WorkflowmanagementController - bindingMap====before ==[role:'NC/DP Coordinator', ROLE_unquoted:, ENVIRONMENT:'', roleType:'Veeva QMS Contributor', company_unquoted:, ENVIRONMENT_unquoted:, userkey:'946531', ROLE:'NC/DP Coordinator', environment_unquoted:, ?1:'1', USERKEY:'946531', ENTITY:'', action:'recreatedyna', company:'', roletype:'Veeva QMS Contributor', id:'316', ID:'316', ROLETYPE:'Veeva QMS Contributor', ROLETYPE_unquoted:Veeva QMS Contributor, controller:'workflowmanagement', role_unquoted:, ACCOUNTS:'0', REQUESTOR:946531, requestor:946531, COMPANY:'', COMPANY_unquoted:, environment:'', requestee:946531, CONTROLLER:'workflowmanagement', ACTION:'recreatedyna', roleType_unquoted:Veeva QMS Contributor, entity_unquoted:, ENTITY_unquoted:, roletype_unquoted:Veeva QMS Contributor, REQUESTEE:946531, accounts:'0', entity:''] 2023-01-24/06:55:39.960 [{}] [https-jsse-nio-443-exec-24] DEBUG println.PrintlnToLogger - Println :: bindingMap======[role:'NC/DP Coordinator', ROLE_unquoted:, ENVIRONMENT:'', roleType:'Veeva QMS Contributor', company_unquoted:, ENVIRONMENT_unquoted:, userkey:'946531', ROLE:'NC/DP Coordinator', environment_unquoted:, ?1:'1', USERKEY:'946531', ENTITY:'', action:'recreatedyna', company:'', roletype:'Veeva QMS Contributor', id:'316', ID:'316', ROLETYPE:'Veeva QMS Contributor', ROLETYPE_unquoted:Veeva QMS Contributor, controller:'workflowmanagement', role_unquoted:, ACCOUNTS:'0', REQUESTOR:946531, requestor:946531, COMPANY:'', COMPANY_unquoted:, environment:'', requestee:946531, CONTROLLER:'workflowmanagement', ACTION:'recreatedyna', roleType_unquoted:Veeva QMS Contributor, entity_unquoted:, ENTITY_unquoted:, roletype_unquoted:Veeva QMS Contributor, REQUESTEE:946531, accounts:'0', entity:''] 2023-01-24/06:55:39.960 [{}] [https-jsse-nio-443-exec-24] DEBUG workflow.WorkflowmanagementController - binding map is [role:'NC/DP Coordinator', ROLE_unquoted:, ENVIRONMENT:'', roleType:'Veeva QMS Contributor', company_unquoted:, ENVIRONMENT_unquoted:, userkey:'946531', ROLE:'NC/DP Coordinator', environment_unquoted:, ?1:'1', USERKEY:'946531', ENTITY:'', action:'recreatedyna', company:'', roletype:'Veeva QMS Contributor', id:'316', ID:'316', ROLETYPE:'Veeva QMS Contributor', ROLETYPE_unquoted:Veeva QMS Contributor, controller:'workflowmanagement', role_unquoted:, ACCOUNTS:'0', REQUESTOR:946531, requestor:946531, COMPANY:'', COMPANY_unquoted:, environment:'', requestee:946531, CONTROLLER:'workflowmanagement', ACTION:'recreatedyna', roleType_unquoted:Veeva QMS Contributor, entity_unquoted:, ENTITY_unquoted:, roletype_unquoted:Veeva QMS Contributor, REQUESTEE:946531, accounts:'0', entity:''] 2023-01-24/06:55:39.960 [{}] [https-jsse-nio-443-exec-24] DEBUG println.PrintlnToLogger - Println :: SQL query is select distinct customproperty7 as id from roles where customproperty18 = '' and customproperty7 is not null and endpointkey=366 ORDER BY customproperty7 ASC 2023-01-24/06:55:39.960 [{}] [https-jsse-nio-443-exec-24] DEBUG workflow.WorkflowmanagementController - SQL query is select distinct customproperty7 as id from roles where customproperty18 = '' and customproperty7 is not null and endpointkey=366 ORDER BY customproperty7 ASC 2023-01-24/06:55:39.961 [{}] [https-jsse-nio-443-exec-24] DEBUG workflow.WorkflowmanagementController - attribute entity need to be displayed done.. 2023-01-24/06:55:39.961 [{}] [https-jsse-nio-443-exec-24] DEBUG println.PrintlnToLogger - Println :: returnMap= [317:] 2023-01-24/06:55:39.961 [{}] [https-jsse-nio-443-exec-24] DEBUG workflow.WorkflowmanagementController - exit recreatedyna attrid = 316 2023-01-24/06:55:40.153 [{}] [https-jsse-nio-443-exec-14] DEBUG workflow.WorkflowmanagementController - enter recreatedyna attrid = 317 2023-01-24/06:55:40.153 [{}] [https-jsse-nio-443-exec-14] DEBUG workflow.WorkflowmanagementController - attrToHide = [] 2023-01-24/06:55:40.158 [{}] [https-jsse-nio-443-exec-14] DEBUG workflow.WorkflowmanagementController - exit recreatedyna attrid = 317 2023-01-24/06:55:40.236 [{}] [pool-5-thread-5] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:40.302 [{}] [pool-5-thread-1] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:40.397 [{}] [https-jsse-nio-443-exec-5] DEBUG workflow.WorkflowmanagementController - enter recreatedyna attrid = 319 2023-01-24/06:55:40.397 [{}] [https-jsse-nio-443-exec-5] DEBUG workflow.WorkflowmanagementController - attrToHide = [] 2023-01-24/06:55:40.402 [{}] [https-jsse-nio-443-exec-5] DEBUG workflow.WorkflowmanagementController - exit recreatedyna attrid = 319 2023-01-24/06:55:40.563 [{}] [pool-5-thread-2] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:40.644 [{}] [https-jsse-nio-443-exec-2] DEBUG workflow.WorkflowmanagementController - Enter entitlementmap : [userkey:946531, accountkey:1000541143, accountname:1000541143, endpoint:366, attributeEndpoint315: Veeva QMS Contributor, attributeEndpoint318: NC/DP Coordinator, attributeEndpoint316: , attributeEndpoint317: , attributeEndpoint319:, muteemail:, undefined:, number:0, controller:workflowmanagement, action:entitlementmap] 2023-01-24/06:55:40.651 [{}] [https-jsse-nio-443-exec-2] DEBUG workflow.WorkflowmanagementController - uparam= [:] 2023-01-24/06:55:40.661 [{}] [https-jsse-nio-443-exec-2] DEBUG workflow.WorkflowmanagementController - Exit entitlementmap 2023-01-24/06:55:40.682 [{}] [https-jsse-nio-443-exec-2] DEBUG workflow.WorkflowmanagementController - existingQuery: select distinct rua.rolekey from Role_user_account rua where rua.rolekey.endpointkey=366 and rua.userkey=946531 and rua.rolekey.requestable=true and rua.rolekey.status=1 and rua.accountkey.status in ('1', 'Manually Provisioned', 'ACTIVE') 2023-01-24/06:55:40.682 [{}] [https-jsse-nio-443-exec-2] DEBUG workflow.WorkflowmanagementController - temp size: 0 2023-01-24/06:55:40.939 [{}] [https-jsse-nio-443-exec-6] DEBUG println.PrintlnToLogger - Println :: [sEcho:1, iColumns:3, sColumns:, iDisplayStart:0, iDisplayLength:5, mDataProp_0:role_name, mDataProp_1:description, mDataProp_2:action, sSearch:, bRegex:false, sSearch_0:, bRegex_0:false, bSearchable_0:true, sSearch_1:, bRegex_1:false, bSearchable_1:true, sSearch_2:, bRegex_2:false, bSearchable_2:true, iSortCol_0:0, sSortDir_0:asc, iSortingCols:1, bSortable_0:true, bSortable_1:true, bSortable_2:false, endpoint:366, all:ALL, multi:null, roleType:4, requestFrom:2, userkey:946531, accountname:1000541143, jsontype:datatable, role_name:, description:, displayname:, glossary:, customproperty1:, customproperty2:, customproperty3:, controller:workflowmanagement, action:applicationRoleMapjson, max:5, offset:0, sort:role_name, order:asc] 2023-01-24/06:55:40.939 [{}] [https-jsse-nio-443-exec-6] DEBUG workflow.WorkflowmanagementController - listQry:select r from Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = '' and r.customproperty7 in () and r.customproperty19 = 'NC/DP Coordinator' and r.customproperty20 IN ()) order by r.role_name asc 2023-01-24/06:55:40.942 [{}] [https-jsse-nio-443-exec-1] DEBUG workflow.WorkflowmanagementController - listQry:select r from Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id in(0) 2023-01-24/06:55:40.977 [{}] [https-jsse-nio-443-exec-6] ERROR hql.PARSER - :0:0: unexpected end of subtree 2023-01-24/06:55:40.977 [{}] [https-jsse-nio-443-exec-6] ERROR hql.PARSER - :0:0: unexpected end of subtree 2023-01-24/06:55:40.981 [{}] [https-jsse-nio-443-exec-6] ERROR errors.GrailsExceptionResolver - QuerySyntaxException occurred when processing request: [POST] /ECM/workflowmanagement/applicationRoleMapjson unexpected end of subtree [select r from com.saviynt.ecm.identitywarehouse.domain.Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = '' and r.customproperty7 in () and r.customproperty19 = 'NC/DP Coordinator' and r.customproperty20 IN ()) order by r.role_name asc]. Stacktrace follows: org.hibernate.hql.ast.QuerySyntaxException: unexpected end of subtree [select r from com.saviynt.ecm.identitywarehouse.domain.Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = '' and r.customproperty7 in () and r.customproperty19 = 'NC/DP Coordinator' and r.customproperty20 IN ()) order by r.role_name asc] at com.saviynt.ecm.workflow.WorkflowmanagementController$_closure344.doCall(WorkflowmanagementController.groovy:20554) at grails.plugin.springsecurity.web.filter.GrailsAnonymousAuthenticationFilter.doFilter(GrailsAnonymousAuthenticationFilter.java:53) at com.saviynt.webservice.SaviyntRestAuthenticationFilter.doFilter(SaviyntRestAuthenticationFilter.groovy:145) 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.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) 2023-01-24/06:55:40.985 [{}] [https-jsse-nio-443-exec-6] ERROR error.ErrorController - Exception org.codehaus.groovy.grails.web.errors.GrailsWrappedRuntimeException: unexpected end of subtree [select r from com.saviynt.ecm.identitywarehouse.domain.Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = '' and r.customproperty7 in () and r.customproperty19 = 'NC/DP Coordinator' and r.customproperty20 IN ()) order by r.role_name asc] at grails.plugin.springsecurity.web.filter.GrailsAnonymousAuthenticationFilter.doFilter(GrailsAnonymousAuthenticationFilter.java:53) at com.saviynt.webservice.SaviyntRestAuthenticationFilter.doFilter(SaviyntRestAuthenticationFilter.groovy:145) 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.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: org.hibernate.hql.ast.QuerySyntaxException: unexpected end of subtree [select r from com.saviynt.ecm.identitywarehouse.domain.Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = '' and r.customproperty7 in () and r.customproperty19 = 'NC/DP Coordinator' and r.customproperty20 IN ()) order by r.role_name asc] at com.saviynt.ecm.workflow.WorkflowmanagementController$_closure344.doCall(WorkflowmanagementController.groovy:20554) ... 9 more 2023-01-24/06:55:43.600 [{}] [https-jsse-nio-443-exec-50] DEBUG workflow.WorkflowmanagementController - attribute entity need to be displayed 2023-01-24/06:55:43.600 [{}] [https-jsse-nio-443-exec-50] DEBUG workflow.WorkflowmanagementController - dynamicAttributeMap11=====[company:, entity:, environment:, role:NC/DP Coordinator, roleType:Veeva QMS Contributor] 2023-01-24/06:55:43.601 [{}] [https-jsse-nio-443-exec-50] DEBUG workflow.WorkflowmanagementController - tempVal======'PMI' 2023-01-24/06:55:43.601 [{}] [https-jsse-nio-443-exec-50] DEBUG workflow.WorkflowmanagementController - bindingMap====before ==[VAL:'PMI', role:'NC/DP Coordinator', ROLE_unquoted:NC/DP Coordinator, ENVIRONMENT:'', roleType:'Veeva QMS Contributor', company_unquoted:PMI, ENVIRONMENT_unquoted:, userkey:'946531', ROLE:'NC/DP Coordinator', environment_unquoted:, ?1:'1', USERKEY:'946531', ENTITY:'', action:'recreatedyna', company:'PMI', roletype:'Veeva QMS Contributor', id:'316', ID:'316', ROLETYPE:'Veeva QMS Contributor', ROLETYPE_unquoted:Veeva QMS Contributor, val:'PMI', controller:'workflowmanagement', role_unquoted:NC/DP Coordinator, ACCOUNTS:'0', REQUESTOR:946531, requestor:946531, COMPANY:'PMI', COMPANY_unquoted:PMI, environment:'', requestee:946531, CONTROLLER:'workflowmanagement', ACTION:'recreatedyna', roleType_unquoted:Veeva QMS Contributor, entity_unquoted:, ENTITY_unquoted:, roletype_unquoted:Veeva QMS Contributor, REQUESTEE:946531, accounts:'0', entity:''] 2023-01-24/06:55:43.601 [{}] [https-jsse-nio-443-exec-50] DEBUG println.PrintlnToLogger - Println :: bindingMap======[VAL:'PMI', role:'NC/DP Coordinator', ROLE_unquoted:NC/DP Coordinator, ENVIRONMENT:'', roleType:'Veeva QMS Contributor', company_unquoted:PMI, ENVIRONMENT_unquoted:, userkey:'946531', ROLE:'NC/DP Coordinator', environment_unquoted:, ?1:'1', USERKEY:'946531', ENTITY:'', action:'recreatedyna', company:'PMI', roletype:'Veeva QMS Contributor', id:'316', ID:'316', ROLETYPE:'Veeva QMS Contributor', ROLETYPE_unquoted:Veeva QMS Contributor, val:'PMI', controller:'workflowmanagement', role_unquoted:NC/DP Coordinator, ACCOUNTS:'0', REQUESTOR:946531, requestor:946531, COMPANY:'PMI', COMPANY_unquoted:PMI, environment:'', requestee:946531, CONTROLLER:'workflowmanagement', ACTION:'recreatedyna', roleType_unquoted:Veeva QMS Contributor, entity_unquoted:, ENTITY_unquoted:, roletype_unquoted:Veeva QMS Contributor, REQUESTEE:946531, accounts:'0', entity:''] 2023-01-24/06:55:43.601 [{}] [https-jsse-nio-443-exec-50] DEBUG workflow.WorkflowmanagementController - binding map is [VAL:'PMI', role:'NC/DP Coordinator', ROLE_unquoted:NC/DP Coordinator, ENVIRONMENT:'', roleType:'Veeva QMS Contributor', company_unquoted:PMI, ENVIRONMENT_unquoted:, userkey:'946531', ROLE:'NC/DP Coordinator', environment_unquoted:, ?1:'1', USERKEY:'946531', ENTITY:'', action:'recreatedyna', company:'PMI', roletype:'Veeva QMS Contributor', id:'316', ID:'316', ROLETYPE:'Veeva QMS Contributor', ROLETYPE_unquoted:Veeva QMS Contributor, val:'PMI', controller:'workflowmanagement', role_unquoted:NC/DP Coordinator, ACCOUNTS:'0', REQUESTOR:946531, requestor:946531, COMPANY:'PMI', COMPANY_unquoted:PMI, environment:'', requestee:946531, CONTROLLER:'workflowmanagement', ACTION:'recreatedyna', roleType_unquoted:Veeva QMS Contributor, entity_unquoted:, ENTITY_unquoted:, roletype_unquoted:Veeva QMS Contributor, REQUESTEE:946531, accounts:'0', entity:''] 2023-01-24/06:55:43.601 [{}] [https-jsse-nio-443-exec-50] DEBUG println.PrintlnToLogger - Println :: SQL query is select distinct customproperty7 as id from roles where customproperty18 = 'PMI' and customproperty7 is not null and endpointkey=366 ORDER BY customproperty7 ASC 2023-01-24/06:55:43.601 [{}] [https-jsse-nio-443-exec-50] DEBUG workflow.WorkflowmanagementController - SQL query is select distinct customproperty7 as id from roles where customproperty18 = 'PMI' and customproperty7 is not null and endpointkey=366 ORDER BY customproperty7 ASC 2023-01-24/06:55:43.700 [{}] [https-jsse-nio-443-exec-50] DEBUG workflow.WorkflowmanagementController - attribute entity need to be displayed done.. 2023-01-24/06:55:43.700 [{}] [https-jsse-nio-443-exec-50] DEBUG println.PrintlnToLogger - Println :: returnMap= [317:] 2023-01-24/06:55:43.700 [{}] [https-jsse-nio-443-exec-50] DEBUG workflow.WorkflowmanagementController - exit recreatedyna attrid = 316 2023-01-24/06:55:43.897 [{}] [https-jsse-nio-443-exec-44] DEBUG workflow.WorkflowmanagementController - enter recreatedyna attrid = 317 2023-01-24/06:55:43.897 [{}] [https-jsse-nio-443-exec-44] DEBUG workflow.WorkflowmanagementController - attrToHide = [] 2023-01-24/06:55:43.901 [{}] [https-jsse-nio-443-exec-44] DEBUG workflow.WorkflowmanagementController - exit recreatedyna attrid = 317 2023-01-24/06:55:44.117 [{}] [https-jsse-nio-443-exec-52] DEBUG workflow.WorkflowmanagementController - Enter entitlementmap : [userkey:946531, accountkey:1000541143, accountname:1000541143, endpoint:366, attributeEndpoint315: Veeva QMS Contributor, attributeEndpoint318: NC/DP Coordinator, attributeEndpoint316: PMI, attributeEndpoint317: , attributeEndpoint319:, muteemail:, undefined:, number:0, controller:workflowmanagement, action:entitlementmap] 2023-01-24/06:55:44.123 [{}] [https-jsse-nio-443-exec-52] DEBUG workflow.WorkflowmanagementController - uparam= [:] 2023-01-24/06:55:44.133 [{}] [https-jsse-nio-443-exec-52] DEBUG workflow.WorkflowmanagementController - Exit entitlementmap 2023-01-24/06:55:44.154 [{}] [https-jsse-nio-443-exec-52] DEBUG workflow.WorkflowmanagementController - existingQuery: select distinct rua.rolekey from Role_user_account rua where rua.rolekey.endpointkey=366 and rua.userkey=946531 and rua.rolekey.requestable=true and rua.rolekey.status=1 and rua.accountkey.status in ('1', 'Manually Provisioned', 'ACTIVE') 2023-01-24/06:55:44.154 [{}] [https-jsse-nio-443-exec-52] DEBUG workflow.WorkflowmanagementController - temp size: 0 2023-01-24/06:55:44.250 [{}] [pool-5-thread-2] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:44.315 [{}] [pool-5-thread-3] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:44.390 [{}] [https-jsse-nio-443-exec-38] DEBUG println.PrintlnToLogger - Println :: [sEcho:1, iColumns:3, sColumns:, iDisplayStart:0, iDisplayLength:5, mDataProp_0:role_name, mDataProp_1:description, mDataProp_2:action, sSearch:, bRegex:false, sSearch_0:, bRegex_0:false, bSearchable_0:true, sSearch_1:, bRegex_1:false, bSearchable_1:true, sSearch_2:, bRegex_2:false, bSearchable_2:true, iSortCol_0:0, sSortDir_0:asc, iSortingCols:1, bSortable_0:true, bSortable_1:true, bSortable_2:false, endpoint:366, all:ALL, multi:null, roleType:4, requestFrom:2, userkey:946531, accountname:1000541143, jsontype:datatable, role_name:, description:, displayname:, glossary:, customproperty1:, customproperty2:, customproperty3:, controller:workflowmanagement, action:applicationRoleMapjson, max:5, offset:0, sort:role_name, order:asc] 2023-01-24/06:55:44.390 [{}] [https-jsse-nio-443-exec-38] DEBUG workflow.WorkflowmanagementController - listQry:select r from Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = 'PMI' and r.customproperty7 in () and r.customproperty19 = 'NC/DP Coordinator' and r.customproperty20 IN ()) order by r.role_name asc 2023-01-24/06:55:44.403 [{}] [https-jsse-nio-443-exec-22] DEBUG workflow.WorkflowmanagementController - listQry:select r from Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id in(0) 2023-01-24/06:55:44.408 [{}] [https-jsse-nio-443-exec-38] ERROR hql.PARSER - :0:0: unexpected end of subtree 2023-01-24/06:55:44.409 [{}] [https-jsse-nio-443-exec-38] ERROR hql.PARSER - :0:0: unexpected end of subtree 2023-01-24/06:55:44.412 [{}] [https-jsse-nio-443-exec-38] ERROR errors.GrailsExceptionResolver - QuerySyntaxException occurred when processing request: [POST] /ECM/workflowmanagement/applicationRoleMapjson unexpected end of subtree [select r from com.saviynt.ecm.identitywarehouse.domain.Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = 'PMI' and r.customproperty7 in () and r.customproperty19 = 'NC/DP Coordinator' and r.customproperty20 IN ()) order by r.role_name asc]. Stacktrace follows: org.hibernate.hql.ast.QuerySyntaxException: unexpected end of subtree [select r from com.saviynt.ecm.identitywarehouse.domain.Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = 'PMI' and r.customproperty7 in () and r.customproperty19 = 'NC/DP Coordinator' and r.customproperty20 IN ()) order by r.role_name asc] at com.saviynt.ecm.workflow.WorkflowmanagementController$_closure344.doCall(WorkflowmanagementController.groovy:20554) at grails.plugin.springsecurity.web.filter.GrailsAnonymousAuthenticationFilter.doFilter(GrailsAnonymousAuthenticationFilter.java:53) at com.saviynt.webservice.SaviyntRestAuthenticationFilter.doFilter(SaviyntRestAuthenticationFilter.groovy:145) 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.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) 2023-01-24/06:55:44.415 [{}] [https-jsse-nio-443-exec-38] ERROR error.ErrorController - Exception org.codehaus.groovy.grails.web.errors.GrailsWrappedRuntimeException: unexpected end of subtree [select r from com.saviynt.ecm.identitywarehouse.domain.Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = 'PMI' and r.customproperty7 in () and r.customproperty19 = 'NC/DP Coordinator' and r.customproperty20 IN ()) order by r.role_name asc] at grails.plugin.springsecurity.web.filter.GrailsAnonymousAuthenticationFilter.doFilter(GrailsAnonymousAuthenticationFilter.java:53) at com.saviynt.webservice.SaviyntRestAuthenticationFilter.doFilter(SaviyntRestAuthenticationFilter.groovy:145) 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.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: org.hibernate.hql.ast.QuerySyntaxException: unexpected end of subtree [select r from com.saviynt.ecm.identitywarehouse.domain.Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = 'PMI' and r.customproperty7 in () and r.customproperty19 = 'NC/DP Coordinator' and r.customproperty20 IN ()) order by r.role_name asc] at com.saviynt.ecm.workflow.WorkflowmanagementController$_closure344.doCall(WorkflowmanagementController.groovy:20554) ... 9 more 2023-01-24/06:55:44.571 [{}] [pool-5-thread-1] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:44.662 [{}] [https-jsse-nio-443-exec-33] INFO domain.JobcontrolController - Auditing for list of JobControl 2023-01-24/06:55:44.662 [{}] [https-jsse-nio-443-exec-33] INFO domain.JobcontrolController - Auditing process completed for JobControl 2023-01-24/06:55:45.237 [{}] [pool-5-thread-3] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:45.302 [{}] [pool-5-thread-5] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:45.632 [{}] [https-jsse-nio-443-exec-15] INFO services.UsersService - starting to process roles auditing 2023-01-24/06:55:45.634 [{}] [https-jsse-nio-443-exec-15] INFO services.UsersService - Auditing for role_otherAttribute action 2023-01-24/06:55:45.636 [{}] [https-jsse-nio-443-exec-15] INFO services.UsersService - Auditing process completed for entitlement 2023-01-24/06:55:46.237 [{}] [pool-5-thread-2] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:46.302 [{}] [pool-5-thread-3] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:46.556 [{}] [pool-5-thread-1] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:47.236 [{}] [pool-5-thread-3] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:47.304 [{}] [pool-5-thread-5] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:48.237 [{}] [pool-5-thread-2] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:48.300 [{}] [pool-5-thread-3] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:48.558 [{}] [pool-5-thread-1] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:49.236 [{}] [pool-5-thread-3] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:49.301 [{}] [pool-5-thread-5] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:49.315 [{}] [https-jsse-nio-443-exec-8] DEBUG workflow.WorkflowmanagementController - enter recreatedyna attrid = 317 2023-01-24/06:55:49.315 [{}] [https-jsse-nio-443-exec-8] DEBUG workflow.WorkflowmanagementController - attrToHide = [] 2023-01-24/06:55:49.319 [{}] [https-jsse-nio-443-exec-8] DEBUG workflow.WorkflowmanagementController - exit recreatedyna attrid = 317 2023-01-24/06:55:49.521 [{}] [https-jsse-nio-443-exec-28] DEBUG workflow.WorkflowmanagementController - Enter entitlementmap : [userkey:946531, accountkey:1000541143, accountname:1000541143, endpoint:366, attributeEndpoint315: Veeva QMS Contributor, attributeEndpoint318: NC/DP Coordinator, attributeEndpoint316: PMI, attributeEndpoint317: Argentina (Merlo) - 75, attributeEndpoint319:, muteemail:, undefined:, number:0, controller:workflowmanagement, action:entitlementmap] 2023-01-24/06:55:49.528 [{}] [https-jsse-nio-443-exec-28] DEBUG workflow.WorkflowmanagementController - uparam= [:] 2023-01-24/06:55:49.538 [{}] [https-jsse-nio-443-exec-28] DEBUG workflow.WorkflowmanagementController - Exit entitlementmap 2023-01-24/06:55:49.560 [{}] [https-jsse-nio-443-exec-28] DEBUG workflow.WorkflowmanagementController - existingQuery: select distinct rua.rolekey from Role_user_account rua where rua.rolekey.endpointkey=366 and rua.userkey=946531 and rua.rolekey.requestable=true and rua.rolekey.status=1 and rua.accountkey.status in ('1', 'Manually Provisioned', 'ACTIVE') 2023-01-24/06:55:49.560 [{}] [https-jsse-nio-443-exec-28] DEBUG workflow.WorkflowmanagementController - temp size: 0 2023-01-24/06:55:49.564 [{}] [pool-5-thread-4] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:49.851 [{}] [https-jsse-nio-443-exec-34] DEBUG println.PrintlnToLogger - Println :: [sEcho:1, iColumns:3, sColumns:, iDisplayStart:0, iDisplayLength:5, mDataProp_0:role_name, mDataProp_1:description, mDataProp_2:action, sSearch:, bRegex:false, sSearch_0:, bRegex_0:false, bSearchable_0:true, sSearch_1:, bRegex_1:false, bSearchable_1:true, sSearch_2:, bRegex_2:false, bSearchable_2:true, iSortCol_0:0, sSortDir_0:asc, iSortingCols:1, bSortable_0:true, bSortable_1:true, bSortable_2:false, endpoint:366, all:ALL, multi:null, roleType:4, requestFrom:2, userkey:946531, accountname:1000541143, jsontype:datatable, role_name:, description:, displayname:, glossary:, customproperty1:, customproperty2:, customproperty3:, controller:workflowmanagement, action:applicationRoleMapjson, max:5, offset:0, sort:role_name, order:asc] 2023-01-24/06:55:49.851 [{}] [https-jsse-nio-443-exec-34] DEBUG workflow.WorkflowmanagementController - listQry:select r from Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = 'PMI' and r.customproperty7 in (Argentina (Merlo) - 75) and r.customproperty19 = 'NC/DP Coordinator' and r.customproperty20 IN ()) order by r.role_name asc 2023-01-24/06:55:49.867 [{}] [https-jsse-nio-443-exec-36] DEBUG workflow.WorkflowmanagementController - listQry:select r from Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id in(0) 2023-01-24/06:55:49.873 [{}] [https-jsse-nio-443-exec-34] ERROR hql.PARSER - :0:0: unexpected end of subtree 2023-01-24/06:55:49.877 [{}] [https-jsse-nio-443-exec-34] ERROR errors.GrailsExceptionResolver - QuerySyntaxException occurred when processing request: [POST] /ECM/workflowmanagement/applicationRoleMapjson unexpected end of subtree [select r from com.saviynt.ecm.identitywarehouse.domain.Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = 'PMI' and r.customproperty7 in (Argentina (Merlo) - 75) and r.customproperty19 = 'NC/DP Coordinator' and r.customproperty20 IN ()) order by r.role_name asc]. Stacktrace follows: org.hibernate.hql.ast.QuerySyntaxException: unexpected end of subtree [select r from com.saviynt.ecm.identitywarehouse.domain.Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = 'PMI' and r.customproperty7 in (Argentina (Merlo) - 75) and r.customproperty19 = 'NC/DP Coordinator' and r.customproperty20 IN ()) order by r.role_name asc] at com.saviynt.ecm.workflow.WorkflowmanagementController$_closure344.doCall(WorkflowmanagementController.groovy:20554) at grails.plugin.springsecurity.web.filter.GrailsAnonymousAuthenticationFilter.doFilter(GrailsAnonymousAuthenticationFilter.java:53) at com.saviynt.webservice.SaviyntRestAuthenticationFilter.doFilter(SaviyntRestAuthenticationFilter.groovy:145) 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.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) 2023-01-24/06:55:49.881 [{}] [https-jsse-nio-443-exec-34] ERROR error.ErrorController - Exception org.codehaus.groovy.grails.web.errors.GrailsWrappedRuntimeException: unexpected end of subtree [select r from com.saviynt.ecm.identitywarehouse.domain.Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = 'PMI' and r.customproperty7 in (Argentina (Merlo) - 75) and r.customproperty19 = 'NC/DP Coordinator' and r.customproperty20 IN ()) order by r.role_name asc] at grails.plugin.springsecurity.web.filter.GrailsAnonymousAuthenticationFilter.doFilter(GrailsAnonymousAuthenticationFilter.java:53) at com.saviynt.webservice.SaviyntRestAuthenticationFilter.doFilter(SaviyntRestAuthenticationFilter.groovy:145) 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.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: org.hibernate.hql.ast.QuerySyntaxException: unexpected end of subtree [select r from com.saviynt.ecm.identitywarehouse.domain.Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = 'PMI' and r.customproperty7 in (Argentina (Merlo) - 75) and r.customproperty19 = 'NC/DP Coordinator' and r.customproperty20 IN ()) order by r.role_name asc] at com.saviynt.ecm.workflow.WorkflowmanagementController$_closure344.doCall(WorkflowmanagementController.groovy:20554) ... 9 more 2023-01-24/06:55:50.237 [{}] [pool-5-thread-5] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:50.304 [{}] [pool-5-thread-1] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:50.510 [{}] [https-jsse-nio-443-exec-39] INFO services.UsersService - starting to process roles auditing 2023-01-24/06:55:50.512 [{}] [https-jsse-nio-443-exec-39] INFO services.UsersService - Auditing for role_dynamic_attribute action 2023-01-24/06:55:50.514 [{}] [https-jsse-nio-443-exec-39] INFO services.UsersService - Auditing process completed for entitlement 2023-01-24/06:55:50.706 [{}] [https-jsse-nio-443-exec-49] INFO services.UsersService - starting to process roles auditing 2023-01-24/06:55:50.709 [{}] [https-jsse-nio-443-exec-49] INFO services.UsersService - Auditing for dynamicattributesjson action 2023-01-24/06:55:50.709 [{}] [https-jsse-nio-443-exec-49] INFO services.UsersService - Auditing process completed for entitlement 2023-01-24/06:55:51.240 [{}] [pool-5-thread-3] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:51.305 [{}] [pool-5-thread-5] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:51.565 [{}] [pool-5-thread-4] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:52.236 [{}] [pool-5-thread-5] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:52.303 [{}] [pool-5-thread-1] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:52.561 [{}] [pool-5-thread-2] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:52.596 [{}] [https-jsse-nio-443-exec-9] DEBUG workflow.WorkflowmanagementController - enter recreatedyna attrid = 319 2023-01-24/06:55:52.596 [{}] [https-jsse-nio-443-exec-9] DEBUG workflow.WorkflowmanagementController - attrToHide = [] 2023-01-24/06:55:52.600 [{}] [https-jsse-nio-443-exec-9] DEBUG workflow.WorkflowmanagementController - exit recreatedyna attrid = 319 2023-01-24/06:55:52.794 [{}] [https-jsse-nio-443-exec-31] DEBUG workflow.WorkflowmanagementController - Enter entitlementmap : [userkey:946531, accountkey:1000541143, accountname:1000541143, endpoint:366, attributeEndpoint315: Veeva QMS Contributor, attributeEndpoint318: NC/DP Coordinator, attributeEndpoint316: PMI, attributeEndpoint317: Argentina (Merlo) - 75, attributeEndpoint319: DEV, muteemail:, undefined:, number:0, controller:workflowmanagement, action:entitlementmap] 2023-01-24/06:55:52.800 [{}] [https-jsse-nio-443-exec-31] DEBUG workflow.WorkflowmanagementController - uparam= [:] 2023-01-24/06:55:52.810 [{}] [https-jsse-nio-443-exec-31] DEBUG workflow.WorkflowmanagementController - Exit entitlementmap 2023-01-24/06:55:52.831 [{}] [https-jsse-nio-443-exec-31] DEBUG workflow.WorkflowmanagementController - existingQuery: select distinct rua.rolekey from Role_user_account rua where rua.rolekey.endpointkey=366 and rua.userkey=946531 and rua.rolekey.requestable=true and rua.rolekey.status=1 and rua.accountkey.status in ('1', 'Manually Provisioned', 'ACTIVE') 2023-01-24/06:55:52.831 [{}] [https-jsse-nio-443-exec-31] DEBUG workflow.WorkflowmanagementController - temp size: 0 2023-01-24/06:55:53.083 [{}] [https-jsse-nio-443-exec-21] DEBUG println.PrintlnToLogger - Println :: [sEcho:1, iColumns:3, sColumns:, iDisplayStart:0, iDisplayLength:5, mDataProp_0:role_name, mDataProp_1:description, mDataProp_2:action, sSearch:, bRegex:false, sSearch_0:, bRegex_0:false, bSearchable_0:true, sSearch_1:, bRegex_1:false, bSearchable_1:true, sSearch_2:, bRegex_2:false, bSearchable_2:true, iSortCol_0:0, sSortDir_0:asc, iSortingCols:1, bSortable_0:true, bSortable_1:true, bSortable_2:false, endpoint:366, all:ALL, multi:null, roleType:4, requestFrom:2, userkey:946531, accountname:1000541143, jsontype:datatable, role_name:, description:, displayname:, glossary:, customproperty1:, customproperty2:, customproperty3:, controller:workflowmanagement, action:applicationRoleMapjson, max:5, offset:0, sort:role_name, order:asc] 2023-01-24/06:55:53.083 [{}] [https-jsse-nio-443-exec-21] DEBUG workflow.WorkflowmanagementController - listQry:select r from Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = 'PMI' and r.customproperty7 in (Argentina (Merlo) - 75) and r.customproperty19 = 'NC/DP Coordinator' and r.customproperty20 IN (DEV)) order by r.role_name asc 2023-01-24/06:55:53.093 [{}] [https-jsse-nio-443-exec-1] DEBUG workflow.WorkflowmanagementController - listQry:select r from Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id in(0) 2023-01-24/06:55:53.129 [{}] [https-jsse-nio-443-exec-21] ERROR util.JDBCExceptionReporter - FUNCTION saviyntaws.Argentina does not exist 2023-01-24/06:55:53.134 [{}] [https-jsse-nio-443-exec-21] ERROR errors.GrailsExceptionResolver - MySQLSyntaxErrorException occurred when processing request: [POST] /ECM/workflowmanagement/applicationRoleMapjson FUNCTION saviyntaws.Argentina does not exist. Stacktrace follows: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION saviyntaws.Argentina does not exist at com.mysql.jdbc.Util.handleNewInstance(Util.java:400) at com.mysql.jdbc.Util.getInstance(Util.java:383) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2002) at com.saviynt.ecm.workflow.WorkflowmanagementController$_closure344.doCall(WorkflowmanagementController.groovy:20554) at grails.plugin.springsecurity.web.filter.GrailsAnonymousAuthenticationFilter.doFilter(GrailsAnonymousAuthenticationFilter.java:53) at com.saviynt.webservice.SaviyntRestAuthenticationFilter.doFilter(SaviyntRestAuthenticationFilter.groovy:145) 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.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) 2023-01-24/06:55:53.137 [{}] [https-jsse-nio-443-exec-21] ERROR error.ErrorController - Exception org.codehaus.groovy.grails.web.errors.GrailsWrappedRuntimeException: FUNCTION saviyntaws.Argentina does not exist at grails.plugin.springsecurity.web.filter.GrailsAnonymousAuthenticationFilter.doFilter(GrailsAnonymousAuthenticationFilter.java:53) at com.saviynt.webservice.SaviyntRestAuthenticationFilter.doFilter(SaviyntRestAuthenticationFilter.groovy:145) 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.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION saviyntaws.Argentina does not exist at com.mysql.jdbc.Util.handleNewInstance(Util.java:400) at com.mysql.jdbc.Util.getInstance(Util.java:383) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2002) at com.saviynt.ecm.workflow.WorkflowmanagementController$_closure344.doCall(WorkflowmanagementController.groovy:20554) ... 9 more 2023-01-24/06:55:53.238 [{}] [pool-5-thread-1] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:53.303 [{}] [pool-5-thread-4] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:53.559 [{}] [pool-5-thread-3] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:53.852 [{}] [https-jsse-nio-443-exec-6] INFO services.UsersService - starting to process roles auditing 2023-01-24/06:55:53.854 [{}] [https-jsse-nio-443-exec-6] INFO services.UsersService - Auditing for getEntitlementValuesJson action 2023-01-24/06:55:53.854 [{}] [https-jsse-nio-443-exec-6] INFO services.UsersService - Auditing process completed for entitlement 2023-01-24/06:55:54.238 [{}] [pool-5-thread-4] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:54.305 [{}] [pool-5-thread-2] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:55.241 [{}] [pool-5-thread-1] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:55.307 [{}] [pool-5-thread-4] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:55.572 [{}] [pool-5-thread-3] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:55.733 [{}] [https-jsse-nio-443-exec-13] DEBUG workflow.WorkflowmanagementController - enter recreatedyna attrid = 319 2023-01-24/06:55:55.733 [{}] [https-jsse-nio-443-exec-13] DEBUG workflow.WorkflowmanagementController - attrToHide = [] 2023-01-24/06:55:55.737 [{}] [https-jsse-nio-443-exec-13] DEBUG workflow.WorkflowmanagementController - exit recreatedyna attrid = 319 2023-01-24/06:55:55.923 [{}] [https-jsse-nio-443-exec-16] DEBUG workflow.WorkflowmanagementController - Enter entitlementmap : [userkey:946531, accountkey:1000541143, accountname:1000541143, endpoint:366, attributeEndpoint315: Veeva QMS Contributor, attributeEndpoint318: NC/DP Coordinator, attributeEndpoint316: PMI, attributeEndpoint317: Argentina (Merlo) - 75, attributeEndpoint319: DEV,QAS, muteemail:, undefined:, number:0, controller:workflowmanagement, action:entitlementmap] 2023-01-24/06:55:55.930 [{}] [https-jsse-nio-443-exec-16] DEBUG workflow.WorkflowmanagementController - uparam= [:] 2023-01-24/06:55:55.940 [{}] [https-jsse-nio-443-exec-16] DEBUG workflow.WorkflowmanagementController - Exit entitlementmap 2023-01-24/06:55:55.960 [{}] [https-jsse-nio-443-exec-16] DEBUG workflow.WorkflowmanagementController - existingQuery: select distinct rua.rolekey from Role_user_account rua where rua.rolekey.endpointkey=366 and rua.userkey=946531 and rua.rolekey.requestable=true and rua.rolekey.status=1 and rua.accountkey.status in ('1', 'Manually Provisioned', 'ACTIVE') 2023-01-24/06:55:55.960 [{}] [https-jsse-nio-443-exec-16] DEBUG workflow.WorkflowmanagementController - temp size: 0 2023-01-24/06:55:56.242 [{}] [pool-5-thread-4] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:56.307 [{}] [https-jsse-nio-443-exec-27] DEBUG println.PrintlnToLogger - Println :: [sEcho:1, iColumns:3, sColumns:, iDisplayStart:0, iDisplayLength:5, mDataProp_0:role_name, mDataProp_1:description, mDataProp_2:action, sSearch:, bRegex:false, sSearch_0:, bRegex_0:false, bSearchable_0:true, sSearch_1:, bRegex_1:false, bSearchable_1:true, sSearch_2:, bRegex_2:false, bSearchable_2:true, iSortCol_0:0, sSortDir_0:asc, iSortingCols:1, bSortable_0:true, bSortable_1:true, bSortable_2:false, endpoint:366, all:ALL, multi:null, roleType:4, requestFrom:2, userkey:946531, accountname:1000541143, jsontype:datatable, role_name:, description:, displayname:, glossary:, customproperty1:, customproperty2:, customproperty3:, controller:workflowmanagement, action:applicationRoleMapjson, max:5, offset:0, sort:role_name, order:asc] 2023-01-24/06:55:56.308 [{}] [https-jsse-nio-443-exec-27] DEBUG workflow.WorkflowmanagementController - listQry:select r from Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id not in(0) and r.id not in(-1) and (r.customproperty18 = 'PMI' and r.customproperty7 in (Argentina (Merlo) - 75) and r.customproperty19 = 'NC/DP Coordinator' and r.customproperty20 IN ('DEV'',''QAS')) order by r.role_name asc 2023-01-24/06:55:56.310 [{}] [pool-5-thread-2] DEBUG println.PrintlnToLogger - Println :: INSERT =1 2023-01-24/06:55:56.313 [{}] [https-jsse-nio-443-exec-41] DEBUG workflow.WorkflowmanagementController - listQry:select r from Roles r where r.status=1 and r.requestable=true and r.roletype=4 and r.endpointkey=366 and r.id in(0) 2023-01-24/06:55:56.331 [{}] [https-jsse-nio-443-exec-27] ERROR util.JDBCExceptionReporter - FUNCTION saviyntaws.Argentina does not exist 2023-01-24/06:55:56.337 [{}] [https-jsse-nio-443-exec-27] ERROR errors.GrailsExceptionResolver - MySQLSyntaxErrorException occurred when processing request: [POST] /ECM/workflowmanagement/applicationRoleMapjson FUNCTION saviyntaws.Argentina does not exist. Stacktrace follows: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION saviyntaws.Argentina does not exist at com.mysql.jdbc.Util.handleNewInstance(Util.java:400) at com.mysql.jdbc.Util.getInstance(Util.java:383) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2002) at com.saviynt.ecm.workflow.WorkflowmanagementController$_closure344.doCall(WorkflowmanagementController.groovy:20554) at grails.plugin.springsecurity.web.filter.GrailsAnonymousAuthenticationFilter.doFilter(GrailsAnonymousAuthenticationFilter.java:53) at com.saviynt.webservice.SaviyntRestAuthenticationFilter.doFilter(SaviyntRestAuthenticationFilter.groovy:145) 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.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) 2023-01-24/06:55:56.341 [{}] [https-jsse-nio-443-exec-27] ERROR error.ErrorController - Exception org.codehaus.groovy.grails.web.errors.GrailsWrappedRuntimeException: FUNCTION saviyntaws.Argentina does not exist at grails.plugin.springsecurity.web.filter.GrailsAnonymousAuthenticationFilter.doFilter(GrailsAnonymousAuthenticationFilter.java:53) at com.saviynt.webservice.SaviyntRestAuthenticationFilter.doFilter(SaviyntRestAuthenticationFilter.groovy:145) 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.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION saviyntaws.Argentina does not exist at com.mysql.jdbc.Util.handleNewInstance(Util.java:400) at com.mysql.jdbc.Util.getInstance(Util.java:383) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2002) at com.saviynt.ecm.workflow.WorkflowmanagementController$_closure344.doCall(WorkflowmanagementController.groovy:20554)