-
Type:
Bug
-
Status: Production Complete
-
Priority:
High
-
Resolution: Bug Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: UI Refresh
-
Labels:None
-
Environment:Pre Production
-
Bug Type:Functional
-
Bug Severity:Critical
-
Level:Partner
-
Module:Platform
-
Reported by:Harbinger
-
Company:All Clients/Multiple Clients
-
Item State:Stage QA - Production Deployment on Hold
Partner login - Global change password - Select name - getting error
Server Error in '/Platform' Application.
Invalid column name 'OtherUniqueIdentifier'.
Invalid column name 'OtherUniqueIdentifier'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.ServiceModel.FaultException: Invalid column name 'OtherUniqueIdentifier'.
Invalid column name 'OtherUniqueIdentifier'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[FaultException: Invalid column name 'OtherUniqueIdentifier'.
Invalid column name 'OtherUniqueIdentifier'.]
WORKTERRA.Shared.WORKTERRAControllerWebTier.GetCollection(ObjectType I_objectType, Hashtable I_criteria, String I_AdditionalCriteriaString, Object I_context, Boolean I_mode, Boolean I_needCollection) +202
WORKTERRA.Models.SearchEmployeePVModel.GetEmployeeDetailsDetails(String CompanyID, Int32 Count, Boolean IsBoxLayout, Int32 maximumRecordCount) +977
WORKTERRA.Shared.Controllers.HomePageController.SearchEmployee(String companyID, String EmployeeQuickLinkNavigationURL, String EmployeeQuickLinkNavigationPageName) +4114
lambda_method(Closure , ControllerBase , Object[] ) +193
System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters) +14
System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) +157
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +27
System.Web.Mvc.<>c_DisplayClass15.<InvokeActionMethodWithFilters>b_12() +56
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) +256
System.Web.Mvc.<>c_DisplayClass17.<InvokeActionMethodWithFilters>b_14() +22
| Field | Original Value | New Value |
|---|---|---|
| Attachment | screenshot-1.png [ 68554 ] |
| Assignee | Vijayendra Shinde [ ID10506 ] | Rakesh Roy [ rakeshr ] |
On loading its still coming--Did you use Global level employee change password..
| Assignee | Rakesh Roy [ rakeshr ] | Vijayendra Shinde [ ID10506 ] |
Same error for Change employee status. May be reason could be same for both issue
Hi Ashwin Wankhede,
OtherUniqueIdentifier column is missing in Employee table from ACPS company. Server error raised.
Please confirm UK benefits script execution on all companies so that same issue will not be raised for rest of the companies.
Thanks,
Vijayendra
CC:Nidhi Kaul, Samir
| Assignee | Vijayendra Shinde [ ID10506 ] | Ashwin Wankhede [ ashwin.wankhede ] |
Sachin Hingole (Inactive)
made changes -
| Attachment | BioRad_2CoreHR_BenAdminNotSelected.png [ 68563 ] |
Bio-Rad : Only Core HR module is mapped, BenAdmin and ACA modules are missing.
Also 2 Core HR tiles displayed. refer image 
Sachin Hingole (Inactive)
added a comment - Bio-Rad : Only Core HR module is mapped, BenAdmin and ACA modules are missing.
Also 2 Core HR tiles displayed. refer image Sachin Hingole (Inactive)
made changes -
I have checked this, This column is not present on 40 companies on Pre-Production.
These companies are recently moved from stage to production. This column was present on companies when it was on stage. After moving this company on production UK Benefits team has given separate script which needs to be executed after every company move from stage to production. In this script they have given schema deletion.
Chaitali Acharya, Vaishali Poojari - Can you please please explain , why it schema deleted after moving company from stage to production.
As this was already executed entry was present in system_db_registry, hence it could not load file for script execution.
Chaitali Acharya - Can you please give me files which needs to be fix this column deletion issue.
During company move on stage to production i have menu deactivation script for below menus.
- Organization Chart
- Profile
- Manage Onboard Status
- Employee Background Check
- Assign Classes And Payroll
Other than these i do not have any script to be explicitly run during company move.
We usually get menu deactivation related scripts during company move.
Once i receive script name i will execute it on all companies.
Chaitali Acharya
This needs to be worked on priority.
Thanks,
Nidhi.
Nidhi Kaul (Inactive)
added a comment - Chaitali Acharya
This needs to be worked on priority.
Thanks,
Nidhi. 
| Attachment | Additiona script.txt [ 68583 ] |
| Attachment | Addtion Scripts.7z [ 68585 ] |
Chaitali Acharya,
Please respond to Ashwin's question? - Can you please please explain , why it schema deleted after moving company from stage to production.
Nidhi Kaul (Inactive)
added a comment - Chaitali Acharya ,
Please respond to Ashwin's question? - Can you please please explain , why it schema deleted after moving company from stage to production. Sachin Hingole (Inactive)
made changes -
| Priority | Highest [ 1 ] | High [ 2 ] |
The schema was deleted because, previously we were getting errors on CurrencyID and other columns on Production.
To solve this issue the reversal script was provided.
Thanks,
Chaitali
| Remaining Estimate | 2.5h [ 9000 ] | |
| Original Estimate | 2.5h [ 9000 ] |
-
- Time Spent:
- 2.5h
-
Discussion
Giving folder structure for deletion scripts
| Remaining Estimate | 2.5h [ 9000 ] | 0h [ 0 ] |
| Time Spent | 2.5h [ 9000 ] | |
| Worklog Id | 92964 [ 92964 ] |
| Assignee | Ashwin Wankhede [ ashwin.wankhede ] | Sachin Hingole [ sachin.hingole ] |
| Time Spent | 2.5h [ 9000 ] | 4h [ 14400 ] |
| Worklog Id | 92997 [ 92997 ] |
Sachin Hingole (Inactive)
made changes -
| Status | Open [ 1 ] | In Development [ 10007 ] |
Sachin Hingole (Inactive)
made changes -
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
Sachin Hingole (Inactive)
made changes -
| Item State | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) |
Nidhi Kaul (Inactive)
made changes -
Nidhi Kaul (Inactive)
made changes -
| Environment | Others [ 18445 ] | Pre Production [ 18470 ] |
| Item State | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
This issue has been fixed on Codemap. Verified for Global Level-Change Employee Password and Change Employee Status.
Password changing successfully and Employee status also changing successfully.
| Attachment | Global-ChangeEEPassword-Pass.png [ 70251 ] |
| Time Spent | 4h [ 14400 ] | 4.5h [ 16200 ] |
| Worklog Id | 96600 [ 96600 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: On Hold(10211) |
Sachin Hingole (Inactive)
made changes -
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
Sachin Hingole (Inactive)
made changes -
| Item State | Parent values: LB QA(10201)Level 1 values: On Hold(10211) | Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224) |
Sachin Hingole (Inactive)
made changes -
| Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
Sachin Hingole (Inactive)
made changes -
| Resolution | Bug Fixed [ 10402 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Transition | Time In Source Status | Execution Times |
|---|
Sachin Hingole (Inactive)
made transition
-
|
1d 1h 56m | 1 |
Sachin Hingole (Inactive)
made transition
-
|
3m 9s | 1 |
Sachin Hingole (Inactive)
made transition
-
|
49d 6h 41m | 1 |
Sachin Hingole (Inactive)
made transition
-
|
65d 15h 4m | 1 |
Sachin Hingole (Inactive)
made transition
-
|
3m 46s | 1 |
Hi Rakesh Roy,
Please provide us name of company for which you tried to search employee. I just tried same steps and I was able to redirect to Change employee password page successfully. I used CHMC company.
Thanks,
Vijayendra
CC:Nidhi Kaul, Sachin Hingole