-
Type:
Enhancement
-
Status: Resolution Setting
-
Priority:
High
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
-
Module:ACA
-
Reported by:Harbinger
-
Item State:Stage QA - Production Deployment on Hold
Hi Rohan J Khandave,
Toaday while viewing history of template delivery information fields, Amit Thorve found that main table columns are not matching to history table columns. We need to scan all tables of import export template pages for such discrepancy and resolve it. This will help us to track template changes in future.
CC-Vijayendra Shinde, Vinayak Kulkarni, Ganesh Sadawarte, Rajendra Pawar
- relates to
-
WT-10995 ACA_Waive implementation_Employee record count is not matching on Cloned and existing template
-
- Closed
-
Field | Original Value | New Value |
---|---|---|
Assignee | Vijay Siddha [ vijays ] | Rohan Khandave [ rohan.khandave ] |
Description |
Hi [~rohan.khandave], As discussed with [~vijayendra] we need to verify all columns of main tables are exact matches with history tables for export related tables only. CC-[~vijayendra] |
Hi [~rohan.khandave], As discussed with [~vijayendra] we need to verify all columns of main tables are exact matches with history tables for export related tables only. CC-[~vijayendra], [~Vinayak.Kulkarni], [~Ganesh.sadawarte], [~rajendra.pawar] |
Description |
Hi [~rohan.khandave], As discussed with [~vijayendra] we need to verify all columns of main tables are exact matches with history tables for export related tables only. CC-[~vijayendra], [~Vinayak.Kulkarni], [~Ganesh.sadawarte], [~rajendra.pawar] |
Hi [~rohan.khandave], Toaday while viewing history of template delivery information fields, [~amitthorve] found that main table columns are not matching to history table columns. We need to scan all tables of import export setting for such discrepancy and resolve it. CC-[~vijayendra], [~Vinayak.Kulkarni], [~Ganesh.sadawarte], [~rajendra.pawar] |
Description |
Hi [~rohan.khandave], Toaday while viewing history of template delivery information fields, [~amitthorve] found that main table columns are not matching to history table columns. We need to scan all tables of import export setting for such discrepancy and resolve it. CC-[~vijayendra], [~Vinayak.Kulkarni], [~Ganesh.sadawarte], [~rajendra.pawar] |
Hi [~rohan.khandave], Toaday while viewing history of template delivery information fields, [~amitthorve] found that main table columns are not matching to history table columns. We need to scan all tables of import export template pages for such discrepancy and resolve it. This will help us to track template changes in future. CC-[~vijayendra], [~Vinayak.Kulkarni], [~Ganesh.sadawarte], [~rajendra.pawar] |
Assignee | Rohan Khandave [ rohan.khandave ] | Vinayak Kulkarni [ vinayak.kulkarni ] |
Status | Open [ 1 ] | In Progress [ 3 ] |
Attachment | Export_History_table_Count.xls [ 34609 ] |
Assignee | Vinayak Kulkarni [ vinayak.kulkarni ] | Nandkumar [ satyap ] |
Status | In Progress [ 3 ] | Open [ 1 ] |
Remaining Estimate | 5h [ 18000 ] | |
Original Estimate | 5h [ 18000 ] |
Remaining Estimate | 5h [ 18000 ] | 1.5h [ 5400 ] |
Time Spent | 3.5h [ 12600 ] | |
Worklog Id | 12014 [ 12014 ] |
Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Module | Parent values: BenAdmin(10100)Level 1 values: Export(10110) | Parent values: ACA(10104) |
Assignee | Nandkumar [ satyap ] | Revansiddha Gaur [ revansiddha.gaur ] |
-
- Time Spent:
- 10m
-
Internal discussion with Nandkumar for priority.
Remaining Estimate | 1.5h [ 5400 ] | 1h 20m [ 4800 ] |
Time Spent | 3.5h [ 12600 ] | 3h 40m [ 13200 ] |
Worklog Id | 23426 [ 23426 ] |
Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Kumar Chhajed [ kumar.chhajed ] |
Assignee | Kumar Chhajed [ kumar.chhajed ] | Revansiddha Gaur [ revansiddha.gaur ] |
Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Yogesh Chaudhari [ yogesh.chaudhari ] |
-
- Time Spent:
- 3.5h
-
Added ISACATemplate Column in History table and made changes in database Triggers.
Completed Unit Testing
Remaining Estimate | 1h 20m [ 4800 ] | 0h [ 0 ] |
Time Spent | 3h 40m [ 13200 ] | 7h 10m [ 25800 ] |
Worklog Id | 74775 [ 74775 ] |
-
- Time Spent:
- 1h
-
Unit testing code review and discussion with Revan
Time Spent | 7h 10m [ 25800 ] | 7h 25m [ 26700 ] |
Worklog Id | 74873 [ 74873 ] |
Status | Open [ 1 ] | In Progress [ 3 ] |
Environment | Production [ 10005 ] | |
Issue Type | Support Activity [ 10301 ] | Enhancement [ 4 ] |
Status | In Progress [ 3 ] | Approved for Development [ 10003 ] |
Support Task Type | Customization [ 11204 ] | |
Workflow | WT_Support [ 28350 ] | WT_Features [ 50614 ] |
Code Review Date | 29/Aug/2017 | |
Code Reviewed By | Revansiddha [ 13002 ] |
Assignee | Yogesh Chaudhari [ yogesh.chaudhari ] | Smita Pawar [ smita.pawar ] |
Time Spent | 7h 25m [ 26700 ] | 8h 25m [ 30300 ] |
Worklog Id | 76030 [ 76030 ] |
Status | Approved for Development [ 10003 ] | In Development [ 10007 ] |
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 | WT-6931TestCases.xls [ 61983 ] |
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) |
Time Spent | 8h 25m [ 30300 ] | 12h 25m [ 44700 ] |
Worklog Id | 79798 [ 79798 ] |
Developer | Yogesh Chaudhari [ yogesh.chaudhari ] |
Production Due Date | 28/Sep/2017 | |
Stage Due Date | 25/Sep/17 [ 2017-09-25 ] |
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) |
Status | Local Testing [ 10200 ] | Pending for Stage Approval [ 10300 ] |
Status | Pending for Stage Approval [ 10300 ] | Approved for Stage [ 10030 ] |
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 | Approved for Stage [ 10030 ] | Stage Testing [ 10201 ] |
Time Spent | 12h 25m [ 44700 ] | 12h 55m [ 46500 ] |
Worklog Id | 105440 [ 105440 ] |
-
- Time Spent:
- 0.5h
-
Replied to email about check in date.
Production Due Date | 28/Sep/2017 | 05/Mar/2018 |
Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) | Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224) |
Labels | Export |
Status | Stage Testing [ 10201 ] | Pending for Production Approval [ 10301 ] |
Status | Pending for Production Approval [ 10301 ] | Approved for production [ 10034 ] |
Status | Approved for production [ 10034 ] | Production Testing [ 10202 ] |
Resolution | Done [ 10000 ] | |
Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
Resolution | Done [ 10000 ] | |
Status | Production Complete [ 10028 ] | Closed [ 6 ] |
Time Spent | 12h 55m [ 46500 ] | 13.25h [ 47700 ] |
Worklog Id | 107095 [ 107095 ] |
Comment |
[ Verified this enhancement on Production, Working as expected. CC-[~hrishikesh.deshpande][~rakeshr] ] |
Assignee | Smita Pawar [ smita.pawar ] | Sachin Hingole [ sachin.hingole ] |
Resolution | Done [ 10000 ] | |
Status | Closed [ 6 ] | Resolution Setting [ 11616 ] |
Transition | Time In Source Status | Execution Times |
---|
|
32m 58s | 1 |
|
266d 9h 49m | 2 |
|
4m 21s | 1 |
|
15d 1h 32m | 1 |
|
39s | 1 |
|
18d 19h 45m | 1 |
|
4s | 1 |
|
41d 6h 5m | 1 |
|
111d 23h 54m | 1 |
|
2s | 1 |
|
4s | 1 |
|
11s | 1 |
|
3s | 1 |
|
51d 12h 28m | 1 |
Hi All,
We have scanned Production and LB for mismatch in number of columns in main and history tables related export, attached Export_History_table_Count.xls
are the details. Below is short summary.
MasterCompanyDB
table ImportExportsettings_History has missing column IsACATemplate.
table ImportExportdeliveryInformation_History has missing column ServiceID
OnlineEnrollmentDB
table ImportExportGlobalTemplate_History has missing column IsACATemplate.
table ImportExportdeliveryInformation_History has missing column ServiceID
table ImportExportGlobaldeliveryInformation_History has missing column ServiceID
We have added serviceID columns in ImportExportDeliveryInformation_History and ImportExportGlobalDeliveryInformation_History tables. Nandkumar Prabhakar Karlekar/Revansiddha Gaur can you please look for IsACATemplate column?
Below are the affected files
/branches/LB/Database Objects/OnlineEnrollment/05_Triggers/OES_TR_trgUpdImportExportGlobalDeliveryInformation_History.Trigger.sql
/branches/LB/Database Objects/OnlineEnrollment/05_Triggers/OES_TR_trgUpdImportExportDeliveryInformation_History.Trigger.sql
/branches/LB/Database Objects/OnlineEnrollment/05_Triggers/OES_TR_trgInsImportExportGlobalDeliveryInformation_History.Trigger.sql
/branches/LB/Database Objects/OnlineEnrollment/05_Triggers/OES_TR_trgInsImportExportDeliveryInformation_History.Trigger.sql
/branches/LB/Database Objects/OnlineEnrollment/05_Triggers/OES_TR_trgDelImportExportGlobalDeliveryInformation_History.Trigger.sql
/branches/LB/Database Objects/OnlineEnrollment/05_Triggers/OES_TR_trgDelImportExportDeliveryInformation_History.Trigger.sql
/branches/LB/Database Objects/OnlineEnrollment/01_DDL/071_
WT-6931_WTB_Export_ModTable_ImportExportGlobalDeliveryInformation_History.sql/branches/LB/Database Objects/OnlineEnrollment/01_DDL/070_
WT-6931_WTB_Export_ModTable_ImportExportDeliveryInformation_History.sql/branches/LB/Database Objects/MasterCompanyDB/05_Triggers/OES_TR_trgUpdImportExportDeliveryInformation_History.Trigger.sql
/branches/LB/Database Objects/MasterCompanyDB/05_Triggers/OES_TR_trgInsImportExportDeliveryInformation_History.Trigger.sql
/branches/LB/Database Objects/MasterCompanyDB/05_Triggers/OES_TR_trgDelImportExportDeliveryInformation_History.Trigger.sql
/branches/LB/Database Objects/MasterCompanyDB/01_DDL/377_
WT-6931_WTB_Export_ModTable_ImportExportDeliveryInformation_History.sql