Situação/Requisito: | Error. log gerado na execução do reprocessamento de Saldos compostos em POSTGRES CT3990: DB error (Update): -29 File: CT3990 - Error : 7 (23505) (RC=-1) - ERROR: duplicate key value violates unique constraint "ct3990_unq" Key (ct3_filial, ct3_data, ct3_custo, ct3_conta, ct3_moeda, ct3_tpsald, ct3_lp, r_e_c_d_e_l_)=(01, 20161231, 2000 , 3010101010101 , 01, 1, Z, 0) already exists.; Error while executing the query ( From tISAMFile::Update ) Thread ID [3056] User [Administrador] IO [25470] Tables [48] MaxTables [50] Comment [CTBA360 - TCPIP - ThreadID(6656)] Status [] SP [ ] Traced [No] InTran [No] DBEnv [POSTGRES/SLATST82] DBThread [(ID )] Started [11/03/2016 08:02:08] LastIO [] IP [172.16.31.54:1890] RCV [914202] SND [1861062] TCBuild [20141119] UPDATE CT3990 SET CT3_DEBITO = 1000.0000000000,CT3_CREDIT = 0.0000000000,CT3_ATUDEB = 1000.0000000000,CT3_ANTCRD = 1000.0000000000,CT3_LP = 'Z' WHERE R_E_C_N_O_ = 488 on MSUNLOCK(APLIB060.PRW) 01/02/2016 09:48:28 line : 682 [TOTVS build: 7.00.131227A-20151103] Called from CT190GRAVA(CTBA190.PRW) 12/05/2015 16:41:44 line : 1450 Called from CT190GRSLD(CTBA190.PRW) 12/05/2015 16:41:44 line : 1354 Called from CT190SLBSE(CTBA190.PRW) 12/05/2015 16:41:44 line : 1878 Called from CTB360PROC(CTBA360.PRW) 06/03/2014 08:21:14 line : 381 Called from {|LEND| CTB360PROC(OPROCESS,CFILANT)}(CTBA360.PRW) 06/03/2014 08:21:14 line : 278 Called from eval line : 66 Called from {|| EVAL(SELF:BACTION,@SELF:LEND,@SELF),SELF:LEND := .T. ,SELF:ODLG:END()}(MSNEWPROC.PRW) 13/05/2010 14:52:12 line : 66 |
Solução/Implementação: | Correção do error.log acima na execução do reprocessamento de Saldos Compostos.Antes de efetuar a atualização de saldos base, CT7, CT3, CT4, CTI, excluir os saldos dessas tabelas. |