When I'm publishing my site to my server the publish fails (log below).
Log indicates its having trouble with the database which is an sqlce db. I'm not trying to publish the database (its not checked to "copy as file"), even renaming the file to .sdf.backup (webmatrix no longer sees it in the database workspace) doesn't change
the error log at all.
The problem started when I added a connection string to the web.config and has remained since. The connection string is 'correct' as it works locally.
I don't really understand why its attempting to publish the database :/
Anyone else enoutered this at all or managed to work around it?
17/02/2012 1:09 PM
1:09:46 PM: Unable to automatically publish framework files. Your remote site may not work correctly.
1:09:46 PM: Using ID '61ba0e45-6a03-46cb-8211-250635e1bb97' for connections to the remote server.
1:09:51 PM: Adding MSDeploy.Continous (MSDeploy.Continous).
1:09:53 PM: Adding dbFullSql (data source=Coomera/App_Data\Coomera.sdf).
1:09:53 PM: The database 'Coomera/App_Data\Coomera.sdf' could not be created.
1:09:53 PM: Retrying operation 'Add' on object dbFullSql (data source=Coomera/App_Data\Coomera.sdf). Attempt 1 of 2.
1:09:53 PM: The database 'Coomera/App_Data\Coomera.sdf' could not be created.
1:09:53 PM: Retrying operation 'Add' on object dbFullSql (data source=Coomera/App_Data\Coomera.sdf). Attempt 2 of 2.
1:09:53 PM: Unable to publish.
1:09:53 PM: Unable to publish. Unable to publish.
1:09:53 PM: Error detail:
1:09:53 PM: (17/02/2012 1:09:53 PM) An error occurred when the request was processed on the remote computer.
1:09:53 PM: at Microsoft.Web.Deployment.StatusThreadHandler.CheckForException()
1:09:53 PM: at Microsoft.Web.Deployment.AgentClientProvider.RemoteDestSync(DeploymentObject sourceObject, DeploymentSyncContext syncContext)
1:09:53 PM: at Microsoft.Web.Deployment.DeploymentObject.SyncToInternal(DeploymentObject destObject, DeploymentSyncOptions syncOptions, PayloadTable payloadTable, ContentRootTable contentRootTable)
1:09:53 PM: at Microsoft.Web.Deployment.DeploymentObject.SyncTo(DeploymentProviderOptions providerOptions, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions)
1:09:53 PM: at Microsoft.Web.Deployment.DeploymentObject.SyncTo(String provider, String path, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions)
1:09:53 PM: at Microsoft.Web.Deployment.DeploymentObject.SyncTo(DeploymentWellKnownProvider provider, String path, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions)
1:09:53 PM: at Microsoft.WebMatrix.Deployment.MsDeployWorker.Execute(CommandManager commandManager, CertificateValidationService certificateValidationService, Boolean skipHiddenFiles)
1:09:53 PM: The database 'Coomera/App_Data\Coomera.sdf' could not be created.
1:09:53 PM: at Microsoft.Web.Deployment.DeploymentObject.Add(DeploymentObject source, DeploymentSyncContext syncContext)
1:09:53 PM: at Microsoft.Web.Deployment.DeploymentSyncContext.HandleAdd(DeploymentObject destObject, DeploymentObject sourceObject)
1:09:53 PM: at Microsoft.Web.Deployment.DeploymentSyncContext.HandleUpdate(DeploymentObject destObject, DeploymentObject sourceObject)
1:09:53 PM: at Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildrenOrder(DeploymentObject dest, DeploymentObject source)
1:09:53 PM: at Microsoft.Web.Deployment.DeploymentSyncContext.ProcessSync(DeploymentObject destinationObject, DeploymentObject sourceObject)
1:09:53 PM: at Microsoft.Web.Deployment.DeploymentObject.SyncToInternal(DeploymentObject destObject, DeploymentSyncOptions syncOptions, PayloadTable payloadTable, ContentRootTable contentRootTable)
1:09:53 PM: at Microsoft.Web.Deployment.DeploymentAgent.HandleSync(DeploymentAgentAsyncData asyncData)
1:09:53 PM: The method or operation is not implemented.
1:09:53 PM: at Microsoft.Web.Deployment.SqlServerCeDatabaseProvider.CreateDatabase()
Questions on deployment/publishing should be posted to the IIS forum for WebMatrix:
http://forums.iis.net/1166.aspx. You can use your existing credentials to log in there as it shares the same membership as this forum.
Bryan Wood
0 Points
1 Post
Unable to Publish
Feb 17, 2012 02:25 AM|LINK
When I'm publishing my site to my server the publish fails (log below).
Log indicates its having trouble with the database which is an sqlce db. I'm not trying to publish the database (its not checked to "copy as file"), even renaming the file to .sdf.backup (webmatrix no longer sees it in the database workspace) doesn't change the error log at all.
The problem started when I added a connection string to the web.config and has remained since. The connection string is 'correct' as it works locally.
I don't really understand why its attempting to publish the database :/
Anyone else enoutered this at all or managed to work around it?
This is using Web Matrix 2 Beta
Mikesdotnett...
All-Star
154955 Points
19872 Posts
Moderator
MVP
Re: Unable to Publish
Feb 17, 2012 04:50 AM|LINK
Questions on deployment/publishing should be posted to the IIS forum for WebMatrix: http://forums.iis.net/1166.aspx. You can use your existing credentials to log in there as it shares the same membership as this forum.
Beginning ASP.NET Web Pages with WebMatrix | My Site | Twitter