cancel
Showing results for 
Search instead for 
Did you mean: 

Objects failed to transform during assessment

Accepted Solution

Objects failed to transform during assessment

What can I do when some of my objects failed to transform during assessment?

Accepted Solutions (1)

Accepted Solutions (1)

Community Manager
Solution

 

The EDB Postgres Migration Portal Repair handler manages the incompatibilities between Oracle and EDB Postgres. In case, of errors you can check the error details in the Assessment output, and based on the error type, you can take one of the following options:

  • Apply the fix and run the assessment.
  • Refer to the Knowledge Base table to resolve the error. (link)
  • Refer to the online documentation to resolve the error. (link)
  • In case you do not find a solution in the Knowledge Base and the online documentation, you can post your query on the PostgresRocks.com forum, and the EDB team member will respond with a possible solution.

 

In the following example, a table with a column named PARTITION is used to remove the incompatibility between Oracle and EDB Postgres. However, EDB Postgres does not support PARTITION.

To remove the incompatibilities complete the following steps:
 

1. Create a project in EDB Postgres Migration Portal and load the extracted script from Oracle.


Screen Shot 2018-08-04 at 8.07.42 AM.png

2. Run the assessment. In case, the assessment fails, check the error details.


Screen Shot 2018-08-04 at 8.08.49 AM.png

3. EDB Postgres does support table column named PARTITION. You must enclose PARTITION in double quotes and click ASSESS.
Following image displays a successful transformation.

Screen Shot 2018-08-04 at 8.09.37 AM.png

Answers (0)

Ask a Question