Click HERE to see how Saviynt Intelligence is transforming the industry. |
08/05/2022 01:58 AM
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
08/12/2022 04:45 PM
Hello @irfan,
Is this still an issue ? It seems to me that the db conection is timing out.
08/14/2022 06:25 AM
This error you get usually when there is huge data. We got this error in past during SAP import but recon is successful only in end this error is thrown.
In your case does import is successful?