SQL17501 Database Reference Error

Question

We have been using SSDT for several months and have references to a standard framework dacpac (containing library functions) used in most of our projects.  The reference works fine in most projects.  There are a few projects, however, where we reference the exact same dacpac in the same way, and yet we get SQL71501 and SQL71502 errors and warnings as if the reference were not there at all. 

We have recently determined that the reference may work fine for a couple of months but then will stop working for some unknown reason.  Recreating the project resolves the issue, however, that approach causes some problems with our TFS history preservation so we would like to avoid it.

I tried deleting the reference and checking to see if there are any differences in the errors and warnings reported and there aren't any.  In other words, whether or not the reference is included in these few projects - the same exact errors and warnings arise.  The project is not seeing the reference at all.

This seems like a corruption problem of some file.  Where can I check for the existence of the reference in a file used by the build process?  Filename? Location?   Any other suggestions?

Thanks

Answer 1

Hi,

Could we take a look at the contents of the .sqlproj file of one of the ones that no longer works? You can send directly to sarahmcd at microsoft dot com.

Thanks!

Sarah McDevitt

---

Sarah McDevitt Program Manager SQL Server Data Tools

Answer 2

Thanks Sarah.  Sorry for the dealy on getting back to you on this.  The problem resolved a few weeks ago on the affected project and has not come back.  I don't know what caused the error or its resolution.  Probably best to consider this issue closed for now.  If it comes back I'll post about it again.  Thanks again for looking into it.