Error Publishing Lightswitch Vs2012 relaese version and RC app

Question

I've been reguarly publishing the app no problems - in fact did it yesterday. Today I'm getting:

Error    1    An exception occurred when deploying the database for the application.
Failed to instantiate Microsoft.Data.Schema.Sql.SchemaModel.ExternalPropertyAnnotation because it was not registered.    C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\LightSwitch\v2.0\Publish\v1.7\Microsoft.LightSwitch.Publish.targets    1220    10    Fred

Google search returns nothing similar. Any idea where the fault may lie?

Thanks

---

Martin

Answer 1

Just got this again after upgrading to the release version. Anyone from MSFT want to comment?

---

Martin

Answer 2

Also get about 70 warnings eg:

Warning    58    The element 'ItemGroup' in namespace 'http://schemas.microsoft.com/developer/msbuild/2003' has invalid child element '_MSDeploySourceManifest' in namespace 'http://schemas.microsoft.com/developer/msbuild/2003'. List of possible elements expected: 'Item, Reference, COMReference, COMFileReference, Xdcmake, Bscmake, ClCompile, ClInclude, Midl, ResourceCompile, PreLinkEvent, CustomBuildStep, Manifest, ProjectConfiguration, ProjectCapability, NativeReference, ProjectReference, Compile, EmbeddedResource, Content, Page, Resource, ApplicationDefinition, None, BaseApplicationManifest, Folder, Import, Service, WebReferences, WebReferenceUrl, FileAssociation, BootstrapperFile, PublishFile, PRIResource, AppxSystemBinary, AppxReservedFileName, AppxManifestFileNameQuery, AppxManifest, StoreAssociationFile, CodeAnalysisDependentAssemblyPaths, CodeAnalysisDictionary, CodeAnalysisImport, Link, ResourceCompile, PreBuildEvent, PostBuildEvent' in namespace 'http://schemas.microsoft.com/developer/msbuild/2003'.    C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\LightSwitch\v2.0\Publish\v1.7\Microsoft.LightSwitch.Publish.targets    998    14    Miscellaneous Files

---

Martin

Answer 3

Can anyone help?

---

Martin

Answer 4

Martin,

I was having the same issue.  I performed a SQL > Schema Compare on my azure hosted database. I used the hosted database as the source and target. It confirmed a 100% match and I was then able to publish my solution. 

Give this a shot!

Answer 5

I have the same problem.It all started after I modified some field type,then tried to publish.

Answer 6

@md musfiqur, Since there are a couple of different replies with errors listed, could you post your exact error?

---

David Kidder | Senior SDET | Microsoft | LightSwitch

Answer 7

Today i updated to VS update 2 and now the following error with 69  warnings! I haven't updated my project yet.

Warning 12 The element 'ItemGroup' in namespace 'http://schemas.microsoft.com/developer/msbuild/2003' has invalid child element '_ApplicationIcon' in namespace 'http://schemas.microsoft.com/developer/msbuild/2003'. List of possible elements expected: 'Item, Reference, COMReference, COMFileReference, Xdcmake, Bscmake, ClCompile, ClInclude, Midl, ResourceCompile, PreLinkEvent, CustomBuildStep, Manifest, ProjectConfiguration, ProjectCapability, NativeReference, ProjectReference, Compile, EmbeddedResource, Content, Page, Resource, ApplicationDefinition, None, BaseApplicationManifest, Folder, Import, Service, WebReferences, WebReferenceUrl, FileAssociation, BootstrapperFile, PublishFile, PRIResource, AppxSystemBinary, AppxReservedFileName, AppxManifestFileNameQuery, AppxManifest, StoreAssociationFile, CodeAnalysisDependentAssemblyPaths, CodeAnalysisDictionary, CodeAnalysisImport, Link, ResourceCompile, PreBuildEvent, PostBuildEvent' in namespace 'http://schemas.microsoft.com/developer/msbuild/2003'. C:\Program Files\MSBuild\Microsoft\VisualStudio\LightSwitch\v2.0\Publish\v1.0\Microsoft.LightSwitch.Publish.targets 150 10 Miscellaneous Files

Error 70 An exception occurred when deploying the database for the application.
Failed to instantiate Microsoft.Data.Schema.Sql.SchemaModel.ExternalPropertyAnnotation because it was not registered. C:\Program Files\MSBuild\Microsoft\VisualStudio\LightSwitch\v2.0\Publish\v1.0\Microsoft.LightSwitch.Publish.targets 1148 

But i never changed the schema! i published yesterday too.

Any update on this?

Answer 8

Have you done this:

-Rebuild the solution

-Clean the solution

-Rebuild the project

-Clean the project

Answer 9

Me too is experiencing this error upon publish.

Error 1 An exception occurred when deploying the database for the application.
Failed to instantiate Microsoft.Data.Schema.Sql.SchemaModel.ExternalPropertyAnnotation because it was not registered. C:\Program Files\MSBuild\Microsoft\VisualStudio\LightSwitch\v2.0\Publish\v1.0\Microsoft.LightSwitch.Publish.targets 1148 10 TMIS

Novic