Ocorrência
Ao efetuar alteração em qualquer tabela de Manutenção de Tabela gera error log: "Error : 905 - ORA-00905: missing keyword ( From tOracleConnection::GetQueryFile )
Thread ID [7112] User [tmoraes] IO [7815] Tables [57] MaxTables [58] Comment [GPEA320 - TCPIP - ThreadID(4400)] SP [ ] Traced [No] SQLReplay [No] InTran [Yes] DBEnv [ORACLE/TOTVS] DBThread [(SID 382,10031,1)] Started [03/07/2020 13:04:42] IP [10.53.8.20:10001] IDLE [ ] InTransact [1 s.] Memory [0] Running [ROP_QUERY for 0 s.] RCV [187506] SND [1726820] TCBuild [20191119-20200217] TCVersion [19.2.1.0] ARCH [64] OS [WINDOWS] BUILD [RELEASE]
SELECT CTT_FILIAL,CTT_TIPO2,CTT_CEI2,CTT_FPAS,CTT_CODTER,CTT_CNAE,CTT_PERRAT,CTT_FAP,CTT_PERCAC,CTT_CUSTO,CTT_TPLOT,CTT_ICTPAT,CTT_CLASSE,COALESCE(RJL_TPPROC,' ') AS RJL_TPPROC,COALESCE(RJL_NRPROC,' ') AS RJL_NRPROC,COALESCE(RJL_CSUSP,' ') AS RJL_CSUSP,COALESCE(RJL_TP,' ') AS RJL_TP FROM CTT080 CTT LEFT JOIN (SELECT RJL_FIL,RJL_CC,RJL_TPPROC,RJL_NRPROC,RJL_CSUSP,RJL_TP,D_E_L_E_T_ FROM RJLT20 RJL INNER JOIN(SELECT RJL_CC AS CC,MAX(RJL_COMPET) AS RJL_COMPET FROM RJLT20 WHERE RJL_COMPET <= '202007' GROUP BY RJL_CC) AS RECENTES ON RJL.RJL_CC = RECENTES.CC AND RJL.RJL_COMPET = RECENTES.RJL_COMPET ) AS RJL ON CTT.CTT_FILIAL = RJL.RJL_FIL AND CTT_CUSTO = RJL.RJL_CC AND RJL.D_E_L_E_T_ <> '*' WHERE CTT.D_E_L_E_T_= ' ' AND (CTT_FILIAL IN (' ')) AND (CTT_PERCAC = 0 AND CTT_PERRAT = 0) ORDER BY CTT.CTT_FILIAL, CTT.CTT_CUSTO on __EXECSQL(APLIB300.PRW)"
Ambiente
TOTVS RH - TOTVS RH (Linha Protheus) - Gestão de Pessoal - a partir da release 12.1.17
Causa
O erro ocorre devido a fontes desatualizados.
Solução
Para correção do problema é necessário aplicar o pacote de Expedição Contínua de RH. Para baixá-lo, clique aqui
0 Comentários