Release Announcement Migration Portal 3.1.0

Highlights

Type

Asynchronous/Parallel assessment 

Use multiple browser tabs to work on multiple projects simultaneously and run assessments in parallel with completion notifications. 

Feature

Detect function/procedure names from the packages which are not supported in EDB Postgres Advanced Server. For example, 'Incompatible function/package found : UTL_FILE.GET_RAW', giving a better understanding of error and the migration efforts required. [Support Ticket 1242297]

Enhancement

Restructured schema assessment report for enhanced readability along with consolidated information about the incompatible functions/packages.

Enhancement

Refined object search and filter experience. 

Enhancement

ERH-2055 - UNSUPPORTED_USING_INDEX_CLAUSE

Updated this such that it does not remove GLOBAL indexes from the table definition

Repair Handler Enhancement

ERH-1012 - INSERT_STATEMENT_ALIAS

Modified as it was not firing for scenarios where INSERT statements contained the SELECT statement

Repair Handler Enhancement

ERH-2090 - CONVERT_FUNCTION

Enhanced the performance for large DDLs

Repair Handler Enhancement

ERH-2027 - SESSION_GLOBAL_SEQUENCE

Enhanced the accuracy so that it functions correctly for additional variations within DDL

Repair Handler Enhancement

ERH-2079 - GLOBAL_PARTITIONED_INDEX

Removed this so that Global Partitioned Indexes will not be removed

Repair Handler Removal

Workaround for Oracle SQLERRM function - The SQLERRM() function returns the error message associated with the most recently raised error exception.  You may use EDB Postgres Advanced Server supported SQLCODE and SQLERRM variables in the exception block to get similar results.

Knowledge Base Addition

Workaround for Oracle SQLCODE function - In PL/SQL blocks, the SQLCODE can be used for getting numeric code of exception, in EDB Postgres Advanced Server you can create a custom function which can return numeric value of error.

Knowledge Base Addition

Value assignment with %type operator for TYPE definition inside package - This syntax is supported starting with EDB Postgres Advanced Server 12, hence we recommend upgrading to EDB Postgres Advanced Server 12 or above to resolve this error.

Knowledge Base Addition

Global Indexes - Global Indexes map one index to multiple partitioned tables. There can be multiple workarounds, for example, aligning partitioning keys across all referencing and referenced tables.

Knowledge Base Addition

Workaround for NESTED Table - In EDB Postgres Advanced Server, ARRAY can be used to achieve the same kind of functionality.

Knowledge Base Addition

Method Overloading - In Oracle, users can overload the method inside the package by changing the name of the arguments. In EDB Postgres Advanced Server, users should change the argument type to overload a method. 

Knowledge Base Addition

For very large DDLs, Migration Portal was getting stuck in between assessments. This issue has been resolved now.

Bug

In the delete project dialogue box, the user could focus on other items on the projects page. Other minor issues related to delete functionality are also fixed in this release.

Bug

Few issues pertaining to the keyboard navigation in the Migration Portal are fixed.

Bug

While reassessing an object and refreshing the object tree and filters, Migration portal showed the incorrect object status. This is fixed now. Also, other minor issues related to tree search and reassessments are fixed in this release.

Bug

Repair handler ERH-1006 was not firing for some PL/SQL objects having more than one error. This is fixed now. 

Bug

Even though the schema file was not uploaded successfully, projects were created. This issue is resolved now.

Bug

What’s New section Bookmarks are now visible on smaller resolutions as well.

Bug

Minor issues pertaining to the bread crumb selection functionality are fixed now.

Bug

The “Contact Us” form was not working for new users from the quick help section. 

Bug

Issues linked to the reports, such as overlapping failed object sections (for large DDL reports), having two to three extra blank pages at the end (for very large DDLs), and few other items are fixed now. 

Bug

Resolved a bug causing the Migration Portal to occasionally only partially complete assessments.

Bug

While uploading a duplicate DDL and switching between projects, the Upload DDL button and the schema area were disabled. This issue has been fixed now.

Bug