Edit

Troubleshoot Database Migration Assessment for Oracle extension errors

  • Article

This article explains how to determine, diagnose, and fix issues/errors you might encounter when using Database Migration Assessment for Oracle extension.

Troubleshoot

To troubleshoot any Database Migration Assessment for Oracle extension issue, you should find the details about the error and warnings from the logs generated. Refer to this section to access the logs.

Logs

The extension stores errors, warnings, and other diagnostic logs in the default log directory:

  • Windows - C:\Users\<username>.dmaoracle\logs\
  • Linux - ~/.dmaoracle/logs
  • macOS - /Users/<username>/.dmaoracle/logs

Note

By default, the extension stores the last seven log files. To change the log directory, update the LogDirectory property in the extension settings file.

Operating system Path
Windows C:\Users\<username>\.azuredatastudio\extensions\microsoft.azuredatastudio-dma-oracle-<VersionNumber>\bin\service\Properties\ConfigSettings\extension-settings.json
Linux ~/.azuredatastudio/extensions/microsoft.azuredatastudio-dma-oracle-/<VersionNumber>/bin/service/Properties/ConfigSettings/extension-settings.json
macOS /Users/<username>/.azuredatastudio/extensions/microsoft.azuredatastudio-dma-oracle-/<VersionNumber>/bin/service/Properties/ConfigSettings/extension-settings.json

Error Codes Details

The below section gives you more details about error codes, messages, possible causes, and their respective remediation actions.

Error Code: FSMB-0001

Error Message: Failed to access assessment data.

Possible causes: This error may appear due to any of the given reasons:

  1. The user may need the appropriate permission to access the assessment data folder.
  2. The assessment data folder doesn't exist or is in use by another program.

Remediation actions: Ensure the logged-in user has read and write permissions on the assessment data folder. If you've changed the assessment data folder path, check that the current assessment path mentioned in the extension settings is correct.

Error Code: GE-0000

Possible causes: Error Message: The data collection failed with an unknown error. Try creating a new assessment.

Possible causes: This error is generic and may appear for multiple reasons.

Remediation actions: Try to create a new assessment. To investigate further, go through the logs to understand the reason for the error. If the issue persists, contact Microsoft for help.

Error Code: FSMB-0002

Error Message: Failed to parse the assessment data. A metadata file is either corrupted or modified externally. Try creating a new assessment.

Possible causes: This error may appear due to any of the given reasons:

  1. The metadata file is either corrupted or modified externally.
  2. Parsing of metadata file couldn't be done correctly.

Remediation actions: You may have to delete the current assessment and then try creating a new assessment. If the issue persists, contact Microsoft for help.

Error Code: FSMB-0003

Error Message: Failed to save the assessment output with a file system error.

Possible causes: This error may appear due to any of the given reasons:

  1. The user may not have the appropriate permission to access the assessment data folder.
  2. The assessment data folder is already in use by another program.

Remediation actions: Ensure the logged-in user has read and write permissions to the assessment data folder. In case you've changed the assessment data folder path, check the current assessment path mentioned in the extension settings is correct and exists. Try to create a new assessment after closing any open assessment file(s).

Error Code: ODC-1000

Error Message: Failed to collect required data with an underlying Oracle exception - {ORA error}. Check Oracle documentation for this error code.

Possible causes: Assessment failed due to an underlying Oracle error - {ORA error}.

Remediation actions: You may need to refer to Oracle documentation to resolve this issue. If the issue persists, contact Microsoft for help.

Error Code: FSRP-0001

Error Message: A terminal error occurred - failed to access lookup data. A lookup file is either deleted or corrupted. Reinstall the extension and try again.

Possible causes: This error may appear due to any of the given reasons:

  1. The lookup metadata file is either deleted or corrupted.
  2. The lookup metadata file is already in use by another program.

Remediation actions: Try reinstalling the extension, close any open assessment file(s), and create a new assessment. If the issue persists, contact Microsoft for help.

Error Code: GE-2000

Error Message: Failed to process the AWR report with an unknown error.

Possible causes: This error may appear due to issue(s) in parsing the AWR report provided by the user.

Remediation actions: Try to create a new assessment with another AWR report. Also, run the assessment while connected to the Oracle instance. If the issue persists, contact Microsoft for help.

Error Code: ODC-1002

Error Message: Connection timed out to the Oracle server. Navigate to the connections panel and refresh the connection to the Oracle server.

Possible causes: This error may appear due to any of the given reasons:

  1. Oracle server connection terminated forcefully or timed out.
  2. Network connectivity to the Oracle server is unstable or lost.

Remediation actions: Try to reconnect to the Oracle server or refresh the connection. Ping the Oracle server to check the network connectivity between your machine and the Oracle server is stable. Check if the timeout parameters are correctly set in sqlnet. ora file. For more information, see Oracle documentation for the ORA-03135 error.

Error Code: SQLA-3001

Error Message: SKU recommendation for Azure SQL target platform failed with an unknown error.

Possible causes: The SKU recommendation failed to process the performance data.

Remediation actions: Try to create a new assessment. To investigate further, go through the logs to understand the reason for the error. If the issue persists, contact Microsoft for help.

Error Code: AWR-0001

Error Message: The specified AWR report version doesn't match with the connected Oracle server. Run a new assessment with an AWR report of the same server.

Possible causes: The version of the Oracle instance in the AWR report differs from that of the connected Oracle server.

Remediation actions: You must upload the correct AWR report for the connected oracle server so that the AWR report and Oracle instance's version match and then try to run a new assessment. If the issue persists, contact Microsoft for help.

Error Code: AWR-0002

Error Message: Uploaded report isn't a valid AWR report. Run a new assessment with a valid AWR report of the connected server.

Possible causes: The name of the Oracle instance in the AWR report differs from the connected Oracle server.

Remediation actions: You must upload the correct AWR report for the connected Oracle server so that the AWR report and Oracle instance's name matches and then try to run a new assessment. If the issue persists, contact Microsoft for help.

Error Code: ORADA-1002

Error Message: Assessment failed as it received an invalid value={invalid value} for metric name={metric name} from the Oracle server.

Possible causes: This error may appear due to any of the given reasons:

  1. The performance data available in the Oracle server is invalid.
  2. The collected performance data file is corrupted or modified externally.

Remediation actions: Try to create a new assessment. To investigate further, go through the logs to understand the reason for the error. If the issue persists, contact Microsoft for help.

Error Code: DBNS-0000

Error Message: Assessment failed as {0} database running on {1} platform with version {2} is unsupported. For supported versions, refer to aka.ms/prereq.

Possible causes: Database Migration Assessment for Oracle extension supports 10 g or higher Oracle versions.

Remediation actions: Try to create a new assessment on a supported version of the Oracle server. The current version is unsupported. Refer to prerequisites.

Error Code: AWR-0000

Error Message: The Oracle database name in the specified AWR report doesn't match the connected Oracle server. Run a new assessment with an AWR report of the same database.

Possible causes: The Oracle database name in the AWR report is different from the connected Oracle database server.

Remediation actions: You must upload the correct AWR report for the connected Oracle server so that the AWR report and Oracle database server name match and then try to create a new assessment. If the issue persists, contact Microsoft for help.

Error Code: GE-1002

Error Message: Configured assessment folder doesn't exist.

Possible causes: The assessment folder path provided doesn't exist locally.

Remediation actions: Verify the assessment folder path exists on the local computer. If you've changed the assessment data folder path, check that the current assessment path mentioned in the extension settings is correct.

Error Code: ODC-1005

Error Message: Connected oracle server is not available due to an underlying Oracle exception - ORA1034.

Possible causes: The database might need to be updated or prepared to accept connections.

Remediation actions: Check if the database is online, healthy, and ready to accept new connections. For more information, see Oracle documentation for the ORA-1034 error.

Error Code: ODC-1003

Error Message: Login failed due to invalid credentials. Verify the login credentials for database and try again.

Possible causes: Sign in failure might be due to invalid credentials.

Remediation actions: You must ensure that the Oracle Database credentials provided are correct. Verify the sign-in credentials for the database and try again.

Error Code: ODC-1004

Error Message: Failed to connect to the Oracle server due to an underlying driver error code {error code}.

Possible causes: This error may appear due to any of the given reasons:

  1. Oracle server connection failed due to TNS connectivity failure.
  2. Network connectivity to the Oracle server is unstable or lost.

Remediation actions: Try to reconnect to the Oracle server or refresh the connection. Also, ping the Oracle server to check the network connectivity between your machine and the Oracle server is stable.

Error Code: ODC-0000

Error Message: The data collection failed with an unknown error. Try creating a new assessment.

Possible causes: This error is generic and may appear for multiple reasons.

Remediation actions: Try to create a new assessment. To investigate further, go through the logs to understand the reason for the error. If the issue persists, contact Microsoft for help.

Error Code: ODC-0004

Error Message: Ora2Pg code complexity data collection failed with an unknown error. Try creating a new assessment.

Possible causes: This error may appear when Ora2pg data collection fails due to an unhandled exception.

Remediation actions: Try to create a new assessment. To investigate further, go through the logs to understand the reason for the error. If the issue persists, contact Microsoft for help.

Error Code: Ora2pg-2000

Error Message: Failed to parse the Ora2Pg assessment report with an unknown error. Try creating a new assessment.

Possible causes: This error may appear during the parsing of the Ora2pg report due to an unhandled exception.

Remediation actions: Try to create a new assessment. To investigate further, go through the logs to understand the reason for the error. If the issue persists, contact Microsoft for help.

Error Code: MDS-0004

Error Message: Failed to save the assessment output with a serializer error.

Possible causes: This error may appear due to any of the given reasons:

  1. The metadata file is either corrupted or modified externally.
  2. Need help with parsing the json for the metadata file correctly.

Remediation actions: You may have to delete the current assessment and then try creating a new assessment. If the issue persists, contact Microsoft for help.

Error Code: MDS-0005

Error Message: Failed to delete the assessment report with an unknown error.

Possible causes: This error may appear due to any of the given reasons:

  1. The user may not have the appropriate permission to delete files from the assessment data folder.
  2. The assessment data files are already in use by another program.

Remediation actions: You must ensure the logged-in user has to delete permissions to the assessment data folder. If you've changed the assessment data folder path, check that the current assessment path mentioned in the extension settings is correct. Try to create a new assessment after closing any open assessment file(s).

Error Code: FSRP-0000

Error Message: A terminal error occurred - failed to access lookup data. A lookup file is either deleted or corrupted. Reinstall the extension and try again.

Possible causes: This error may appear due to any of the given reasons:

  1. The lookup metadata file is either deleted or corrupted.
  2. The lookup metadata file is already in use by another program.

Remediation actions: Try reinstalling the extension, close any open assessment file(s), and create a new assessment. If the issue persists, contact Microsoft for help.

Error Code: LDR-0000

Error Message: A terminal error occurred - failed to access lookup data. A lookup file is either deleted or corrupted. Reinstall the extension and try again.

Possible causes: This error may appear due to any of the given reasons:

  1. The lookup metadata file is either deleted or corrupted.
  2. The lookup metadata file is already in use by another program.

Remediation actions: Try reinstalling the extension, close any open assessment file(s), and create a new assessment. If the issue persists, contact Microsoft for help.

Error Code: LDR-0001

Error Message: A terminal error occurred - failed to parse lookup data. A lookup file is either deleted or corrupted. Reinstall the extension and try again.

Possible causes: This error may appear due to any of the given reasons:

  1. The lookup metadata file is either deleted or corrupted.
  2. The lookup metadata file is already in use by another program.

Remediation actions: Try reinstalling the extension, close any open assessment file(s), and create a new assessment. If the issue persists, contact Microsoft for help.

Error Code: ORADA-0000

Error Message: Failed to aggregate the collected performance data with an unknown error.

Possible causes: This error is uncategorized.

Remediation actions: To investigate further, go through the logs to understand the reason for the error. contact Microsoft for help

Error Code: ODC-0002

Error Message: Failed to collect Oracle feature data with an unknown error.

Possible causes: This error is uncategorized.

Remediation actions: To investigate further, go through the logs to understand the reason for the error. contact Microsoft for help

Error Code: FSMB-0000

Error Message: Failed to generate the assessment output with an unknown error.

Possible causes: This error may appear due to any of the given reasons:

  1. The user may not have permission to write to the assessment data folder.
  2. The assessment data folder is already in use by another program.

Remediation actions: Ensure the logged-in user has written permissions on the assessment data folder. If you've changed the assessment data folder path, check that the current assessment path mentioned in the extension settings is correct. Try to create a new assessment after closing any open assessment file(s).

Error Code: FSMB-0004

Error Message: Failed to save the assessment output with a serializer error.

Possible causes: The generated assessment data Couldn't be converted to JSON format.

Remediation actions: You may try to run a new assessment. To investigate further, go through the logs to understand the reason for the error. If the issue persists, contact Microsoft for help

Error Code: FSMB-0005

Error Message: Failed to delete the assessment report with a file system error.

Possible causes: This error may appear due to any of the given reasons:

  1. The user may not have the appropriate permission to delete files from the assessment data folder.
  2. The assessment data files are already in use by another program.

Remediation actions: You must ensure the logged-in user has to delete permissions on the assessment data folder. If you've changed the assessment data folder path, check that the current assessment path mentioned in the extension settings is correct. Try to create a new assessment after closing any open assessment file(s).

Error Code: MDS-0001

Error Message: Failed to read the assessment data with a file system error.

Possible causes: This error may appear due to any of the given reasons:

  1. The user may need the appropriate permission to access the assessment data folder.
  2. The assessment data folder doesn't exist or is in use by another program.

Remediation actions: Ensure the logged-in user has read and write permissions on the assessment data folder. If you've changed the assessment data folder path, check that the current assessment path mentioned in the extension settings is correct.

Error Code: MDS-0002

Error Message: Failed to read the assessment data with a serializer error.

Possible causes: This error may appear due to any of the given reasons:

  1. The user may need the appropriate permission to access the assessment data folder.
  2. The assessment data folder doesn't exist or is in use by another program.
  3. The assessment data was generated by an older version of the Azure Data Studio extension that isn't supported.

Remediation actions: Ensure the logged-in user has read and write permissions on the assessment data folder. If you've changed the assessment data folder path, check that the current assessment path mentioned in the extension settings is correct. Try to delete the current assessment and then run a new assessment.

Error Code: ORADA - 1001

Error Message: Failed to process collected static data with serializer error. Try creating a new assessment.

Possible causes: This error may appear due to any of the given reasons:

  1. Unable to populate performance counter from static data.
  2. Instance or database configs are unavailable or not in the required format.

Remediation actions: You may try to run a new assessment. To investigate further, go through the logs to understand the reason for the error. If the issue persists, contact Microsoft for help

Error Code: ORADA-1000

Error Message: Failed to process collected performance data with serializer error. Try creating a new assessment.

Possible causes: This error may appear due to any of the given reasons:

  1. Unable to populate performance counter from static data.
  2. Instance or database configs are unavailable or not in the required format.

Remediation actions: Try to create a new assessment. To investigate further, go through the logs to understand the reason for the error. If the issue persists, contact Microsoft for help

Error Code: AWR-0003

Error Message: Uploaded AWR report is for a pluggable database, but a CDB root container AWR report was expected for performance data collection. Try creating a new assessment with the AWR report for the CDB root container.

Possible causes: The uploaded AWR report is for a Pluggable database. You must provide a CDB root container AWR report for performance data collection.

Remediation actions: Try creating a new assessment with the AWR report for the CDB root container. If the issue persists, contact Microsoft for help

Error Code: MDS-0003

Error Message: Failed to save the assessment output with an unknown error.

Possible causes: This error may appear due to any of the given reasons:

  1. The user may need the appropriate permission to access the chosen folder for saving the assessment.
  2. The folder is already in use by another program.

Remediation actions: Ensure the logged-in user has read and write permissions on the assessment data folder. If you've changed the assessment data folder path, check that the current assessment path mentioned in the extension settings is correct. And then, try to create a new assessment after closing any open assessment file(s).

Error Code: ODC-0003

Error Message: Failed to collect Oracle static data with an unknown error.

Possible causes: An unknown internal error has occurred.

Remediation actions: Try to create a new assessment. To investigate further, go through the log to understand the reason for the error if the issue persists, contact Microsoft for help.

Error Code: SQLA-1000

Error Message: Failed to calculate feature compatibility with an unknown error.

Possible causes: An unknown internal error has occurred.

Remediation actions: Try to create a new assessment. To investigate further, go through the log to understand the reason for the error if the issue persists, contact Microsoft for help.

Error Code: SQLA-2001

Error Message: Failed to calculate schema workload complexity with an unknown error.

Possible causes: An unknown internal error has occurred.

Remediation actions: Try to create a new assessment. To investigate further, go through the log to understand the reason for the error if the issue persists, contact Microsoft for help.

Error Code: GE-0001

Error Message: Failed to run one or more assessment components with an unknown error.

Possible causes: An unknown internal error has occurred.

Remediation actions: Try to create a new assessment. To investigate further, go through the log to understand the reason for the error if the issue persists, contact Microsoft for help.

Error Code: Ora2Pg-2001

Error Message: Failed to retrieve the Ora2Pg assessment report version.

Possible causes: This error may appear due to any of the given reasons:

  1. Ora2Pg HTML report needed to be in the correct format.
  2. Ora2Pg HTML report was corrupted.
  3. Ora2Pg HTML report version isn't supported.

Remediation actions: Check the installed version of Ora2Pg should be v23.1 or greater. You can install Ora2Pg using the script. And then try to create a new assessment.

Error Code: Ora2Pg-2002

Error Message: Failed to retrieve the Ora2Pg assessment report version.

Possible causes: This error may appear due to any of the given reasons:

  1. Ora2Pg HTML report needed to be in the correct format.
  2. Ora2Pg HTML report was corrupted.
  3. Ora2Pg HTML report version isn't supported.

Remediation actions: Check the installed version of Ora2Pg should be v23.1 or greater. You can install Ora2Pg using the script. And then try to create a new assessment.

Error Code: Ora2Pg-2003

Error Message: Failed as Ora2Pg assessment report version {version} isn't supported.

Possible causes: This error may appear due to any of the given reasons:

  1. Ora2Pg HTML report wasn't in the correct format.
  2. Ora2Pg HTML report was corrupted.
  3. Ora2Pg HTML report version isn't supported.

Remediation actions: Check the installed version of Ora2Pg should be v23.1 or greater. You can install Ora2Pg using the script. And then try to create a new assessment.

Error Code: Ora2Pg-0000

Error Message: Failed to execute code compatibility report with an unknown exception.

Possible causes: This error may appear due to any of the given reasons:

  1. Ora2Pg wasn't installed.
  2. Ora2Pg wasn't able to connect to the Oracle server.
  3. Ora2Pg failed with an unknown error.
  4. Ora2Pg process crashed due to a system error.

Remediation actions: Check the installed version of Ora2Pg should be v23.1 or greater. You can install Ora2Pg using the script. And then try to create a new assessment.

Error Code: Ora2Pg-0003

Error Message: Failed as Ora2pg execution timed out before the operation's completion.

Possible causes: This error may appear due to any of the given reasons:

  1. Ora2Pg wasn't able to connect to the Oracle server.
  2. Ora2pg execution took more than config time-out. The default config time-out is five hours.

Remediation actions: You can increase the ora2pgTimeOutInMin setting in the app.config file, located in the Azure Data Studio extension install folder (e.g., on Windows %USERPROFILE%/.azuredatastudio/extensions/microsoft.azuredatastudio-dma-oracle-*/bin/service).

Error Code: Ora2Pg-0004

Error Message: Failed as an invalid Oracle object caused Ora2pg to consume excess memory. Ora2pg execution terminated gracefully.

Possible causes: Due to certain invalid Oracle objects, Ora2Pg DDL extractor runs into out-of-memory condition. This extension monitors the memory usage and caps it at 50% of available system memory. If Ora2Pg starts to take more memory, the background process is gracefully exited.

Remediation actions: You can increase the maxSystemMemoryPercentage setting in the app.config file which is located in the
Azure Data Studio extension install folder (for example, on Windows %USERPROFILE%/.azuredatastudio/extensions/microsoft.azuredatastudio-dma-oracle- */bin/service). Check with Oracle DBA if they can identify any objects that can cause Ora2Pg to crash.

Error Code: Ora2Pg-0006

Error Message: Failed to retrieve the Ora2Pg assessment report version.

Possible causes: This error may appear due to any of the given reasons:

  1. Ora2Pg HTML report wasn't in the correct format.
  2. Ora2Pg HTML report was corrupted.
  3. Ora2Pg HTML report version isn't supported.

Remediation actions: Check the installed version of Ora2Pg should be v23.1 or greater. You can install Ora2Pg using the script. And then try to create a new assessment.

Error Code: Ora2Pg-0007

Error Message: Failed to retrieve the Ora2Pg assessment report version.

Possible causes: This error may appear due to any of the given reasons:

  1. Ora2Pg HTML report wasn't in the correct format.
  2. Ora2Pg HTML report was corrupted.
  3. Ora2Pg HTML report version isn't supported.

Remediation actions: Check the installed version of Ora2Pg should be v23.1 or greater. You can install Ora2Pg using the script. And then try to create a new assessment.

Error Code: Ora2Pg-0008

Error Message: Failed to detect Oracle home path. Check if the Oracle home path is configured correctly.

Possible causes: This error may appear due to any of the given reasons:

  1. Ora2Pg needs to be installed correctly.
  2. Oracle Home path needs to be correctly set in the environment variable.
  3. Oracle Home path needs to be correctly set in the extension settings.
  4. The Oracle Home path in the environment variable differs from the one mentioned in the extension settings.

Remediation actions: Check that Ora2Pg is installed correctly by running the command ora2pg -v on the command prompt. You can install Ora2Pg using the script. Check the value of the environment variable from the command prompt using echo %ORACLE_HOME%. Also, Check the Oracle Home path setting in the extension settings. Refer to configure extension settings.

Error Code: Ora2Pg-0009

Error Message: Failed to generate Ora2pg assessment report with an unknown error.

Possible causes: This error may appear due to any of the given reasons:

  1. Ora2Pg wasn't installed.
  2. Ora2Pg wasn't able to connect to the Oracle server.
  3. Ora2Pg failed with an unknown error.
  4. Ora2Pg process crashed due to a system error.

Remediation actions: Check the installed version of Ora2Pg should be v23.1 or greater. You can install Ora2Pg using the script. And then try to create a new assessment.

Error Code: Ora2Pg-0010

Error Message: Failed to detect Oracle home path. Check if the Oracle home path is configured correctly.

Possible causes: This error may appear due to any of the given reasons:

  1. Ora2Pg needs to be installed correctly.
  2. Oracle Home path needs to be correctly set in the environment variable.
  3. Oracle Home path needs to be correctly set in the extension settings.
  4. The Oracle Home path in the environment variable differs from the one mentioned in the extension settings.

Remediation actions: Check that Ora2Pg is installed correctly by running the command ora2pg -v on the command prompt. You can install Ora2Pg using the script. Check the value of the environment variable from the command prompt using echo %ORACLE_HOME%. Also, Check the Oracle Home path setting in the extension settings. Refer to the configure extension settings.

Error Code: Ora2Pg-0012

Error Message: Assessment failed due to an issue with the Ora2pg installation. Install Ora2pg using the script {0}. This script will install the Ora2pg and its prerequisites. Verify that the PATH (Windows) environment variable or ORACLE_HOME (Linux) environment variable points to the correct Oracle Home Directory.

Possible causes: Ora2Pg isn't installed or visible to you.

Remediation actions: Check that Ora2Pg is installed correctly by running the command ora2pg -v on the command prompt. You can install Ora2Pg using the script. Check the value of the environment variable from the command prompt using echo %ORACLE_HOME%. Also, Check the Oracle Home path setting in the extension settings. Refer to the configure extension settings.