After migrate helper (FHCA-4070)

Description

Idea is to create a Window or Report or Info Window that can help to identify problems after applying migration scripts, initially two simple things to show here:

  • Verify if all records in AD_ChangeLog marked as Customization correspond with the database value

    • here could be possible to add a button to "re-apply" the change, but the tricky part is that some String changes need to be reapplied as concatenation and others as replacement

  • Verify if additional columns (or maybe simply all columns) in views and indexes exist in database

    • here we can add a button to recreate the view

Environment

None

Activity

Carlos Ruiz 
September 27, 2023 at 3:19 PM

Reopening to improve the validation of views.

After a migration is possible that views are incomplete (f.e. postgresql errors that cannot drop columns of a view)

Carlos Ruiz 
January 13, 2023 at 9:56 PM

Documented at:

Carlos Ruiz 
March 15, 2022 at 9:44 AM

xref → https://mattermost.idempiere.org/idempiere/pl/xr1r4zignty5xr155mfwnpwxjh

Ideas from

  • add a preference "Is Customization" - if I check that preference then the change log records will be saved with IsCustomization=Y

  • add a SavedSearch in Change Log to identify them easily

Fixed

Details

Assignee

Reporter

Fix versions

Priority

Created March 15, 2022 at 9:21 AM
Updated November 1, 2023 at 11:07 AM
Resolved October 1, 2023 at 10:08 AM