This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 46%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Here is the error from application server: Source is Azure SQL Database
Exception during aggregation. Reason: java.lang.RuntimeException: sailpoint.connector.ConnectorException: The application script threw an exception: java.sql.SQLException: [generateTranslationMapping]: ***SQLException error: com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:3680) at com.microsoft.sqlserver.jdbc.TDSChannel.write(IOBuffer.java:2333) at com.microsoft.sqlserver.jdbc.TDSWriter.flush(IOBuffer.java:4586) at com.microsoft.sqlserver.jdbc.TDSWriter.writePacket(IOBuffer.java:4488) at com.microsoft.sqlserver.jdbc.TDSWriter.endMessage(IOBuffer.java:3523) at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:8151) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:613) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:537) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7785) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3793) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:268) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:242) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:456) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122) at sun.reflect.GeneratedMethodAccessor5396.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at bsh.Reflect.invokeMethod(Reflect.java:166) at bsh.Reflect.invokeObjectMethod(Reflect.java:99) at bsh.Name.invokeMethod(Name.java:858) at bsh.BSHMethodInvocation.eval(BSHMethodInvocation.java:75) at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:102) at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:47) at bsh.BSHAssignment.eval(BSHAssignment.java:77) at bsh.BSHBlock.evalBlock(BSHBlock.java:130) at bsh.BSHBlock.eval(BSHBlock.java:80) at bsh.BSHBlock.eval(BSHBlock.java:46) at bsh.BSHIfStatement.eval(BSHIfStatement.java:48) at bsh.BSHBlock.evalBlock(BSHBlock.java:130) at bsh.BSHBlock.eval(BSHBlock.java:80) at bsh.BSHBlock.eval(BSHBlock.java:46) at bsh.BSHTryStatement.eval(BSHTryStatement.java:88) at bsh.BSHBlock.evalBlock(BSHBlock.java:130) at bsh.BSHBlock.eval(BSHBlock.java:80) at bsh.BSHBlock.eval(BSHBlock.java:46) at bsh.BSHIfStatement.eval(BSHIfStatement.java:48) at bsh.BSHBlock.evalBlock(BSHBlock.java:130) at bsh.BSHBlock.eval(BSHBlock.java:80) at bsh.BshMethod.invokeImpl(BshMethod.java:371) at bsh.BshMethod.invoke(BshMethod.java:267) at bsh.BshMethod.invoke(BshMethod.java:195) at bsh.Name.invokeLocalMethod(Name.java:917) at bsh.Name.invokeMethod(Name.java:804) at bsh.BSHMethodInvocation.eval(BSHMethodInvocation.java:75) at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:102) at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:47) at bsh.BSHVariableDeclarator.eval(BSHVariableDeclarator.java:86) at bsh.BSHTypedVariableDeclaration.eval(BSHTypedVariableDeclaration.java:84) at bsh.BSHBlock.evalBlock(BSHBlock.java:130) at bsh.BSHBlock.eval(BSHBlock.java:80) at bsh.BSHBlock.eval(BSHBlock.java:46) at bsh.BSHIfStatement.eval(BSHIfStatement.java:48) at bsh.BSHBlock.evalBlock(BSHBlock.java:130) at bsh.BSHBlock.eval(BSHBlock.java:80) at bsh.BSHBlock.eval(BSHBlock.java:46) at bsh.BSHIfStatement.eval(BSHIfStatement.java:48) at bsh.BSHBlock.evalBlock(BSHBlock.java:130) at bsh.BSHBlock.eval(BSHBlock.java:80) at bsh.BshMethod.invokeImpl(BshMethod.java:371) at bsh.BshMethod.invoke(BshMethod.java:267) at bsh.BshMethod.invoke(BshMethod.java:195) at bsh.Name.invokeLocalMethod(Name.java:917) at bsh.Name.invokeMethod(Name.java:804) at bsh.BSHMethodInvocation.eval(BSHMethodInvocation.java:75) at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:102) at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:47) at bsh.Interpreter.eval(Interpreter.java:664) at bsh.Interpreter.eval(Interpreter.java:758) at bsh.Interpreter.eval(Interpreter.java:747) at bsh.util.BeanShellBSFEngine.eval(BeanShellBSFEngine.java:186) at org.apache.bsf.BSFManager$5.run(BSFManager.java:445) at java.security.AccessController.doPrivileged(Native Method) at org.apache.bsf.BSFManager.eval(BSFManager.java:442) at sailpoint.server.BSFRuleRunner.eval(BSFRuleRunner.java:245) at sailpoint.server.BSFRuleRunner.runRule(BSFRuleRunner.java:216) at sailpoint.server.InternalContext.runRule(InternalContext.java:1268) at sailpoint.server.InternalContext.runRule(InternalContext.java:1240) at sailpoint.connector.DefaultConnectorServices.runRule(DefaultConnectorServices.java:107) at sailpoint.connector.DefaultConnectorServices.runRule(DefaultConnectorServices.java:87) at sailpoint.connector.ConnectorProxy.runCustomizationRule(ConnectorProxy.java:940) at sailpoint.connector.ConnectorProxy.access$100(ConnectorProxy.java:87) at sailpoint.connector.ConnectorProxy$CustomizingIterator.peek(ConnectorProxy.java:1332) at sailpoint.connector.ConnectorProxy$CustomizingIterator.hasNext(ConnectorProxy.java:1355) at sailpoint.api.Aggregator.aggregateAccounts(Aggregator.java:3264) at sailpoint.api.Aggregator.primaryAccountAggregation(Aggregator.java:2935) at sailpoint.api.Aggregator.aggregateApplication(Aggregator.java:2783) at sailpoint.api.Aggregator.phaseAggregate(Aggregator.java:2653) at sailpoint.api.Aggregator.execute(Aggregator.java:2200) at sailpoint.task.ResourceIdentityScan.doUnpartitioned(ResourceIdentityScan.java:248) at sailpoint.task.ResourceIdentityScan.execute(ResourceIdentityScan.java:228) at sailpoint.api.TaskManager.runSync(TaskManager.java:909) at sailpoint.request.TaskExecuteExecutor.execute(TaskExecuteExecutor.java:161) at sailpoint.request.RequestHandler.run(RequestHandler.java:163) Caused by: javax.net.ssl.SSLException: Connection reset at sun.security.ssl.Alert.createSSLException(Alert.java:127) at sun.security.ssl.TransportContext.fatal(TransportContext.java:324) at sun.security.ssl.TransportContext.fatal(TransportContext.java:267) at sun.security.ssl.TransportContext.fatal(TransportContext.java:262) at sun.security.ssl.SSLSocketImpl$AppOutputStream.write(SSLSocketImpl.java:979) at com.microsoft.sqlserver.jdbc.TDSChannel.write(IOBuffer.java:2327) ... 92 more Suppressed: java.net.SocketException: Broken pipe (Write failed) at java.net.SocketOutputStream.socketWrite0(Native Method) at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111) at java.net.SocketOutputStream.write(SocketOutputStream.java:155) at com.microsoft.sqlserver.jdbc.TDSChannel$ProxyOutputStream.writeInternal(IOBuffer.java:1318) at com.microsoft.sqlserver.jdbc.TDSChannel$ProxyOutputStream.write(IOBuffer.java:1311) at sun.security.ssl.SSLSocketOutputRecord.encodeAlert(SSLSocketOutputRecord.java:81) at sun.security.ssl.TransportContext.fatal(TransportContext.java:355) ... 96 more Caused by: java.net.SocketException: Connection reset at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:115) at java.net.SocketOutputStream.write(SocketOutputStream.java:155) at com.microsoft.sqlserver.jdbc.TDSChannel$ProxyOutputStream.writeInternal(IOBuffer.java:1318) at com.microsoft.sqlserver.jdbc.TDSChannel$ProxyOutputStream.write(IOBuffer.java:1311) at sun.security.ssl.SSLSocketOutputRecord.deliver(SSLSocketOutputRecord.java:319) at sun.security.ssl.SSLSocketImpl$AppOutputStream.write(SSLSocketImpl.java:974) ... 93 more BSF info: SWY-ResourceObjectCustomization-HCMCloud at line: 0 column: columnNo
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 16%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKK%3C/text%3E%3C/svg%3E)
Hello Vijay Kumar,
Thanks for posting your question on Microsoft Q&A!
I want to make sure we’re aligned before diving into the solution. Could you please help clarify a few things listed below?
Thanks!
Kalyani
Hi Kalyani,
Let me get all the info. this issue was reported by one of our application team.
Hi Vijay Kumar,
Thanks for acknowledging, yes if that information available we can guide you in right path.
Thanks!
Hi Vijay Kumar,
Hope you have good day!
Any update for the requested details? Please let us know we will try to guide you in right path. if your issue resolved feel free to share the solution so that it will help others who are facing similar issues.
Thanks!
Hi Kalyani,
Sorry for the delay.
Here are the details :
HCM lookuptables are on iiqServiceAccountRepo on this DB. When HCM aggregation runs, the data from HCM is looked upon these tables and populated to identity.
We are connecting from SailPoint application hosted on Azure servers.
3.Is this error occurring consistently, or only intermittently?
Yes, its occurring once in week or 2.
4.Which JDBC driver version is being used to connect to Azure SQL DB? (Older versions may have TLS/SSL issues).
mssql-jdbc-10.2.0.jre8.jar
5.Can you please check if there are any network interruptions on your side while connecting to the Azure SQL Database?
No issue from connecting.
Other tasks are fine, only this task fails.
Hi Vijay Kumar ,
Thank you for providing the details
Can you please try the following once
mssql-jdbc-10.2.0.jre8.jar which is good, but consider testing with the latest version of the JDBC driver if you haven’t already. Newer versions have improved handling for TLS connections, which can mitigate issues like SSL exceptions.If you've gone through these steps and the issue persists, you may need to look deeper into potential configuration issues within SailPoint or involve Azure support for further diagnostics.
Hope this helps! Let me know if you need further assistance or clarification on any of these points.
Thanks!
Kalyani
Hi Vijay Kumar ,
Could you please confirm if you have gone through the above response and if that worked for you? If yes, then could you please do an "Upvote" so that it would help other community members.
Please let us know if you need further assistance.
Thanks!
Hi Vijay Kumar ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Thanks!
Please note that support for connections using TLS 1.0 or TLS 1.1 ends this month of August 2025 as you can read here. Make sure SailPoint is trying to connect using TLS 1.2 and is using a recent Microsoft JDBC driver.