Passo a passo: | Error log na rotina GPEM110 ou GPER040:
THREAD ERROR : Error : 1033 (37000) (RC=-1) - [Microsoft][SQL Server Native Client 10.0][SQL Server]The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified. ( From tMSSQLConnection::GetQueryFile )
Thread ID [26792] User [BDO.CONTABIL]
IO [1758] Tables [33]
MaxTables [34] Comment [GPEM110 - TCPIP - ThreadID(37192)]
Status [] SP [ ]
Traced [No] SQLReplay [No]
InTran [No] DBEnv [MSSQL/RDQC27_TESTE]
DBThread [(SPID 111,112)] Started [13/09/2017 17:09:20]
LastIO [13/09/2017 17:18:30] IP [192.168.4.135:4032]
RCV [179782] SND [218146]
TCBuild [20161016-20170530]
SELECT RZ_FILIAL, RZ_MAT, RZ_CC, RZ_PD, SUM(RZ_HRS) AS RZ_HRS, SUM(RZ_VAL) AS RZ_VAL, SUM(RZ_OCORREN) AS RZ_OCORREN, RZ_TIPO, RZ_TPC FROM ( SELECT RC_FILIAL as RZ_FILIAL, RC_MAT as RZ_MAT, RC_CC as RZ_CC, RC_PD as RZ_PD, SUM( RC_HORAS) as RZ_HRS, SUM( RC_VALOR) as RZ_VAL, COUNT( RC_PD ) RZ_OCORREN, CASE RC_ROTEIR WHEN '132' then '13' ELSE 'FL' END AS RZ_TIPO , '1' as RZ_TPC, 'SRC' as Tabela, RC_ROTEIR as RZ_ROTEIR FROM SRC010, SRA010 WHERE RC_FILIAL >= ' ' AND RC_FILIAL <= 'zz' AND RC_PERIODO IN ( '201708' ) AND RC_SEMANA IN ( '01' ) AND RC_ROTEIR IN ( '132','AUT','FOL','PLR' ) AND SRA010.D_E_L_E_T_ = ' ' AND SRC010.D_E_L_E_T_ = ' ' AND RC_FILIAL = RA_FILIAL AND RC_MAT = RA_MAT AND RA_TPCONTR IN (' ','*','1') GROUP BY RC_FILIAL, RC_MAT,RC_CC, RC_PD, RC_ROTEIR ORDER BY RC_FILIAL, RC_MAT,RC_CC, RC_PD ) A GROUP BY A.RZ_FILIAL, A.RZ_MAT, A.RZ_CC, A.RZ_PD, A.RZ_TIPO,A.RZ_TPC on MSOPENDBF(APLIB070.PRW) 06/07/2017 10:53:43 line : 58
SOLUÇÃO: A Release Oficial foi expedida e publicada na Central de Downloads.
O pacote pode ser acessado no endereço: 12.1.17: https://suporte.totvs.com/portal/p/10098/download?e=617781 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. |
