Está sendo gerado o error.log abaixo quando é tentado efetuar a abertura do monitor para cancelamento de MDF-e com a opção Status do Manifesto? igual a Não autorizado: THREAD ERROR ([13172], crisleyne.nunes, JVN060104755) 17/07/2019 18:57:52
: Error : 209 (37000) (RC=-1) - [Microsoft][ODBC SQL Server Driver][SQL Server]Nome da coluna 'DYN_STCMDF' ambíguo.
Error : 209 (37000) (RC=-1) - [Microsoft][ODBC SQL Server Driver][SQL Server]Nome da coluna 'DYN_STCMDF' ambíguo.
( From tMSSQLConnection::GetQueryFile )
Thread ID [12108] User [Administrador] IO [5315] Tables [113] MaxTables [114] Comment [TMSA144D - TCPIP - ThreadID(13172)] SP [ ] Traced [No] SQLReplay [No] InTran [No] DBEnv [MSSQL/P12_17] DBThread [(SPID 56,58,65,66,68,60,61)] Started [17/07/2019 18:56:24] IP [127.0.0.1:1218] IDLE [ ] InTransact [ ] Memory [2726960] Running [ROP_QUERY] RCV [632689] SND [616893] TCBuild [20181212-20190503] TCVersion [18.2.1.1_RC1] ARCH [64] OS [WINDOWS] BUILD [DEBUG]
SELECT * FROM (SELECT ' ' DTQ_STATUS,DYN1.DYN_FILIAL DTX_FILIAL,DYN1.DYN_FILMAN DTX_FILMAN,COALESCE(DYN1.DYN_MANIFE,' ') DTX_MANIFE,DYN1.DYN_DATMAN DTX_DATMAN,DYN1.DYN_HORMAN DTX_HORMAN,DYN1.DYN_RTIMDF DTX_RTIMDF,DYN1.DYN_STIMDF DTX_STIMDF,DYN1.DYN_RTCMDF DTX_RTFMDF,DYN1.DYN_STCMDF DTX_STFMDF,' ' DTX_FIMP,DYN1.R_E_C_N_O_ DTXRECNO,DYN1.DYN_FILORI DTX_FILORI,DYN1.DYN_VIAGEM DTX_VIAGEM,DYN1.DYN_CODEVE DTX_CODEVE,' ' DTX_STATUS,DYN1.DYN_SERMAN DTX_SERMAN,DYN1.DYN_NUMROM DTX_NUMROM,COALESCE(DYN1.DYN_PRMACO,' ') DTX_PRMACO FROM DYNT10 DYN LEFT JOIN DYNT10 DYN1 ON DYN1.DYN_FILIAL = 'M SP ' AND DYN1.DYN_FILMAN = 'M SP 01 ' AND DYN1.DYN_DATMAN BETWEEN '20181201' AND '20191231' AND (DYN1.DYN_MANIFE = DYN.DYN_PRMACO OR DYN1.DYN_MANIFE = DYN.DYN_MANIFE) AND DYN1.DYN_SERMAN = DYN.DYN_SERMAN AND DYN1.D_E_L_E_T_ = ' ' WHERE DYN.DYN_FILIAL = 'M SP ' AND DYN.DYN_DATMAN BETWEEN '20181201' AND '20191231' AND DYN.DYN_FILMAN = 'M SP 01 ' AND DYN.DYN_MANIFE BETWEEN ' ' AND 'ZZZZZZZZZ' AND DYN_STCMDF <> '2' AND DYN.D_E_L_E_T_ = ' ' UNION SELECT ' ' DTQ_STATUS,DYN1.DYN_FILIAL DTX_FILIAL,DYN1.DYN_FILMAN DTX_FILMAN,COALESCE(DYN1.DYN_MANIFE,' ') DTX_MANIFE,DYN1.DYN_DATMAN DTX_DATMAN,DYN1.DYN_HORMAN DTX_HORMAN,DYN1.DYN_RTIMDF DTX_RTIMDF,DYN1.DYN_STIMDF DTX_STIMDF,DYN1.DYN_RTCMDF DTX_RTFMDF,DYN1.DYN_STCMDF DTX_S on TME73LST(TMSAE73.PRW) 05/07/2019 14:34:12 line : 530 [TOTVS build: 7.00.131227A-20180920 NG]
Called from TME73LST(TMSAE73.PRW) 05/07/2019 14:34:12 line : 530
Called from TMSAE73(TMSAE73.PRW) 05/07/2019 14:34:12 line : 227
Called from FWMBROWSE:EXECUTE(FWFORMBROWSE.PRW) 12/07/2019 17:33:43 line : 1107
Called from { || OSELF:EXECUTE("TMSAE73", 2,0,"MDF-E", 3,"()","","", 7 ) }(FWFORMBROWSE.PRW) 12/07/2019 17:33:43 line : 1107
Called from ::MSDIALOG:ACTIVATE line : 1107
Called from FWMBROWSE:ACTIVATE(FWMBROWSE.PRW) 12/07/2019 17:33:43 line : 678
Called from FWMBROWSE(MSLIB.PRW) 12/07/2019 17:33:43 line : 12899
Called from MBROWSE(MSLIB.PRW) 12/07/2019 17:33:43 line : 197
Called from TMSA144(TMSA144.PRW) 26/06/2019 07:41:10 line : 256
Called from TMSA144D(TMSA144D.PRW) 28/08/2014 15:24:11 line : 25
Called from __EXECUTE(APLIB090.PRW) 12/07/2019 17:33:40 line : 679
Called from MDIEXECUTE(APLIB260.PRW) 12/07/2019 17:33:40 line : 882
Called from STATICCALL(APLIB260.PRW) 12/07/2019 17:33:40 line : 882 |
