MeGaDeTH_91

MSSQL Insert Errors

Oct 19th, 2017
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.12 KB | None | 0 0
  1. Checking identity information: current identity value '50'.
  2. DBCC execution completed. If DBCC printed error messages, contact your system administrator.
  3. Checking identity information: current identity value '6'.
  4. DBCC execution completed. If DBCC printed error messages, contact your system administrator.
  5. Checking identity information: current identity value '6'.
  6. DBCC execution completed. If DBCC printed error messages, contact your system administrator.
  7. Checking identity information: current identity value '4'.
  8. DBCC execution completed. If DBCC printed error messages, contact your system administrator.
  9. Checking identity information: current identity value '20'.
  10. DBCC execution completed. If DBCC printed error messages, contact your system administrator.
  11. Checking identity information: current identity value '53'.
  12. DBCC execution completed. If DBCC printed error messages, contact your system administrator.
  13. Checking identity information: current identity value '21'.
  14. DBCC execution completed. If DBCC printed error messages, contact your system administrator.
  15. Msg 7997, Level 16, State 1, Line 7
  16. 'OrderParts' does not contain an identity column.
  17. Msg 7997, Level 16, State 1, Line 7
  18. 'PartsNeeded' does not contain an identity column.
  19.  
  20. (50 rows affected)
  21.  
  22. (6 rows affected)
  23.  
  24. (6 rows affected)
  25.  
  26. (4 rows affected)
  27.  
  28. (20 rows affected)
  29. Msg 8152, Level 16, State 14, Line 145
  30. String or binary data would be truncated.
  31. The statement has been terminated.
  32. Msg 547, Level 16, State 0, Line 206
  33. The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Orders". The conflict occurred in database "WMS", table "dbo.Jobs", column 'JobId'.
  34. The statement has been terminated.
  35. Msg 547, Level 16, State 0, Line 233
  36. The INSERT statement conflicted with the FOREIGN KEY constraint "FK_OpOrders". The conflict occurred in database "WMS", table "dbo.Orders", column 'OrderId'.
  37. The statement has been terminated.
  38. Msg 547, Level 16, State 0, Line 272
  39. The INSERT statement conflicted with the FOREIGN KEY constraint "FK_PnJobId". The conflict occurred in database "WMS", table "dbo.Jobs", column 'JobId'.
  40. The statement has been terminated.
Advertisement
Add Comment
Please, Sign In to add comment