Blog Post

Azure Database Support Blog
2 MIN READ

Lesson Learned #287: Contains an unresolved reference to an object due to database collation

Jose_Manuel_Jurado's avatar
Jose_Manuel_Jurado
Icon for Microsoft rankMicrosoft
Jan 17, 2023
Today, we worked on a new service request that our customer got the following error message exporting the database to a BacPac:  One or more unsupported elements were found in the schema used as pa...
Updated Jan 18, 2023
Version 2.0
saeed_aliakbarian's avatar
saeed_aliakbarian
Copper Contributor
Apr 20, 2024

In brief the error happens when trying to create a dacpac/bacpac from a database or database project (or build the database project) that has one of the following situations:

1. SELECT * : using star(*) in a SELECT statement in a view

2. 3 Part names: Including database name when referencing a table (or other object types) even the current database name