0
Answered

Unify Identity Broker- The transaction has aborted Error

Abhishek S 4 months ago in UNIFYBroker Service updated 4 months ago 4

Hi,

We are using Unify identity Broker version v4.1.1 Revision #1 and one of the Connector is having below error  

Import All Run

Change detection engine import all items for connector Aurion Staging Staff Details Connector failed with reason The transaction has aborted.. Duration: 00:12:00.6306978

Based on my understanding, Connector is timing out if it's runs more than 10mins and I'm unable to find the set timeout threshold field limit in Identity broker. Can you please confirm where it could be set  or is there option to set the version we have.

Thank you

Below is from the logs

Direct communicator
Exception occured after [00:10:18.3617284] duration.

System.Transactions.TransactionAbortedException: The transaction has aborted. ---> System.TimeoutException: Transaction Timeout
--- End of inner exception stack trace ---
at System.Transactions.TransactionStateAborted.BeginCommit(InternalTransaction tx, Boolean asyncCommit, AsyncCallback asyncCallback, Object asyncState)
at System.Transactions.CommittableTransaction.Commit()
at System.Transactions.TransactionScope.InternalDispose()
at System.Transactions.TransactionScope.Dispose()
at Unify.Framework.Data.AdoNetDataControl.ExecuteDataSetQuery(DataSet resultSet, String commandText, IEnumerable`1 parameters, String[] tableNames, CommandType commandType)
at Unify.Framework.Data.AdoNetDataControl.ReturnDataSetQuery[T](String commandText, IEnumerable`1 parameters, String[] tableNames, CommandType commandType)
at Unify.Product.IdentityBroker.DirectCommunicatorBase`1.GetAllEntitiesDataTable()
at Unify.Product.IdentityBroker.DirectCommunicatorBase`1.GetAllEntities()
Affected Versions:
Fixed by Version:

Answer

Answer
Answered

Hi Abhishek,

The timeout for the database connector can be set on the agent that is used for that connector. In this case that appears to be the SQL server agent, which has a configuration setting for Operation Timeout.

You can find details on that configuration here: SQL Server Database Agent / UNIFYBroker knowledge / UNIFY Solutions

GOOD, I'M SATISFIED
Satisfaction mark by Abhishek S 4 months ago

Is there any possibility to set the timeout threshold in Identity broker Config file?

Answer
Answered

Hi Abhishek,

The timeout for the database connector can be set on the agent that is used for that connector. In this case that appears to be the SQL server agent, which has a configuration setting for Operation Timeout.

You can find details on that configuration here: SQL Server Database Agent / UNIFYBroker knowledge / UNIFY Solutions

Hi Matthew,
Thank you for the quick response. The Identity broker version in the setup environment is v4.1.1 Revision #1. Following the KB article, when I select the option to edit the SQL agent, the Time-out field is not present.
Please confirm if the timeout is set in the config file?
Attached screenshot for reference.

Assuming I create a new SQL Server database agent in Identity broker v4.1.1 Revision #1, even in this instance it's not giving us the option to set timeout.

Thank you, we were able to solve the issue by creating indexes for the database.