-
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
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.
- relates to
-
NF-5640 Dashboard configuration - show name card without employee data when company does not have EE on Dashboard preview
-
- Closed
-
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 (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 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
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 This issue is resolved and will be deployed in next codemap build.
Thanks,
Sonali
Sonali Farakate (Inactive)
added a comment - HI Jayshree Nagpure
This issue is resolved and will be deployed in next codemap build.
Thanks,
Sonali Verified on codemap
Login - SA
Issue of Server error on add company is fixed
PFA - 
Marking item state as Ready for stage
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 
cc : Sachin Hingole Prasad Pise Rakesh Roy