SQL Server存储过程报错及应用

在1206线建立batchs intervals发生以下错误 

 

 ERROR QUERY :Violation of PRIMARY KEY constraint 'PK_T_TRANCH_LOT'. Cannot insert duplicate key in object 'dbo.T_TRANCH_LOT'. The duplicate key value is (4994).

Query issue : sp_exec_and_log_tran_with_return N'insert into T_TRANCH_LOT (ET_PROD, TRANCH_NO_START, TRANCH_TAILLE, TRANCH_NBUSE, TRANCH_NB_AVANCE, NOMMODIF, DATEMODIF, HEUREMODIF) values(''1206'', ''4994'', 1, 0, 20,''J3.5.28-41-JONVY.YOU'',''20230206'',''11400670'');', 'J3.5.28-41-JONVY.YOU','20230206','11400670'

line 571 : util.database.DB_COM.throwSqlException(DB_COM.java:571)

Test Cxa:

 

测试以下存储过程，replication sas in成功到所有产线

sp_exec_and_log_tran_with_return N'update t_refakf set refakf_nom=''Test part for station 18'' where id_refakf=''TEST18000A'';', 'J3.5.28-41-JONVY.YOU','20230206','11400670'