MP - FIS - Error.log - Error : 1756 - ORA-01756: quoted string not properly terminated - MSCONHIST(MATXFUNC.PRX)

Dúvida

Ao gerar o SPED FISCAL esta sendo apresentado o error.log abaixo: 

THREAD ERROR ([3984], Sistem, MTZ-TREI001) 12/06/2019 12:14:30
: Error : 1756 - ORA-01756: quoted string not properly terminated
( From tOracleConnection::GetQueryFile )
Thread ID [4896] User [Marcela.Santos] IO [747413] Tables [106] MaxTables [107] Comment [SPEDFISCAL - TCPIP - ThreadID(3984)] SP [ ] Traced [No] SQLReplay [No] InTran [No] DBEnv [ORACLE/ORAINST] DBThread [(SID 2958,35417,2)] Started [12/06/2019 10:42:59] IP [172.16.10.42:12004] IDLE [ ] InTransact [ ] Memory [-141233152] Running [ROP_QUERY] RCV [222069027] SND [414292379] TCBuild [20181212-20190211] TCVersion [18.2.1.0] ARCH [64] OS [WINDOWS] BUILD [RELEASE]
SELECT * FROM AIF010 AIF WHERE AIF.AIF_FILIAL='01001001' AND AIF.AIF_FILTAB='01 ' AND AIF.AIF_TABELA='SA4' AND AIF.AIF_TRANSP='00000'' AND AIF.AIF_DATA>='20190501' AND AIF.AIF_DATA<='20491231' AND AIF.D_E_L_E_T_=' ' ORDER BY AIF_FILIAL,AIF_FILTAB,AIF_TABELA,AIF_TRANSP,AIF_DATA on MSCONHIST(MATXFUNC.PRX) 11/06/2018 10:26:23 line : 8928

[TOTVS build: 7.00.131227A-20181218 NG]
Called from MSCONHIST(MATXFUNC.PRX) 11/06/2018 10:26:23 line : 8928
Called from PRSPED(SPEDFISCAL.PRW) 12/12/2018 11:06:57 line : 995
Called from {|oSay|PrSped(@lEnd,@cFileDest,cPerfil,oSay,lTabComp,lTabCDT,lTabCD0,lTabCE5,lIntTMS,aWizScreen,lTabCD1)}(SPEDFISCAL.PRW) 12/12/2018 11:06:57 line : 995
Called from {|| Eval(bAction, oSay), oDlgSVG:End() }(FWMSGRUN.PRW) 23/10/2018 18:06:47 line : 995
Called from ::FWSTYLEDDIALOG:ACTIVATE line : 995
Called from FWMSGRUN(FWMSGRUN.PRW) 23/10/2018 18:06:47 line : 100
Called from SPEDFISCAL(SPEDFISCAL.PRW) 12/12/2018 11:06:57 line : 77
Called from __EXECUTE(APLIB090.PRW) 23/10/2018 18:06:47 line : 636
Called from MDIEXECUTE(APLIB260.PRW) 23/10/2018 18:06:47 line : 836
Called from STATICCALL(APLIB260.PRW) 23/10/2018 18:06:47 line : 836

Ambiente

Protheus – Livos Fiscais – A partir da versão 11.80

Solução

O problema está no campo F2_TRANSP, onde o mesmo está preenchido com uma aspa no final do preenchimento do campo.

Retire a mesma do campo da SF2 para a solução do problema, verifique se no cadastro da transportadora o mesmo está preenchido com a aspa.

Field 177: F2_TRANSP(C) :00000'

Apos a correção do campo F2_TRANSP na SF2 o erro será solucionado.