4

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.

Vinicius Gonçalves
  • 2,514
  • 1
  • 29
  • 54

2 Answers2

5

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 ...

Vinicius Gonçalves
  • 2,514
  • 1
  • 29
  • 54
  • 3
    Deleting the refactor log fixed this for me – Stafford Williams Jun 02 '17 at 04:52
  • In my case, I could not delete it, since I had made several renames in my objects. If I deleted, I would need to reapply renames to a refactor generation or create them manually in the file later. But delete the .refactor file will solve the problem. – Vinicius Gonçalves Jun 02 '17 at 11:12
  • In my case I caused the error in the refactor log by doing a find replace in my entire solution when I was doing some refactoring. The manual edit in the refactorlog corrupted it along the way. – David Sep 25 '19 at 15:13
2

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.

mdisibio
  • 3,148
  • 31
  • 47