DRHGFP-2795 - Sistêmico - Cálculo de Dissídio Retroativo

Tempo aproximado para leitura: 00 min

01. DADOS GERAIS

02. SITUAÇÃO/REQUISITO

Ao efetuar o cálculo do dissídio retroativo, GPEM691, após o reajuste por tabela, o sistema exibiu error.log:

                     THREAD ERROR ([3506], manoela.gonzaga, SPON010113628) 21/01/2019 15:45:17
: Error : 1 (42P10) (RC=-1) - ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list;
Error while executing the query
( From tPostgresConnection::GetQueryFile )
Thread ID [16114] User [MANOELA.GONZAGA] IO [8792] Tables [35] MaxTables [35] Comment [GPEM691 - TCPIP - ThreadID(3506)] SP [ ] Traced [No] SQLReplay [No] InTran [No] DBEnv [POSTGRES/BRTS1217PV2] DBThread [(ID 16206)] Started [21/01/2019 16:33:06] IP [10.171.67.120:60609] IDLE [ ] InTransact [ ] Memory [1788432] Running [ROP_QUERY] RCV [354163] SND [3328482] TCBuild [20181212-20190117] TCVersion [18.2.1.0_RC2] ARCH [64] OS [LINUX] BUILD [RELEASE] 
SELECT DISTINCT RCH_FILIAL,RCH_PER,RA_PROCES,RCH_DTFECH,RA_FILIAL FROM RCHT10 RCH INNER JOIN SRAT10 SRA ON RCH_PROCES = RA_PROCES AND SUBSTR(SRA.RA_FILIAL , 1 , 4)::bpchar = SUBSTR(RCH.RCH_FILIAL , 1 , 4)::bpchar WHERE RCH_PROCES = '50000' AND RCH_PER = '201802' AND RCH_NUMPAG = '01' AND RCH_ROTEIR = 'FPB' AND RCH.D_E_L_E_T= ' ' AND SRA.D_E_L_E_T_= ' ' ORDER BY RCH.RCH_FILIAL, RCH.RCH_PER, SRA.RA_PROCES on _EXECSQL(APLIB300.PRW) 18/01/2019 16:26:58 line : 134

[TOTVS build: 7.00.170117A-20190118]
Called from FGP691PER(GPEM691.PRX) 07/01/2019 11:17:23 line : 4074

03. SOLUÇÃO