-
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.
Please check this