Árvore de páginas
Ir para o final dos metadados
Ir para o início dos metadados

Produto:

Protheus.

Ocorrência:

 PSIGAERRO0260 - GPER390 - THREAD ERROR : Error : 7 (42883) (RC=-1) - ERROR: operator does not exist: character <> integer __EXECSQL(APLIB300.PRW) 15/09/2017 11:35:59 line : 124

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.

Observações: