-
Type:
Bug
-
Status: Done
-
Priority:
Medium
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: Enhancements - Fall
-
Labels:None
-
Company:All Clients/Multiple Clients
-
Epic Link:
Environment: production
Page: Review and Sign
Issue: Post comments displaying error
Steps:
1. Add comments
2. Click Post comments button
3. System unable to post comments
Refer screen capture.
Hi Priya Dhamande,
The error occurred due to database table constraint fail :
MySql.Data.MySqlClient.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`dms_prod`.`useruploadpostcomment`, CONSTRAINT `FK_PersonID` FOREIGN KEY (`PersonID`) REFERENCES `dms_master`.`person` (`id`))
Preprod's person table was getting referenced for Prod's useruploadpostcomment table.
This issue was only on production and has been corrected.
Please verify the scenario.
Ramya Tantry (Inactive)
added a comment - Hi Priya Dhamande ,
The error occurred due to database table constraint fail :
MySql.Data.MySqlClient.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`dms_prod`.`useruploadpostcomment`, CONSTRAINT `FK_PersonID` FOREIGN KEY (`PersonID`) REFERENCES `dms_master`.`person` (`id`))
Preprod's person table was getting referenced for Prod's useruploadpostcomment table.
This issue was only on production and has been corrected.
Please verify the scenario.
CC: Rohan J Khandave , Ganesh Sadawarte , Samir 
Environment: production
Login: candidate
The issue of error while posting comment is verified and resolved.
Verified for
1. With attachment
2. Without attachment
Refer screen capture. So, marking jira done.
Sachin Hingole Samir Ramya Tantry Rohan J Khandave