Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Visual Studio Database Edition: What is causing "ModelException: At least one identifier expected."?

We have a database project in Visual Studio 2008 that has been working great. Out of the blue, however, deployment stopped working. This is the error we get:

EZTrac.Database.dbschema : Deploy error TSD01234: Microsoft.Data.Schema.SchemaModel.ModelException: At least one identifier expected.

We've searched everywhere trying to debug this problem. The exception that's being thrown to the Ouput window is too generic to actually decipher anything. I know 'ModelException' gets thrown when there's a problem with the model, but I have no idea where to begin looking.

Does anyone know what could be causing this?

alt text

Edit:

We now have MSDN Premier support on the line about this. It's been about 4 days and they haven't been able to figure it out. I'll update with a solution if/when I get one.

like image 916
The Matt Avatar asked Nov 15 '22 14:11

The Matt


1 Answers

After much back and forth troubleshooting with Microsoft Premiere support, we've been informed that we've found a bug in the database edition of Visual Studio. We gave up before it was resolved and ended up scrapping using the part of the database project in our solution.

The official workaround from Microsoft is to deploy the database project using an account which is able to see the account which granted the deploying account the VIEW DEFINITION permission.

like image 135
The Matt Avatar answered Jan 02 '23 18:01

The Matt