Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Lachlann 344 posts 626 karma points
    Nov 11, 2013 @ 17:43
    Lachlann
    0

    Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader

    Using CMSImport

    Hi Richard.

    I have just installed the free version of the package and have tested it with some simple XML however I am getting an error

    Error during load, check the logfile for details Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader

    when i look at the log i get the following:

    ERROR umbraco.DataLayer.SqlHelper`1[[System.Data.SqlClient.SqlParameter, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] - [Thread 22] Error executing query  Select Id, Text from cmsTab 
    System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'cmsTab'.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
       at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
       at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters)
       at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
    ClientConnectionId:bd6abe99-89cb-44dc-a1e2-47bb95de7399
    2013-11-11 16:26:57,825 [19] INFO  umbraco.BusinessLogic.Log - [Thread 20] Redirected log call (please use Umbraco.Core.Logging.LogHelper instead of umbraco.BusinessLogic.Log) | Type: Error | User: 0 | NodeId: -1 | Comment: Error during load umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader ---> System.Data.SqlClient.SqlException: Invalid object name 'cmsTab'.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
       at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
       at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] 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.Helpers.DataHelper.GetAllDocumentTabs()
       at CMSImportLibrary.Helpers.TabInfoHelper.()
       at CMSImportLibrary.Helpers.TabInfoHelper.TabName(Int32 tabId)
       at CMSImport.Controls.ImportSteps.MapProperties.FormatCaption(Object name, Object alias, Int32 tabId)
       at ASP.umbraco_plugins_cmsimport_usercontrols_importsteps_mapproperties_ascx.__DataBinding__control3(Object sender, EventArgs e)
       at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
       at System.Web.UI.Control.DataBindChildren()
       at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
       at System.Web.UI.WebControls.Repeater.CreateItem(Int32 itemIndex, ListItemType itemType, Boolean dataBind, Object dataItem)
       at System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource)
       at System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e)
       at System.Web.UI.Control.DataBindChildren()
       at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
       at System.Web.UI.Control.DataBindChildren()
       at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
       at CMSImport.Controls.ImportSteps.MapProperties.InitializeStepControl(ImportState state)
       at CMSImport.Controls.CMSImport.OnPreRender(EventArgs e)

     

    I am running v6.1.6 with an SQL server 2008 DB. 

    Any Ideas?

    Cheers

    L

     

    Copy Link
  • Richard Soeteman 4035 posts 12842 karma points MVP
    Nov 12, 2013 @ 07:21
    Richard Soeteman
    0

    Hi,

    The installer couldn't install the required tables. Check manual configuration in the documentation http://soetemansoftware.nl/cmsimport/downloads for a complete create tables script.

    Cheers,

    Richard

    Copy Link
  • Lachlann 344 posts 626 karma points
    Nov 12, 2013 @ 10:19
    Lachlann
    0

    Thanks Richard.

    All of the tables seem to have been created by the installer. When i deleted them and tried again with the script from the manual setup It runs fine up to the final INSERT statements where it fails with error

    Invalid object name 'umbracoAppTree'.

     

    Any ideas?

    L

     

    Copy Link
  • Richard Soeteman 4035 posts 12842 karma points MVP
    Nov 12, 2013 @ 10:29
    Richard Soeteman
    0

    Could it be that your tables are not prefixed with dbo. ?

    Copy Link
  • Lachlann 344 posts 626 karma points
    Nov 12, 2013 @ 10:38
    Lachlann
    0

    Hmm the table names appear to be prefixed with dbo for example dbo.cmsContent etc.... should there be a table called umbracoAppTree? becuase I cannot see that one.

    Copy Link
  • Lachlann 344 posts 626 karma points
    Nov 12, 2013 @ 10:52
    Lachlann
    0

    I see from this post thatthe AppTree stuff may just be for older versions of Umbraco.

    http://our.umbraco.org/projects/developer-tools/cmsimport/bugs/42085-Invalid-object-name-umbracoAppTree-when-creating-tables-from-script

    I removedthe tables that were in the DB (relatign to CMS import) and ran the manual script minus the last INSERT statements. It compelted correctly however I am still faced with the original issue of not being able to import XML.

    L

     

     

    Copy Link
  • Richard Soeteman 4035 posts 12842 karma points MVP
    Nov 12, 2013 @ 11:05
    Richard Soeteman
    0

    Weird,

    Should only happen when the table can't be accessed.

    Copy Link
  • Lachlann 344 posts 626 karma points
    Nov 12, 2013 @ 11:10
    Lachlann
    0

    Hmm so Looking at the original Error at the top I do not seem to have any table called cmsTab. Could this have been removed in a recent update to Umbraco? The rest of my install seems to work fine.

    I just foudn this post about database changes for Umbraco 6 https://detangleddigital.wordpress.com/2013/02/11/umbraco-v6-database-changes/ 

    cmsTab is now called cmsPropertyTypeGroup.

     

    L

    Copy Link
  • Richard Soeteman 4035 posts 12842 karma points MVP
    Nov 12, 2013 @ 11:24
    Richard Soeteman
    0

    Think there is something serious wrong with the database but not sure what.

    Copy Link
  • Lachlann 344 posts 626 karma points
    Nov 12, 2013 @ 11:28
    Lachlann
    0

    Hey Richard,

    Should the package work for v6? if it should why would the error above reference tables that have been removed from Umbraco 6? 

    L

    Copy Link
  • Richard Soeteman 4035 posts 12842 karma points MVP
    Nov 12, 2013 @ 11:44
    Richard Soeteman
    0

    Yes fully functional on V6. Is the version number set correct in web.config?

    Copy Link
  • Lachlann 344 posts 626 karma points
    Nov 12, 2013 @ 11:54
    Lachlann
    0

    You hit the nail on the head :) The config didnt have the configuration status set for some reason.

    Thanks for your help Richard!

     

    L

    Copy Link
  • Sunshine Lewis 31 posts 140 karma points c-trib
    Jan 21, 2014 @ 15:51
    Sunshine Lewis
    0

    I also received this error message while trying to import an XML file to Umbraco 7.0.1 even though my installation of CMS import did not report any errors (in the UI). 

    Manually running the database script on page 45 of the CMSImport manual also solved the problem for me with the following modifications:

    1. I also had to remove the final insert statement (into UmbracoAppTree) because that was an "invalid object name"
    2. I had to remove every instance of the "ON [PRIMARY]" statement to get it to run on SQL azure
    Hopefully that helps someone else.
    Richard, should I have received a install error if the database script didn't work?
    Copy Link
  • Richard Soeteman 4035 posts 12842 karma points MVP
    Jan 21, 2014 @ 16:04
    Richard Soeteman
    0

    Hi,

    I have an update waiting that solves the Azure database errors. It was due to lack of my knowledge about Azure why this is is taking so long to fix. Sorry about that. Indeed the ON [Primary] is causing the issue. Only need to test the next version against the major supported versions of Umbraco should not be too long before it gets out.

    I agree the installer should have shown an error but it's based on the default Umbraco installer which doesn't show errors during the install process.

    Best,

    Richard

    Copy Link
  • Phil 5 posts 25 karma points
    Apr 24, 2014 @ 22:43
    Phil
    0

    I'm getting the same error with 7.1 running on Azure. Any news of the update plase?

    Copy Link
  • Richard Soeteman 4035 posts 12842 karma points MVP
    Apr 28, 2014 @ 06:46
    Richard Soeteman
    0

    Did you download the latest version of CMSImport? I think the issues is different than the above since the DB installer is optimized for Azure since 2.5.1. Can you send a copy of the log if you still have it to [email protected] please?

    Thanks,

    Richard

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft