Issue:

Users reported that the database migration is running in the error message after starting the ADMS Console on Vault Server.

"Migration of <database> failed: The dependencies reported for entity
"[dbo].[uf_CheckDuplicateFileName]" might not include references to all
columns. This is either because the entity references an object that does
not exist or because of an error in one or more statements in the entity.
Before rerunning the query, ensure that there are no errors in the entity
and that all objects referenced by the entity exist."

Status:

No issue has been identified and the software is behaving as designed.

Workaround:

Set the database compatibility level to "SQL Server 2016 (130)" and start the database migration again with the steps:

Start SQL Server Management Studio.
Select database > right-click > Properties.
Database properties > Select page: Options > Set Compatibility Level: SQL Server 2016(130) > OK.

Do this for all Autodesk Vault databases.
Start the ADMS Console > select Vaults > right-click > migrate.
Create and start the Maintenance Plan. The instructions are described in the link:

Vault Help | Server Maintenance Part 6: Create SQL Maintenance Plan | Autodesk

See Also:

Products:

Vault Products;

Incident ID:

40787