MP - FIS - DB error (Insert): -37 File: SFT010 - Error : 1 - ORA-00001: unique constraint (PROTHEUS.SFT010_UNQ) violated

Dúvida

THREAD ERROR ([112156], XXXXX) 20/08/2020 10:44:59
SFT010: DB error (Insert): -37 File: SFT010 - Error : 1 - ORA-00001: unique constraint (PROTHEUS.SFT010_UNQ) violated
( From tISAMFile::Write )
Thread ID [51632] User [Adrian] IO [8291] Tables [163] MaxTables [164] Comment [MATA103 - TCPIP - ThreadID(112156)] SP [ ] Traced [No] SQLReplay [No] InTran [Yes] DBEnv [ORACLE/COOPEAVI] DBThread [(SID 6798,60174,1)] Started [20/08/2020 10:11:34] IP [10.1.1.31:1409] IDLE [ ] InTransact [4 s.] Memory [0] Running [ROP_WRITE for 0 s.] RCV [661170] SND [4464374] TCBuild [20191119-20200706] TCVersion [19.2.1.1] ARCH [64] OS [WINDOWS] BUILD [RELEASE]
INSERT INTO SFT010(FT_FILIAL,FT_ENTRADA,FT_EMISSAO,FT_NFISCAL,FT_SERIE,FT_CLIEFOR,FT_LOJA,FT_ESTADO,FT_CFOP,FT_ALIQICM,FT_VALCONT,FT_BASEICM,FT_VALICM,FT_ISENICM,FT_OBSERV,FT_TIPO,FT_PDV,FT_ESPECIE,FT_CREDST,FT_PRODUTO,FT_TIPOMOV,FT_ITEM,FT_CLASFIS,FT_CTIPI,FT_POSIPI,FT_IDENTF3,FT_ESTOQUE,FT_DESPIPI,FT_QUANT,FT_PRCUNIT,FT_TOTAL,FT_SERORI,FT_ITEMORI,FT_RECISS,FT_CHVNFE,FT_CSTPIS,FT_CSTCOF,FT_CODBCC,FT_TPPRODE,FT_TNATREC,FT_CNATREC,FT_AGREG,FT_CODISS,FT_IDSFB,FT_IDSFC,FT_IDSB5,FT_IDSED,FT_IDSF7,FT_IDSA2,FT_IDSBZ,FT_IDCFC,FT_CV139,FT_SERSAT,FT_CEST,FT_ATIVCPB,FT_CLIDEST,FT_LOJDEST,FT_BSICMOR,FT_TAFKEY,FT_TES,FT_SDOC,FT_SDOCORI,FT_LOJDVMC,FT_CLIDVMC,FT_COLVDIF,R_E_C_N_O_) VALUES ( :1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:29,:30,:31,:32,:33,:34,:35,:36,:37,:38,:39,:40,:41,:42,:43,:44,:45,:46,:47,:48,:49,:50,:51,:52,:53,:54,:55,:56,:57,:58,:59,:60,:61,:62,:63,:64,:65,:66)
-- Binded Parameters List --
#1 [C] [47]
#2 [D] [20200731]
#3 [D] [20200729]
#4 [C] [000004259]
#5 [C] [1 ]
#6 [C] [139803]
#7 [C] [01]
#8 [C] [ES]
#9 [C] [1201 ]
#10 [N] [17.000000]
#11 [N] [1.000000]
#12 [N] [0.180000]
#13 [N] [0.030000]
#14 [N] [0.820000]
#15 [C] [ ]
#16 [C] [D]
#17 [C] [ ]
#18 [C] [SPED ]
#19 [C] [ ]
#20 [C] [029610 ]
#21 [C] [E]
#22 [C] [0001]
#23 [C] [020]
#24 [C] [49]
#25 [C] [04051000 ]
#26 [C] [000001]
#27 [C] [S]
#28 [C] [S]
#29 [N] [1.000000]
#30 [N] [1.000000]
#31 [N] [1.00 - Integrity failure. on ENDTRAN(APLIB060.PRW) 05/03/2020 22:36:09 line : 220

Ambiente

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

Solução

Para identificar a causa do error.log, será necessário verificar se esta sendo utilizado algum ponto de entrada no processo utilizado pelo cliente.

No exemplo acima, foi identificado o ponto de entrada "MA030ROT e SD1100I ", abaixo trecho do erro mencionando os pontos de entradas impactando no processo: 

d:\totvs\protheus\protheus_data\system\xx6010.dtc; Rdd:DBFCDX; Alias:XX6; Filter :; Recno:1; Total Recs:2130; Order:2
Index (0) :I_RECNO
Index (1) :**XX60101 XX6_CODFUN+XX6_TYPE
Index (2) :XX60102 XX6_DESC+XX6_CODFUN
Field 1: D_E_L_E_T_E_D(C) :
Field 2: R_E_C_N_O(N) :1
Field 3: XX6_CODFUN(C) :MA030ROT
Field 4: XX6_TYPE(C) :2
Field 5: XX6_DESC(C) :Incluído automaticamente pelo sistema-03/07/10
d:\totvs\protheus\protheus_data\system\xx7010.dtc; Rdd:DBFCDX; Alias:XX7; Filter :; Recno:129; Total Recs:2130; Order:2
Index (0) :I_RECNO
Index (1) :**XX70101 XX7_CODFUN+XX7_TYPE+XX7_FILIAL
Index (2) :XX70102 XX7_TYPE+XX7_CODFUN+XX7_FILIAL
Field 1: D_E_L_E_T_E_D(C) :
Field 2: R_E_C_N_O(N) :129
Field 3: XX7_CODFUN(C) :SD1100I
Field 4: XX7_TYPE(C) :1
Field 5: XX7_FILIAL(C) :
Field 6: XX7_STATUS(C) :1
Field 7: XX7_DEFRET(C)

Para certificar se o ponto de entrada está impactando no processo, será necessário desabilitar os pontos de entrada através da chave IXBLOG=NORUN.