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
            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
            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
            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
            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
            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

              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