TOTVS Automação Fiscal

Árvore de páginas

01. DADOS GERAIS

Produto:

TOTVS Backoffice

Linha de Produto:

Linha Protheus 

Segmento:

Backoffice SP 

Módulo:AUTOMAÇÃO FISCAL
Função:

WSTAF0022060

Ticket:22045847
Requisito/Story/Issue (informe o requisito relacionado) :DSERTAF2-20711


02. SITUAÇÃO/REQUISITO

O cliente apresentou o seguinte errorlog na apuração do R-2060: Errorlog na apuração do R-2060 - [Informix ODBC Driver][Informix]A syntax error has occurred. - Banco INFORMIX

THREAD ERROR ([6572], TP|SD|HTTP@01|TRUE, A3EB63FF71F5AC4B9229A8EABA106630) 10/12/2024 15:46:03
: Error : -201 (37000) (RC=-1) - [Informix][Informix ODBC Driver][Informix]A syntax error has occurred.
Error : -201 (00000) (RC=-1) -
( From tInformixConnection::GetQueryFile )
Thread ID [6696] User [TP|SD|HTTP@01|TRUE] IO [6171] Tables [95] MaxTables [97] Comment [] SP [ ] Traced [No] SQLReplay [No] InTran [No] DBEnv [INFORMIX/TAF] DBThread [(SID 21803013)] Started [10/12/2024 15:45:32] IP [127.0.0.1:5943] IDLE [ ] InTransact [ ] Memory [0] Running [ROP_QUERY2 for 0 s.] RCV [201407] SND [661016] TCBuild [20240224-20241002] TCVersion [24.1.0.0] ARCH [64] OS [WINDOWS] BUILD [RELEASE]
SELECT COUNT TOTAL FROM ( SELECT CASE WHEN C5M.C5M_PROCID <> ? THEN ? WHEN C5M.C5M_PROCID = ? THEN ? END AS STATUS FROM C5M010 C5M WHERE C5M.C5M_FILIAL IN  AND C5M.C5M_DTINI BETWEEN ? AND ? AND C5M.C5M_DTFIM BETWEEN ? AND ? AND C5M.D_E_L_E_T_ = ?) STATUS WHERE STATUS.STATUS = ? on MPSYSOPENQUERY(MPSYSOPENTABLES.PRW) 22/11/2024 17:02:41 line : 742
[TOTVS build: 7.00.210324P-20240902]
Called from FWEXECSTATEMENT:OPENALIAS(FWEXECSTATEMENT.PRW) 22/11/2024 17:02:34 line : 68
Called from RETSTQTD(WSTAF0022060.PRW) 09/10/2024 15:44:04 line : 243
Called from WS0022060(WSTAF0022060.PRW) 09/10/2024 15:44:04 line : 42
Called from REST_WSTAF002:POST_EVENTDETAIL(WSTAF002.PRW) 02/10/2024 09:10:09 line : 275
Called from WSRESTFUL:CALLMETHOD(WSRESTFUL.PRG) 22/11/2024 17:02:34 line : 497
Called from RESTCALLWS(FWRESTHANDLER.PRW) 22/11/2024 17:02:34 line : 1636
Called from TLPP.REST.REST:HTTPCALLWSRESTFUL(CLASSREST.TLPP) 02/09/2024 12:17:17 line : 1225
Called from TLPP.REST.REST:HTTPCALL(CLASSREST.TLPP) 02/09/2024 12:17:17 line : 1172
Called from TLPP.REST.REST:HANDLE(CLASSREST.TLPP) 02/09/2024 12:17:17 line : 841
Called from TLPP.REST.HANDLEREST(FUNCTIONREST.TLPP) 02/09/2024 12:17:16 line : 121

03. SOLUÇÃO

Realizado proteção para o comando no banco de dados Informix funcionar.

04. DEMAIS INFORMAÇÕES

Não há.

05. ASSUNTOS RELACIONADOS

         TOTVS Automação Fiscal