Sintoma

Estava ocorrendo o seguinte erro na geração do registro E115 em ambientes SQL:

Erro ao processar pesquisa registro E115: SQL: SELECT

BSC_NF_CAPA.*

, BSC_NF_ITEM.NIT_ID, BSC_NF_ITEM.NIT_COD_BENEF, BSC_NF_IMPOSTO.NIP_TP_LANC, BSC_NF_IMPOSTO.NIP_VL_IMPOSTO, BSC_TP_IMPOSTO.BTI_CODIGO, BSC_MODELO_DOC.BMD_CODIGO, BSC_STATUS.BST_CODIGO, SFC_AJUSTE_ADICIONAL.FAD_COD_AJUSTE, SFC_AJUSTE_ADICIONAL_TRANSIT.FAT_DESC_AJUSTE

FROM

BSC_NF_CAPA BSC_NF_CAPA

JOIN BSC_NF_ITEM BSC_NF_ITEM ON BSC_NF_CAPA.NCP_ID = BSC_NF_ITEM.NCP_ID

JOIN BSC_NF_IMPOSTO BSC_NF_IMPOSTO ON BSC_NF_ITEM.NIT_ID = BSC_NF_IMPOSTO.NIT_ID

JOIN BSC_TP_IMPOSTO BSC_TP_IMPOSTO ON BSC_TP_IMPOSTO.BTI_ID = BSC_NF_IMPOSTO.BTI_ID

JOIN BSC_MODELO_DOC BSC_MODELO_DOC ON BSC_MODELO_DOC.BMD_ID = BSC_NF_CAPA.BMD_ID

JOIN BSC_STATUS BSC_STATUS ON BSC_STATUS.BST_ID = BSC_NF_CAPA.BST_ID

LEFT JOIN SFC_AJUSTE_ADICIONAL SFC_AJUSTE_ADICIONAL ON SF_AJUSTE_ADICIONAL.FAD_COD_AJUSTE = BSC_NF_ITEM.NIT_COD_BENEF

LEFT JOIN SFC_AJUSTE_ADICIONAL_TRANSIT SFC_AJUSTE_ADICIONAL_TRANSIT ON SFC_AJUSTE_ADICIONAL_TRANSIT.FAD_ID = SFC_AJUSTE_ADICIONAL.FAD_ID

 WHERE

BSC_NF_CAPA.NCP_DT_FISCAL >= '2018-07-01' AND

BSC_NF_CAPA.NCP_DT_FISCAL <= '2018-07-31' AND

 BSC_NF_CAPA.BUS_ID IN (80) AND

 BSC_MODELO_DOC.BMD_CODIGO IN (55,65) AND

 BSC_STATUS.BST_CODIGO IN (01,79) AND

 BSC_NF_CAPA.NCP_IND_TP_DOC IN (1,3) AND

 NOT  BSC_NF_ITEM.NIT_COD_BENEF  IS NULL AND

LTRIM(BSC_NF_ITEM.NIT_COD_BENEF) <> '' AND

 BSC_TP_IMPOSTO.BTI_CODIGO IN (01) AND

( SFC_AJUSTE_ADICIONAL_TRANSIT.FAT_ID  IS NULL OR

(((FAT_DT_INI >= '2018-07-01' AND

FAT_DT_INI <= '2018-07-31'

) OR

(FAT_DT_FIN >= '2018-07-01' AND

FAT_DT_FIN <= '2018-07-31'

) OR

(FAT_DT_INI <= '2018-07-01' AND

FAT_DT_FIN >= '2018-07-31'

) OR

(FAT_DT_INI <= '2018-07-01' AND

 FAT_DT_FIN  IS NULL

)

)

)

)

 ORDER BY

BSC_NF_ITEM.NIT_COD_BENEF ASC, BSC_NF_ITEM.NIT_ID ASC, BSC_NF_IMPOSTO.NIP_TP_LANC ASC

Solução

Tratamento realizado na geração do registro E115 para que não seja interrompida nos ambientes SQL.