Ocorrência
TAF - ESOCIAL - THREAD ERROR An ON clause associated with a JOIN operator or in a MERGE statement is not valid FOR READ ONLY on FILLTEMP TAFMONDET.PRW 17/01/2018 16:56:09 line : 1002
Causa
THREAD ERROR ([2288], kassio.rosa, SPOD2767) 05/02/2018 11:59:25
: Error : -338 (42972) (RC=-1) - [IBM][CLI Driver][DB2/NT64] SQL0338N An ON clause associated with a JOIN operator or in a MERGE statement is not valid. SQLSTATE=42972
( From tDB2Connection::GetQueryFile )
Thread ID [4076] User [Administrador] IO [7542] Tables [14] MaxTables [14] Comment [TAFMONTES - TCPIP - ThreadID(2288)] SP [ ] Traced [No] SQLReplay [No] InTran [No] DBEnv [DB2/SLATST97] DBThread [(DB2ID *LOCAL.DB2.180205135754)] Started [05/02/2018 11:57:54] IP [10.172.123.168:4532] IDLE [ ] InTransact [ ] Memory [415256] Running [ROP_QUERY] RCV [97250] SND [584529] TCBuild [20171117-20171205]
SELECT DISTINCT 'S-1000' EVENTO,C1E.C1E_FILIAL FILIAL,C1E.C1E_STATUS XSTATUS,TAFKEY TAFKEY,C1E.C1E_ID ID,C1E.C1E_CODFIL CODIGO,C1E.C1E_FILTAF DESCR,C1E.C1E_DTINI INIVALD,C1E.C1E_DTFIN FINVALID,' ' INDAPU,' ' PERAPU,' ' MENSG,' ' XMLERRO,' ' DATALI,' ' REGRA,C1E.C1E_PROTUL RECIBO,C1E.C1E_VERSAO VERSAO,C1E.R_E_C_N_O_ RECNO,'TAF050Xml' FUNCAO,'C1E' ALIAS,'S-1000' LAYOUT,'evtInfoEmpregador' CREGNODE,'C1E' TABELA FROM C1E990 C1E LEFT JOIN TAFXERP TAFXERP ON TAFXERP.TAFALIAS = 'C1E' AND TAFXERP.TAFRECNO = C1E.R_E_C_N_O_ AND TAFXERP.TAFKEY = (SELECT B.TAFKEY TAFKEY FROM TAFXERP B WHERE B.TAFALIAS = TAFXERP.TAFALIAS AND B.TAFRECNO = TAFXERP.TAFRECNO AND B.D_E_L_E_T_ = ' ' AND TAFXERP.D_E_L_E_T_ = ' ' ORDER BY B.R_E_C_N_O_ DESC FETCH FIRST 1 ROWS ONLY ) WHERE C1E.C1E_STATUS IN (' ','0','1','2','3','4') AND C1E.D_E_L_E_T_ <> '*' AND C1E.C1E_ATIVO = '1' AND C1E_MATRIZ = 'T' AND C1E.C1E_FILTAF IN ('01' ) FOR READ ONLY on FILLTEMP(TAFMONDET.PRW) 17/01/2018 16:56:09 line : 1002
Ambiente
Protheus - Gestão de Pessoal - A partir da versão 12.1.17.
Solução
A correção do erro será liberada na Issue DSERTAF2-2712.
Para recebê-la quando da liberação, gentileza registrar um ticket à equipe de Suporte Técnico RH Protheus.
0 Comentários