New Features 2017Project Type: software

New Features 2017

Uploaded image for project: 'New Features 2017'
  1. New Features 2017
  2. NF-5642

Add company -> server error

    Details

    • Type: Bug
    • Status: Resolution Setting
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: UI Refresh
    • Labels:
      None
    • Environment:
      Others
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Level:
      Partner
    • Module:
      BenAdmin - Customization
    • Reported by:
      Harbinger
    • Company:
      All Clients/Multiple Clients
    • Item State:
      Stage QA - Production Deployment on Hold

      Description

      Environment - Codemap

      1) Login with partner
      2) Add company
      3) Fill mandatory details -> Save and continue
      4) system throws server error

      ErrorID : 0
      ErrorSource : ControllerAppTier.Clone->WORKTERRAControllerAppTier.Clone->Company.Clone->Company.AddCompany->Company.BackupAndRestoreNewCompany
      ErrorMessage: User does not have permission to alter database 'TestCompany1_13551', the database does not exist, or the database is not in a state that allows access checks.
      ALTER DATABASE statement failed.
      The file 'D:\MSSQL\Data\MasterCompanyDB.mdf' cannot be overwritten. It is being used by database 'MasterCompanyDB'.
      File 'MasterCompanyDB_Data' cannot be restored to 'D:\MSSQL\Data\MasterCompanyDB.mdf'. Use WITH MOVE to identify a valid location for the file.
      The file 'D:\MSSQL\Log\MasterCompanyDB.ldf' cannot be overwritten. It is being used by database 'MasterCompanyDB'.
      File 'MasterCompanyDB_Log' cannot be restored to 'D:\MSSQL\Log\MasterCompanyDB.ldf'. Use WITH MOVE to identify a valid location for the file.
      Problems were identified while planning for the RESTORE statement. Previous messages provide details.
      RESTORE DATABASE is terminating abnormally.
      User does not have permission to alter database 'TestCompany1_13551', the database does not exist, or the database is not in a state that allows access checks.
      ALTER DATABASE statement failed.

        Attachments

          Issue Links

          relates to

          Change Request - Change Request NF-5640 Dashboard configuration - show name card without employee data when company does not have EE on Dashboard preview

          • Medium - Has the potential to affect progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            jayshree.nagpure Jayshree Nagpure (Inactive) created issue -
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to NF-5640 [ NF-5640 ]
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            cc : Sachin Hingole Prasad Pise Rakesh Roy

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - cc : Sachin Hingole Prasad Pise Rakesh Roy
            nidhi.kaul Nidhi Kaul (Inactive) made changes -
            Assignee Nidhi Kaul [ nidhi.kaul ] Vijayendra Shinde [ ID10506 ]
            vijayendra Vijayendra Shinde (Inactive) made changes -
            Assignee Vijayendra Shinde [ ID10506 ] Sonali Farakate [ sonali.farakate ]
            sonali.farakate Sonali Farakate (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            sonali.farakate Sonali Farakate (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            Permalink
            pratap.patil Pratap Patil (Inactive) logged work - 04/Jan/18 10:12 AM - edited
            • Time Spent:
              2.5h
               

              Internal discussion with Sonali and Ashwin .
              Worked with Sonali.

            Permalink
            sonali.farakate Sonali Farakate (Inactive) logged work - 04/Jan/18 01:45 PM
            • Time Spent:
              3.5h
               

              Analysis and repro

            Permalink
            sonali.farakate Sonali Farakate (Inactive) logged work - 04/Jan/18 01:46 PM
            • Time Spent:
              4h
               

              Discussion and changes

            sonali.farakate Sonali Farakate (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 3.5h [ 12600 ]
            Worklog Id 99390 [ 99390 ]
            sonali.farakate Sonali Farakate (Inactive) made changes -
            Time Spent 3.5h [ 12600 ] 7.5h [ 27000 ]
            Worklog Id 99391 [ 99391 ]
            Permalink
            pratap.patil Pratap Patil (Inactive) logged work - 05/Jan/18 10:13 AM - edited
            • Time Spent:
              2.5h
               

              Worked with Sonali to fix issue .
              Discussion with Vijayendra and Sonali.
              Code review .

            Permalink
            sonali.farakate Sonali Farakate (Inactive) logged work - 05/Jan/18 12:22 PM
            • Time Spent:
              3.5h
               

              Internal discussion and script writing

            sonali.farakate Sonali Farakate (Inactive) made changes -
            Time Spent 7.5h [ 27000 ] 11h [ 39600 ]
            Worklog Id 99488 [ 99488 ]
            Hide
            Permalink
            sonali.farakate Sonali Farakate (Inactive) added a comment - - edited

            Concern : Error while adding Company - not able to navigate to Dashboard on adding company
            Cause : MasterCompanyDB data was not correct- OriginalProjectID value was NULL for Some Rows
            Correction : Updated OriginalProjectID to ProjectID

            Added Script :
            730_NF-5642_WTB_UiRefresh_ModData_OriginalProjectID_MenuActionModuleMapping

            Show
            sonali.farakate Sonali Farakate (Inactive) added a comment - - edited Concern : Error while adding Company - not able to navigate to Dashboard on adding company Cause : MasterCompanyDB data was not correct- OriginalProjectID value was NULL for Some Rows Correction : Updated OriginalProjectID to ProjectID Added Script : 730_ NF-5642 _WTB_UiRefresh_ModData_OriginalProjectID_MenuActionModuleMapping
            sonali.farakate Sonali Farakate (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: In Progress(10206)
            Original Estimate 0h [ 0 ]
            Hide
            Permalink
            sonali.farakate Sonali Farakate (Inactive) added a comment -

            Added one more column 'ShowAnnaulElectionForPerPaycheck' to table 'PlanDesign_CostAndCoverage' which was not present on Codemap.

            Written script for it.
            729_NF-5642_WTB_UiRefresh_ModTable_PlanDesign_CostAndCoverage_ShowAnnaulElectionForPerPaycheck

            Show
            sonali.farakate Sonali Farakate (Inactive) added a comment - Added one more column ' ShowAnnaulElectionForPerPaycheck ' to table ' PlanDesign_CostAndCoverage ' which was not present on Codemap. Written script for it. 729_ NF-5642 _WTB_UiRefresh_ModTable_PlanDesign_CostAndCoverage_ShowAnnaulElectionForPerPaycheck
            Permalink
            sonali.farakate Sonali Farakate (Inactive) logged work - 09/Jan/18 08:41 AM
            • Time Spent:
              4h
               
              <No comment>
            sonali.farakate Sonali Farakate (Inactive) made changes -
            Time Spent 11h [ 39600 ] 15h [ 54000 ]
            Worklog Id 99718 [ 99718 ]
            sonali.farakate Sonali Farakate (Inactive) made changes -
            Code Reviewed By Vijayendra Shinde [ 11901 ]
            Hide
            Permalink
            sonali.farakate Sonali Farakate (Inactive) added a comment -

            HI Jayshree Nagpure

            This issue is resolved and will be deployed in next codemap build.

            Thanks,
            Sonali

            Show
            sonali.farakate Sonali Farakate (Inactive) added a comment - HI Jayshree Nagpure This issue is resolved and will be deployed in next codemap build. Thanks, Sonali
            sonali.farakate Sonali Farakate (Inactive) made changes -
            Assignee Sonali Farakate [ sonali.farakate ] Jayshree Nagpure [ jayshree.nagpure ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 09/Jan/18 12:56 PM
            • Time Spent:
              0.5h
               

              Testing on codemap

            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Attachment 5642.jpg [ 71510 ]
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Verified on codemap
            Login - SA

            Issue of Server error on add company is fixed
            PFA -

            Marking item state as Ready for stage

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Verified on codemap Login - SA Issue of Server error on add company is fixed PFA - Marking item state as Ready for stage
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 15h [ 54000 ] 15.5h [ 55800 ]
            Worklog Id 99790 [ 99790 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            pratap.patil Pratap Patil (Inactive) made changes -
            Time Spent 15.5h [ 55800 ] 18h [ 64800 ]
            Worklog Id 100203 [ 100203 ]
            pratap.patil Pratap Patil (Inactive) made changes -
            Time Spent 18h [ 64800 ] 20.5h [ 73800 ]
            Worklog Id 100205 [ 100205 ]
            pratap.patil Pratap Patil (Inactive) made changes -
            Worklog Id 100205 [ 100205 ]
            pratap.patil Pratap Patil (Inactive) made changes -
            Worklog Id 100203 [ 100203 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Stage Testing [ 10201 ] Resolution Setting [ 11616 ]
            Transition Time In Source Status Execution Times
            Sonali Farakate (Inactive) made transition -
            Open In Development
            		21h 5m 1
            Sachin Hingole (Inactive) made transition -
            In Development In LB Testing
            		5d 3h 3m 1
            Hrishikesh Deshpande (Inactive) made transition -
            In LB Testing Stage Testing
            		13d 21h 59m 1
            Sachin Hingole (Inactive) made transition -
            Stage Testing Resolution Setting
            		92d 16h 40m 1

              People

              Assignee:
              jayshree.nagpure Jayshree Nagpure (Inactive)
              Reporter:
              jayshree.nagpure Jayshree Nagpure (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

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