Ao processar o GPEM020 - Processamento por Roteiros, e informar esse filtro: SRA->RA_FILIAL $ ("01").AND.(SRA->RA_MAT <= "000001") e gerado error log: THREAD ERROR
: Error : 102 (37000) (RC=-1) - [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near ')'. ( From tMSSQLConnection::GetQueryFile )
Thread ID [2572] User [Administrador] IO [10910] Tables [29] MaxTables [29] Comment [GPEM020 - TCPIP - ThreadID(448)] Status [] SP [ ] Traced [No] SQLReplay [No] InTran [No] DBEnv [MSSQL/P12_17] DBThread [(SPID 51,52)] Started [13/10/2017 14:01:58] LastIO [13/10/2017 14:03:22] IP [127.0.0.1:4330] RCV [379505] SND [1292085] TCBuild [20170202-20171004]
SELECT * FROM RCH990 RCH INNER JOIN SRY990 SRY ON RCH.RCH_ROTEIR = SRY.RY_CALCULO AND RCH.RCH_FILIAL = SRY.RY_FILIAL INNER JOIN SRA990 SRA ON ' ' =' ' AND RA_PROCES = '00001' AND SRA.RA_FILIAL IN ('01')) AND (SRA.RA_MAT <= '000001') WHERE RCH_PROCES = '00001' AND RCH_PER = '201701' AND RCH_DTINTE = ' ' AND RY_INTEGRA = '1' AND RCH.D_E_L_E_T_ <> '*' AND SRY.D_E_L_E_T_ <> '*' on FCHKINTEG(GPEM020.PRX) 28/08/2017 14:03:22 line : 3617 [TOTVS build: 7.00.131227A-20171002 NG]
Called from FCHKINTEG(GPEM020.PRX) 28/08/2017 14:03:22 line : 3617
Called from GPEM020PROCESSA(GPEM020.PRX) 28/08/2017 14:03:22 line : 658
Called from { || Gpem020Processa( cExpFiltro , cTabMestra , cRoteiro , , cFterAux ) }(GPEM020.PRX) 28/08/2017 14:03:22 line : 658
Called from { || Eval( bAction ) , lEnd := .T. , RestKeys( aSvKeys , .T. ) , oDlg2BarGauge:End() }(GPPROCES.PRW) 02/06/2014 09:13:47 line : 658
Called from ::MSDIALOG:ACTIVATE line : 658
Called from PROC2BARGAUGE(GPPROCES.PRW) 02/06/2014 09:13:47 line : 380
Called from GPEM020(GPEM020.PRX) 28/08/2017 14:03:22 line : 350
Called from __EXECUTE(APLIB090.PRW) 05/10/2017 18:39:40 line : 602
Called from FWPREEXECUTE(FWPREEXECUTE.PRW) 05/10/2017 18:39:41 line : 82
Called from {|| FWPreExecute('Por Roteiros', 'GPEM020()', 1, '07', 'xxxxxxxxxx') }(FWUIMENUL.PRW) 05/10/2017 18:39:41 line : 82
Called from ::TWINDOW:ACTIVATE line : 82
Called from MSAPP:ACTIVATE(FWAPP.PRW) 05/10/2017 18:39:41 line : 678
Called from SIGAADV(APLIB000.PRW) 05/10/2017 18:39:40 line : 58
Called from STATICCALL(APLIB000.PRW) 05/10/2017 18:39:40 line : 58 Solução: A Release Oficial foi expedida e publicada na Central de Downloads.
O pacote pode ser acessado no endereço: 12.1.16: https://suporte.totvs.com/portal/p/10098/download?e=641063 ; 12.1.17: https://suporte.totvs.com/portal/p/10098/download?e=641066 ; 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 base de conhecimento: PSIGABD0086 - Qual o link direto para pesquisar e baixar o pacote acumulado do Portal do Cliente? Aceitar apenas fontes atualizados. | 