5417337 DRHGCH-942 - DT Relatório Valores Rescisão - Error.log

01. DADOS GERAIS

02. SITUAÇÃO/REQUISITO

Ao executar o relatório GPER630, o sistema gera um erro. Dependendo da atualização da lib, o erro pode ocorrer de duas maneiras diferentes:

THREAD ERROR ([13824], xxxx.xxxx, xxxxxxx) 22/03/2019 13:38:26
: Error : 102 (37000) (RC=-1) - [Microsoft][ODBC SQL Server Driver][SQL Server]Sintaxe incorreta próxima a ' '.
( From tMSSQLConnection::GetQueryFile )
Thread ID [13512] User [Administrador] IO [15837] Tables [28] MaxTables [28] Comment [GPEM040 - TCPIP - ThreadID(13824)] SP [ ] Traced [No] SQLReplay [No] InTran [No]DBEnv [MSSQL/P12_FUNCIONA] DBThread [(SPID 51,52)] Started [22/03/2019 10:53:32] IP [127.0.0.1:1234] IDLE [ ] InTransact [ ] Memory [99920] Running [ROP_QUERY] RCV [298280] SND [2938494] TCBuild [20181212-20190211] TCVersion [18.2.1.0] ARCH [64] OS [WINDOWS] BUILD [RELEASE] 
SELECT RA_FILIAL,RA_CC,RA_TNOTRAB,RA_MAT,RA_NOME,SRA.RA_DEPIR,SRA.RA_DEPSF,RG_FILIAL,RG_MAT,RG_DATADEM,RG_DATAHOM,RG_DTAVISO,RG_DTGERAR,RG_DAVISO,RG_TIPORES,RG_MEDATU,RG_DFERVEN,RG_DFERPRO,RG_SALMES,RG_SALDIA,RG_SALHORA,RG_EFETIVA,RR_FILIAL,RR_MAT,RR_PD,RR_HORAS,RR_TIPO1,RR_VALOR,RR_TIPO3,RR_DATA,RV_COD,RV_DESC,RV_TIPOCOD,R6_DESC,CTT_DESC01 FROM SRAT10 SRA , SRGT10 SRG , SRRT10 SRR , SRVT10 SRV , SR6T10 SR6 , CTTT10 CTT WHERE SRA.RA_FILIAL = SRG.RG_FILIAL AND SRA.RA_MAT = SRG.RG_MAT AND SRA.RA_FILIAL = SRR.RR_FILIAL AND SRA.RA_MAT = SRR.RR_MAT AND SRR.RR_TIPO3 = 'R' AND ' ' =' ' AND SRR.RR_PD = SRV.RV_COD AND SUBSTRING(SR6.R6_FILIAL, 1, 4) = SUBSTRING(SRA.RA_FILIAL, 1, 4) AND SR6.R6_TURNO = SRA.RA_TNOTRAB ' ' =' ' AND CTT.CTT_CUSTO = SRA.RA_CC AND SRA.RA_SITFOLH IN (' ','A','D','F','T' ) AND SRA.RA_CATFUNC IN ('A','C','D','E','G','H','I','J','M','P','S','T','','','*' ) AND SRG.RG_EFETIVA IN (' ','S' ) AND SRA.D_E_L_E_T_= ' ' AND SRG.D_E_L_E_T_= ' ' AND SRR.D_E_L_E_T_= ' ' AND CTT.D_E_L_E_T_= ' ' AND SRV.D_E_L_E_T_= ' ' AND SR6.D_E_L_E_T_= ' ' ORDER BY RA_FILIAL, RA_MAT, RR_PD on __EXECSQL(APLIB300.PRW) 15/03/2019 14:27:42 line : 134

THREAD ERROR ([80016], xxxx.xxxxx, xxxxxxxx) 26/03/2019 11:32:33 : Error : 102 (37000) (RC=-1) - [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'CTT'. ( From tMSSQLConnection::GetQueryFile ) Thread ID [77220] User [Administrador] IO [2706] Tables [26] MaxTables [27] Comment [GPEM040 - TCPIP - ThreadID(80016)] SP [ ] Traced [No] SQLReplay [No] InTran [No] DBEnv [MSSQL/P12117MNT] DBThread [(SPID 60,61)] Started [26/03/2019 11:27:47] IP [192.168.137.1:1230] IDLE [ ] InTransact [ ] Memory [204504] Running [ROP_QUERY] RCV [386278] SND [978307] TCBuild [20181212-20190211] TCVersion [18.2.1.0] ARCH [64] OS [WINDOWS] BUILD [RELEASE] SELECT RA_FILIAL,RA_CC,RA_TNOTRAB,RA_MAT,RA_NOME,SRA.RA_DEPIR,SRA.RA_DEPSF,RG_FILIAL,RG_MAT,RG_DATADEM,RG_DATAHOM,RG_DTAVISO,RG_DTGERAR,RG_DAVISO,RG_TIPORES,RG_MEDATU,RG_DFERVEN,RG_DFERPRO,RG_SALMES,RG_SALDIA,RG_SALHORA,RG_EFETIVA,RR_FILIAL,RR_MAT,RR_PD,RR_HORAS,RR_TIPO1,RR_VALOR,RR_TIPO3,RR_DATA,RV_COD,RV_DESC,RV_TIPOCOD,R6_DESC,CTT_DESC01 FROM SRAT10 SRA , SRGT10 SRG , SRRT10 SRR , SRVT10 SRV , SR6T10 SR6 , CTTT10 CTT WHERE SRA.RA_FILIAL = SRG.RG_FILIAL AND SRA.RA_MAT = SRG.RG_MAT AND SRA.RA_FILIAL = SRR.RR_FILIAL AND SRA.RA_MAT = SRR.RR_MAT AND SRR.RR_TIPO3 = 'R' AND SRV.RV_FILIAL = SRA.RA_FILIAL AND SRR.RR_PD = SRV.RV_COD AND SUBSTRING(SR6.R6_FILIAL, 1, 4) = SUBSTRING(SRA.RA_FILIAL, 1, 4) AND SR6.R6_TURNO = SRA.RA_TNOTRAB CTT.CTT_FILIAL = SRA.RA_FILIAL AND CTT.CTT_CUSTO = SRA.RA_CC AND SRA.RA_SITFOLH IN (' ','A','D','F','T' ) AND SRA.RA_CATFUNC IN ('A','C','D','E','G','H','I','J','M','P','S','T','*','*','*' ) AND SRG.RG_EFETIVA IN (' ','S' ) AND SRA.D_E_L_E_T_= ' ' AND SRG.D_E_L_E_T_= ' ' AND SRR.D_E_L_E_T_= ' ' AND CTT.D_E_L_E_T_= ' ' AND SRV.D_E_L_E_T_= ' ' AND SR6.D_E_L_E_T_= ' ' ORDER BY RA_FILIAL, RA_MAT, RR_PD on __EXECSQL(APLIB300.PRW) 15/03/2019 14:54:46 line : 134

03. SOLUÇÃO

Realizado ajuste na query de consulta do relatório, incluindo operador AND após condição SR6.R6_TURNO = SRA.RA_TNOTRAB , a fim de realizar impressão corretamente.