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.
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.
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.
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.
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.
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.
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?
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
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
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.
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
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.
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
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