Passo a passo: | Errorlog na rotina GPEM610: THREAD ERROR ([5592], marcos, MICRO-08) 05/09/2017 11:24:07
: Error : 102 (37000) (RC=-1) - [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near ')'. ( From tMSSQLConnection::GetQueryFile )
Thread ID [2936] User [marcos] IO [2864] Tables [28] MaxTables [29] Comment [GPEM610 - TCPIP - ThreadID(5592)] Status [] SP [ ] Traced [No] SQLReplay [No] InTran [No] DBEnv [MSSQL/PRODUCAO] DBThread [(SPID 57,68)] Started [05/09/2017 11:12:13] LastIO [05/09/2017 11:24:07] IP [10.10.10.2:1234] RCV [322563] SND [686806] TCBuild [20170202-20170724]
SELECT 'SRC' ORIGEM,RC_FILIAL RC_FILIAL,RC_MAT RC_MAT,RC_VALOR RC_VALOR,RC_PD RC_PD,RC_CC RC_CC,RC_DATA RC_DATA,RC_HORAS RC_HORAS,RC_ROTEIR RC_ROTEIR,RA_FILIAL,RA_MAT,RA_CC FROM SRC030 RC , SRA030 RA WHERE RC_FILIAL>= '01' AND RC_FILIAL<= '01' AND RC_MAT>= ' ' AND RC_MAT <= '999999' AND RC_ROTEIR IN () AND RC_PERIODO = '201708' AND RC.D_E_L_E_T_ = ' ' AND RA_FILIAL = RC_FILIAL AND RA_MAT = RC_MAT AND RA.D_E_L_E_T_ = ' ' UNION ALL SELECT 'SRD' ORIGEM,RD_FILIAL,RD_MAT,RD_VALOR,RD_PD,RD_CC,RD_DATPGT,RD_HORAS,RD_ROTEIR,RA_FILIAL,RA_MAT,RA_CC FROM SRD030 RD , SRA030 RA WHERE RD_FILIAL>= '01' AND RD_FILIAL<= '01' AND RD_MAT>= ' ' AND RD_MAT <= '999999' AND RD_ROTEIR IN () AND RD_PERIODO = '201708' AND RD.D_E_L_E_T_ = ' ' AND RA_FILIAL = RD_FILIAL AND RA_MAT = RD_MAT AND RA.D_E_L_E_T_ = ' ' ORDER BY RA_FILIAL,RA_CC,RA_MAT,RC_PD on MONTAARQTRAB(GPEM610.PRX) 07/07/2017 15:25:47 line : 6294 [TOTVS build: 7.00.131227A-20170830 NG]
Called from MONTAARQTRAB(GPEM610.PRX) 07/07/2017 15:25:47 line : 6294
Called from GPM610PROCESSA(GPEM610.PRX) 07/07/2017 15:25:47 line : 584
Called from {|lEnd| GPM610Processa()}(GPEM610.PRX) 07/07/2017 15:25:47 line : 584
Called from { || Eval( bAction, @lEnd ),lEnd := .t. , oDlg:End() }(GPPROCES.PRW) 02/06/2014 09:13:47 line : 584
Called from ::MSDIALOG:ACTIVATE line : 584
Called from PROCGPE(GPPROCES.PRW) 02/06/2014 09:13:47 line : 113
Called from GPEM610(GPEM610.PRX) 07/07/2017 15:25:47 line : 261
Called from __EXECUTE(APLIB090.PRW) 11/08/2017 19:00:10 line : 602
Called from FWPREEXECUTE(FWPREEXECUTE.PRW) 11/08/2017 19:00:12 line : 82
Called from {|| FWPreExecute('Geração Sefip', 'GPEM610()', 1, '07', 'xxxxxxxxxx') }(FWUIMENUL.PRW) 11/08/2017 19:00:12 line : 82
Called from ::TWINDOW:ACTIVATE line : 82
Called from MSAPP:ACTIVATE(FWAPP.PRW) 11/08/2017 19:00:12 line : 674
Called from SIGAADV(APLIB000.PRW) 11/08/2017 19:00:10 line : 58
Called from STATICCALL(APLIB000.PRW) 11/08/2017 19:00:10 line : 58 [TOTVS Environment: nutrihouse]
[TOTVS Environment RPODB: top]
[TOTVS Environment Trace: 0]
[TOTVS Environment IBXLog: None]
[TOTVS Environment KillStack: None]
[TOTVS Environment TraceStack: None]
[TOTVS Environment SpecialKey: None]
[TOTVS Environment LocalFiles: CTREE]
[TOTVS Environment LogProfiler: None]
[TOTVS Environment TopMemoMega: 1]
[TOTVS Environment RPOLanguage: Portuguese]
[TOTVS Environment RegionalLanguage: None]
[TOTVS Environment LocalDBExtension: .dtc]
[TOTVS Environment ConnectionTimeOut: None]
[TOTVS Environment General CTreeMode: None]
[TOTVS Environment General ConsoleLog: None]
[TOTVS Environment General ConsoleFile: None]
[TOTVS Environment General MaxQuerySize: None]
[TOTVS Environment General MaxStringSize: 10]
[TOTVS Remote Type: Microsoft Windows]
[TOTVS Remote Build: 7.00.131227A-20170719]
[TOTVS Server Type: Console]
[TOTVS Server Build: 7.00.131227A-20170830 NG]
[TOTVS Server Unix: No]
[TOTVS DBAccess DB: MSSQL]
[TOTVS DBAccess API Build: 20170202-20170626]
[TOTVS DBAccess Build: 20170202]
[TOTVS DBAccess Type: WinNT (x64)]
[TOTVS Framework Version: 20170710]
[TOTVS Framework Date: 20170810-145314]
[TOTVS Framework Commit: 8a32336f94bd55aa562b7a289c5c31f3e215dd0f]
[TOTVS RPO Release: 12.1.017] SOLUÇÃO: A Release Oficial foi expedida e publicada na Central de Downloads.
O pacote pode ser acessado no endereço: 12.1.7: https://goo.gl/ZzgM3S
12.1.14: https://goo.gl/eRDWMG
12.1.16: https://goo.gl/QjYNFx
12.1.17: https://goo.gl/bqD4CR 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. |
