Hello Experts,
We have observed that when we run the job to import access from Workday application it fails with below error
Error - Error in doAccessImport - Heuristic
completion: outcome state is mixed; nested
exception is
org.springframework.transaction.TransactionSystemE
xception: Could not commit Hibernate transaction;
nested exception is
org.hibernate.TransactionException: JDBC commit
failed
In the debug logs we could see the below error:
2022-08-05/07:47:23.108 [{}] [quartzScheduler_Worker-23] DEBUG rest.RestProvisioningService - inside processAccountEntitlements
2022-08-05/07:47:23.108 [{}] [quartzScheduler_Worker-23] DEBUG rest.RestProvisioningService - ACCKEY:745372;ENTVALKEY:396605
2022-08-05/07:47:23.109 [{}] [quartzScheduler_Worker-23] DEBUG rest.RestProvisioningService - Exception in processAccountEntitlements :
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
at com.mysql.jdbc.Util.getInstance(Util.java:383)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1023)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:997)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:983)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:928)
at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:466)
at com.mysql.jdbc.StatementImpl.addBatch(StatementImpl.java:398)
at com.saviynt.provisoning.rest.RestProvisioningService.processAccountEntitlements(RestProvisioningService.groovy:7597)
at com.saviynt.provisoning.workday.WorkdayAccessImportService$_processSecurityGroupAccEntEntitlements_closure3_closure13.doCall(WorkdayAccessImportService.groovy:417)
at com.saviynt.provisoning.workday.WorkdayAccessImportService$_processSecurityGroupAccEntEntitlements_closure3.doCall(WorkdayAccessImportService.groovy:414)
at com.saviynt.provisoning.workday.WorkdayAccessImportService.processSecurityGroupAccEntEntitlements(WorkdayAccessImportService.groovy:377)
at com.saviynt.provisoning.workday.WorkdayImportService.doAccessImport(WorkdayImportService.groovy:290)
at com.saviynt.provisoning.workday.WorkdayImportService.doImport(WorkdayImportService.groovy:98)
at com.saviynt.ecm.integration.ExternalConnectionCallService.invokeExternalMethod(ExternalConnectionCallService.groovy:269)
at ApplicationDataImportJob.execute(ApplicationDataImportJob.groovy:206)
at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)
2022-08-05/07:47:23.109 [{}] [quartzScheduler_Worker-23] ERROR rest.RestProvisioningService - Exception in processAccountEntitlements :
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
at com.mysql.jdbc.Util.getInstance(Util.java:383)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1023)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:997)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:983)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:928)
at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:466)
at com.mysql.jdbc.StatementImpl.addBatch(StatementImpl.java:398)
at com.saviynt.provisoning.rest.RestProvisioningService.processAccountEntitlements(RestProvisioningService.groovy:7597)
at com.saviynt.provisoning.workday.WorkdayAccessImportService$_processSecurityGroupAccEntEntitlements_closure3_closure13.doCall(WorkdayAccessImportService.groovy:417)
at com.saviynt.provisoning.workday.WorkdayAccessImportService$_processSecurityGroupAccEntEntitlements_closure3.doCall(WorkdayAccessImportService.groovy:414)
at com.saviynt.provisoning.workday.WorkdayAccessImportService.processSecurityGroupAccEntEntitlements(WorkdayAccessImportService.groovy:377)
at com.saviynt.provisoning.workday.WorkdayImportService.doAccessImport(WorkdayImportService.groovy:290)
at com.saviynt.provisoning.workday.WorkdayImportService.doImport(WorkdayImportService.groovy:98)
at com.saviynt.ecm.integration.ExternalConnectionCallService.invokeExternalMethod(ExternalConnectionCallService.groovy:269)
at ApplicationDataImportJob.execute(ApplicationDataImportJob.groovy:206)
at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)
2022-08-05/07:47:23.109 [{}] [quartzScheduler_Worker-23] DEBUG rest.RestProvisioningService - inside processAccountEntitlements
2022-08-05/07:47:23.109 [{}] [quartzScheduler_Worker-23] DEBUG rest.RestProvisioningService - ACCKEY:745372;ENTVALKEY:396601
2022-08-05/07:47:23.109 [{}] [quartzScheduler_Worker-23] DEBUG rest.RestProvisioningService - Exception in processAccountEntitlements :
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
Looks like the job is failing while linking accounts to entitlements as I can see that the security groups are getting reconciled. Has anyone faced this issue? Can someone please suggest what could be wrong here?
Regards,
Irfan
