Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Please help, I have been trying to fix this error for the better part of 8 hours so far. I have a report in Crystal Reports that just started throwing this error. I changed a field in the View that is attached to the report, so I opened up my XSD file in VS2010 and renamed the current DT to ViewTracker0 and then pulled in the ViewTracker view. I added my queries from the old DT, ensured that there is no primary key, double checked that each length of the fields were the same as the db, checked to make sure that each column name is named to match the DB. I can preview my data fine in the XSD, as well as in SQL I can run my queries and everything is returned correctly. When I run my report, it dies everytime with this error.

Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

What do I need to check next.

Answers


Have you tried verifying the database within the Crystal Reports designer, then running the report?


Try traversing GetErrors(), described here: http://www.fransson.net/blog/failed-to-enable-constraints-one-or-more-rows-contain-values-violating-non-null-unique-or-foreign-key-constraints/


Need Your Help

dynamic array IN struct, C

c pointers arrays struct memory-management

I have looked around but have been unable to find a solution to what must be a well asked question.

Why no Stub in REST?

rest soap rpc

EDIT : My original title was "Use of Stub in RPC" ; I edited the title just to let others know it is more than that question.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.