Document Management SystemProject Type: software

Document Management System

Uploaded image for project: 'Document Management System'
  1. Document Management System
  2. DMS-1513

DMS | Production | Post comments displaying error

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: Enhancements - Fall
    • Labels:
      None

      Description

      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.

      Sachin Hingole Rohan J Khandave Ganesh Sadawarte

        Attachments

        1. Screenshot (2517).png
          Screenshot (2517).png
          171 kB
        2. Screenshot (2595).png
          Screenshot (2595).png
          167 kB
        3. Screenshot (2596).png
          Screenshot (2596).png
          167 kB

          Activity

          Ascending order - Click to sort in descending order
          priya.dhamande Priya Dhamande (Inactive) created issue -
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          Field Original Value New Value
          Fix Version/s Enhancements - Fall [ 10610 ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Summary DMS | production | Post comments displaying error DMS | Production | Post comments displaying error
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Attachment Screenshot (2517).png [ 110549 ]
          samir Samir made changes -
          Epic Link DMS-473 [ 75966 ]
          Hide
          Permalink
          samir Samir added a comment -

          Please check this

          Show
          samir Samir added a comment - Please check this
          samir Samir made changes -
          Assignee Samir [ samir ] Ramya Tantry [ ramya.tantry ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status To Do [ 10000 ] In Progress [ 3 ]
          Permalink
          ramya.tantry Ramya Tantry (Inactive) logged work - 19/Jun/19 01:46 AM
          • Time Spent:
            2h
             

            issue analysis

            discussion with Ashwin

            testing

          Hide
          Permalink
          ramya.tantry 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

          Show
          ramya.tantry 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
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 2h [ 7200 ]
          Worklog Id 184008 [ 184008 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status In Progress [ 3 ] In QA Testing [ 11901 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Assignee Ramya Tantry [ ramya.tantry ] Priya Dhamande [ priya.dhamande ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Labels Prod_Regression
          Original Estimate 0h [ 0 ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Labels Prod_Regression
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Attachment Screenshot (2595).png [ 110825 ]
          Attachment Screenshot (2596).png [ 110826 ]
          Permalink
          priya.dhamande Priya Dhamande (Inactive) logged work - 19/Jun/19 05:40 AM
          • Time Spent:
            0.5h
             

            Production verification

          Hide
          Permalink
          priya.dhamande Priya Dhamande (Inactive) added a comment -

          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

          Show
          priya.dhamande Priya Dhamande (Inactive) added a comment - 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
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status In QA Testing [ 11901 ] Done [ 10001 ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Assignee Priya Dhamande [ priya.dhamande ] Ramya Tantry [ ramya.tantry ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Time Spent 2h [ 7200 ] 2.5h [ 9000 ]
          Worklog Id 184047 [ 184047 ]
          Transition Time In Source Status Execution Times
          Ramya Tantry (Inactive) made transition -
          To Do In Progress
          		1d 21h 51m 1
          Ramya Tantry (Inactive) made transition -
          In Progress In QA Testing
          		2h 19m 1
          Priya Dhamande (Inactive) made transition -
          In QA Testing Done
          		3h 53m 1

            People

            Assignee:
            ramya.tantry Ramya Tantry (Inactive)
            Reporter:
            priya.dhamande Priya Dhamande (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 0h
                0h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 2.5h
                2.5h