Ocorrência
GPEA210 - RHO990: DB error (Update): -29 File: RHO990 - Error : 1 - ORA-00001: unique constraint (LOGIX.RHO990_UNQ) violated UPDATE RHO990 SET RHO_COMPPG = :1 WHERE R_E_C_N_O_ = :2 on FGRAVA210(GPEA210.PRX) 17/05/2018 18:11:27 line : 1386
Causa
THREAD ERROR ([4132], josiane.silva, IC01080014) 27/07/2018 09:21:09
RHO990: DB error (Update): -29 File: RHO990 - Error : 1 - ORA-00001: unique constraint (LOGIX.RHO990_UNQ) violated ( From tISAMFile::Update ) Thread ID [3189] User [josiane] IO [665] Tables [23] MaxTables [23] Comment [GPEA210 - TCPIP - ThreadID(4132)] SP [ ] Traced [No] SQLReplay [No] InTran [Yes] DBEnv [ORACLE/PRD] DBThread [(SID 3817,38721,1)] Started [27/07/2018 09:18:10] IP [192.168.0.214:4144] IDLE [ ] InTransact [0 s.] Memory [552332] Running [ROP_UPDATE] RCV [48965] SND [83696] TCBuild [20171117-20180412]
UPDATE RHO990 SET RHO_COMPPG = :1 WHERE R_E_C_N_O_ = :2
-- Binded Parameters List --
#1 [C] [ ]
#2 [N] [727.000000] on FGRAVA210(GPEA210.PRX) 17/05/2018 18:11:27 line : 1386
[TOTVS build: 7.00.131227A-20180425 NG]
Called from FGRAVA210(GPEA210.PRX) 17/05/2018 18:11:27 line : 1386
Called from GPA210PROCESSA(GPEA210.PRX) 17/05/2018 18:11:27 line : 683
Called from {|lEnd| GPA210Processa(aPerg1,aPerg2,aPerg3),FWI18NLang("GPEA1210","STR0001",1)}(GPEA210.PRX) 17/05/2018 18:11:27 line : 683
Called from { || FWSetShowKeys( .F. ), Eval( bAction, @lEnd ),lEnd := .t. , FWSetShowKeys( .T. ), oDlgModal:Deactivate() }(MSPROCES.PRW) 06/07/2018 09:23:54 line : 683
Called from {|Self|(Eval(oSelf:bInit))}(FWDIALOGMODAL.PRW) 06/07/2018 09:23:49 line : 683
Called from ::MSDIALOG:ACTIVATE line : 683
Called from FWDIALOGMODAL:ACTIVATE(FWDIALOGMODAL.PRW) 06/07/2018 09:23:49 line : 461
Called from PROCESSA(MSPROCES.PRW) 06/07/2018 09:23:54 line : 95
Called from GPEA210(GPEA210.PRX) 17/05/2018 18:11:27 line : 130
Called from __EXECUTE(APLIB090.PRW) 06/07/2018 09:23:49 line : 599
Called from MDIEXECUTE(APLIB260.PRW) 06/07/2018 09:23:49 line : 836
Called from STATICCALL(APLIB260.PRW) 06/07/2018 09:23:49 line : 836
[TOTVS Environment: CERAMFIX]
[TOTVS Environment RPODB: SQL]
[TOTVS Environment Trace: Nenhum]
[TOTVS Environment IBXLog: Nenhum]
[TOTVS Environment KillStack: Nenhum]
[TOTVS Environment TraceStack: Nenhum]
[TOTVS Environment SpecialKey: Nenhum]
[TOTVS Environment LocalFiles: CTREE]
[TOTVS Environment LogProfiler: 1]
[TOTVS Environment TopMemoMega: 1]
[TOTVS Environment RPOLanguage: Portuguese]
[TOTVS Environment RegionalLanguage: BRA]
[TOTVS Environment LocalDBExtension: Nenhum]
[TOTVS Environment ConnectionTimeOut: Nenhum]
[TOTVS Environment General CTreeMode: server]
[TOTVS Environment General ConsoleLog: 1]
[TOTVS Environment General ConsoleFile: Nenhum]
[TOTVS Environment General MaxQuerySize: Nenhum]
[TOTVS Environment General MaxStringSize: Nenhum]
[TOTVS Remote Lib: QT-4.5.2 WIN]
[TOTVS Remote type: Microsoft Windows]
[TOTVS Remote Build: 7.00.131227A-20180507]
[TOTVS Server Type: Console]
[TOTVS Server Build: 7.00.131227A-20180425 NG]
[TOTVS Server Version: 13.2.3.34]
[TOTVS Server 64 bits: Não]
[TOTVS Server Unix: Sim]
[TOTVS DBAccess DB: ORACLE]
[TOTVS DBAccess API Build: 20171117-20180102]
[TOTVS DBAccess Build: 20171117]
[TOTVS DBAccess Type: Linux]
[TOTVS Framework Versão: 20180615]
[TOTVS Framework Date: 20180706_92317]
[TOTVS Framework Commit: be6d9d668f4967b37b3bf801ee5c05346e81937c]
[TOTVS RPO Release: 12.1.017]
[TOTVS License Server Version: License 2014]
Publicas
Public 1: CPAISLOC(C) :BRA
Public 2: LWSISPORTAL(L) :.F.
Public 3: OAPP(O) :O
Public 4: HELP(L) :.F.
Public 5: USIGAADV(L) :.F.
Public 6: CACESSO(C)
Ambiente
Protheus – Gestão de Pessoal – A partir da versão 12.1.17
Solução
Ao realizar a importação de variáveis é necessário o preenchimento do campo Sequencia, que não pode ser igual, se usado de algum arquivo externo .txt.
Importante
Mantenha o seu ambiente atualizado:
MP - GPE - Links para atualizar pacote acumulado no Portal de Cliente
MP- BD0054 - Procedimento para atualizar Lib no Protheus
