Local: PDVServico Mensagem: Violation of UNIQUE KEY constraint 'IX_tbTabelaPrecoProdutoItemPDV'. Cannot insert duplicate key in object 'dbo.tbTabelaPrecoProdutoItemPDV'. The duplicate key value is (6, 128). The statement has been terminated. Instrucao SQL Truncate Table tbTabelaPrecoProdutoItemPDV ; Insert Into tbTabelaPrecoProdutoItemPDV (tpv_CodigoEmpresa, tpv_CodigoTabelaPrecoProduto, tpv_CodigoProduto, tpv_Preco, tpv_PrecoPromocao) Select tpi_CodigoEmpresa, tpi_CodigoTabelaPrecoProduto, tpi_CodigoProduto, Case When isnull(prl_PrecoLoja, 0) = 0 Or isnull(tpi_TipoAlteracaoPreco, 'M') <> 'L' Then tpi_Preco When isnull(tpi_TipoAlteracaoPreco, 'M') = 'L' And isnull(prl_PrecoLoja, 0) > isnull(tpi_Preco, 0) And isnull(tpi_PctMaximaPermitidoLojaAlteraPreco, 0) = 0 Then prl_PrecoLoja When isnull(tpi_TipoAlteracaoPreco, 'M') = 'L' And isnull(prl_PrecoLoja, 0) > isnull(tpi_Preco, 0) And isnull(tpi_PctMaximaPermitidoLojaAlteraPreco, 0) > 0 And Convert(decimal(10,2),(tpi_Preco + ((tpi_Preco * isnull(tpi_PctMaximaPermitidoLojaAlteraPreco, 0)) /100))) <= isnull(prl_PrecoLoja, 0) Then prl_PrecoLoja When isnull(tpi_TipoAlteracaoPreco, 'M') = 'L' And isnull(tpi_PctMinimoPermitidoLojaAlteraPreco, 0) = 100 Then prl_PrecoLoja When isnull(tpi_TipoAlteracaoPreco, 'M') = 'L' And isnull(tpi_PctMinimoPermitidoLojaAlteraPreco , 0) = 0 And isnull(prl_PrecoLoja, 0) < isnull(tpi_Preco, 0) Then tpi_Preco When isnull(tpi_TipoAlteracaoPreco, 'M') = 'L' And isnull(tpi_Preco, 0) = 0 Then isnull(prl_PrecoLoja, 0) When isnull(tpi_TipoAlteracaoPreco, 'M') = 'L' And isnull(prl_PrecoLoja, 0) < isnull(tpi_Preco, 0) And isnull(tpi_PctMinimoPermitidoLojaAlteraPreco, 0) > 0 And isnull(tpi_PctMinimoPermitidoLojaAlteraPreco, 0) < 100 And Convert(decimal(10,2),(tpi_Preco - ((tpi_Preco * isnull(tpi_PctMinimoPermitidoLojaAlteraPreco, 0)) /100))) <= isnull(prl_PrecoLoja, 0) Then prl_PrecoLoja Else tpi_Preco End as tpi_Preco, tpi_PrecoPromocao From tbTabelaPrecoProdutoItem (NOLOCK) Inner Join tbTabelaPrecoProduto (NOLOCK) On tpp_CodigoEmpresa = tpi_CodigoEmpresa And tpp_Codigo = tpi_CodigoTabelaPrecoProduto And tpp_Ativo = '1' Inner Join tbTabelaPrecoProdutoLoja (NOLOCK) on ppl_CodigoEmpresa = tpi_CodigoEmpresa And ppl_CodigoTabelaPrecoProduto = tpi_CodigoTabelaPrecoProduto And ppl_Principal = '1' Inner Join tbProduto (NOLOCK) ON pro_CodigoEmpresa = tpi_CodigoEmpresa And pro_Codigo = tpi_CodigoProduto And pro_Ativo = 1 And isnull(pro_DataProdutoDescontinuacao, getdate()) >= getdate() Left Join tbProdutoLoja (NOLOCK) on prl_CodigoEmpresa = tpi_CodigoEmpresa And prl_CodigoProduto = tpi_CodigoProduto And prl_CodigoLoja = 339 Where tpp_CodigoEmpresa = 6 And ppl_CodigoLoja = 339 And Convert(DATE, tpp_InicioVigencia, 23) <= Convert(DATE, getdate(), 23) And Convert(DATE, isnull(tpp_TerminoVigencia, '2200-01-01'), 23) >= Convert(DATE, getdate(), 23) ; Stack Trace: at ideologica.IdeoFramework.BancoDadosSQL.GerarExcecaoComando(SqlCommand comando, Exception innerException) at ideologica.IdeoFramework.BancoDadosSQL.Executar(SqlCommand comando) at ideologica.clsBD_TabelaPrecoProduto.MontaTabelaPDVLoja() at ideologica.basPDVServicoEProduto.SetaTabelaPrecoProdutoPrincipal() at ideologica.frmAbertura.frmAbertura_Load(Object sender, EventArgs e) at System.Windows.Forms.Form.OnLoad(EventArgs e) at System.Windows.Forms.Form.OnCreateControl() at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) at System.Windows.Forms.Control.CreateControl() at System.Windows.Forms.Control.WmShowWindow(Message& m) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ScrollableControl.WndProc(Message& m) at System.Windows.Forms.Form.WmShowWindow(Message& m) at System.Windows.Forms.Form.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) Local: .Net SqlClient Data Provider Mensagem: Violation of UNIQUE KEY constraint 'IX_tbTabelaPrecoProdutoItemPDV'. Cannot insert duplicate key in object 'dbo.tbTabelaPrecoProdutoItemPDV'. The duplicate key value is (6, 128). The statement has been terminated. Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ideologica.IdeoFramework.BancoDadosSQL.Executar(SqlCommand comando) ========================= Informações do Aplicativo ========================= Arquivo: PDVServico.exe Caminho: C:\Allegro.IoT\PDVServico.exe Versão: 7.0.0.1238 ====================== Informações da Máquina ====================== Nome da Máquina: DESKTOP-3CL40GT Memória: 6,92 GB Sistema Operacional: Microsoft Windows 10 Pro Processador: Intel(R) Core(TM) i5-10400 CPU @ 2.90GHz (2904Mhz) Usuário: DESKTOP-3CL40GT\Sapataria Resolução do Vídeo: 1366x768 Versão SQL Server: Microsoft SQL Server 2016 (SP2) (KB4052908) - 13.0.5026.0 (X64) Mar 18 2018 09:11:49 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 19045: ) Versão exe: 7.0.0, Computador: DESKTOP-3CL40GT