Problema durante leitura de dados

System.Exception: [APP]Problema durante leitura de dados ---> System.Exception: [APP]Problema de acesso aos dados. [SQL origem] SELECT CO.idColaborador, CO.idCliente, CO.idPessoa, ISNULL((select TOP 1 idUsuario from ACE_Usuario where idPessoa = CO.idPessoa),0) as idUsuario, CO.nomCargo, CO.nomDepartamento, CO.indContato, CO.datRegistro, ISNULL(P.Nextel, '') AS Nextel, CO.indRepasse , CO.ordemContato, ISNULL(CO.idUsuario,0) AS idUsuario, R.Nome AS Cliente, P.Nome, ISNULL(U.nomLogin,'') AS nomLogin, P.Email, ISNULL(P.datNascimento,'2000-01-01') AS datNascimento, CO.datAdmissao, CO.datDemissao, CO.indVendedor , ISNULL((select TOP 1 g.dscGrupo from ace_UsuarioGrupo as ug inner join ace_grupo as g on ug.idgrupo = g.idgrupo WHERE ug.idusuario = co.idUsuario and dscGrupo = 'ADMIN'),'') AS dscAdmin, CO.indAtivo, U.idUsuario , ISNULL(P.Endereco, '') Endereco, ISNULL(P.Cidade, '') Cidade, ISNULL(P.Estado, '') Estado, P.nomFoto , CO.telefone, CO.celular, CO.operadora, CO.whatsapp FROM CLI_Colaborador AS CO INNER JOIN GEN_Revenda AS R ON CO.idCliente = R.idRevenda INNER JOIN ACE_Pessoa AS P ON CO.idPessoa = P.idPessoa INNER JOIN ACE_Usuario AS U ON CO.idUsuario = U.idUsuario WHERE CO.idCliente = 17132 AND datDemissao = '2000-01-01' AND U.indAtivo=1 AND indContato = 1 ORDER BY P.Nome ASC ---> System.Data.SqlClient.SqlException: Transaction (Process ID 100) was deadlocked on lock | generic waitable object resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at GrupoPLA._Matrix.Matrix.RecuperarDataset(String SQL) in C:\TRABALHO\GRUPOPLA\GrupoPLA._Matrix\GrupoPLA._Matrix\Matrix.cs:line 61 --- End of inner exception stack trace --- at GrupoPLA._Matrix.Matrix.RecuperarDataset(String SQL) in C:\TRABALHO\GRUPOPLA\GrupoPLA._Matrix\GrupoPLA._Matrix\Matrix.cs:line 67 at GrupoPLA.Cliente.Colaborador.RecuperarTodos(Cliente cli, Boolean somenteAtivo, String ordem, Boolean somenteContatos, Int32 idColaborador, String busca, Boolean indVendedor) in C:\Trabalho\GrupoPLA.Cliente\GrupoPLA.Cliente\Colaborador.cs:line 359 --- End of inner exception stack trace --- at GrupoPLA.Cliente.Colaborador.RecuperarTodos(Cliente cli, Boolean somenteAtivo, String ordem, Boolean somenteContatos, Int32 idColaborador, String busca, Boolean indVendedor) in C:\Trabalho\GrupoPLA.Cliente\GrupoPLA.Cliente\Colaborador.cs:line 404 at DetalhesVeiculo.CarregarPagina() in c:\inetpub\wwwroot\sys.autogerenciador.com.br\11\DetalhesVeiculo.aspx.cs:line 97

Rodrigo Tratores MG - Revenda em Pouso Alto - MG
WhatsApp

  • Detalhe


Faça sua Proposta

 Faça sua proposta pelo WhatsApp



RELACIONADOS

Anúncios relacionados ao modelo atual.