10297161 DLOGTMS02-14180 DT Erro ao transmitir Manifesto Eletrônico

01. DADOS GERAIS

02. SITUAÇÃO/REQUISITO

Erro ocorre com Database Oracle ao realizar a transmissão do MDF-e.

THREAD ERROR ([17568], daiane.aguiar, SRV-RDS-GERAL) 24/11/2020 14:27:18
: Error : 1785 - ORA-01785: ORDER BY item must be the number of a SELECT-list expression
( From tOracleConnection::GetQueryFile )
Thread ID [10156] User [daiane.aguiar] IO [1918] Tables [63] MaxTables [65] Comment [TMSA144D - TCPIP - ThreadID(17568)] SP [ ] Traced [No] SQLReplay [No] InTran [No] DBEnv [ORACLE/PROTHEUS_PRODUCAO] DBThread [(SID 13124,52297,1)] Started [24/11/2020 14:26:19] IP [192.168.0.195:7002] IDLE [ ] InTransact [ ] Memory [0] Running [ROP_QUERY for 0 s.] RCV [52461] SND [207226] TCBuild [20200606-20201110] TCVersion [20.1.1.2] ARCH [64] OS [WINDOWS] BUILD [RELEASE]
SELECT MAX(DTC.DTC_VALOR),DTC.DTC_TIPNFC,DTC.DTC_DEVFRE,DTC.DTC_CODOBS,DTC.DTC_CTRDPC,DTC.DTC_SERDPC,DTC.DTC_TIPANT,DTC.DTC_DPCEMI,DTC.DTC_CTEANT,DTC.DTC_SELORI,DTC.DTC_CLIDES,DTC.DTC_LOJDES,DTC.DTC_CLIREM,DTC.DTC_LOJREM,A1DES.A1_CEP CEPDES,DTC.DTC_SQEDES,A1REM.A1_CEP CEPREM,DTC.DTC_CLIREC,DTC.DTC_LOJREC,A1REC.A1_CEP CEPREC,DTC.DTC_FILORI,DTC.DTC_NUMSOL,DTC.DTC_CLIEXP,DTC.DTC_LOJEXP,A1EXP.A1_CEP CEPEXP,DTC.DTC_FILORI,DTC.DTC_LOTNFC,DV3REM.DV3_INSCR REMDV3_INSCR,DV3DES.DV3_INSCR DESDV3_INSCR,SB1.B1_DESC,SB1.B1_COD,SB1.B1_UM,SB1.B1_POSIPI,SB1.B1_CODBAR,SB1.B1_TIPCAR,DUD.DUD_FILMAN,DUD.DUD_MANIFE,DUD.DUD_NUMROM,DUD.DUD_FILORI,DUD.DUD_VIAGEM,DTC.DTC_FILDOC,DTC.DTC_DOC,DTC.DTC_SERIE,DTC.DTC_SQIREM FROM DUD150 DUD LEFT JOIN DT6150 DT6 ON (DT6.DT6_FILIAL = ' ' AND DT6.DT6_FILDOC = DUD.DUD_FILDOC AND DUD.DUD_DOC = DT6.DT6_DOC AND DUD.DUD_SERIE = DT6.DT6_SERIE AND DT6.D_E_L_E_T_ = ' ') LEFT JOIN DTC150 DTC ON (DTC.DTC_FILIAL = ' ' AND DT6.DT6_FILDOC = DTC.DTC_FILDOC AND DT6.DT6_DOC = DTC.DTC_DOC AND DT6.DT6_SERIE = DTC.DTC_SERIE AND DTC.D_E_L_E_T_ = ' ') INNER JOIN SB1150 SB1 ON (SB1.B1_FILIAL = '01' AND (SB1.B1_COD = DTC.DTC_CODPRO ) AND SB1.D_E_L_E_T_ = ' ') LEFT JOIN DV3150 DV3REM ON (DV3REM.DV3_FILIAL = ' ' AND DV3REM.DV3_CODCLI = DTC.DTC_CLIREM AND DV3REM.DV3_LOJCLI = DTC.DTC_LOJREM AND DV3REM.DV3_SEQUEN = DTC.DTC_SQIREM AND DV3REM.D_E_L_E_T_ = ' ') LEFT JOIN DV3150 DV3DES ON (DV3DES.DV3_FILIAL = ' ' AND DV3DES.DV3_CODCLI = DTC.DT on PRODPRED(TMSXSEFA.PRW) 04/11/2020 16:47:30 line : 1261

03. SOLUÇÃO

Foi realizado o ajuste de queries na função ProdPred() dentro do código fonte TMSXSEFA.PRW. 

04. DEMAIS INFORMAÇÕES

05. ASSUNTOS RELACIONADOS