Situação/Requisito: | Relatório gera "error.log" ao ser emitido em modo sintético.
THREAD ERROR ([1840], aluno, I-0597E40EC) 24/02/2018 16:55:28
: Error : 4145 (37000) (RC=-1) - [Microsoft][SQL Server Native Client 11.0][SQL Server]Uma expressao de tipo nao booleano especificada em um contexto no qual se espera uma condicao, proximo a 'SRA'. ( From tMSSQLConnection::GetQueryFile )
Thread ID [1544] User [aluno] IO [10413] Tables [16] MaxTables [18] Comment [GPER040 - TCPIP - ThreadID(1840)] Status [] SP [ ] Traced [No] SQLReplay [No] InTran [No] DBEnv [MSSQL/P12117PAD] DBThread [(SPID 51,52)] Started [24/02/2018 16:38:44] LastIO [24/02/2018 16:55:28] IP [127.0.0.1:1240] RCV [117073] SND [1048586] TCBuild [20170202-20170626]
SELECT TVIEW.FILIAL,TVIEW.MAT FROM (SELECT SRA.RA_FILIAL FILIAL,SRA.RA_MAT MAT FROM SRAT10 SRA INNER JOIN SRCT10 SRC ON SRA.RA_MAT = SRC.RC_MAT AND SRA.RA_FILIAL = SRC.RC_FILIAL AND SRA.RA_MAT = SRC.RC_MAT INNER JOIN CTTT10 CTT ON CTT.D_E_L_E_T_ = ' ' AND CTT.CTT_FILIAL = SRC.RC_FILIAL AND CTT.CTT_CUSTO = SRC.RC_CC WHERE SRA.RA_SITFOLH IN (' ','A','D','F','T','*' ) AND SRA.RA_CATFUNC IN ('M','*','*','*','*','*','*','*','*','*','*','*','*','*','*','*','*','*' ) AND SRA.RA_TPCONTR IN ('3' ) AND SRC.RC_PROCES = '00001' AND SRC.RC_PERIODO = '201706' AND SRC.RC_ROTEIR = 'FOL' AND ' ' SRA.D_E_L_E_T_= ' ' AND RA_FILIAL IN('D MG 01 ', ' ' ) AND SRC.D_E_L_E_T_= ' ' GROUP BY SRA.RA_FILIAL, SRA.RA_MAT UNION SELECT SRA.RA_FILIAL FILIAL,SRA.RA_MAT MAT FROM SRAT10 SRA INNER JOIN SRDT10 SRD ON SRA.RA_MAT = SRD.RD_MAT AND SRA.RA_FILIAL = SRD.RD_FILIAL AND SRA.RA_MAT = SRD.RD_MAT INNER JOIN CTTT10 CTT ON CTT.D_E_L_E_T_ = ' ' AND CTT.CTT_FILIAL = SRD.RD_FILIAL AND CTT.CTT_CUSTO = SRD.RD_CC WHERE SRA.RA_SITFOLH IN (' ','A','D','F','T','*' ) AND SRA.RA_CATFUNC IN ('M','*','*','*','*','*','*','*','*','*','*','*','*','*','*','*','*','*' ) AND SRA.RA_TPCONTR IN ('3' ) AND SRD.RD_PROCES = '00001' AND SRD.RD_PERIODO = '201706' AND SRD.RD_ROTEIR = 'FOL' AND ' ' SRA.D_E_L_E_T_= ' ' AND RA_FILIAL IN('D MG 01 ', ' ' ) AND SRD.D_E_L_E_T_= ' ' GROUP BY SRA.RA_FILIAL, SRA.RA_MAT ) TVIEW GROUP BY TVIEW.FILIAL, TVIEW.MAT on __EXECSQL(APLIB300.PRW) 22/02/2018 16:52:33 line : 126 [TOTVS build: 7.00.131227A-20180104 NG]
Called from __EXECSQL(APLIB300.PRW) 22/02/2018 16:52:33 line : 126
Called from APURASIT(GPER106.PRW) 12/02/2018 16:20:53 line : 3647 |
