Passo a passo: | THREAD ERROR : Error : 904 - ORA-00904: "SRA"."RA_MAT": invalid identifier
( From tOracleConnection::GetQueryFile )
Thread ID [14670] User [JAIRO] IO [6487] Tables [29] MaxTables [30] Comment [GPEM120 - TCPIP - ThreadID(22202)] Status [] SP [ ] Traced [No] SQLReplay [No] InTran [No] DBEnv [ORACLE/producao_folha] DBThread [(SID 1526,31199,1)] Started [28/12/2017 11:41:35] LastIO [28/12/2017 11:42:31] IP [172.20.7.214:1233] RCV [95757] SND [15708193] TCBuild [20161016-20170331]
SELECT DISTINCT SRA.R_E_C_N_O_ NRECNO,SRA.RA_FILIAL FILIAL,SRA.RA_PROCES,SRA.RA_TNOTRAB,SRA.RA_SEQTURN,SRA.RA_REGRA,SRA.RA_MAT FROM SRA010 SRA INNER JOIN RCH010 RCH ON ' ' = ' ' WHERE SRA.RA_PROCES = '00001' AND (SRA.RA_DEMISSA = ' ' OR SRA.RA_DEMISSA >= '20171201' ) AND SRA.D_E_L_E_T_= ' ' AND RCH.RCH_FILIAL = ' ' AND RCH.D_E_L_E_T_= ' ' UNION SELECT DISTINCT SRA.R_E_C_N_O_ NRECNO,SRA.RA_FILIAL FILIAL,SRA.RA_PROCES,SRA.RA_TNOTRAB,SRA.RA_SEQTURN,SRA.RA_REGRA,SRA.RA_MAT FROM SRA010 SRA INNER JOIN RCH010 RCH ON ' ' = ' ' INNER JOIN SRG010 SRG ON SRG.RG_FILIAL = SRA.RA_FILIAL AND SRG.RG_MAT = SRA.RA_MAT AND SRG.RG_DTGERAR >= '20171201' AND SRG.D_E_L_E_T_= ' ' WHERE SRA.RA_PROCES = '00001' AND SRA.D_E_L_E_T_= ' ' AND RCH.RCH_FILIAL = ' ' AND RCH.D_E_L_E_T_= ' ' AND SRA.RA_DEMISSA < '20171201' ORDER BY SRA.RA_FILIAL, SRA.RA_PROCES, SRA.RA_TNOTRAB, SRA.RA_SEQTURN, SRA.RA_REGRA, SRA.RA_MAT on __EXECSQL(APLIB300.PRW) 05/10/2017 18:39:40 line : 126 [TOTVS build: 7.00.131227A-20171123 NG] Called from __EXECSQL(APLIB300.PRW) 05/10/2017 18:39:40 line : 126
Called from FSRATHREAD(GPEM120.PRX) 16/12/2017 16:24:22 line : 8390
Called from GPM120PROCESSA(GPEM120.PRX) 16/12/2017 16:24:22 line : 617
Called from { || GPM120Processa(aRoteiros) }(GPEM120.PRX) 16/12/2017 16:24:22 line : 617
Called from { || Eval( bAction ) , lEnd := .T. , RestKeys( aSvKeys , .T. ) , oDlg2BarGauge:End() }(GPPROCES.PRW) 02/06/2014 09:13:47 line : 617
Called from ::MSDIALOG:ACTIVATE line : 617
Called from PROC2BARGAUGE(GPPROCES.PRW) 02/06/2014 09:13:47 line : 380
Called from GPM120INIMARK(GPEM120.PRX) 16/12/2017 16:24:22 line : 10283
Called from FWMBROWSE:EXECUTE(FWFORMBROWSE.PRW) 05/10/2017 18:39:41 line : 1077
Called from { || OSELF:EXECUTE("GPM120INIMARK", 2, 0,"CONFIRMAR", 1,"()","","", 1) }(FWFORMBROWSE.PRW) 05/10/2017 18:39:41 line : 1077
Called from ::MSDIALOG:ACTIVATE line : 1077
Called from GPEM120(GPEM120.PRX) 16/12/2017 16:24:22 line : 331
Called from __EXECUTE(APLIB090.PRW) 05/10/2017 18:39:40 line : 602
Called from FWPREEXECUTE(FWPREEXECUTE.PRW) 05/10/2017 18:39:41 line : 82
Called from {|| FWPreExecute('Período', 'GPEM120()', 1, '07', 'xxxxxxxxxx') }(FWUIMENUL.PRW) 05/10/2017 18:39:41 line : 82
Called from ::TWINDOW:ACTIVATE line : 82
Called from MSAPP:ACTIVATE(FWAPP.PRW) 05/10/2017 18:39:41 line : 678
Called from SIGAGPE(APLIB000.PRW) 05/10/2017 18:39:40 line : 157
Called from STATICCALL(APLIB000.PRW) 05/10/2017 18:39:40 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.16: https://suporte.totvs.com/portal/p/10098/download?e=654165 ; 12.1.17: https://suporte.totvs.com/portal/p/10098/download?e=654168 ; 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. |
