Árvore de páginas

Error log em ambiente Informix

Linha de Produto:

Microsiga Protheus

Segmento:

Recursos Humanos

Módulo:

SIGAGPE

Função:

GPEXC131

Situação/Requisito:

Error.log ao calcular a folha com complemento de 13º salário em ambiente informix:

THREAD ERROR ([4144], Vitor_Alonso, DESKTOP-19G1EEI) 07/02/2018 08:16:47 : Error : -201 (37000) (RC=-1) - [Informix][Informix ODBC Driver][Informix]A syntax error has occurred. ( From tInformixConnection::GetQueryFile ) Thread ID [300] User [Administrador] IO [11437] Tables [51] MaxTables [52] Comment [GPEM020 - TCPIP - ThreadID(4144)]Status [] SP [ ] Traced [No] SQLReplay [No] InTran [No] DBEnv [INFORMIX/protheus12] DBThread [(SID 321 86)] Started [07/02/2018 08:14:11] LastIO [07/02/2018 08:16:47] IP [192.168.1.112:1236] RCV [550460] SND [3525063] TCBuild [20170202-20170904] SELECT COUNT(1) AS CONTADOR FROM SRD010 SRD WHERE SRD.RD_FILIAL = '01' AND SRD.RD_MAT = '000112' AND SRD.RD_ROTEIR = '132' AND SRD.RD_PERIODO BETWEEN '201701' AND '201712' AND SRD.D_E_L_E_T_= ' ' on _EXECSQL(APLIB300.P RW) 03/01/2018 17:40:20 line : 126 [TOTVS build: 7.00.131227A-20171213 NG] Called from __EXECSQL(APLIB300.PRW) 03/01/2018 17:40:20 line : 126 Called from FTEM132(GPEXC131.PRX) 23/01/2018 09:51:23 line : 1058 Called from FMEDIA13(GPEXC131.PRX) 23/01/2018 09:51:23 line : 321 Called from S_MEDIA13(S_MEDIA13.PRG) 00/00/0000 00:00:00 line : 34 Called from S_ROT132(S_ROT_132.PRG) 00/00/0000 00:00:00 line : 159 Called from

{ ||&cFunRotExec }(GPEXFORM.PRX) 09/11/2017 15:59:05 line : 159 Called from CHECKEXECFORM(GPEXFORM.PRX) 09/11/2017 15:59:05 line : 3256 Called from EXECROT(GPEXFORM.PRX) 09/11/2017 15:59:05 line : 3906 Called from FCOMPL13(GPEXUSUA.PRX) 12/01/2018 16:00:10 line : 1539 Called from GRAVACALC(GPEXINI.PRX) 24/01/2018 18:15:56 line : 2974 Called from S_LGRAVA(S_LGRAVA.PRG) 00/00/0000 00:00:00 line : 9 Called from S_ROT_FOL(S_ROT_FOL.PRG) 00/00/0000 00:00:00 line : 579 Called from { ||&cFunRotExec }

Solução/Implementação:

Ajuste na query para que não ocorra erro com SGBD Informix

Tickets relacionados:

2230194

Pacote:12.1.17: https://suporte.totvs.com/portal/p/10098/download?e=674933