Knowledge Base : Glossary : Suggest a Question
Search The Knowledge Base
Browse The Knowledge Base
Knowledge Base : HQ : DataUpload (CSD/AHD) : CSD Backup Issue

Unique Constraint violated while loading CSDS Backup upload

ISSUE :

unique constraint (RAYMEDI_CS.XXXXXXXX) violated.

SYMPTOMS :

While sending the complete or period backup this error occurs in upload status.

CAUSE :

1.This is due to Deleted trigger not available for that table in the outlet side.
2.Some duplicate available for the table in the HQ(CS Database)side.
3.TSID column for the table is possibly NULL.

SOLUTION :

1.Execute the deleted trigger for that table.
2.Delete the duplicate entries from the table.
3.If the TSID column for the table is NULL ,delete the table from the database and send table wise backup(that table only).
4.Send last success from HQ to Outlet or put the file into pending status in the table comm_recv_trans and then load the backup.


Related Articles
There are no related articles


Viewer Comments Add Comment
No viewers have posted comments

Powered By AutoKB