![]() ![]() Also, we changed the new maintenance windows of the database to only on weekend days but the errors are still happening during week days.ĭoes anyone know what could be causing this sudden problem? Has Microsoft changed anything to databases and/or data factories that we are not aware of? What could we do to try and prevent these errors? We are kind of at a loss here. We have tried rescaling the SQL database to simulate a restart (since Azure SQL Databases can't be restarted.) but that has not helped. HY000-2146893048MicrosoftSQL Server Native Client 11.0SQL Server Network Interfaces. Details: Microsoft SQL Server 2008 R2 (RTM). ImplicitTransactions, Lock Count are perfect. Tried all possible options that i have got from web. Also, the errors seem to be happening at random and are not tied to any specific pipelines or data flows. SPWHO2 shows that, a blocking is created by a system process with spid '7', which can't be killed. When have not made any changes to the SQL server/database itself, or to our Data Factories that could cause a sudden rise in these types of errors. Please search error to get more details.,Source=,''Type=,Message=Lock request time out period exceeded.,Source=.Net SqlClient Data Provider,SqlErrorNumber=1222,Class=16,ErrorCode=-2146232060,State=112,Errors=,' Operation on target Copy_bseg_from_blob_master_to_dwh_sql failed: ErrorCode=SqlOperationFailed,'Type=.HybridDeliveryException,Message=A database operation failed. We have not had any troubles with this process until last week. Since last week we have been getting many 'lock request time out period exceeded' errors in ADF in pipelines and data flows that connect to the SQL database: 'Lock request time out period exceeded' in Azure Data Factory when connecting with Azure SQL Database Asked 702 times 0 We use Azure Data Factory to copy data from source systems to our Azure SQL Data Warehouse. We use Azure Data Factory to copy data from source systems to our Azure SQL Data Warehouse.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |