Detalhe do erro #102

30/06/2026 01:57:49 — ImportacaoInventario

Voltar ao log
Etapa
ImportacaoInventario
Id fila
3517
Id inventário
71653
Id assinatura
1
Tipo
Microsoft.Data.SqlClient.SqlException
Caminho arquivo
C:\inetpub\wwwroot\sgs\App_Data\Arquivos por API\Upload Invent Automatico\luz_da_lua_151__shopping_jockey_plaza_projeto_71653_web\inventory_data.sql
Mensagem
Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Detalhe / stack trace

Microsoft.Data.SqlClient.SqlException (0x80131904): Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
   at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean isAsync, Int32 timeout, Boolean asyncWrite)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Datasite.Inventario.Sincronizador.Nuvem.Infrastructure.Conversion.ComandosSqlExclusaoInventario.Executar(SqlConnection connection, SqlTransaction transaction, Int32 inventoryId, Int32 subscriptionId, Int32 timeoutComandoSegundos) in C:\Meus Projetos\ReoneDataSite\NovoInventarioLocal\DataSite.Inventario\Datasite.Inventario.Sincronizador.Nuvem\Infrastructure\Conversion\ComandosSqlExclusaoInventario.cs:line 83
   at Datasite.Inventario.Sincronizador.Nuvem.Infrastructure.Conversion.ConversorMySqlParaSqlServerEsquemaFixo.ConverterDeArquivo(String mysqlDataScriptPath, Int32 inventoryId, Int32 subscriptionId) in C:\Meus Projetos\ReoneDataSite\NovoInventarioLocal\DataSite.Inventario\Datasite.Inventario.Sincronizador.Nuvem\Infrastructure\Conversion\ConversorMySqlParaSqlServerEsquemaFixo.cs:line 134
   at Datasite.Inventario.Sincronizador.Nuvem.Infrastructure.Azure.ArmazenamentoInventarioSqlAzure.ImportarArquivosInventarioAsync(FilaSincNuvemItem itemFila, String caminhoArquivoSql, Int32 idAssinatura, CancellationToken cancellationToken) in C:\Meus Projetos\ReoneDataSite\NovoInventarioLocal\DataSite.Inventario\Datasite.Inventario.Sincronizador.Nuvem\Infrastructure\Azure\ArmazenamentoInventarioSqlAzure.cs:line 87
   at Datasite.Inventario.Sincronizador.Nuvem.Infrastructure.Azure.ArmazenamentoInventarioSqlAzure.ImportarArquivosInventarioAsync(FilaSincNuvemItem itemFila, String caminhoArquivoSql, Int32 idAssinatura, CancellationToken cancellationToken) in C:\Meus Projetos\ReoneDataSite\NovoInventarioLocal\DataSite.Inventario\Datasite.Inventario.Sincronizador.Nuvem\Infrastructure\Azure\ArmazenamentoInventarioSqlAzure.cs:line 122
   at Datasite.Inventario.Sincronizador.Nuvem.Infrastructure.Sync.OrchestradorSincronizacao.ProcessarFilaPendenteAsync(CancellationToken cancellationToken) in C:\Meus Projetos\ReoneDataSite\NovoInventarioLocal\DataSite.Inventario\Datasite.Inventario.Sincronizador.Nuvem\Infrastructure\Sync\OrchestradorSincronizacao.cs:line 161
ClientConnectionId:feef2531-1623-4bb6-b9e2-d169d22012e4
Error Number:1205,State:72,Class:13