-
Type:
Change Request
-
Status: Closed
-
Priority:
High
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:None
-
Module:BenAdmin - Export
-
Reported by:Harbinger
-
Company:CAISO
-
Item State:Production Complete - Closed
Error Log:
Dear User,
Following Are Error Logged While Exporting Data.
Group Template Name: CAISO_CEREDIAN
Company Name: CAISO
Company Level Template Name: New_CAISO EDeduct Payroll Flex Pre Tax Employee Limit_UPDATED
ErrorMessage: Error converting data type varchar to bigint.
- relates to
-
-
- Closed
-
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Vijay Siddha [ vijays ] | Rakesh Shahane [ rakesh.shahane ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Remaining Estimate | 7h [ 25200 ] | |
| Original Estimate | 7h [ 25200 ] |
| Remaining Estimate | 7h [ 25200 ] | 0h [ 0 ] |
| Time Spent | 7h [ 25200 ] | |
| Worklog Id | 17916 [ 17916 ] |
| Time Spent | 7h [ 25200 ] | 8.5h [ 30600 ] |
| Worklog Id | 18334 [ 18334 ] |
| Time Spent | 8.5h [ 30600 ] | 9.5h [ 34200 ] |
| Worklog Id | 18562 [ 18562 ] |
| Assignee | Rakesh Shahane [ rakesh.shahane ] | Vinayak Kulkarni [ vinayak.kulkarni ] |
| Assignee | Vinayak Kulkarni [ vinayak.kulkarni ] | Rajendra Pawar [ rajendra.pawar ] |
| Time Spent | 9.5h [ 34200 ] | 11.5h [ 41400 ] |
| Worklog Id | 19607 [ 19607 ] |
Checked this yesterday, But effective date service only inserting dead enrollments, not inserting new entry for coverage.
Modified dead enrollment check and enrollment and coverage is moving to main table .. needs to check export file.
| Time Spent | 11.5h [ 41400 ] | 14.5h [ 52200 ] |
| Worklog Id | 20426 [ 20426 ] |
| Component/s | BenAdmin [ 10000 ] |
-
- Time Spent:
- 6h
-
Did analysis for valid dead enrollment ids udf OES_UDF_Export_GetExportedDeadEnrollmentIDs and identified the change to do.
| Time Spent | 14.5h [ 52200 ] | 20.5h [ 73800 ] |
| Worklog Id | 24134 [ 24134 ] |
Below are the 3C's.
Concern : Error Logged While Exporting feed Data.
Cause : The thing is, there was future election and that were sent on file as active previously. After that election got dead. When effective date service runs, then this is not considering dead enrollments for move operation. so dead enrollment remains in intermediate table. After that when feed runs, it checks that dead enrollment in main table. but it is actually in interminable. Export is looking in main table because effective date is less than current date. So this is causing failures in export.
Correction : To handle such failures we need to move dead enrollments through effective date service. And there is one more change in export UDF (OES_UDF_Export_GetExportedDeadEnrollmentIDs) logic to consider such moved dead enrollments.
Rohan J Khandave Vinayak Kulkarni Ganesh Sadawarte Rakesh Shahane
| Resolution | Done [ 10000 ] | |
| Status | In Progress [ 3 ] | Resolved [ 5 ] |
| Resolution | Done [ 10000 ] | |
| Status | Resolved [ 5 ] | Reopened [ 4 ] |
| Time Spent | 20.5h [ 73800 ] | 21.6h [ 77760 ] |
| Worklog Id | 24202 [ 24202 ] |
| Status | Reopened [ 4 ] | In Progress [ 3 ] |
| Environment | Production [ 10005 ] | |
| Issue Type | Support Activity [ 10301 ] | Change Request [ 10002 ] |
| Status | In Progress [ 3 ] | New Request [ 10029 ] |
| Support Task Type | Data Correction [ 11203 ] | |
| Workflow | WT_Support [ 30053 ] | WT_Features [ 32586 ] |
This change will be done after WT-8417 is completed.
| Time Spent | 21.6h [ 77760 ] | 22.6h [ 81360 ] |
| Worklog Id | 24986 [ 24986 ] |
| Time Spent | 22.6h [ 81360 ] | 23.1h [ 83160 ] |
| Worklog Id | 25000 [ 25000 ] |
| Status | New Request [ 10029 ] | Pending for Approval [ 10002 ] |
| Status | Pending for Approval [ 10002 ] | Approved for Development [ 10003 ] |
| Status | Approved for Development [ 10003 ] | In Development [ 10007 ] |
| Item State | Parent values: Development(10200)Level 1 values: In Progress(10206) |
| Attachment | Affected Files.txt [ 40226 ] |
| Item State | Parent values: Development(10200)Level 1 values: In Progress(10206) | Parent values: Development(10200)Level 1 values: Ready for Review(10208) |
| Account Executive | Vinayak Kulkarni [ vinayak.kulkarni ] | |
| Dev Estimates | 20 | |
| Developer | Rajendra Pawar [ rajendra.pawar ] | |
| QA | Aniruddha Dev [ aniruddha.dev ] |
| Code Review Date | 22/Feb/2017 | |
| Code Reviewed By | Vinalyak Kulkarni [ 12100 ] | |
| Resolution | Fixed [ 1 ] |
| Item State | Parent values: Development(10200)Level 1 values: Ready for Review(10208) | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) |
We are done with export changes and those are checked-into trunk. We can not move this without completing WT-8417.
| Attachment | Affected Files.txt [ 40226 ] |
| Attachment | Affected Files.txt [ 41214 ] |
| Item State | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) | Parent values: Development(10200)Level 1 values: On Hold(10207) |
| Item State | Parent values: Development(10200)Level 1 values: On Hold(10207) | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) |
| Assignee | Rajendra Pawar [ rajendra.pawar ] | Aniruddha Dev [ aniruddha.dev ] |
| Time Spent | 23.1h [ 83160 ] | 23h 26m [ 84360 ] |
| Worklog Id | 47883 [ 47883 ] |
Khandu Kshirsagar (Inactive)
made changes -
| 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) |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
-
- Time Spent:
- 20m
-
LB And Uirefresh check in
-
- Time Spent:
- 0.75h
-
Analaysis and Explaining this to Pallavi K and discussion
HI Pallavi Kulkarni,
Can you please check this and take it forward. Please let me know in case of any help required from my side
CC: Mandar Kulkarni Hrishikesh Deshpande
Thanks & Regards,
Aniruddha Dev
| Assignee | Aniruddha Dev [ aniruddha.dev ] | Pallavi Kulkarni [ pallavi.kulkarni ] |
-
- Time Spent:
- 3h
-
Discussion with Aniruddha
Analysis of task.
Creating template Template
-
- Time Spent:
- 4h
-
Trying find scenario with VSP plan.
Hi Aniruddha Dev,
Verified on LB working as expected, following scenarios checked,
1.Future Dead Enrollment
2.Current Dead Enrollment
3.Back Date Dead Enrollment
4. Current and Future flag effect on respective enrollment.
Details of template are as follows,
Environment:LB
Template name:New_CAISO EDeduct Payroll Flex Pre Tax Employee Limit_UPDATED
Group Template name:A
Can you please verify at you end.
Thanks,
Pallavi Kulkarni
| Assignee | Pallavi Kulkarni [ pallavi.kulkarni ] | Aniruddha Dev [ aniruddha.dev ] |
-
- Time Spent:
- 4h
-
Verifying backdate,current date and flag impact
| Time Spent | 23h 26m [ 84360 ] | 24h 11m [ 87060 ] |
| Worklog Id | 50304 [ 50304 ] |
| Time Spent | 24h 11m [ 87060 ] | 27h 11m [ 97860 ] |
| Worklog Id | 50578 [ 50578 ] |
| Time Spent | 27h 11m [ 97860 ] | 31h 11m [ 112260 ] |
| Worklog Id | 50587 [ 50587 ] |
| Time Spent | 31h 11m [ 112260 ] | 35h 11m [ 126660 ] |
| Worklog Id | 50590 [ 50590 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
| 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) |
| Status | Local Testing [ 10200 ] | Pending for Stage Approval [ 10300 ] |
| Time Spent | 35h 11m [ 126660 ] | 35.35h [ 127260 ] |
| Worklog Id | 54745 [ 54745 ] |
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) |
-
- Time Spent:
- 1.5h
-
Stage testing. (In Progress)
Verified this fix on Stage on CAISO for HSPL company . Working as expected. Ready for Production
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
| Status | Pending for Stage Approval [ 10300 ] | Approved for Stage [ 10030 ] |
| Status | Approved for Stage [ 10030 ] | Stage Testing [ 10201 ] |
| Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) |
| Time Spent | 35.35h [ 127260 ] | 36.85h [ 132660 ] |
| Worklog Id | 56310 [ 56310 ] |
| Time Spent | 36.85h [ 132660 ] | 38.35h [ 138060 ] |
| Worklog Id | 56477 [ 56477 ] |
| Item State | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) | Parent values: Stage QA(10202)Level 1 values: On Hold(10215) |
| Item State | Parent values: Stage QA(10202)Level 1 values: On Hold(10215) | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) |
| Time Spent | 38.35h [ 138060 ] | 38h 31m [ 138660 ] |
| Worklog Id | 64002 [ 64002 ] |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) |
| Time Spent | 38h 31m [ 138660 ] | 38.85h [ 139860 ] |
| Worklog Id | 64211 [ 64211 ] |
| Status | Stage Testing [ 10201 ] | Pending for Production Approval [ 10301 ] |
| Item State | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) | Parent values: Production QA(10203)Level 1 values: In Testing(10218) |
| Status | Pending for Production Approval [ 10301 ] | Approved for production [ 10034 ] |
| Status | Approved for production [ 10034 ] | Production Testing [ 10202 ] |
Verified this change on ASML for HSPL company on production by creating this scenario and executing Effective Date service on company .
It is working as expected. Closing this JIRA
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Item State | Parent values: Production QA(10203)Level 1 values: In Testing(10218) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
-
- Time Spent:
- 3.5h
-
Checking this fix on Production by running effective date service along with Enrollment team
| Time Spent | 38.85h [ 139860 ] | 42.35h [ 152460 ] |
| Worklog Id | 67531 [ 67531 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
15s | 1 |
|
34d 22h 52m | 1 |
|
42s | 1 |
|
17s | 1 |
|
3d 21h 49m | 1 |
|
6d 2h 13m | 1 |
|
23h 49m | 1 |
|
5s | 1 |
|
91d 4h 32m | 1 |
|
19d 18h 25m | 1 |
|
7d 5h 27m | 1 |
|
2s | 1 |
|
28d 22h 33m | 1 |
|
7s | 1 |
|
2s | 1 |
|
1m 24s | 1 |
|
8s | 1 |
Hi Rajendra, Please check this.