Passo a passo: | THREAD ERROR Incorrect syntax near ')'
SELECT DISTINCT SRC.RC_FILIAL,SRC.RC_CC,SRC.RC_MAT,SRA.RA_NOME,SRA.RA_ADMISSA,SRA.RA_CATFUNC,SRA.RA_SALARIO,SRA.RA_DEPIR,SRA.RA_DEPSF,SRA.RA_PERCADT,SRA.RA_HRSMES,SRA.RA_DEMISSA,SRA.RA_TPCONTR,' ' AS RA_NOMECOM,SRA.RA_CODFUNC,SRA.RA_PERCSAT,SRA.RA_FILIAL,SRA.RA_CC,SRA.RA_MAT,SRA.RA_RESEXT,SRA.RA_DEPTO FROM SRC010 SRC , SRA010 SRA WHERE SRC.RC_FILIAL = SRA.RA_FILIAL AND SRC.RC_MAT = SRA.RA_MAT AND SRC.RC_FILIAL BETWEEN ' ' AND 'zz' AND SRC.RC_MAT BETWEEN ' ' AND 'zzzzzz' AND SRC.RC_CC BETWEEN ' ' AND 'zzzzzzzzz' AND SRA.RA_DEPTO BETWEEN ' ' AND 'ZZZZZZZZZ' AND SRA.RA_CATFUNC IN ('A','C','D','E','G','H','I','J','M','P','S','T' ) AND SRC.D_E_L_E_T_ = ' ' AND SRA.D_E_L_E_T_ = ' ' AND EXISTS(SELECT RC_MAT FROM SRC010 SRC WHERE SRC.RC_FILIAL = SRA.RA_FILIAL AND SRC.RC_MAT = SRA.RA_MAT AND SRC.D_E_L_E_T_ = ' ' AND () ) UNION SELECT SRA.RA_FILIAL AS RC_FILIAL,SRA.RA_CC AS RC_CC,SRA.RA_MAT AS RC_MAT,SRA.RA_NOME,SRA.RA_ADMISSA,SRA.RA_CATFUNC,SRA.RA_SALARIO,SRA.RA_DEPIR,SRA.RA_DEPSF,SRA.RA_PERCADT,SRA.RA_HRSMES,SRA.RA_DEMISSA,SRA.RA_TPCONTR,' ' AS RA_NOMECOM,SRA.RA_CODFUNC,SRA.RA_PERCSAT,SRA.RA_FILIAL,SRA.RA_CC,SRA.RA_MAT,SRA.RA_RESEXT,SRA.RA_DEPTO FROM SR8010 SR8 , SRA010 SRA WHERE SR8.R8_FILIAL = SRA.RA_FILIAL AND SR8.R8_MAT = SRA.RA_MAT AND SRA.RA_FILIAL BETWEEN ' ' AND 'zz' AND SRA.RA_MAT BETWEEN ' ' AND 'zzzzzz' AND SRA.RA_CC BETWEEN ' ' AND 'zzzzzzzzz' AND (R8_DATAINI <= '20170831' AND (R8_DATAFIM >= '20170801' OR R8_DATAFIM = ' ') ) AND SR8.D_E_L_E_T_ = ' ' AND SRA.D_ on FIMPGERFOL(GPER040.PRX) 28/07/2017 17:50:26 line : 3399 [build: 7.00.131227A-20151103]
[environment: PLANERJ]
[thread: 3316]
[dbthread: 3380]
[rpodb: SQL]
[localfiles: CTREE]
[remark: Emp :01/01 Logged :ivan.peppe SIGAGPE Obj :GPEM110 - Contabilização]
[threadtype: RmtSockThread]
Called from GR040IMP(GPER040.PRX) 28/07/2017 17:50:26 line : 957
Called from {|| LRET := GR040IMP(,,"SRZ",CMESANOREF,ATPCONTR[NNROCONTR], .T. ,@LEXECPROC)}(GPEM110.PRX) 15/12/2016 10:13:44 line : 2248
Called from eval line : 116
Called from PROCESSA(MSPROCES.PRW) 15/01/2015 09:53:12 line : 116
Called from FGERAFOLSRZ(GPEM110.PRX) 15/12/2016 10:13:44 line : 2248
Called from GPEM110PROCESSA(GPEM110.PRX) 15/12/2016 10:13:44 line : 720
Called from {|LEND| GPEM110PROCESSA( .F. , LGPEM110EXECINREMOTE ) , IF( CPAISLOC $ "ANG|PTG", "CONTABILIZAçãO DA FOLHA", "CONTABILIZACAO DA FOLHA" ) }(GPEM110.PRX) 15/12/2016 10:13:44 line : 456
Called from eval line : 116
Called from PROCESSA(MSPROCES.PRW) 15/01/2015 09:53:12 line : 116
Called from GPEM110PROCESSA(GPEM110.PRX) 15/12/2016 10:13:44 line : 456
Called from GPEM110(GPEM110.PRX) 15/12/2016 10:13:44 line : 251
Called from __EXECUTE(APLIB090.PRW) 20/01/2017 10:25:36 line : 581
Called from FWPREEXECUTE(FWPREEXECUTE.PRW) 28/06/2017 16:26:32 line : 82
Called from {|| FWPREEXECUTE('CONTABILIZAçãO', 'GPEM110()', 1, '07', 'XXXXXXXXXX') } line : 183
Called from ::TWINDOW:ACTIVATE
Called from MSAPP:ACTIVATE(FWAPP.PRW) 28/03/2017 18:37:00 line : 635
Called from SIGAADV(APLIB000.PRW) 15/12/2016 16:43:54 line : 55 Solução: Aplicar o pacote de correção: https://suporte.totvs.com/portal/p/10098/download?e=616265 Observação: Caso esteja com o RPO muito desatualizado, além de aplicar o pacote pontual acima, será necessário atualizar também o pacote acumulado da sua versão conforme a faq: PSIGABD0086 - Qual o link direto para pesquisar e baixar o pacote acumulado do Portal do Cliente? Aceitar apenas fontes atualizados. |
