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. |