-
Type:
Bug
-
Status: In Development
-
Priority:
Medium
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
-
Environment:Production, Stage, QA
-
Bug Type:Functional
-
Bug Severity:Medium
-
Module:BenAdmin - Import
-
Reported by:Harbinger
-
Company:All Clients/Multiple Clients
-
Item State:Development - On Hold
-
Issue Importance:Must Have
-
Sprint:WT Sprint 35 - Bugs
Lb For Qa ASML Company
Consider there is a life EE plan & a dependent life plan (enrollment allowed for EE = NO | enrollment allowed for CH and SP = Yes). Refer the dependent life plan's customization in the attached screenshot.
Through import try to enroll on EE plan
Actual Result : import getting failed.
Refer below error log:
ErrorID : 0
ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportEmployeeEnrollment.ImportData->ImportEmployeeEnrollment.GenerateRatesPolicyNoHealthTierQueryStringForAll->ImportEmployeeEnrollment.ExecuteEnrollmentQuery
ErrorMessage: Conversion failed when converting date and/or time from character string.
- relates to
-
-
- Closed
-
| Assignee | Vijay Siddha [ vijays ] | Jaideep Vinchurkar [ jaideep.vinchurkar ] |
| Assignee | Jaideep Vinchurkar [ jaideep.vinchurkar ] | Suraj Sokasane [ suraj.sokasane ] |
| Assignee | Suraj Sokasane [ suraj.sokasane ] | Vishal Bajad [ vishal.bajad ] |
| Status | Open [ 1 ] | In Development [ 10007 ] |
| Dev Due Date | 16/Aug/2017 | |
| Developer | Vishal Bajad [ vishal.bajad ] | |
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) | |
| QA | Rashmita Dudhe [ rashmita.dudhe ] |
-
- Time Spent:
- 8h
-
Analysis, Repro, Code walk through
| Remaining Estimate | 0h [ 0 ] | |
| Time Spent | 8h [ 28800 ] | |
| Worklog Id | 71525 [ 71525 ] |
| Attachment | Import Data.txt [ 58663 ] |
Hi Rashmita Dudhe ,
We have tried to repro as per suggested customization , but it could not repro.
Please help us or provide inputs to repro this issue.
You can find customization on LB as we tried ,
Company : For QA MATT
Plans : voluntary employee life -> Parent and voluntary Spouse life > Child
Import File : Import Data.txt
Thanks!
CC : Jaideep Vinchurkar, Satya
| Assignee | Vishal Bajad [ vishal.bajad ] | Rashmita Dudhe [ rashmita.dudhe ] |
| Time Spent | 8h [ 28800 ] | 8.5h [ 30600 ] |
| Worklog Id | 71809 [ 71809 ] |
-
- Time Spent:
- 2h
-
Discussion, Customization verification and tried to repro
| Time Spent | 8.5h [ 30600 ] | 10.5h [ 37800 ] |
| Worklog Id | 71834 [ 71834 ] |
Gaurav Sodani (Inactive)
made changes -
| Sprint | WT Sprint 35 - Bugs [ 81 ] | |
| Original Estimate | 0h [ 0 ] |
| Attachment | eligibity.txt [ 59342 ] |
Hi Vishal Bajad,
This issue is getting reproduced done all customization On
Company : For QA ASML for hspl Company
Plan Name: Supplement employee life and supplement spouse life plan.
Template name: ElectionImport.
Refer attached File eligibity.txt
Thanks
Rashmita
| Time Spent | 10.5h [ 37800 ] | 13.5h [ 48600 ] |
| Worklog Id | 73095 [ 73095 ] |
| Assignee | Rashmita Dudhe [ rashmita.dudhe ] | Vishal Bajad [ vishal.bajad ] |
Rashmita Dudhe, where are attached screen shots?
| Assignee | Vishal Bajad [ vishal.bajad ] | Suraj Sokasane [ suraj.sokasane ] |
| Description |
Lb For Qa ASML Company consider there is a life EE plan & a dependent life plan (enrollment allowed for EE = NO | enrollment allowed for CH and SP = Yes) refer the dependent life plan's customization in the attached screenshot through import try to enrolled on EE plan Expected Result : import getting failed refer below error log: ErrorID : 0 ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportEmployeeEnrollment.ImportData->ImportEmployeeEnrollment.GenerateRatesPolicyNoHealthTierQueryStringForAll->ImportEmployeeEnrollment.ExecuteEnrollmentQuery ErrorMessage: Conversion failed when converting date and/or time from character string. |
Lb For Qa ASML Company consider there is a life EE plan & a dependent life plan (enrollment allowed for EE = NO | enrollment allowed for CH and SP = Yes) refer the dependent life plan's customization in the attached screenshot through import try to enroll on EE plan Expected Result : import getting failed refer below error log: ErrorID : 0 ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportEmployeeEnrollment.ImportData->ImportEmployeeEnrollment.GenerateRatesPolicyNoHealthTierQueryStringForAll->ImportEmployeeEnrollment.ExecuteEnrollmentQuery ErrorMessage: Conversion failed when converting date and/or time from character string. |
| Description |
Lb For Qa ASML Company consider there is a life EE plan & a dependent life plan (enrollment allowed for EE = NO | enrollment allowed for CH and SP = Yes) refer the dependent life plan's customization in the attached screenshot through import try to enroll on EE plan Expected Result : import getting failed refer below error log: ErrorID : 0 ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportEmployeeEnrollment.ImportData->ImportEmployeeEnrollment.GenerateRatesPolicyNoHealthTierQueryStringForAll->ImportEmployeeEnrollment.ExecuteEnrollmentQuery ErrorMessage: Conversion failed when converting date and/or time from character string. |
Lb For Qa ASML Company Consider there is a life EE plan & a dependent life plan (enrollment allowed for EE = NO | enrollment allowed for CH and SP = Yes). Refer the dependent life plan's customization in the attached screenshot. Through import try to enroll on EE plan Actual Result : import getting failed. Refer below error log: ErrorID : 0 ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportEmployeeEnrollment.ImportData->ImportEmployeeEnrollment.GenerateRatesPolicyNoHealthTierQueryStringForAll->ImportEmployeeEnrollment.ExecuteEnrollmentQuery ErrorMessage: Conversion failed when converting date and/or time from character string. |
Hi Rashmita Dudhe,
The issue is not getting reproduced now. This might be some specific scenario. It'll be great if you check and provide bit more details.
| Assignee | Suraj Sokasane [ suraj.sokasane ] | Rashmita Dudhe [ rashmita.dudhe ] |
| Assignee | Rashmita Dudhe [ rashmita.dudhe ] | Jayshree Nagpure [ jayshree.nagpure ] |
| Attachment | Plan customization1.png [ 59713 ] |
| Attachment | Customization2.png [ 59714 ] |
| Attachment | Enroll_Now.png [ 59715 ] |
Hi Suraj Sokasane,
CC:Jaideep Vinchurkar,Hrishikesh Deshpande
This issue is getting reproduced and it is Braking functionality of wt-9635 please follow below steps and customization to reproduced it.
Plan customization
(enrollment allowed for EE = NO | enrollment allowed for CH and SP = Yes).
1]Employee enrolled in to the Parent plan with effective date 01/01/2017 either UI or Import as child plan is forced contingent.
Spouse and child enrolled in to the child plan with effective date 01/01/2017
2]Again If we do import for parent plan with 07/01/2017 then Import is getting failed.
But enrollment done in parent plan with Effective date 07/01/2017
But child plan it showing Effective date 01/01/2017
Syatem behavior is not correct in this scenario
Refer attached screen shots.
Refer error log:
ErrorID : 0
ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->ExecuteImportDTS.ImportData_Isolated->WTIsolatedRoutines.Main->ExecuteImportDTS.ImportData->ImportEmployeeEnrollment.ImportData->ImportEmployeeEnrollment.TerminateCurrentEnrollments
ErrorMessage: Object reference not set to an instance of an object.
Thanks,
Rashmita
| Time Spent | 13.5h [ 48600 ] | 14.5h [ 52200 ] |
| Worklog Id | 74017 [ 74017 ] |
| Assignee | Jayshree Nagpure [ jayshree.nagpure ] | Suraj Sokasane [ suraj.sokasane ] |
| Assignee | Suraj Sokasane [ suraj.sokasane ] | Ankur Deshpande [ ankur.deshpande ] |
| Time Spent | 14.5h [ 52200 ] | 15h [ 54000 ] |
| Worklog Id | 74095 [ 74095 ] |
Hi Rashmita Dudhe,
I have solved the error that you were getting. Following are the 3c's.
Concern : Object reference not set to an instance of an object.
Cause : Error during closing the datareader.
Correction : Applied check using if condition.
Regards,
Ankur
Ankur Deshpande (Inactive)
added a comment - Hi Rashmita Dudhe ,
I have solved the error that you were getting. Following are the 3c's.
Concern : Object reference not set to an instance of an object.
Cause : Error during closing the datareader.
Correction : Applied check using if condition.
Regards,
Ankur -
- Time Spent:
- 1.5h
-
Initial analysis and discussion with Ankur
| Time Spent | 15h [ 54000 ] | 16.5h [ 59400 ] |
| Worklog Id | 74144 [ 74144 ] |
Ankur Deshpande (Inactive)
made changes -
| Code Reviewed By | Jaideep Vinchurkar [ 11908 ] | |
| Dev Due Date | 16/Aug/2017 | 16/Aug/2017 |
Ankur Deshpande (Inactive)
made changes -
| Assignee | Ankur Deshpande [ ankur.deshpande ] | Rashmita Dudhe [ rashmita.dudhe ] |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
| Attachment | El1.png [ 59974 ] |
| Attachment | el2.png [ 59975 ] |
| Attachment | El3.png [ 59976 ] |
CC:Jyoti Mayne,Hrishikesh Deshpande,Rakesh Roy,Satya,Gaurav Sodani
Import failed related issue is solved and when i am verifying actual issue which is related to this issue WT-9635. This issue is implemented recently for enrollment.
Customization of plan is below:
When we done fresh Election import for parent plan then contingent plan is enrolled with proper coverage and it showing on Enroll now screen
But on view enrollment summary and confirmation statement it is not showing
Thanks,
Rashmita
| Time Spent | 16.5h [ 59400 ] | 17.5h [ 63000 ] |
| Worklog Id | 74587 [ 74587 ] |
| Status | Local Testing [ 10200 ] | Reopen in Local [ 10018 ] |
| Assignee | Rashmita Dudhe [ rashmita.dudhe ] | Jaideep Vinchurkar [ jaideep.vinchurkar ] |
Ankur Deshpande (Inactive)
made changes -
| Time Spent | 17.5h [ 63000 ] | 20h [ 72000 ] |
| Worklog Id | 75597 [ 75597 ] |
| Status | Reopen in Local [ 10018 ] | In Development [ 10007 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: In Testing(10210) | Parent values: Development(10200)Level 1 values: In Analysis(10204) |
| Labels | Manual_import |
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) | Parent values: Development(10200)Level 1 values: On Hold(10207) |
Gaurav Sodani (Inactive)
made changes -
| Company | All Clients/Multiple Clients [ 18434 ] | |
| Environment | Production,Stage,LB [ 18442, 18443, 18444 ] |
| Assignee | Jaideep Vinchurkar [ jaideep.vinchurkar ] | Ganesh Sadawarte [ ganesh.sadawarte ] |
| Assignee | Ganesh Sadawarte [ ganesh.sadawarte ] | Suraj Sokasane [ suraj.sokasane ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
19d 16h 10m | 1 |
|
14d 23h 13m | 1 |
|
28m 42s | 1 |
|
3d 1h 45m | 1 |
CC: Hrishikesh Deshpande, Rakesh Roy, Jyoti Mayne, Rohit Shete