WORKTERRAProject Type: software

WORKTERRA

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

          relates to

          Bug - A problem which impairs or prevents the functions of the product. WT-10995 ACA_Waive implementation_Employee record count is not matching on Cloned and existing template

          • Medium - Has the potential to affect progress.
          • Closed

            Activity

            Descending order - Click to sort in ascending order
            Hide
            Permalink
            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
            Hide
            Permalink
            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.
            Hide
            Permalink
            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
            Hide
            Permalink
            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
            Hide
            Permalink
            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?
            Hide
            Permalink
            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

              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