Passo a passo: | Errorlog na rotina GPER390: THREAD ERROR : Error : 7 (42883) (RC=-1) - ERROR: operator does not exist: character <> integer; Error while executing the query ( From tPostgresConnection::GetQueryFile ) Thread ID [1436] User [Administrador] IO [8918] Tables [21] MaxTables [23] Comment [GPER390 - TCPIP - ThreadID(4176)] Status [] SP [ ] Traced [No] SQLReplay [No] InTran [No] DBEnv [POSTGRES/IPRH91] DBThread [(ID 2260)] Started [19/09/2017 14:50:20] LastIO [19/09/2017 14:51:06] IP [10.172.22.104:4323] RCV [80131] SND [700049] TCBuild [20161016-20170331] SELECT SRA.RA_FILIAL,SRA.RA_CC,SRA.RA_MAT,SRA.RA_NOME,SRF.RF_FILIAL,SRF.RF_MAT,SRA.RA_SITFOLH,SRA.RA_CATFUNC,SRA.RA_ADMISSA,SRF.RF_DATABAS,SRF.RF_DFALVAT, SRF.RF_DFERANT,SRF.RF_IVENPEN,SRF.RF_DVENPEN FROM SRA010 SRA LEFT JOIN SRF010T SRF ON SRA.RA_FILIAL = SRF.RF_FILIAL AND SRA.RA_MAT = SRF.RF_MAT WHERE 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 SRA.D_E_L_E_T_= ' ' AND SRF.RF_STATUS <> 3 AND SRF.D_E_L_E_T_= ' ' ORDER BY RA_FILIAL,RA_MAT on __EXECSQL(APLIB300.PRW) 15/09/2017 11:35:59 line : 124 [TOTVS build: 7.00.131227A-20170904 NG] Called from __EXECSQL(APLIB300.PRW) 15/09/2017 11:35:59 line : 124 Called from TRSECTION:EXECSQL(REPORT02.PRW) 15/09/2017 11:36:00 line : 2549 Called from TRSECTION:SETQUERY(REPORT02.PRW) 15/09/2017 11:36:00 line : 1740 Called from TRSECTION:ENDQUERY(REPORT02.PRW) 15/09/2017 11:36:00 line : 2318 Called from R390IMP(GPER390.PRX) 03/05/2017 11:19:24 line : 185 Called from {|oReport|R390Imp(oReport)}(GPER390.PRX) 03/05/2017 11:19:24 line : 185 Called from {|| Iif(Self:Init(),(lAction := Eval(Self:bAction,Self),Self:Finish()),lOk:= .F. ),lEnd := .T. ,oDlg:End()}(REPORT01.PRW) 15/09/2017 11:36:00 line : 185 Called from ::MSDIALOG:ACTIVATE line : 185 Called from TREPORT:PRINT(REPORT01.PRW) 15/09/2017 11:36:00 line : 1957 Called from TREPORT:PRINTDIALOG(REPORT01.PRW) 15/09/2017 11:36:00 line : 3118 Called from GPER390(GPER390.PRX) 03/05/2017 11:19:24 line : 46 Called from __EXECUTE(APLIB090.PRW) 15/09/2017 11:35:59 line : 602 Called from FWPREEXECUTE(FWPREEXECUTE.PRW) 15/09/2017 11:36:02 line : 82 Called from { || FWPreExecute('Férias Vencidas No Mês', 'GPER390()', 1, '07', 'xxxxxxxxxx') }(FWUISEARCH.PRW) 15/09/2017 11:35:59 line : 82 Called from FWUISEARCH:SHOWWAIT(FWUISEARCH.PRW) 15/09/2017 11:35:59 line : 230 Called from FWUISEARCH:SEARCH(FWUISEARCH.PRW) 15/09/2017 11:35:59 line : 112 Called from {|cGet| __oSearch:Search(cGet) }(FWUISKINSTAND.PRW) 15/09/2017 11:36:02 line : 112 Called from {|| Eval(oSkin:bFinder,cGet), .T. }(FWUISKINSTAND.PRW) 15/09/2017 11:36:02 line : 112 Called from ::TWINDOW:ACTIVATE line : 112 Called from MSAPP:ACTIVATE(FWAPP.PRW) 15/09/2017 11:36:02 line : 678 Called from SIGAGPE(APLIB000.PRW) 15/09/2017 11:35:59 line : 157 Solução: A Release Oficial foi expedida e publicada na Central de Downloads. O pacote pode ser acessado no endereço: 12.1.14: https://suporte.totvs.com/portal/p/10098/download?e=634194 ; 12.1.16: https://suporte.totvs.com/portal/p/10098/download?e=634198 ; 12.1.17: https://suporte.totvs.com/portal/p/10098/download?e=634199 ; 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. |