Ao excluir um manifesto de uma viagem de comboio estão apresentando dois erros.log O primeiro ocorre na seguinte situação: Inclui uma viagem de comboio (com dois veículos diferentes), manifesta, transmite o manifesto, após, visualiza o manifesto. Serão gerados dois MDF-es, um para cada veículo. Ao selecionar o segundo gerado e clicar em excluir, logo é apresentado o primeiro erro, informando que a tabela DYN está alocada, porém a mesma não está em uso:
THREAD ERROR ([7384], crisleyne.nunes, JVD60100061) 21/12/2018 16:44:25 DYNT10: DB error (Update): -29 File: DYNT10 - Error : 2601 (23000) (RC=-1) - [Microsoft][ODBC SQL Server Driver][SQL Server]Não é possível inserir uma linha de chave duplicada no objeto 'dbo.DYNT10' com índice exclusivo 'DYNT10_UNQ'. O valor de chave duplicada é (M SP , M SP 01 , 444000015, 0). ( From tISAMFile::Update ) Thread ID [1668] User [Administrador] IO [1161] Tables [40] MaxTables [40] Comment [TMSA144D - TCPIP - ThreadID(7384)] Status [] SP [ ] Traced [No] SQLReplay [No] InTran [Yes] DBEnv [MSSQL/P12_17] DBThread [(SPID 66,71)] Started [21/12/2018 16:43:41] LastIO [21/12/2018 16:44:25] IP [127.0.0.1:1218] RCV [55907] SND [112391] TCBuild [20161016-20170331] UPDATE dbo.DYNT10 SET DYN_CODOBS = ?,DYN_PRMACO = ?,D_E_L_E_T_ = ?,R_E_C_D_E_L_ = ? WHERE R_E_C_N_O_ = ? -- Binded Parameters List -- #1 [C] [000629] #2 [C] [444000014] #3 [C] [ ] #4 [N] [0.000000] #5 [N] [9.000000] on ENDTRAN(APLIB060.PRW) 23/10/2018 18:06:47 line : 218 [TOTVS build: 7.00.131227A-20180920 NG] Called from ENDTRAN(APLIB060.PRW) 23/10/2018 18:06:47 line : 218 Called from TMSA190PROC(TMSA190.PRW) 13/12/2018 19:54:05 line : 868 Called from {|| TmsA190Proc( .T. , DTX->DTX_FILORI, DTX->DTX_VIAGEM, cObsCan)}(TMSA190.PRW) 13/12/2018 19:54:05 line : 868 Called from { || FWSetShowKeys( .F. ), Eval( bAction, @lEnd ),lEnd := .t. , FWSetShowKeys( .T. ), oDlgModal:Deactivate() }(MSPROCES.PRW) 23/10/2018 18:06:50 line : 868 Called from {|Self|(Eval(oSelf:bInit))}(FWDIALOGMODAL.PRW) 23/10/2018 18:06:47 line : 868 Called from ::MSDIALOG:ACTIVATE line : 868 Called from FWDIALOGMODAL:ACTIVATE(FWDIALOGMODAL.PRW) 23/10/2018 18:06:47 line : 461 Called from PROCESSA(MSPROCES.PRW) 23/10/2018 18:06:50 line : 107 Called from TMSA190MNT(TMSA190.PRW) 13/12/2018 19:54:05 line : 343 Called from {||WMudaCad(cTitle,'&Excluir'),TmsA190Mnt(Alias(),RecNo(), 3),oBrowse:SetFocus(),oBrowse:Refresh()}(WNDBROWS.PRW) 16/05/2014 20:45:10 line : 343 Called from ::MSDIALOG:ACTIVATE line : 343 Called from MAWNDBROWSE(WNDBROWS.PRW) 16/05/2014 20:45:10 line : 304 Called from TMSA144SUB(TMSA144.PRW) 13/12/2018 09:24:51 line : 5991 Called from FWMBROWSE:EXECUTE(FWFORMBROWSE.PRW) 23/10/2018 18:06:50 line : 1107 Called from { || OSELF:EXECUTE("TMSA144SUB", 2,0,"VISUAL/EXCLUIR", 1,"(3, 2)","","", 7 ) }(FWFORMBROWSE.PRW) 23/10/2018 18:06:50 line : 1107 Called from ::MSDIALOG:ACTIVATE line : 1107 Called from FWMBROWSE:ACTIVATE(FWMBROWSE.PRW) 23/10/2018 18:06:50 line : 677 Called from FWMBROWSE(MSLIB.PRW) 23/10/2018 18:06:50 line : 12770 Called from MBROWSE(MSLIB.PRW) 23/10/2018 18:06:50 line : 197 Called from TMSA144(TMSA144.PRW) 13/12/2018 09:24:51 line : 243 Called from TMSA144D(TMSA144D.PRW) 28/08/2014 15:24:11 line : 25 Called from __EXECUTE(APLIB090.PRW) 23/10/2018 18:06:47 line : 636 Called from MDIEXECUTE(APLIB260.PRW) 23/10/2018 18:06:47 line : 836 Called from STATICCALL(APLIB260.PRW) 23/10/2018 18:06:47 line : 836
Após, a tela é finalizada. Ao tentar fazer o processo de exclusão novamente é apresentado o segundo erro, informando registro duplicado na tabela:
THREAD ERROR ([6228], crisleyne.nunes, JVD60100061) 21/12/2018 17:24:20 Update error - lock required - File: DYNT10 in file D:\bamboo-agent-5.7.2\xml-data\build-dir\TP11-BUILDV2APPSRV-TEC11WIN32RPO32\advtec9_tt11\advpl\advplfile.cpp at line 74 on TMSA190PROC(TMSA190.PRW) 13/12/2018 19:54:05 line : 703 [TOTVS build: 7.00.131227A-20180920 NG] Called from TMSA190PROC(TMSA190.PRW) 13/12/2018 19:54:05 line : 703 Called from {|| TmsA190Proc( .T. , DTX->DTX_FILORI, DTX->DTX_VIAGEM, cObsCan)}(TMSA190.PRW) 13/12/2018 19:54:05 line : 703 Called from { || FWSetShowKeys( .F. ), Eval( bAction, @lEnd ),lEnd := .t. , FWSetShowKeys( .T. ), oDlgModal:Deactivate() }(MSPROCES.PRW) 23/10/2018 18:06:50 line : 703 Called from {|Self|(Eval(oSelf:bInit))}(FWDIALOGMODAL.PRW) 23/10/2018 18:06:47 line : 703 Called from ::MSDIALOG:ACTIVATE line : 703 Called from FWDIALOGMODAL:ACTIVATE(FWDIALOGMODAL.PRW) 23/10/2018 18:06:47 line : 461 Called from PROCESSA(MSPROCES.PRW) 23/10/2018 18:06:50 line : 107 Called from TMSA190MNT(TMSA190.PRW) 13/12/2018 19:54:05 line : 343 Called from {||WMudaCad(cTitle,'&Excluir'),TmsA190Mnt(Alias(),RecNo(), 3),oBrowse:SetFocus(),oBrowse:Refresh()}(WNDBROWS.PRW) 16/05/2014 20:45:10 line : 343 Called from ::MSDIALOG:ACTIVATE line : 343 Called from MAWNDBROWSE(WNDBROWS.PRW) 16/05/2014 20:45:10 line : 304 Called from TMSA144SUB(TMSA144.PRW) 13/12/2018 09:24:51 line : 5991 Called from FWMBROWSE:EXECUTE(FWFORMBROWSE.PRW) 23/10/2018 18:06:50 line : 1107 Called from { || OSELF:EXECUTE("TMSA144SUB", 2,0,"VISUAL/EXCLUIR", 1,"(3, 2)","","", 7 ) }(FWFORMBROWSE.PRW) 23/10/2018 18:06:50 line : 1107 Called from ::MSDIALOG:ACTIVATE line : 1107 Called from FWMBROWSE:ACTIVATE(FWMBROWSE.PRW) 23/10/2018 18:06:50 line : 677 Called from FWMBROWSE(MSLIB.PRW) 23/10/2018 18:06:50 line : 12770 Called from MBROWSE(MSLIB.PRW) 23/10/2018 18:06:50 line : 197 Called from TMSA144(TMSA144.PRW) 13/12/2018 09:24:51 line : 243 Called from TMSA144D(TMSA144D.PRW) 28/08/2014 15:24:11 line : 25 Called from __EXECUTE(APLIB090.PRW) 23/10/2018 18:06:47 line : 636 Called from MDIEXECUTE(APLIB260.PRW) 23/10/2018 18:06:47 line : 836 Called from STATICCALL(APLIB260.PRW) 23/10/2018 18:06:47 line : 836 |