ERROR 4819

Question

SQL Server: 2019&nbsp;ERROR (4819) -" Cannot bulk load. The bulk data stream was incorrectly specified as sorted or the data violates a uniqueness constraint imposed by the target table. Sort order incorrect for the follow"&nbsp;We tested the exact same stored procedures on SQL2019 System A and everything worked as expected.&nbsp; But it gives errors when we test on the SQL SERVER 2019 System B.&nbsp;&nbsp; SQL Server A and SQL Server B are the same version, 2019 but something is causing these jobs to fail.I’m not sure what to do next.&nbsp; Any thoughts/suggestions would be greatly appreciated.&nbsp;Thanks.

rodgerkong · Answer

Check DB configurations, constraint on target table.

reacher01 · Answer

rodgerkong&nbsp;&nbsp;Thank you for your kind reply and help. &nbsp;There were no constraints on the DB. &nbsp;

rodgerkong · Answer

Reacher01&nbsp;execute sql below in both server, check results&nbsp;SELECT name, collation_name  
FROM sys.databases  
WHERE name = N'Your DB Name'; --replace the string to your db name &nbsp;

2024437 · Answer

Reacher01: Have you found any solution?We are getting the similar error. I have checked the sort order in the stored procedure and it does seem to be right. So far, i do not see any issues with the code.

Forum Discussion

ERROR 4819

4 Replies

Resources