[WT-6931] Need to check all export related main table and history table columns are in sync - Workterra Jira

Details

Type: Enhancement
Status: Resolution Setting
Priority: High
Resolution: Done
Affects Version/s: None
Fix Version/s: None
Component/s: None
Labels:
- Export

Module:
ACA
Reported by:
Harbinger
Item State:
Stage QA - Production Deployment on Hold

Description

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

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

Export_History_table_Count.xls
31 kB
07/Dec/16 12:48 PM
WT-6931TestCases.xls
14 kB
19/Sep/17 01:02 PM

Issue Links

relates to

WT-10995 ACA_Waive implementation_Employee record count is not matching on Cloned and existing template

Closed

Activity

Ascending order - Click to sort in descending order

Rakesh Shahane (Inactive) created issue - 07/Dec/16 12:01 AM

Rakesh Shahane (Inactive) made changes - 07/Dec/16 12:01 AM

Field	Original Value	New Value
Assignee	Vijay Siddha [ vijays ]	Rohan Khandave [ rohan.khandave ]

Rakesh Shahane (Inactive) made changes - 07/Dec/16 12:11 AM

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]

Vijayendra Shinde (Inactive) made changes - 07/Dec/16 12:30 AM

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]

Vijayendra Shinde (Inactive) made changes - 07/Dec/16 12:31 AM

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 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]

Vinayak Kulkarni (Inactive) made changes - 07/Dec/16 12:21 PM

Assignee	Rohan Khandave [ rohan.khandave ]	Vinayak Kulkarni [ vinayak.kulkarni ]
Status	Open [ 1 ]	In Progress [ 3 ]

Vinayak Kulkarni (Inactive) made changes - 07/Dec/16 12:48 PM

Attachment

Export_History_table_Count.xls [ 34609 ]

Vinayak Kulkarni (Inactive) made changes - 07/Dec/16 12:52 PM

Assignee

Vinayak Kulkarni [ vinayak.kulkarni ]

Nandkumar [ satyap ]

Vinayak Kulkarni (Inactive) made changes - 07/Dec/16 12:54 PM

Status

In Progress [ 3 ]

Open [ 1 ]

Vinayak Kulkarni (Inactive) made changes - 07/Dec/16 02:14 PM

Remaining Estimate		5h [ 18000 ]
Original Estimate		5h [ 18000 ]

Vinayak Kulkarni (Inactive) made changes - 07/Dec/16 02:14 PM

Remaining Estimate	5h [ 18000 ]	1.5h [ 5400 ]
Time Spent		3.5h [ 12600 ]
Worklog Id	12014 [ 12014 ]

Khandu Kshirsagar (Inactive) made changes - 08/Dec/16 06:39 AM

Item State

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Vinayak Kulkarni (Inactive) made changes - 01/Feb/17 05:28 PM

Module

Parent values: BenAdmin(10100)Level 1 values: Export(10110)

Parent values: ACA(10104)

Nandkumar Prabhakar Karlekar (Inactive) made changes - 02/Feb/17 05:50 AM

Assignee

Nandkumar [ satyap ]

Revansiddha Gaur [ revansiddha.gaur ]

Revansiddha Gaur (Inactive) made changes - 07/Feb/17 06:52 AM

Remaining Estimate	1.5h [ 5400 ]	1h 20m [ 4800 ]
Time Spent	3.5h [ 12600 ]	3h 40m [ 13200 ]
Worklog Id	23426 [ 23426 ]

Revansiddha Gaur (Inactive) made changes - 20/Mar/17 07:36 AM

Assignee

Revansiddha Gaur [ revansiddha.gaur ]

Kumar Chhajed [ kumar.chhajed ]

Kumar Chhajed (Inactive) made changes - 03/Jul/17 01:33 PM

Assignee

Kumar Chhajed [ kumar.chhajed ]

Revansiddha Gaur [ revansiddha.gaur ]

Revansiddha Gaur (Inactive) made changes - 14/Aug/17 05:49 AM

Assignee

Revansiddha Gaur [ revansiddha.gaur ]

Yogesh Chaudhari [ yogesh.chaudhari ]

Yogesh Chaudhari (Inactive) made changes - 29/Aug/17 09:36 AM

Remaining Estimate	1h 20m [ 4800 ]	0h [ 0 ]
Time Spent	3h 40m [ 13200 ]	7h 10m [ 25800 ]
Worklog Id		74775 [ 74775 ]

Revansiddha Gaur (Inactive) made changes - 29/Aug/17 01:27 PM

Time Spent	7h 10m [ 25800 ]	7h 25m [ 26700 ]
Worklog Id		74873 [ 74873 ]

Yogesh Chaudhari (Inactive) made changes - 30/Aug/17 11:23 AM

Status

Open [ 1 ]

In Progress [ 3 ]

Yogesh Chaudhari (Inactive) made changes - 30/Aug/17 11:27 AM

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 ]

Yogesh Chaudhari (Inactive) made changes - 30/Aug/17 11:28 AM

Code Review Date		29/Aug/2017
Code Reviewed By		Revansiddha [ 13002 ]

Yogesh Chaudhari (Inactive) made changes - 30/Aug/17 02:18 PM

Assignee

Yogesh Chaudhari [ yogesh.chaudhari ]

Smita Pawar [ smita.pawar ]

Yogesh Chaudhari (Inactive) made changes - 31/Aug/17 10:27 AM

Time Spent	7h 25m [ 26700 ]	8h 25m [ 30300 ]
Worklog Id		76030 [ 76030 ]

Sachin Hingole (Inactive) made changes - 14/Sep/17 01:00 PM

Status

Approved for Development [ 10003 ]

In Development [ 10007 ]

Sachin Hingole (Inactive) made changes - 14/Sep/17 01:01 PM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Sachin Hingole (Inactive) made changes - 14/Sep/17 01:01 PM

Item State

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Smita Pawar (Inactive) made changes - 19/Sep/17 01:02 PM

Attachment

WT-6931TestCases.xls [ 61983 ]

Smita Pawar (Inactive) made changes - 19/Sep/17 01:03 PM

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)

Smita Pawar (Inactive) made changes - 19/Sep/17 01:15 PM

Time Spent	8h 25m [ 30300 ]	12h 25m [ 44700 ]
Worklog Id		79798 [ 79798 ]

Smita Pawar (Inactive) made changes - 20/Sep/17 10:10 AM

Developer

Yogesh Chaudhari [ yogesh.chaudhari ]

Smita Pawar (Inactive) made changes - 20/Sep/17 10:18 AM

Production Due Date		28/Sep/2017
Stage Due Date		25/Sep/17 [ 2017-09-25 ]

Khandu Kshirsagar (Inactive) made changes - 03/Oct/17 07:58 AM

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)

Smita Pawar (Inactive) made changes - 03/Oct/17 08:47 AM

Status

Local Testing [ 10200 ]

Pending for Stage Approval [ 10300 ]

Smita Pawar (Inactive) made changes - 03/Oct/17 08:47 AM

Status

Pending for Stage Approval [ 10300 ]

Approved for Stage [ 10030 ]

Smita Pawar (Inactive) made changes - 03/Oct/17 08:47 AM

Item State

Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)

Parent values: Stage QA(10202)Level 1 values: In Testing(10214)

Smita Pawar (Inactive) made changes - 13/Nov/17 01:52 PM

Status

Approved for Stage [ 10030 ]

Stage Testing [ 10201 ]

Ramya Tantry (Inactive) made changes - 23/Nov/17 11:58 AM

Link

This issue relates to ~~WT-10995~~ [ ~~WT-10995~~ ]

Revansiddha Gaur (Inactive) made changes - 21/Feb/18 11:47 AM

Time Spent	12h 25m [ 44700 ]	12h 55m [ 46500 ]
Worklog Id		105440 [ 105440 ]

Rakesh Roy (Inactive) made changes - 22/Feb/18 09:50 AM

Production Due Date

28/Sep/2017

05/Mar/2018

Rakesh Roy (Inactive) made changes - 22/Feb/18 10:13 AM

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)

Rakesh Roy (Inactive) made changes - 26/Feb/18 06:36 AM

Labels

Export

Swapnil Eksambekar (Inactive) made changes - 05/Mar/18 01:46 PM

Status

Stage Testing [ 10201 ]

Pending for Production Approval [ 10301 ]

Swapnil Eksambekar (Inactive) made changes - 05/Mar/18 01:46 PM

Status

Pending for Production Approval [ 10301 ]

Approved for production [ 10034 ]

Swapnil Eksambekar (Inactive) made changes - 05/Mar/18 01:46 PM

Status

Approved for production [ 10034 ]

Production Testing [ 10202 ]

Swapnil Eksambekar (Inactive) made changes - 05/Mar/18 01:47 PM

Resolution		Done [ 10000 ]
Status	Production Testing [ 10202 ]	Production Complete [ 10028 ]

Swapnil Eksambekar (Inactive) made changes - 05/Mar/18 01:47 PM

Resolution	Done [ 10000 ]
Status	Production Complete [ 10028 ]	Closed [ 6 ]

Swapnil Eksambekar (Inactive) made changes - 05/Mar/18 01:47 PM

Time Spent	12h 55m [ 46500 ]	13.25h [ 47700 ]
Worklog Id		107095 [ 107095 ]

Swapnil Eksambekar (Inactive) made changes - 06/Mar/18 05:03 AM

Comment

[ Verified this enhancement on Production,
Working as expected.

CC-[~hrishikesh.deshpande][~rakeshr]
]

Sachin Hingole (Inactive) made changes - 12/Apr/18 11:06 PM

Assignee

Smita Pawar [ smita.pawar ]

Sachin Hingole [ sachin.hingole ]

Sachin Hingole (Inactive) made changes - 26/Apr/18 03:15 AM

Resolution		Done [ 10000 ]
Status	Closed [ 6 ]	Resolution Setting [ 11616 ]

People

Assignee:: Sachin Hingole (Inactive)

Reporter:: Rakesh Shahane (Inactive)

Developer:: Yogesh Chaudhari (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 07/Dec/16 12:01 AM

Updated:: 26/Apr/18 03:15 AM

Resolved:: 26/Apr/18 03:15 AM

Pre-Prod Due Date:: 25/Sep/2017

Production Due Date:: 05/Mar/2018

Code Review Date:: 29/Aug/2017

Time Tracking

Estimated:

Remaining:

Logged:

13.25h