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 |
