WORKTERRAProject Type: software

WORKTERRA

Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-12386

Clone company - employee delete error

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Bug Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Platform
    • Labels:
      None
    • Environment:
      Stage
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - EDS
    • Reported by:
      Harbinger
    • Company:
      All Clients/Multiple Clients
    • Item State:
      Development - Ready for Local Testing

      Description

      While cloning any company on stage, below exception is getting thrown,

      ErrorID : 0
      ErrorSource : ControllerAppTier.Clone->WORKTERRAControllerAppTier.Clone->Company.Clone->Company.CloneCompany->Company.DeleteEmployeeDetails
      ErrorMessage: The DELETE statement conflicted with the REFERENCE constraint "FK_pm.RaisedEventBuilder_dbo.Employee_ID". The conflict occurred in database "BioRadEDIDataLoadTesting_13705", table "dbo.RaisedEventBuilder", column 'EmployeeID'.
      The DELETE statement conflicted with the REFERENCE constraint "FK_pm.RaisedEventBuilder_dbo.Employee_ID". The conflict occurred in database "BioRadEDIDataLoadTesting_13705", table "dbo.RaisedEventBuilder", column 'EmployeeID'.
      The statement has been terminated.
      The statement has been terminated.
      DBCC execution completed. If DBCC printed error messages, contact your system administrator.
      Checking identity information: current identity value '85', current column value '0'.
      DBCC execution completed. If DBCC printed error messages, contact your system administrator.
      Checking identity information: current identity value 'NULL', current column value '0'.
      DBCC execution completed. If DBCC printed error messages, contact your system administrator.
      Checking identity information: current identity value '53', current column value '0'.
      DBCC execution completed. If DBCC printed error messages, contact your system administrator.
      Checking identity information: current identity value '10', current column value '0'.
      DBCC execution completed. If DBCC printed error messages, contact your system administrator.
      Checking identity information: current identity value '121', current column value '0'.
      DBCC execution completed. If DBCC printed error messages, contact your system administrator.
      Checking identity information: current identity value '19', current column value '0'.
      StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.Clone(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity)
      at WORKTERRA.ControllerAppTier.Clone(Int32 intProjectsId, String strInput)
      TargetSite: System.String Clone(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity)

        Attachments

          Activity

          Ascending order - Click to sort in descending order
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) created issue -
          Permalink
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 23/Nov/17 01:13 PM
          • Time Spent:
            0.5h
             

            analysis

          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Field Original Value New Value
          Remaining Estimate 6h [ 21600 ] 5.5h [ 19800 ]
          Time Spent 0.5h [ 1800 ]
          Worklog Id 92389 [ 92389 ]
          Permalink
          snehal.katkar Snehal Katkar (Inactive) logged work - 24/Nov/17 05:15 AM
          • Time Spent:
            3.5h
             

            Analysis, Discussion

          snehal.katkar Snehal Katkar (Inactive) made changes -
          Remaining Estimate 5.5h [ 19800 ] 2h [ 7200 ]
          Time Spent 0.5h [ 1800 ] 4h [ 14400 ]
          Worklog Id 92485 [ 92485 ]
          Jennifer.Reed Jennifer Reed (Inactive) made changes -
          Reported by EDI (Workterra) [ 18440 ] Harbinger [ 10700 ]
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Akash Thakur [ akash.thakur ]
          akash.thakur Akash Thakur (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          Permalink
          akash.thakur Akash Thakur (Inactive) logged work - 28/Nov/17 08:59 AM
          • Time Spent:
            2.5h
             

            WT-12386 Analysis & fix for local & LB and Testing on both platform

          Hide
          Permalink
          akash.thakur Akash Thakur (Inactive) added a comment -

          Hi Jaideep Vinchurkar,

          We have fixed this issue Cloning company without Data on LB the SP was outdated & we have updated it for new columns added in database working fine now on LB . need your approval to check-in updated Sp on Stage.

          Thanks ,
          Akash Thakur

          Show
          akash.thakur Akash Thakur (Inactive) added a comment - Hi Jaideep Vinchurkar , We have fixed this issue Cloning company without Data on LB the SP was outdated & we have updated it for new columns added in database working fine now on LB . need your approval to check-in updated Sp on Stage. Thanks , Akash Thakur
          akash.thakur Akash Thakur (Inactive) made changes -
          Remaining Estimate 2h [ 7200 ] 0h [ 0 ]
          Time Spent 4h [ 14400 ] 6.5h [ 23400 ]
          Worklog Id 93196 [ 93196 ]
          Permalink
          akash.thakur Akash Thakur (Inactive) logged work - 05/Dec/17 07:15 AM
          • Time Spent:
            3h
             
            <No comment>
          akash.thakur Akash Thakur (Inactive) made changes -
          Time Spent 6.5h [ 23400 ] 9.5h [ 34200 ]
          Worklog Id 95716 [ 95716 ]
          akash.thakur Akash Thakur (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          akash.thakur Akash Thakur (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
          akash.thakur Akash Thakur (Inactive) made changes -
          Assignee Akash Thakur [ akash.thakur ] Sachin Hingole [ sachin.hingole ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Resolution Bug Fixed [ 10402 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Production Complete [ 10028 ] Closed [ 6 ]
          Transition Time In Source Status Execution Times
          Akash Thakur (Inactive) made transition -
          Open In Development
          		4d 17h 14m 1
          Akash Thakur (Inactive) made transition -
          In Development In LB Testing
          		22d 5h 51m 1
          Sachin Hingole (Inactive) made transition -
          In LB Testing Stage Testing
          		92d 20h 26m 1
          Sachin Hingole (Inactive) made transition -
          Stage Testing In Production Testing
          		18s 1
          Sachin Hingole (Inactive) made transition -
          In Production Testing Production Complete
          		25s 1
          Sachin Hingole (Inactive) made transition -
          Production Complete Closed
          		21s 1

            People

            Assignee:
            sachin.hingole Sachin Hingole (Inactive)
            Reporter:
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 6h Original Estimate - 6h
                6h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 9.5h
                9.5h