Problema ao carregar os dados.

System.Exception: [APP]Problema ao carregar os dados. ---> System.Exception: [APP]Problema de acesso aos dados. [SQL origem] SELECT ISNULL(C.dscEmpresa, '') AS dscEmpresa, ISNULL(c.idTema, 1) as tema, ISNULL(C.dscEditavelPrincipal, '') AS dscEditavelPrincipal, C.urlDestaque1, C.urlDestaque2, C.urlDestaque3, C.urlDestaque4, C.urlDestaque5, ISNULL(C.urlPatrocinio1, '') AS urlPatrocinio1, ISNULL(C.urlPatrocinio2, '') AS urlPatrocinio2, ISNULL(C.urlPatrocinio3, '') AS urlPatrocinio3, ISNULL(T.nomPasta, '') AS nomPasta, ISNULL(t.dscTema, '') as dscTema, ISNULL(t.indLayout, 0) as indLayout, C.nomCapaSite, indBlankDestaque1, indBlankDestaque2, indBlankDestaque3, indBlankDestaque4, indBlankDestaque5, descSEOCapa, descSEOEmpresa, descSEOTitulo, scriptsgerais, scriptsgeraisBody, c.codDesenvPor, ISNULL(C.corFundo, '') AS corFundo, ISNULL(C.atributoFundo, '') AS atributoFundo , ISNULL(T.codTema,'01') as codTema, C.mnuHome, C.mnuEmpresa, C.mnuSobre, C.mnuEquipe, C.mnuLocalizacao, C.mnuEstoque, C.mnuNovos, c.mnuPecas, C.mnuServicos, C.mnuAvaliacao, C.mnuContato, C.indTipo, C.mnuMarcas, C.indMarcas, C.mnuSatisfacao , (SELECT count(v.idVeiculo) FROM VEI_Veiculo v WHERE v.indAtivo = 1 AND v.idRevenda = 0 AND indPublicado = 1 and indNovo = 0) as totVeiculo , (SELECT count(v.idVeiculo) FROM VEI_Veiculo v WHERE v.indAtivo = 1 AND v.idRevenda = 0 AND indPublicado = 1 and indNovo = 1) as totNovos , (SELECT count(PP.idProduto) FROM SER_Produto_PEC As PP WHERE PP.indPublicado = 1 AND PP.idloja = 0 AND PP.indStatus = 'True' AND EXISTS (SELECT idRevenda FROM GEN_RevendaContrato As RC WHERE (RC.idCategoria = PP.idCategoria OR ISNULL(RC.idCategoria, 0) = 0) AND (RC.idItem = PP.idItem OR ISNULL(RC.idItem,0) = 0) AND (RC.datInicioCobranca <= GETDATE() AND RC.datCancelamento >= GETDATE()))) as totProduto , (SELECT count(PP.idServico) FROM SER_Servico_PEC As PP WHERE PP.indPublicado = 1 AND PP.idloja = 0 AND PP.indStatus = 'True' AND EXISTS (SELECT idRevenda FROM GEN_RevendaContrato As RC WHERE (RC.idCategoria = PP.idCategoria OR ISNULL(RC.idCategoria, 0) = 0) AND (RC.idItem = PP.idItem OR ISNULL(RC.idItem,0) = 0) AND (RC.datInicioCobranca <= GETDATE() AND RC.datCancelamento >= GETDATE()))) as totServico , (SELECT count(pm.idMarcaFornecedor) FROM PAR_MarcaFornecedor as pm inner join CLI_MarcaFornecedor as cm on cm.idMarcafornecedor = pm.idMarcaFornecedor where cm.idCliente = 0) as totMarca , (SELECT COUNT(idSatisfacao) FROM CLI_Satisfacao WHERE idCliente = 0) as totSatisfacao , 'www.agrocia.com.br' as nomDominio, ISNULL((SELECT recaptcha from cli_dominio where nomdominio = 'www.agrocia.com.br'),'0|0') as recaptcha, ISNULL((SELECT indSSL from cli_dominio where nomdominio = 'www.agrocia.com.br'),'') as indSSL, ISNULL((SELECT indIndex from cli_dominio where nomdominio = 'www.agrocia.com.br'),'') as indIndex FROM GEN_Custom AS C LEFT OUTER JOIN GEN_Tema AS T ON C.idTema = T.idTema WHERE C.idRevenda =0 ---> System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ---> System.ComponentModel.Win32Exception: The network path was not found --- End of inner exception stack trace --- at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at GrupoPLA._Matrix.Matrix.RecuperarDataset(String SQL) in C:\TRABALHO\GRUPOPLA\GrupoPLA._Matrix\GrupoPLA._Matrix\Matrix.cs:line 58 --- 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.Template..ctor(Int32 idCliente, String host) in C:\Trabalho\GrupoPLA.Cliente\GrupoPLA.Cliente\Template.cs:line 169 --- End of inner exception stack trace --- at GrupoPLA.Cliente.Template..ctor(Int32 idCliente, String host) in C:\Trabalho\GrupoPLA.Cliente\GrupoPLA.Cliente\Template.cs:line 242 at DetalhesVeiculo.Page_PreInit(Object sender, EventArgs e) in c:\inetpub\wwwroot\sys.autogerenciador.com.br\11\DetalhesVeiculo.aspx.cs:line 39

Problema não previsto ocorreu no sistema.

System.Exception: Problema de acesso aos dados. ---> System.Exception: [APP]Problema de acesso aos dados. [SQL origem] SELECT indTipoPessoa, tipoFrete, idRevenda, idSistema, Nome, ISNULL(CNPJ,'') AS CNPJ, ISNULL(Inscricao,'') AS Inscricao, ISNULL(RazaoSocial, '') AS RazaoSocial, ISNULL(Endereco,'') AS Endereco, Numero, Complemento, ISNULL(CEP,'') AS CEP, ISNULL(Bairro,'') AS Bairro, ISNULL(Cidade, '') AS Cidade, idCidade, codCidade, Estado, ISNULL((SELECT Nome FROM GEN_Estado WHERE Estado = R.Estado),'') AS nomEstado, Pais, idVendedor, ISNULL((SELECT gc.dscEmpresa FROM GEN_Custom as gc WHERE gc.idRevenda = R.idRevenda),'') AS sobre, DDD, ISNULL(Telefone,'') AS Telefone, DDDCelular, ISNULL(Telefone2,'') AS Telefone2, Operadora, indWhatsApp, ISNULL(Telefone3,'') AS Telefone3 , ISNULL(Contatos,'') AS Contatos, ISNULL(Email,'') AS Email, emailCelular, ISNULL(finEmail, Email) AS finEmail, ISNULL(Website,'') AS Website, indVendoCompro, indLogo, indAtivo, indAlteraDados, indSuspenso, indExcluido, indAnunciante, indAnuncioFixo, indBanner, indTimbrado, indServico, ISNULL(indForcaAgricola,0) AS indTEC, ISNULL(indCaminhoesCarretas,0) AS indCEC, idRamoAtividade, nomCobranca, ISNULL(Facebook, '') AS Facebook, ISNULL(Twitter, '') AS Twitter, ISNULL(Google, '') AS Google, ISNULL(Youtube, '') AS Youtube, ISNULL(Linkedin, '') AS Linkedin, indRevenda, seqBanner, urlBanner, indBannerFixo, indBannerPosicao, indSendGrid, datContrato, idTipoWebSite, datCriacao, datUltimoAcesso, indDestaque, nroBoleto, ISNULL(idMatriz,0) AS idMatriz, isnull(geoLocation.Lat,0) AS geoLatitude, ISNULL(geoLocation.Long,0) AS geoLongitude, ISNULL(geoZoom,0) AS geoZoom, indCaminhoesCarretas, indForcaAgricola, indTipoPessoa, indBannerCEC, indBannerTEC, isnull(idCategoria,0) AS idCategoria, R.idMarca, idOrigem , idRamoAtividade, indExisteLogotipo, ISNULL(indImportaVeiculo,0) AS indImportaVeiculo,isnull(DDDCelular2, '') as DDDCelular2, ISNULL(Celular2,'') as Celular2, indWhatsApp2, (SELECT COUNT(RC.idRevenda) FROM GEN_RevendaContrato AS RC INNER JOIN GEN_PlanoPgto AS PP ON RC.idPlano = PP.idPlano WHERE RC.idRevenda = R.idRevenda AND (PP.indLogotipo = 1) AND (RC.datInicioCobranca < GETDATE()) AND (RC.datCancelamento IS NULL OR RC.datCancelamento + 1 > GETDATE())) AS indLogotipo, (SELECT COUNT(RC.idRevenda) FROM GEN_RevendaContrato AS RC INNER JOIN GEN_PlanoPgto AS PP ON RC.idPlano = PP.idPlano WHERE RC.idRevenda = R.idRevenda AND (PP.indWebSite = 1) AND (RC.datInicioCobranca < GETDATE()) AND (RC.datCancelamento IS NULL OR RC.datCancelamento + 1 > GETDATE())) AS indWebSite, (SELECT COUNT(RC.idRevenda) FROM GEN_RevendaContrato AS RC INNER JOIN GEN_PlanoPgto AS PP ON RC.idPlano = PP.idPlano WHERE RC.idRevenda = R.idRevenda AND (PP.indLinkSite = 1) AND (RC.datInicioCobranca < GETDATE()) AND (RC.datCancelamento IS NULL OR RC.datCancelamento + 1 > GETDATE())) AS indLinkSite, ISNULL((SELECT TOP 1 idPlano FROM GEN_RevendaContrato AS RC WHERE RC.idRevenda=R.idRevenda AND RC.datInicioCobranca <= GETDATE() AND Rc.datCancelamento+1 > GETDATE() ORDER BY (CASE WHEN idPlano=79 then 0 ELSE 1 END)),0) AS planoContrato, finNome, finTelefone, finEmail, ISNULL(tipoEnvioBoleto, 'BNC') as tipoEnvioBoleto, ISNULL(idAgenciaConta, 0) as idAgenciaConta , ISNULL((select top 1 indPortal from gen_revendacontrato as rc inner join GEN_PlanoPgto as pp on rc.idPlano=pp.idplano where idrevenda=r.idRevenda and datInicioCobranca < getdate() and datCancelamento+1 >= getdate() and indBonus=0 and indPatrocinado=0 and indCortesia=0 order by pp.indEstoque DESC, pp.indServico DESC, valor DESC),'') AS indSitePrincipal , indIgnorarBloqueioAutomatico, ISNULL(nomMarca,'') as nomMarca, Abertura, Fechamento, AberturaSabado, FechamentoSabado, AberturaAlmoco, FechamentoAlmoco, indHorarioAlmoco, DiasSemana, indForaHorario, indAnunciarHorario, token_MLB, datToken , indGotaDagua, indGotaDaguaPosicao, indMarcaPortal, planoML, token_FB, datToken_FB, tokenPage_FB, idPage_FB, indMarcaIntegracao from GEN_Revenda R LEFT JOIN CLI_Marca AS M on R.idMarca=M.idMarca WHERE idRevenda = 0 ---> System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ---> System.ComponentModel.Win32Exception: The network path was not found --- End of inner exception stack trace --- at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at GrupoPLA._Matrix.Matrix.RecuperarDataset(String SQL) in C:\TRABALHO\GRUPOPLA\GrupoPLA._Matrix\GrupoPLA._Matrix\Matrix.cs:line 58 --- 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.Cliente..ctor(Int32 id) in C:\Trabalho\GrupoPLA.Cliente\GrupoPLA.Cliente\Cliente.cs:line 247 --- End of inner exception stack trace --- at GrupoPLA.Cliente.Cliente..ctor(Int32 id) in C:\Trabalho\GrupoPLA.Cliente\GrupoPLA.Cliente\Cliente.cs:line 341 at DetalhesVeiculo.CarregarPagina() in c:\inetpub\wwwroot\sys.autogerenciador.com.br\11\DetalhesVeiculo.aspx.cs:line 78

WhatsApp

  • Detalhe


Faça sua Proposta

 Faça sua proposta pelo WhatsApp



RELACIONADOS

Anúncios relacionados ao modelo atual.