Scribd Logo
Upload

Welcome to Scribd!

  • 157 views

    Errolog Financeiro

    Uploaded by

    Jefferson Douglas
    The document is a log from a TOTVS system describing an error that occurred during a SQL query. The error indicates a syntax error near a comma in the SQL. The log provides details on the query, thread, user, called routines, and system environment details to help diagnose the issue.

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd

    Errolog Financeiro

    Uploaded by

    Jefferson Douglas
    157 views4 pages
    The document is a log from a TOTVS system describing an error that occurred during a SQL query. The error indicates a syntax error near a comma in the SQL. The log provides details on the query, thread, user, called routines, and system environment details to help diagnose the issue.

    Original Description:

    sdfa

    Original Title

    ERROLOG_FINANCEIRO

    Copyright

    © © All Rights Reserved

    Available Formats

    TXT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document is a log from a TOTVS system describing an error that occurred during a SQL query. The error indicates a syntax error near a comma in the SQL. The log provides details on the query, thread, user, called routines, and system environment details to help diagnose the issue.

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    157 views4 pages

    Errolog Financeiro

    Uploaded by

    Jefferson Douglas
    The document is a log from a TOTVS system describing an error that occurred during a SQL query. The error indicates a syntax error near a comma in the SQL. The log provides details on the query, thread, user, called routines, and system environment details to help diagnose the issue.

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    of 4

    THREAD ERROR ([5440], gergilei, SUP_FINANCEIRO) 10/02/2020 17:41:14

    : Error : 102 (37000) (RC=-1) - [Microsoft][SQL Server Native Client 11.0][SQL


    Server]Sintaxe incorreta próxima a ','.

    ( From tMSSQLConnection::GetQueryFile )

    Thread ID [16032] User [Gergilei] IO [7761] Tables [83] MaxTables [84] Comment
    [FINA740 - TCPIP - ThreadID(5440)] SP [ ] Traced [No] SQLReplay [No] InTran [Yes]
    DBEnv [MSSQL/TOTVS_P12] DBThread [(SPID 54,62)] Started [10/02/2020 17:16:26] IP
    [192.168.1.17:1239] IDLE [ ] InTransact [2 s.] Memory [918224] Running [ROP_QUERY]
    RCV [270391] SND [5070898] TCBuild [20181212-20190924] TCVersion [18.2.1.3] ARCH
    [64] OS [WINDOWS] BUILD [RELEASE]

    SELECT
    E5_FILIAL,E5_MOTBX,E5_DOCUMEN,E5_CLIFOR,E5_LOJA,E5_PREFIXO,E5_NUMERO,E5_PARCELA,E5_
    TIPO,E5_SITUACA,E5_DATA,E5_VALOR,E5_SEQ,E5_FATPREF,E5_FATURA,E1_NUMLIQ,E1_BCOCHQ,E1
    _FATURA,SE1.R_E_C_N_O_ RECSE1,E1_VLCRUZ,E1_FATPREF,E1_FATURA,E1_STATUS FROM SE5010
    SE5 INNER JOIN SE1010 SE1 ON SE1.E1_CLIENTE = SE5.E5_CLIFOR AND SE1.E1_LOJA =
    SE5.E5_LOJA AND SE1.E1_PREFIXO = SE5.E5_PREFIXO AND SE1.E1_NUM = SE5.E5_NUMERO AND
    SE1.E1_PARCELA = SE5.E5_PARCELA AND SE1.E1_TIPO = SE5.E5_TIPO AND SE1.D_E_L_E_T_ =
    ' ' WHERE SE5.E5_FILIAL = '0102' AND SE1.E1_FILIAL IN (,'0102','0102' ) AND
    SE5.E5_DOCUMEN = '005450' AND SE5.E5_MOTBX = 'LIQ' AND SE5.E5_SITUACA <> 'C' AND
    SE5.D_E_L_E_T_ = ' ' AND SE1.D_E_L_E_T_ = ' ' on FA440LIQSE1(FINA440.PRX)
    08/11/2019 13:32:47 line : 4940

    [TOTVS build: 7.00.170117A-20191024]

    Called from FA440CALCB(FINA440.PRX) 08/11/2019 13:32:47 line : 1586

    Called from FA070GRV(FINXBX.PRX) 13/11/2019 10:50:29 line : 1309

    Called from FA070TIT(FINA070.PRX) 14/11/2019 19:08:03 line : 2894

    Called from { |a,b,c,d,e| fA070Tit(a,b,c,d,e) }(FINA070.PRX) 14/11/2019 19:08:03


    line : 274

    Called from FINA070(FINA070.PRX) 14/11/2019 19:08:03 line : 275

    Called from FWFORMBROWSE:EXECUTE(FWFORMBROWSE.PRW) 18/11/2019 18:56:05 line : 1107

    Called from { || OSELF:EXECUTE("FINA070", 4,0,"BAIXAR", 1,"(,3,.T.)","","", 6 ) }


    (FWFORMBROWSE.PRW) 18/11/2019 18:56:05 line : 600

    Called from ::MSDIALOG:ACTIVATE

    Called from FWMBROWSE:ACTIVATE(FWMBROWSE.PRW) 18/11/2019 18:56:05 line : 680

    Called from FWMBROWSE(MSLIB.PRW) 18/11/2019 18:56:05 line : 12929

    Called from MBROWSE(MSLIB.PRW) 18/11/2019 18:56:05 line : 197

    Called from FINA740(FINA740.PRW) 09/08/2019 17:29:16 line : 60

    Called from __EXECUTE(APLIB090.PRW) 18/11/2019 18:56:02 line : 680

    Called from FWPREEXECUTE(FWPREEXECUTE.PRW) 18/11/2019 18:56:05 line : 79


    Called from { || FWPreExecute('Funções Contas a Receber', 'FINA740()', 1, '06',
    'xxxxxxxxxx') }(FWUIMENUL.PRW) 18/11/2019 18:56:05 line : 197

    Called from ::TWINDOW:ACTIVATE

    Called from MSAPP:ACTIVATE(FWAPP.PRW) 18/11/2019 18:56:05 line : 741

    Called from SIGAADV(APLIB000.PRW) 18/11/2019 18:56:02 line : 47

    [TOTVS Environment: producao]

    [TOTVS Environment RPODB: Top]

    [TOTVS Environment Trace: 0]

    [TOTVS Environment IBXLog: Nenhum]

    [TOTVS Environment KillStack: Nenhum]

    [TOTVS Environment TraceStack: Nenhum]

    [TOTVS Environment SpecialKey: Nenhum]

    [TOTVS Environment LocalFiles: CTREE]

    [TOTVS Environment LogProfiler: Nenhum]

    [TOTVS Environment TopMemoMega: 1]

    [TOTVS Environment RPOLanguage: portuguese]

    [TOTVS Environment RegionalLanguage: BRA]

    [TOTVS Environment LocalDBExtension: .dtc]

    [TOTVS Environment ConnectionTimeOut: Nenhum]

    [TOTVS Environment General CTreeMode: Nenhum]

    [TOTVS Environment General ConsoleLog: 1]

    [TOTVS Environment General ConsoleFile: Nenhum]

    [TOTVS Environment General MaxQuerySize: 31960]

    [TOTVS Environment General MaxStringSize: 10]

    [TOTVS Remote Lib: QT-5.9.7 WIN]

    [TOTVS Remote type: Microsoft Windows]

    [TOTVS Remote Build: 7.00.170117A-20190903]

    [TOTVS Remote Version: 17.3.0.10]

    [TOTVS Server Type: Console]


    [TOTVS Server Build: 7.00.170117A-20191024]

    [TOTVS Server Version: 17.3.0.16]

    [TOTVS Server 64 bits: Sim]

    [TOTVS Server Unix: Não]

    [TOTVS DBAccess DB: MSSQL]

    [TOTVS DBAccess API Build: 20181212-20190724]

    [TOTVS DBAccess Build: 20181212-20190924]

    [TOTVS DBAccess Type: WinNT (x64)]

    [TOTVS DBAccess Latency with SGDB: 1]

    [TOTVS Framework Versão: 20191122]

    [TOTVS Framework Date: 20191118_154738]

    [TOTVS Framework Commit: cf0b95351abf6aada8bb69865dba1f356c0eaf63]

    [TOTVS RPO Release: 12.1.025]

    [TOTVS License Server Version: 1.03.014]

    [TOTVS Workarea - Alias: Nenhum]

    [TOTVS Dicionário no banco de dados: Sim]

    Publicas

    Public 1: CPAISLOC(C) :BRA

    Public 2: LWSISPORTAL(L) :.F.

    Public 3: OAPP(O) :O

    Public 4: HELP(L) :.F.

    Public 5: USIGAADV(L) :.T.

    Public 6: CACESSO(C)
    :SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSNSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS
    SSSSSSSSSNNNNNNNNNNSSSNNSNNSSSSNNSSSSSSSSNNNNNSSSSNNNSSSSSSSSSSSNSNNNNSNNNSNNSSSSSS
    SSSNNSSSNSSSSSSSSSSSSNSSNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN
    NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN
    NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN
    NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN
    NNNNNNNNNNNNNNN

    Public 7: CARQTAB(C) :

    Public 8: CARQREL(C) :SIGAFIN.REW


    Public 9: CARQEMP(C) :SIGAMAT.EMP

    Public 10: AEMPRESAS(A) :

    Public 11: CUSUARIO(C) :******FRANCISCO


    GERGISSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSNSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS
    SSSSSSSSSSSSSNNNNNNNNNNSSSNNSNNSSSSNNSSSSSSSSNNNNNSSSSNNNSSSSSSSSSSSNSNNNNSNNNSNNSS
    SSSSSSSNNSSSNSSSSSSSSSSSSNSSNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN
    NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN
    NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN
    NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN
    NNNNNNNNNNNNNNNNNNN

    Public 12: CNIVEL(N) :5

    Public 13: ACBROWSE(C) :xxxxxxxxxx

    Public 14: ATRIGGER(A) :

    Public 15: __CINTERNET(U) :NIL

    Public 16: __CBINDER(U) :NIL

    Public 17: __CTERMINAL(U) :NIL

    Public 18: MV_RELT(U) :NIL

    Public 19: MV_CENT(U) :NIL

    You might also like