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)

Archived Discussions


Effective March 31st, we will no longer engage on PostgresRocks.


How to engage with us further?


  • Thought Leadership: EDB Blogs

  • Tips and Tricks: Postgres Tutorials

  • Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket

  • Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.

© 2019 EnterpriseDB Corporation. All rights reserved.   |   Privacy Policy   |  Terms of Use   |   Trademarks