Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSDT: "Identifiers must include at least one name (for example, MyTable)"

Two days trying to find the origin of this error and can not ...

My problem is the same: Link

When i build my db project the following error occur:

"Identifiers must include at least one name (for example, MyTable)"

Build output:

C:\Program Files (x86)\MSBuild\12.0\bin\Csc.exe /noconfig /nowarn:1701,1702,2008 /nostdlib+ /errorreport:prompt /warn:4 /define:DEBUG;TRACE /errorendlocation /preferreduilang:en-US /highentropyva+ /reference:"C:\Program Files (x86)\Reference Assemblies\Microsoft\Framework.NETFramework\v4.5\mscorlib.dll" /debug+ /debug:full /optimize- /out:obj\Debug\Objetivo.Rango.BancoDados.dll /subsystemversion:6.00 /target:library /warnaserror- /utf8output "C:\Users\Vinicius\AppData\Local\Temp.NETFramework,Version=v4.5.SqlClrAttributes.cs" Loading project references... Loading project files... Building the project model and resolving object interdependencies... Validating the project model... Writing model to D:\WorkspaceObjetivoSistemas\ObjetivoSistemas\Rango\RamoPrincipal\Rango\Objetivo.Rango.BancoDados\obj\Debug\Model.xml... Writing create script to Rango_Create.sql... C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v12.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets(546,5): Error: : Identifiers must include at least one name (for example, MyTable). Done building project "Objetivo.Rango.BancoDados.sqlproj" -- FAILED.

like image 629
Vinicius Gonçalves Avatar asked Oct 23 '25 13:10

Vinicius Gonçalves


2 Answers

I Finally solved my problem.

There was a bug in .refactorlog file...

This error message is too vague and it's not enough to know where the problem is happening ...

like image 96
Vinicius Gonçalves Avatar answered Oct 25 '25 10:10

Vinicius Gonçalves


I accidentally reproduced this by using the Refactor menu tool to rename some columns, making several other changes, then UNDOING all changes via TFS.

A couple of original refactor items were left in the .refactorlog file after the Undo. Once I removed them from the xml, publishing worked as expected.

like image 34
mdisibio Avatar answered Oct 25 '25 10:10

mdisibio



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!