[2024-01-19 09:35:06] local.ERROR: 数据库异常 -> SQLSTATE[23000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]违反了 PRIMARY KEY 约束“PK__orders__78CD1049AC8DA072”。不能在对象“dbo.produce_order”中插入重复键。重复键值为 (OA20240119)。 (SQL: insert into [produce_order] ([method], [poNumber], [productId], [plantId], [lineId], [batchNo], [makeDate], [validDate], [planAmount], [printMarket], [printFrom], [printLogo], [poPrefix], [generateFlag], [packageRules]) values (0, OA20240119093506000018, 1, 1, 3, OA20240119, 2024-01-19, 2026-01-01, 10000, ?, ?, ?, OA, 0, [{"type":0,"indicator":0,"level":1,"name":"Primary","GTIN":"00343547289508","amount":3,"materialCode":"28950","__is_add":false,"filterValue":"0","available":22886,"threshold":20000,"verify":10},{"type":0,"indicator":3,"level":3,"name":"Case","GTIN":"30343547289509","amount":2,"materialCode":"28950","__is_add":false,"filterValue":"3","available":20296,"threshold":20000,"verify":10,"zero":0},{"type":1,"indicator":5,"level":4,"name":"Pallet","GTIN":"0343547","amount":1,"materialCode":"28950","palletGTIN":"50343547289503","__is_add":false,"filterValue":"3","available":5143,"threshold":5000,"verify":10}])) [2024-01-19 09:35:11] local.ERROR: 数据库异常 -> SQLSTATE[23000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]违反了 PRIMARY KEY 约束“PK__orders__78CD1049AC8DA072”。不能在对象“dbo.produce_order”中插入重复键。重复键值为 (OA20240119)。 (SQL: insert into [produce_order] ([method], [poNumber], [productId], [plantId], [lineId], [batchNo], [makeDate], [validDate], [planAmount], [printMarket], [printFrom], [printLogo], [poPrefix], [generateFlag], [packageRules]) values (0, OA20240119093511000555, 1, 1, 3, OA20240119, 2024-01-19, 2026-01-01, 10000, ?, ?, ?, OA, 0, [{"type":0,"indicator":0,"level":1,"name":"Primary","GTIN":"00343547289508","amount":3,"materialCode":"28950","__is_add":false,"filterValue":"0","available":22886,"threshold":20000,"verify":10},{"type":0,"indicator":3,"level":3,"name":"Case","GTIN":"30343547289509","amount":2,"materialCode":"28950","__is_add":false,"filterValue":"3","available":20296,"threshold":20000,"verify":10,"zero":0},{"type":1,"indicator":5,"level":4,"name":"Pallet","GTIN":"0343547","amount":1,"materialCode":"28950","palletGTIN":"50343547289503","__is_add":false,"filterValue":"3","available":5143,"threshold":5000,"verify":10}])) [2024-01-19 09:35:28] local.ERROR: 数据库异常 -> SQLSTATE[23000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]违反了 PRIMARY KEY 约束“PK__orders__78CD1049AC8DA072”。不能在对象“dbo.produce_order”中插入重复键。重复键值为 (OA20240119)。 (SQL: insert into [produce_order] ([method], [poNumber], [productId], [plantId], [lineId], [batchNo], [makeDate], [validDate], [planAmount], [printMarket], [printFrom], [printLogo], [poPrefix], [generateFlag], [packageRules]) values (0, OA20240119093528000060, 2, 1, 3, OA20240119, 2024-01-19, 2026-01-01, 1000, ?, ?, ?, OA, 1, [{"type":0,"indicator":1,"level":1,"name":"Primary","GTIN":"10240111233448","amount":4,"materialCode":"23344","__is_add":false,"filterValue":"1","available":0,"threshold":20000,"verify":15},{"type":0,"indicator":3,"level":3,"name":"Case","GTIN":"30240111233442","amount":2,"materialCode":"23344","__is_add":false,"filterValue":"3","available":0,"threshold":10000,"verify":15,"zero":0},{"type":1,"indicator":5,"level":4,"name":"Pallet","GTIN":"0240111","amount":1,"materialCode":"23344","palletGTIN":"50240111233446","__is_add":false,"filterValue":"9","available":0,"threshold":5000,"verify":15}])) [2024-01-19 09:35:34] local.ERROR: 数据库异常 -> SQLSTATE[23000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]违反了 PRIMARY KEY 约束“PK__orders__78CD1049AC8DA072”。不能在对象“dbo.produce_order”中插入重复键。重复键值为 (OA20240119)。 (SQL: insert into [produce_order] ([method], [poNumber], [productId], [plantId], [lineId], [batchNo], [makeDate], [validDate], [planAmount], [printMarket], [printFrom], [printLogo], [poPrefix], [generateFlag], [packageRules]) values (1, OA20240119093534000752, 2, 1, 3, OA20240119, 2024-01-19, 2026-01-01, 1000, ?, ?, ?, OA, 1, [{"type":0,"indicator":1,"level":1,"name":"Primary","GTIN":"10240111233448","amount":4,"materialCode":"23344","__is_add":false,"filterValue":"1","available":0,"threshold":20000,"verify":15},{"type":0,"indicator":3,"level":3,"name":"Case","GTIN":"30240111233442","amount":2,"materialCode":"23344","__is_add":false,"filterValue":"3","available":0,"threshold":10000,"verify":15,"zero":0},{"type":1,"indicator":5,"level":4,"name":"Pallet","GTIN":"0240111","amount":1,"materialCode":"23344","palletGTIN":"50240111233446","__is_add":false,"filterValue":"9","available":0,"threshold":5000,"verify":15}]))