locked
Error while converting packages from Oracle to SQL Server Azure RRS feed

  • Question

  • Hello Everyone.

    I am migrating from Oracle 11 to SQL Server Azure using SSMA v7.11.0 and while migrating package XXXX getting the below error.

    Converting packaged-procedure APPOWNER.XXXXX.YYYYYY ...
     Errors: O2SS0004: Unparsed SQL [] cannot be converted.

    Can anyone help me resolve the issue ASAP

    Regards,

    Poonam Singh V

    Monday, September 16, 2019 2:06 PM

All replies

  • using SSMA v7.11.0

    That version is very old, better use the latest version 8.4: Microsoft SQL Server Migration Assistant 8.4 for Oracle

    Olaf Helper

    [ Blog] [ Xing] [ MVP]


    Monday, September 16, 2019 2:28 PM
  • You mean... if I upgrade to 8.4 version... the issue would be resolved. Please confirm
    Tuesday, September 17, 2019 11:41 AM
  • The same issue even after upgrading to 8.4

    Oracle Server Object Collector error: package : XXXXX
         No package body statement was found in package 'XXXXX'. This might be caused by a parsing error.
    Refreshing from database is complete.

    I am unable to migrate any package due to this error

    Oracle : 11

    Azure SQL Server 

    Tuesday, September 17, 2019 2:41 PM
  • Hello,

    Can you please reach out to us through a Help -> Feedback within SSMA tool so that we can get more details?

    From the error message - SSMA cannot extract PL/SQL for the package. It might be a permission issue or something else specific to your environment.

    Thanks and regards,
    Alex.

    Monday, September 23, 2019 5:14 PM