Passo a passo: | Ao tentar executar a geração de períodos, sendo que existam alguns períodos, o sistema identifica que já existem registros mas gera error log de chave duplicada: THREAD ERROR DB error (Insert): -37 File: RCG010 - Error : 1 - ORA-00001: unique constraint (TESTE.RCG010_UNQ) violated ( From tISAMFile::Write )
INSERT INTO RCG010(RCG_FILIAL,RCG_MES,RCG_ANO,RCG_PER,RCG_PROCES,RCG_ROTEIR,RCG_TNOTRA,RCG_SEMANA,RCG_DIAMES,RCG_TIPDIA,RCG_VTRANS,RCG_DIFTRA,RCG_VREFEI,RCG_VALIM, RCG_DTINI,RCG_DTFIM,RCG_MODULO,R_E_C_N_O_) VALUES ( :1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18)
-- Binded Parameters List --
#1 [C] [02]
#2 [C] [07]
#3 [C] [2017]
#4 [C] [201707]
#5 [C] [00001]
#6 [C] [ ]
#7 [C] [@@@]
#8 [C] [01]
#9 [D] [20170701]
#10 [C] [2]
#11 [C] [2]
#12 [C] [2]
#13 [C] [2]
#14 [C] [2]
#15 [D] [20170701]
#16 [D] [20170731]
#17 [C] [GPE]
#18 [N] [34932.000000]
- Integrity failure. in file D:\bamboo-agent-5.7.2\xml-data\build-dir\TP11-BUILDV2APPSRV-TEC11WIN32RPO32\advtec9_tt11\lib\top.cpp at line 2386
on MSUNLOCK(APLIB060.PRW) 11/08/2017 19:00:10 line : 750 [TOTVS build: 7.00.131227A-20170904 NG]
Called from MSUNLOCK(APLIB060.PRW) 11/08/2017 19:00:10 line : 750
Called from FGRAVARCG(GPEA400.PRW) 07/07/2017 15:25:47 line : 1169
Called from GP490GRAVA(GPEA490.PRW) 17/01/2017 17:49:53 line : 1045
Called from FDISPTELAEXCL(GPEA490.PRW) 17/01/2017 17:49:53 line : 586
Called from {|| fDispTelaExcl() }(GPEA490.PRW) 17/01/2017 17:49:53 line : 586
Called from { || Eval( bAction, @lEnd ),lEnd := .t. , oDlg:End() }(MATXFUNA.PRX) 12/06/2017 17:22:46 line : 586
Called from ::MSDIALOG:ACTIVATE line : 586
Called from MSAGUARDE(MATXFUNA.PRX) 12/06/2017 17:22:46 line : 4371
Called from FPREGERACAO(GPEA490.PRW) 17/01/2017 17:49:53 line : 471
Called from GP490EXECGER(GPEA490.PRW) 17/01/2017 17:49:53 line : 210
Called from GPEA490(GPEA490.PRW) 17/01/2017 17:49:53 line : 108
Called from __EXECUTE(APLIB090.PRW) 11/08/2017 19:00:10 line : 602
Called from MDIEXECUTE(APLIB260.PRW) 11/08/2017 19:00:10 line : 820
Called from STATICCALL(APLIB260.PRW) 11/08/2017 19:00:10 line : 820
Solução: A Release Oficial foi expedida e publicada na Central de Downloads.
O pacote pode ser acessado no endereço: 12.1.7: https://goo.gl/VueHSn ; 12.1.14: https://goo.gl/QsD5Zv ; 12.1.16: https://goo.gl/33MHhi ; 12.1.17: https://goo.gl/VY2zTm ; Observação: Caso esteja com o RPO muito desatualizado, além de aplicar o pacote pontual acima, será necessário atualizar também o pacote acumulado da sua versão conforme a base de conhecimento: PSIGABD0086 - Qual o link direto para pesquisar e baixar o pacote acumulado do Portal do Cliente? Aceitar apenas fontes atualizados. |
