Detalhe do erro #100

30/06/2026 01:47:48 — ImportacaoInventario

Voltar ao log
Etapa
ImportacaoInventario
Id fila
3513
Id inventário
72239
Id assinatura
1
Tipo
Microsoft.Data.SqlClient.SqlException
Caminho arquivo
C:\inetpub\wwwroot\sgs\App_Data\Arquivos por API\Upload Invent Automatico\boticario_sao_jose_dos_campos_14037__sjc__jd__paulista_projeto_72239_web\inventory_data.sql
Mensagem
Transaction (Process ID 75) 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 75) 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:7384a2f4-ecd0-4495-b528-9ea70e634e91
Error Number:1205,State:72,Class:13