0

We are using azure data sync to sync data from one database to another. We have created a new sync group for another environment. we don't have any issues from backend as sync is running fine but we are having below DataSync error from Frontend side when user try functionality that is related to table participating in DataSync.

System.Data.Entity.Infrastructure.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.Entity.Core.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'local_create_peer_timestamp', table 'PULSECOACHIN_7_QCEC.DataSync.CoachingSessionNotificationScheduler_dss_tracking'; column does not allow nulls. UPDATE fails.

Improve this question
3
  • 1
    The error message is very clearly, it has the null value, please recheck the value. Commented Feb 10, 2020 at 6:28
  • By chance, Is that a computed column? Commented Feb 10, 2020 at 6:31
  • We are are not inserting any data to those Columns or tables .those are DataSync tables which are automatically created by when the sync is enabled. Commented Feb 10, 2020 at 6:34
Related questions
1
Get Schema error when making Data sync in Azure
2
Sql Azure Data Sync Agent invalid key error message
4
Sql Data Sync fails and no logs are available
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.