Getting the following error when attempting an import after installing from the Package Repository on a 4.7.1.1 installation with the SQL CE Database option (from the Umbraco Log). Are you able to tell me what the scripts would be to generate the tables in Sql CE?
Error during load umbraco.DataLayer.SqlHelperException: Umbraco
Exception (DataLayer): SQL helper exception in ExecuteReader --->
SqlCE4Umbraco.SqlCeProviderException: Error running Reader:
SQL Statement:
SELECT [UniqueIdentifier], [Name] FROM [CMSImportState] where parent =
@parent
Exception:
System.Data.SqlServerCe.SqlCeException: The specified table does not
exist. [ CMSImportState ]
at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr)
at System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan()
at
System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior
behavior, String method, ResultSetOptions options)
at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String
connectionString, CommandType commandType, String commandText,
SqlCeParameter[] commandParameters)
at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String
connectionString, CommandType commandType, String commandText,
SqlCeParameter[] commandParameters)
at SqlCE4Umbraco.SqlCEHelper.ExecuteReader(String commandText,
SqlCeParameter[] parameters)
at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText,
IParameter[] parameters)
--- End of inner exception stack trace ---
at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText,
IParameter[] parameters)
at CMSImportLibrary.DAL.State.(Guid )
at
CMSImport.Controls.ImportSteps.ConfirmSelectedOptions.(StringBuilder ,
Guid )
at
CMSImport.Controls.ImportSteps.ConfirmSelectedOptions.(ImportState )
at
CMSImport.Controls.ImportSteps.ConfirmSelectedOptions.InitializeState(ImportState
state)
at CMSImport.Controls.CMSImport.OnPreRender(EventArgs e)
CMSImport isn't supporting SQL CE sorry. Apart from the creation script I use a lot of sql queries that might not be compatible with sql server CE. If you want to try you can open the package.xml file for all the queries that generate the database. SqlServer express is supported.
Glad I quickly found this "bug". I started playing around more seriously with a couple of migration projects, but I was only using SQL CE for simplicity.
The migrate tool in WebMatrix is quite decent by the way: only needed to manually update the umbracoDbDSN key under appSettings in the web.config and the database was upgraded to SQLExpress.
Another tip to others in the same situation: you need to uninstall/install CMSImport for it to work.
CMSImport tables missing on SqlCE Database
Hi,
Getting the following error when attempting an import after installing from the Package Repository on a 4.7.1.1 installation with the SQL CE Database option (from the Umbraco Log). Are you able to tell me what the scripts would be to generate the tables in Sql CE?
Error during load umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader ---> SqlCE4Umbraco.SqlCeProviderException: Error running Reader: SQL Statement: SELECT [UniqueIdentifier], [Name] FROM [CMSImportState] where parent = @parent Exception: System.Data.SqlServerCe.SqlCeException: The specified table does not exist. [ CMSImportState ] at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr) at System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan() at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options) at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters) at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters) at SqlCE4Umbraco.SqlCEHelper.ExecuteReader(String commandText, SqlCeParameter[] parameters) at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) --- End of inner exception stack trace --- at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) at CMSImportLibrary.DAL.State.(Guid ) at CMSImport.Controls.ImportSteps.ConfirmSelectedOptions.(StringBuilder , Guid ) at CMSImport.Controls.ImportSteps.ConfirmSelectedOptions.(ImportState ) at CMSImport.Controls.ImportSteps.ConfirmSelectedOptions.InitializeState(ImportState state) at CMSImport.Controls.CMSImport.OnPreRender(EventArgs e)
Hi Robert,
CMSImport isn't supporting SQL CE sorry. Apart from the creation script I use a lot of sql queries that might not be compatible with sql server CE. If you want to try you can open the package.xml file for all the queries that generate the database. SqlServer express is supported.
Thanks,
Richard
Hi Richard,
Glad I quickly found this "bug". I started playing around more seriously with a couple of migration projects, but I was only using SQL CE for simplicity.
The migrate tool in WebMatrix is quite decent by the way: only needed to manually update the umbracoDbDSN key under appSettings in the web.config and the database was upgraded to SQLExpress.
Another tip to others in the same situation: you need to uninstall/install CMSImport for it to work.
Mark.
Thanks Mark for your reply. I will support this SQL CE in a next version also. but at the moment it isn't.
Thanks,
Richard
is working on a reply...