2024-03-13T09:13:33.766366404Z stdout F 2024-03-13 09:13:33,766 [http-nio-8080-exec-174] INFO domain.JobcontrolController - Auditing for list of JobControl
2024-03-13T09:13:33.776195358Z stdout F 2024-03-13 09:13:33,776 [http-nio-8080-exec-174] INFO domain.x - Auditing process completed for JobControl
2024-03-13T09:13:31.093846334Z stdout F IMPORTGROUPHIERARCHY"
2024-03-13T09:13:31.093848534Z stdout F FROM ENTITLEMENT_VALUES CURENT
2024-03-13T09:13:31.093850834Z stdout F LEFT JOIN ENTITLEMENT_VALUES NEWENT ON CURENT.ENTITLEMENT_VALUEKEY=NEWENT.REFERENCED_ENTITLEMENT AND NEWENT.ENTITLEMENTTYPEKEY=34
2024-03-13T09:13:31.093853034Z stdout F WHERE NEWENT.REFERENCED_ENTITLEMENT IS NULL
2024-03-13T09:13:31.093855234Z stdout F AND (CURENT.ENTITLEMENT_VALUEKEY IN (8,72,74,75,0))
2024-03-13T09:13:31.093857634Z stdout F
2024-03-13T09:13:31.095212115Z stderr F 13-Mar-2024 09:13:31.095 WARNING [quartzScheduler_Worker-14] groovy.sql.Sql.executeInsert Failed to execute:
2024-03-13T09:13:31.095217016Z stderr F INSERT INTO ENTITLEMENT_VALUES (ENTITLEMENT_GLOSSARY, ENTITLEMENTTYPEKEY, JOB_ID, REFERENCED_ENTITLEMENT,
2024-03-13T09:13:31.095219716Z stderr F DC=COM
2024-03-13T09:13:31.095225316Z stderr F IMPORTGROUPHIERARCHY"
2024-03-13T09:13:31.095227716Z stderr F SELECT DISTINCT CURENT.ENTITLEMENT_GLOSSARY, 34, 110548, CURENT.ENTITLEMENT_VALUEKEY,
2024-03-13T09:13:31.095230216Z stderr F CURENT.DC=COM
2024-03-13T09:13:31.095232517Z stderr F IMPORTGROUPHIERARCHY"
2024-03-13T09:13:31.095234817Z stderr F FROM ENTITLEMENT_VALUES CURENT
2024-03-13T09:13:31.095237117Z stderr F LEFT JOIN ENTITLEMENT_VALUES NEWENT ON CURENT.ENTITLEMENT_VALUEKEY=NEWENT.REFERENCED_ENTITLEMENT AND NEWENT.ENTITLEMENTTYPEKEY=34
2024-03-13T09:13:31.095239417Z stderr F WHERE NEWENT.REFERENCED_ENTITLEMENT IS NULL
2024-03-13T09:13:31.095241617Z stderr F AND (CURENT.ENTITLEMENT_VALUEKEY IN (8,72,74,75,0))
2024-03-13T09:13:31.095243817Z stderr F because: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=COM
2024-03-13T09:13:31.095396626Z stdout F 2024-03-13 09:13:31,095 [quartzScheduler_Worker-14] DEBUG services.ImportUtilityService - Error in inserting ENTITLEMENT_VALUES:
2024-03-13T09:13:31.095400727Z stdout F com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=COM
"2024-03-13T09:13:31.095404527Z stdout F at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)"
"2024-03-13T09:13:31.095408327Z stdout F at com.mysql.jdbc.Util.getInstance(Util.java:383)"
"2024-03-13T09:13:31.095411627Z stdout F at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1062)"
"2024-03-13T09:13:31.095415327Z stdout F at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4208)"
"2024-03-13T09:13:31.095418528Z stdout F at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4140)"
"2024-03-13T09:13:31.095421528Z stdout F at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2597)"
"2024-03-13T09:13:31.095425028Z stdout F at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2758)"
"2024-03-13T09:13:31.095428428Z stdout F at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2820)"
"2024-03-13T09:13:31.095431428Z stdout F at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1759)"
"2024-03-13T09:13:31.095433929Z stdout F at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1844)"
"2024-03-13T09:13:31.095436529Z stdout F at com.saviynt.ecm.services.ImportUtilityService$_populateImportDataToEndpoints_closure4_closure50_closure55.doCall(ImportUtilityService.groovy:774)"
"2024-03-13T09:13:31.095438729Z stdout F at com.saviynt.ecm.services.ImportUtilityService$_populateImportDataToEndpoints_closure4_closure50.doCall(ImportUtilityService.groovy:652)"
"2024-03-13T09:13:31.095444529Z stdout F at com.saviynt.ecm.services.ImportUtilityService$_populateImportDataToEndpoints_closure4.doCall(ImportUtilityService.groovy:651)"
"2024-03-13T09:13:31.095446729Z stdout F at com.saviynt.ecm.services.ImportUtilityService.populateImportDataToEndpoints(ImportUtilityService.groovy:620)"
"2024-03-13T09:13:31.095449229Z stdout F at com.saviynt.ecm.integration.ExternalConnectionCallService.invokeExternalMethod(ExternalConnectionCallService.groovy:336)"
"2024-03-13T09:13:31.09545143Z stdout F at ApplicationDataImportJob.execute(ApplicationDataImportJob.groovy:210)"
"2024-03-13T09:13:31.09545363Z stdout F at org.quartz.core.JobRunShell.run(JobRunShell.java:199)"
"2024-03-13T09:13:31.09545773Z stdout F at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)"
2024-03-13T09:13:31.09546003Z stdout F 2024-03-13 09:13:31,095 [quartzScheduler_Worker-14] DEBUG services.ImportUtilityService - Inactivating Child Entitlments Not Updated/Inserted :
2024-03-13T09:13:31.09546223Z stdout F UPDATE ENTITLEMENT_VALUES SET JOB_ID=110548,STATUS=2
2024-03-13T09:13:31.09546443Z stdout F WHERE ENTITLEMENTTYPEKEY=34 and (JOB_ID IS NULL OR JOB_ID<>110548)
2024-03-13T09:13:31.095467931Z stdout F AND STATUS=1
2024-03-13T09:13:31.095470231Z stdout F
2024-03-13T09:13:31.096972321Z stdout F 2024-03-13 09:13:31,096 [quartzScheduler_Worker-14] DEBUG services.ImportUtilityService - Child Entitlements Inactivated : 0
2024-03-13T09:13:31.096976621Z stdout F 2024-03-13 09:13:31,096 [quartzScheduler_Worker-14] DEBUG services.ImportUtilityService - Setting Batch Size from config = 1000
The same configuration is working in dev and prod. The groups are imported but entitlements are not added in the endpoint filter based endpoints.
Endpoints are created but entitlements are not added. It is working in deva nd prod environments.
Thanks,
Ranjan
[This message has been edited by moderator to merge reply comment]
