Failed To Obtain DB Connection From Data Source Default - This Platform Does Not Support Distributed Transactions

News Knowledge Base
,
1

Calendar can not be created in orchestrator, below error in Event viewer: "Quartz.JobPersistenceException: Failed to obtain DB connection from data source 'default': System.PlatformNotSupportedException: This platform does not support distributed transactions. at System.Transactions.Distributed.DistributedTransactionManager.GetDistributedTransactionFromTransmitterPropagationToken(Byte[] propagationToken) at System.Transactions.TransactionInterop.GetDistributedTransactionFromTransmitterPropagationToken(Byte[] propagationToken) ... at System.Data.SqlClient.SqlConnection.Open() at Quartz.Impl.AdoJobStore.JobStoreSupport.GetConnection()"

Root Cause: This error can be generated by a failed migration of 202109061532001_Remove_Quartz_DbProvider (dbo._ReleaseHistory), in this case some information are not removed from UiPath.Orchestrator.dll.cofig. Corrupted Orchestrator migration.

Resolution: Remove the configurations from UiPath.Orchestrator.dll.cofig as below,

  • <add key="quartz.dbprovider.SqlServer.productName" value="Microsoft SQL Server" />
  • <add key="quartz.dbprovider.SqlServer.assemblyName" value="System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
  • <add key="quartz.dbprovider.SqlServer.connectionType" value="System.Data.SqlClient.SqlConnection, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
  • <add key="quartz.dbprovider.SqlServer.commandType" value="System.Data.SqlClient.SqlCommand, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
  • <add key="quartz.dbprovider.SqlServer.parameterType" value="System.Data.SqlClient.SqlParameter, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
  • <add key="quartz.dbprovider.SqlServer.parameterDbType" value="System.Data.SqlDbType, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
  • <add key="quartz.dbprovider.SqlServer.parameterDbTypePropertyName" value="SqlDbType" />
  • <add key="quartz.dbprovider.SqlServer.parameterNamePrefix" value="@" />
  • <add key="quartz.dbprovider.SqlServer.exceptionType" value="System.Data.SqlClient.SqlException, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
  • <add key="quartz.dbprovider.SqlServer.useParameterNamePrefixInParameterCollection" value="true" />
  • <add key="quartz.dbprovider.SqlServer.bindByName" value="true" />
  • <add key="quartz.dbprovider.SqlServer.dbBinaryTypeName" value="VarBinary" />

Before removing the parameters it is recommended to take backup the file in another directory. This backup will be used if additional parameters are deleted.