Remodeling the record (LOG) of Migration of Release/Version

Product:

Microsiga Protheus

Versions:

12

Step by Step:

The LOG table of Migration of Version/Release records several types of events occurred during the process of migration. (Migration of version via MP710TO120 or Migration of Release in the version 12 via UPDDISTR).

The log can be accessed at the end of the migration process or when resuming the process after validation or failure.

A remodeling of table and query tool was executed making the task to query altered data or the verification of inconsistencies in the process easier and more productive.

We highlight the main changes:

• Transfer of MPUPDLOG table to the SQL database in environments with SQL database
• Better performance of insertion in relation to the CTREE table
• Creation of new non-textual fields (columns) enabling an easier, faster and safer filter of data (dictionary, severity, key, attribute, release of departure, release of arrival)
• Creation of a new severity column. Severity is calculated in a different way for each field, dictionary and content updated.
• Creation of indexes for the most important columns.
• Creation of customized filters for the most common operations (per dictionary, today's date, per severity)
• Creation of customized filters by using the LOG table fields
• Remodeling of the view "browser", with a broader view area (size adjusted to resolution), larger font, description more representative of columns.
• Printer of browser via TReport, with better reports. 
  
  
  Columns available in the LOG 

Column

Description

Severity 

Column informing the level of impact of a given occurrence. The level of impact is calculated in a different way per type of occurrence, dictionary, altered column, previous data and current data. 

Date

Date of occurrence. The date of Protheus applications server is considered

Time

Schedule of occurrence in HH:MM:SS.mmm format (hour:minutes:seconds:milliseconds). The schedule of Protheus applications server is considered. Data imported of the former table of LOG does not have milliseconds

Operation

Classifier of operation executed. Example: Inclusion

Group of companies

Group of companies related to LOG generated

Task

Code of task executed. Example: Task 05, updating of SX3 dictionary

Description

Description in text format (not codified) of the action executed

Former Value

Content of attribute before update

New Value

Content of attribute after update

Table

Table updated (dictionary). Example: SX3. Not available in data imported of former model LOG.

Table Description

Table description. Example: Data Dictionary. Not available in data imported of former model LOG.

Key

Key that identifies the record. Example: A1_COD. Not available in data imported of former model LOG.

Attribute

Propriety altered. Example: X3_VALID. Not available in data imported of former model LOG.

Attribute description

Propriety description (Example: Validation of System). Not available in data imported of former model LOG.

Release of entry

Release starting migration. Not available in data imported of former model LOG.

Release of arrival

Release object of migration. Not available in data imported of former model LOG.

Event

Event code. Example: 073