Troubleshooting

Troubleshooting: the fix-import dialog didn't help

This page covers the Fix & Retry dialog on a schema import. For how the dialog works, see Fix failed import items.

The explanation is vague

Likely cause: The raw error didn’t give the AI much to go on, often because the DDL uses an unusual construct.

What to do:

  1. Click Show technical error and read the raw message.
  2. Find the lines it points to in DDL (editable).
  3. Try the usual fixes:
    • Swap a vendor-specific data type for a portable one.
    • Quote column names that are reserved words.
    • Remove partition or filegroup clauses.
    • Remove vendor options such as WITH (...) or OPTIONS (...).
  4. Click Retry with Changes.

I edited the DDL but get the same error

Likely cause: The edit didn’t touch what the parser objects to.

What to do:

  1. Click Reset to Original.
  2. Make one small change, such as removing a single suspicious clause.
  3. Retry. If the error changes, you’re in the right area; keep simplifying.

The error says a dependency is missing

Likely cause: The object refers to a table, view or function that doesn’t exist yet, or that failed too.

What to do:

  1. Find the dependency in All Items. If it failed, fix it first. (Fix stays disabled on items whose dependency failed.)
  2. When it succeeds, accept Retry All Dependents.
  3. If you don’t need the reference, remove it from the DDL and retry.

I want to skip this object

There’s no skip button, and you don’t need one. A failed item doesn’t block the rest of the schema.

  1. Leave the item failed. Everything else keeps working.
  2. The item stays on the import page as a record of what didn’t come across.
  3. If you need the object later, create it by hand.

Tip: Many failures are legacy objects nobody needs. It’s fine to leave them.

I can’t get back to the import page

Go to Organization Settings › Schema Imports and click the open icon on the import’s row. Organization Settings is for organization admins; if you aren’t one, ask an admin.

The Fix button is missing or won’t open

  • Fix only appears on Failed and Skipped items that have DDL, and only when 15 or fewer items failed. With more failures, fix the source file and re-import instead; Download Failed DDL collects the failed DDL for you.
  • It’s disabled when a dependency also failed. Hover it to see which.
  • Retrying writes to the schema, so it isn’t available while the organization is in read-only mode.
  • Refresh the page.