You may have some content or comments with "$(" inside. Even more if you have
ever written about jQuery. This is a WebMatrix bug which takes this as an
internal command an tries to execute it.
Could you try to find this occurrence in your content ?
From: Steve Schofield [mailto:[email protected]]
Sent: Wednesday, May 11, 2011 6:27 PM
To: [email protected]
Subject: migration from web matrix sqlce to sql express / sql server fails with
cryptic error.
I'm trying to migrate my sqlce database and getting this error below. I tried
SQL Server and sql express with no luck. Any advice?
The migration of the database from SQL Server Compact to SQL Server failed.
---------------------------
Migration failed
---------------------------
Migration failed
An error occurred during execution of the database script. The error occurred
between the following lines of the script: "5800" and "5812". The verbose log
might have more information about the error. The command started with the
following:
"INSERT INTO [dbo].[Common_BodyPartRecord]([Id],[Co"
---------------------------
OK
---------------------------
---------------------------
Microsoft.Web.Deployment.DeploymentException: An error occurred during
execution of the database script. The error occurred between the following
lines of the script: "5800" and "5812". The verbose log might have more
information about the error. The command started with the following:
"INSERT INTO [dbo].[Common_BodyPartRecord]([Id],[Co"
---> ManagedBatchParser.ParserException
at ManagedBatchParser.Parser.Parse()
at Microsoft.Web.Deployment.SqlBatchParser.ProcessSqlCmdScript(String
sqlCmdScript)
at Microsoft.Web.Deployment.SqlScriptToDBProvider.AddHelper(DeploymentObject
source, Boolean whatIf)
--- End of inner exception stack trace ---
at Microsoft.Web.Deployment.SqlScriptToDBProvider.AddHelper(DeploymentObject
source, Boolean whatIf)
at Microsoft.Web.Deployment.SqlScriptToDBProvider.Add(DeploymentObject
source, Boolean whatIf)
at Microsoft.Web.Deployment.DeploymentObject.AddChild(DeploymentObject
source, Int32 position, DeploymentSyncContext syncContext)
at
Microsoft.Web.Deployment.DeploymentSyncContext.HandleAddChild(DeploymentObject
destParent, DeploymentObject sourceObject, Int32 position)
at
Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildrenOrder(DeploymentObject
dest, DeploymentObject source)
at
Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildren(DeploymentObject
dest, DeploymentObject source)
at
Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildrenOrder(DeploymentObject
dest, DeploymentObject source)
at
Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildren(DeploymentObject
dest, DeploymentObject source)
at
Microsoft.Web.Deployment.DeploymentSyncContext.ProcessSync(DeploymentObject
destinationObject, DeploymentObject sourceObject)
at Microsoft.Web.Deployment.DeploymentObject.SyncToInternal(DeploymentObject
destObject, DeploymentSyncOptions syncOptions, PayloadTable payloadTable,
ContentRootTable contentRootTable)
at
Microsoft.Web.Deployment.DeploymentObject.SyncTo(DeploymentProviderOptions
providerOptions, DeploymentBaseOptions baseOptions, DeploymentSyncOptions
syncOptions)
at Microsoft.Web.Deployment.DeploymentObject.SyncTo(String provider, String
path, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions)
at
Microsoft.Web.Deployment.DeploymentObject.SyncTo(DeploymentWellKnownProvider
provider, String path, DeploymentBaseOptions baseOptions, DeploymentSyncOptions
syncOptions)
at
Microsoft.WebMatrix.DatabaseManager.Client.SqlCeHelper.<>c__DisplayClass6.<StartMigrate>b__5(Object
sender, DoWorkEventArgs eventArgs)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
---------------------------
Thank you,
Steve Schofield
Windows Server MVP - IIS
http://weblogs.asp.net/steveschofield
---
You are currently subscribed to orchard-discuss as:
[email protected]<mailto:[email protected]>.
To unsubscribe send a blank email to
[email protected]<mailto:[email protected]>.
---
You are currently subscribed to orchard-discuss as: [email protected].
To unsubscribe send a blank email to [email protected].
