Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-6931

Need to check all export related main table and history table columns are in sync

    Details

    • 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

      Description

      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

        Attachments

          Issue Links

            Activity

            rakesh.shahane Rakesh Shahane (Inactive) created issue -
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            Field Original Value New Value
            Assignee Vijay Siddha [ vijays ] Rohan Khandave [ rohan.khandave ]
            rakesh.shahane Rakesh Shahane (Inactive) made changes -
            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 Vijayendra Shinde (Inactive) made changes -
            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]
            vijayendra Vijayendra Shinde (Inactive) made changes -
            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]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Assignee Rohan Khandave [ rohan.khandave ] Vinayak Kulkarni [ vinayak.kulkarni ]
            Status Open [ 1 ] In Progress [ 3 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Attachment Export_History_table_Count.xls [ 34609 ]
            Hide
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            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

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - 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
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Assignee Vinayak Kulkarni [ vinayak.kulkarni ] Nandkumar [ satyap ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Status In Progress [ 3 ] Open [ 1 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 07/Dec/16 02:14 PM
            • Time Spent:
              3.5h
               
              <No comment>
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Remaining Estimate 5h [ 18000 ]
            Original Estimate 5h [ 18000 ]
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Remaining Estimate 5h [ 18000 ] 1.5h [ 5400 ]
            Time Spent 3.5h [ 12600 ]
            Worklog Id 12014 [ 12014 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            Hide
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            Hi Nandkumar Prabhakar Karlekar Any update on this?

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Nandkumar Prabhakar Karlekar Any update on this?
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
            Module Parent values: BenAdmin(10100)Level 1 values: Export(10110) Parent values: ACA(10104)
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Assignee Nandkumar [ satyap ] Revansiddha Gaur [ revansiddha.gaur ]
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - - edited

            Hi Nandkumar Prabhakar Karlekar,

            As per dicussion with you, This task is on low priority and whenever I will get the free time will focus on this task.

            Regards,
            Revan

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - - edited Hi Nandkumar Prabhakar Karlekar , As per dicussion with you, This task is on low priority and whenever I will get the free time will focus on this task. Regards, Revan
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 06/Feb/17 10:00 PM
            • Time Spent:
              10m
               

              Internal discussion with Nandkumar for priority.

            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 1.5h [ 5400 ] 1h 20m [ 4800 ]
            Time Spent 3.5h [ 12600 ] 3h 40m [ 13200 ]
            Worklog Id 23426 [ 23426 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Kumar Chhajed [ kumar.chhajed ]
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Assignee Kumar Chhajed [ kumar.chhajed ] Revansiddha Gaur [ revansiddha.gaur ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Yogesh Chaudhari [ yogesh.chaudhari ]
            Hide
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Hi Vinayak Kulkarni

            As per above comments, we are going to add only one column ISACATemplate in ImportExportSettings_History table and will make respective changes required for that column.
            So we will not scanned again export related data table.

            Thanks,
            Yogesh Chaudhari

            Nandkumar Prabhakar KarlekarNandkumar Prabhakar KarlekarSmita Pawar

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Hi Vinayak Kulkarni As per above comments, we are going to add only one column ISACATemplate in ImportExportSettings_History table and will make respective changes required for that column. So we will not scanned again export related data table. Thanks, Yogesh Chaudhari Nandkumar Prabhakar Karlekar Nandkumar Prabhakar Karlekar Smita Pawar
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 22/Aug/17 09:35 AM
            • Time Spent:
              3.5h
               

              Added ISACATemplate Column in History table and made changes in database Triggers.

              Completed Unit Testing

            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Remaining Estimate 1h 20m [ 4800 ] 0h [ 0 ]
            Time Spent 3h 40m [ 13200 ] 7h 10m [ 25800 ]
            Worklog Id 74775 [ 74775 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 29/Aug/17 10:27 AM
            • Time Spent:
              1h
               

              Unit testing code review and discussion with Revan

            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Time Spent 7h 10m [ 25800 ] 7h 25m [ 26700 ]
            Worklog Id 74873 [ 74873 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 29/Aug/17 09:00 PM
            • Time Spent:
              0.25h
               

              Code Review

            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            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 Yogesh Chaudhari (Inactive) made changes -
            Code Review Date 29/Aug/2017
            Code Reviewed By Revansiddha [ 13002 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Assignee Yogesh Chaudhari [ yogesh.chaudhari ] Smita Pawar [ smita.pawar ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Time Spent 7h 25m [ 26700 ] 8h 25m [ 30300 ]
            Worklog Id 76030 [ 76030 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Approved for Development [ 10003 ] In Development [ 10007 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned change request on LB.
            Its working fine.
            PFA test cases and testing status.
            Enhancement is ready for Stage.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned change request on LB. Its working fine. PFA test cases and testing status. Enhancement is ready for Stage.
            smita.pawar Smita Pawar (Inactive) made changes -
            Attachment WT-6931TestCases.xls [ 61983 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            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 Smita Pawar (Inactive) logged work - 19/Sep/17 01:15 PM
            • Time Spent:
              4h
               

              Lb testing

            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 8h 25m [ 30300 ] 12h 25m [ 44700 ]
            Worklog Id 79798 [ 79798 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Developer Yogesh Chaudhari [ yogesh.chaudhari ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Production Due Date 28/Sep/2017
            Stage Due Date 25/Sep/17 [ 2017-09-25 ]
            khandu.kshirsagar 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)
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            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 Smita Pawar (Inactive) made changes -
            Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Link This issue relates to WT-10995 [ WT-10995 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Time Spent 12h 25m [ 44700 ] 12h 55m [ 46500 ]
            Worklog Id 105440 [ 105440 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 21/Feb/18 10:00 PM
            • Time Spent:
              0.5h
               

              Replied to email about check in date.

            rakeshr Rakesh Roy (Inactive) made changes -
            Production Due Date 28/Sep/2017 05/Mar/2018
            rakeshr Rakesh Roy (Inactive) made changes -
            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)
            rakeshr Rakesh Roy (Inactive) made changes -
            Labels Export
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Status Approved for production [ 10034 ] Production Testing [ 10202 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) logged work - 05/Mar/18 01:47 PM
            • Time Spent:
              20m
               
              <No comment>
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Production Complete [ 10028 ] Closed [ 6 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Time Spent 12h 55m [ 46500 ] 13.25h [ 47700 ]
            Worklog Id 107095 [ 107095 ]
            swapnil.eksambekar Swapnil Eksambekar (Inactive) made changes -
            Comment [ Verified this enhancement on Production,
            Working as expected.


            CC-[~hrishikesh.deshpande][~rakeshr]
            ]
            Hide
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment -

            Verified all scenarios mentioned in test cases ,

            • MasterCompanyDB
              Verified
              table ImportExportsettings_History has column IsACATemplate. - Pass
              table ImportExportdeliveryInformation_History has column ServiceID - Pass
            • OnlineEnrollmentDB
              table ImportExportGlobalTemplate_History has column IsACATemplate.- Pass
              table ImportExportdeliveryInformation_History has column ServiceID- Pass
              table ImportExportGlobaldeliveryInformation_History has column ServiceID- Pass

            It is working as expected.

            CC-Hrishikesh DeshpandeRakesh Roy

            Show
            swapnil.eksambekar Swapnil Eksambekar (Inactive) added a comment - Verified all scenarios mentioned in test cases , MasterCompanyDB Verified table ImportExportsettings_History has column IsACATemplate. - Pass table ImportExportdeliveryInformation_History has column ServiceID - Pass OnlineEnrollmentDB table ImportExportGlobalTemplate_History has column IsACATemplate.- Pass table ImportExportdeliveryInformation_History has column ServiceID- Pass table ImportExportGlobaldeliveryInformation_History has column ServiceID- Pass It is working as expected. CC- Hrishikesh Deshpande Rakesh Roy
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Sachin Hingole [ sachin.hingole ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Closed [ 6 ] Resolution Setting [ 11616 ]
            Transition Time In Source Status Execution Times
            Vinayak Kulkarni (Inactive) made transition -
            In Progress Open
            32m 58s 1
            Yogesh Chaudhari (Inactive) made transition -
            Open In Progress
            266d 9h 49m 2
            Yogesh Chaudhari (Inactive) made transition -
            In Progress Approved for Development
            4m 21s 1
            Sachin Hingole (Inactive) made transition -
            Approved for Development In Development
            15d 1h 32m 1
            Sachin Hingole (Inactive) made transition -
            In Development In LB Testing
            39s 1
            Smita Pawar (Inactive) made transition -
            In LB Testing Pending for Stage Approval
            18d 19h 45m 1
            Smita Pawar (Inactive) made transition -
            Pending for Stage Approval Approved for Stage
            4s 1
            Smita Pawar (Inactive) made transition -
            Approved for Stage Stage Testing
            41d 6h 5m 1
            Swapnil Eksambekar (Inactive) made transition -
            Stage Testing Pending for Production Approval
            111d 23h 54m 1
            Swapnil Eksambekar (Inactive) made transition -
            Pending for Production Approval Approved for production
            2s 1
            Swapnil Eksambekar (Inactive) made transition -
            Approved for production In Production Testing
            4s 1
            Swapnil Eksambekar (Inactive) made transition -
            In Production Testing Production Complete
            11s 1
            Swapnil Eksambekar (Inactive) made transition -
            Production Complete Closed
            3s 1
            Sachin Hingole (Inactive) made transition -
            Closed Resolution Setting
            51d 12h 28m 1

              People

              Assignee:
              sachin.hingole Sachin Hingole (Inactive)
              Reporter:
              rakesh.shahane Rakesh Shahane (Inactive)
              Developer:
              Yogesh Chaudhari (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Pre-Prod Due Date:
                Production Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 5h Original Estimate - 5h
                  5h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 13.25h
                  13.25h