null exception on a project

Posted By SAbow Mon 24 Jun 2019
Add to Favorites0
Author Message
SAbow
 Posted Mon 24 Jun 2019
Supreme Being

Supreme Being - (38,991 reputation)Supreme Being - (38,991 reputation)Supreme Being - (38,991 reputation)Supreme Being - (38,991 reputation)Supreme Being - (38,991 reputation)Supreme Being - (38,991 reputation)Supreme Being - (38,991 reputation)Supreme Being - (38,991 reputation)Supreme Being - (38,991 reputation)

Group: Forum Members
Last Active: Tue 2 Feb 2021
Posts: 77, Visits: 334
we are using the latest version of Kartris for one of our project and after working and making adjustments to the database and code we are getting this error when trying to load product page
"System.Data.ConstraintException: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints."

please advice what can be that cause this error.
Paul
 Posted Tue 25 Jun 2019
große Käse

große Käse - (450,038 reputation)große Käse - (450,038 reputation)große Käse - (450,038 reputation)große Käse - (450,038 reputation)große Käse - (450,038 reputation)große Käse - (450,038 reputation)große Käse - (450,038 reputation)große Käse - (450,038 reputation)große Käse - (450,038 reputation)

Group: Administrators
Last Active: Fri 15 Sep 2023
Posts: 806, Visits: 2,737
Need to try to debug where in the code it's happening. It suggests data is being pulled, maybe into an adapter, but that constraints that expect certain values to be unique are violated by the data, e.g. there may be two items with the same IDs.

Using debug on the page, or possibly errors from the screen, you should be able to narrow down the actual call that is failing, and we should be able to identify the cause. Once we have more info, it's normally possible to query the data directly and then figure out how to fix it.


--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.

If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
SAbow
 Posted Tue 25 Jun 2019
Supreme Being

Supreme Being - (38,991 reputation)Supreme Being - (38,991 reputation)Supreme Being - (38,991 reputation)Supreme Being - (38,991 reputation)Supreme Being - (38,991 reputation)Supreme Being - (38,991 reputation)Supreme Being - (38,991 reputation)Supreme Being - (38,991 reputation)Supreme Being - (38,991 reputation)

Group: Forum Members
Last Active: Tue 2 Feb 2021
Posts: 77, Visits: 334
there are no more details given when we debug. this is happening randomly. When we run the queries directly in SQL or preview the data in the xsd file it runs fine. there are no duplicate IDs - and this is happening even when there is only one row in the result set!!

Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Back To Top