Migration creation failures

In Oracle Cloud Infrastructure Database Migration, if you have a Migration (odms-migration) resource in failed state use the following steps to gather more details about the failure:

Get the migration OCID.
- Using the OCI Web Console:
  
  Go to the OCI Console, and open Database Migration Service/Migrations (for example, https://console.us-phoenix-1.oraclecloud.com/odms/migrations).
  
  Locate the failed Migration in the list, and select Copy OCID from the Actions (three dots) menu.
- Using Oracle Database Migration Service (database-migration) OCI Command line interface:
  
  The compartment OCID where the failed migration was created is required.
  - List all migration resources and find the failure:
```
oci database-migration migration list -c `compartmentOCID`
```
    See database-migration >> migration >> list
  - If you know the migration display name, you can use it to filter results:
```
oci database-migration migration list -c `compartmentOCID` --display-name `migrationDisplayName`
```
Get the Work Request OCID associated with the migration creation request.
- Using Oracle Database Migration Service (database-migration) OCI Command line interface:
  
  The compartment OCID where the failed migration was created is required.
  - Use the migration OCID to list the work requests:
```
oci database-migration work-request list --resource-id odms-migration-OCID --compartment-id
 odms-migration-compartment-OCID
```
    See database-migration >> work-request >> list
  - Use the compartment OCID to list the work requests of the compartment:
```
oci database-migration work-request list --compartment-id odms-migration-compartment-OCID
```
  - Use the sort-by option to sort the results by displayName or timeCreated:
```
oci database-migration work-request list --compartment-id odms-migration-compartment-OCID --sort-by displayName
```
  - Use the sort-order option with asc or desc:
```
oci database-migration work-request list --compartment-id odms-migration-compartment-OCID --sort-oder ASC
```
    Only one sort order can be specified. Default order for --sort-by timeCreated is descending.
- Using the Database Migration REST API:
  - Use the migration OCID to list the work requests:
```
GET /20210929/workRequests?resourceId=odms-migration-OCID&compartmentId=odms-migration-compartment-OCID
```
    See ListWorkRequests
  - Use the compartment OCID to list the work requests of the compartment:
```
GET /20210929/workRequests?compartmentId=compartment-OCID-of-resource
```
  - Use the sort-by option to sort the results by displayName or timeCreated:
```
GET /20210929/workRequests?compartmentId=compartment-OCID-of-resource&sortBy=displayName
```
  - Use the sort-orderoption with asc or desc:
```
GET /20210929/workRequests?compartmentId=compartment-OCID-of-resource&sortOrder=ASC
```
    Only one sort order can be specified. Default order for --sort-by timeCreated is descending.
Use the work request OCID to get details, logs, and errors related to the failure:
- Using Oracle Database Migration Service (database-migration) OCI Command line interface:
  - Use the work request identifier to get details:
```
oci database-migration work-request get --work-request-id workRequestId
```
    See database-migration >> work-request >> get
  - Use the work request identifier to list the errors:
```
oci database-migration work-request-error list --work-request-id workRequestId
```
    See database-migration >> work-request-error >> list
  - Use the work request identifier to list the logs:
```
oci database-migration work-request-logs list --work-request-id workRequestId
```
    See database-migration >> work-request-logs >> list
- Using the Database Migration REST API:
  - Use the work request identifier to get the details:
```
GET /20210929/workRequests/{workRequestId}
```
    See GetWorkRequest
  - Use the work request identifier to get the errors:
```
GET /20210929/workRequests/{workRequestId}/errors
```
    See ListWorkRequestErrors
  - Use the work request identifier to get the logs:
```
GET /20210929/workRequests/{workRequestId}/logs
```
    See ListWorkRequestLogs
Inspect the logs and errors in the work request and resolve the issues reported.

For more information about using the API and signing requests, see REST APIs and Security CredentialsSecurity Credentials. For information about SDKs, see Software Development Kits and Command Line Interface.

Parent topic: Troubleshoot