Linha de Produto:

Microsiga Protheus

Módulo:

SIGAGPE

Situação/Requisito:

Em ambientes oracle, quando o processo possuí caracteres diferentes de numéricos, ocorre error.log durante a execução do cálculo.

THREAD ERROR ([9428], notebook, SPON020100095) 09/08/2018 09:07:16

: Error : 904 - ORA-00904: "W0002": invalid identifier
( From tOracleConnection::GetQueryFile )
Thread ID [10141] User [Administrador] IO [3146] Tables [34] MaxTables [35] Comment [GPEM690 - TCPIP - ThreadID(9428)] SP [ ] Traced [No] SQLReplay [No] InTran [No] DBEnv [ORACLE/PRIME17] DBThread [(SID 303,17045,1)] Started [09/08/2018 09:11:15] IP [10.172.123.199:1245] IDLE [ ] InTransact [ ] Memory [1126880] Running [ROP_QUERY] RCV [322796] SND [937899] TCBuild [20171117-20180412]
SELECT RHH_FILIAL,RHH_DATA,RHH_MAT,RHH_MESANO,RHH_VB,RHH_CC,RHH_ITEM,RHH_CLVL FROM RHHT10 RHH WHERE RHH.RHH_DATA BETWEEN '201806' AND '201807' AND RHH_PROCES = W0002 AND RHH.D_E_L_E_T_ = ' ' ORDER BY RHH_FILIAL, RHH_DATA, RHH_MAT, RHH_MESANO, RHH_VB, RHH_CC, RHH_ITEM, RHH_CLVL on GP690CAL(GPEM690.PRX) 06/06/2018 16:41:26 line : 499