error invalid object name 'conciergelockunlock' after install

Jonas Eriksson 930 posts 1825 karma points

Feb 09, 2011 @ 19:53

I tried to install Concierge, but got this error:

Invalid object name 'ConciergeLockUnLock' *sigh*

At /umbraco/webservices/TreeDataService.ashx?rnd=c398d9e5ef154144a0ddd4ef46f22f62&id=-1&treeType=content&contextMenu=true&isDialog=false&rnd2=11.1 (Referred by: http://gvk.dev.golvbranschen.se/umbraco/umbraco.aspx): System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'ConciergeLockUnLock'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() 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) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteScalar(String commandText, SqlParameter[] parameters) at umbraco.DataLayer.SqlHelper`1.ExecuteScalar[T](String commandText, IParameter[] parameters)

Copy Link

Jonas Eriksson 930 posts 1825 karma points

Feb 09, 2011 @ 20:40

Do'h! My bad! A noob error gave me so much frustration. Always remember to unblock a zip containing dll's after download - mmkay!? *double sigh* Unblocked the zip an reinstalled the concierge 2.01 + copying updated files from 2.01 update. All seems to work fine now. Happiness!

Copy Link

Mila 60 posts 79 karma points

Feb 28, 2012 @ 19:45

I'm also getting the same error

Invalid object name 'ConciergeLockUnLock'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'ConciergeLockUnLock'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Invalid object name 'ConciergeLockUnLock'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +404
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +412
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1363
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +59
   System.Data.SqlClient.SqlDataReader.get_MetaData() +118
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6387873
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +6389442
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +538
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +28
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +256
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +228
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +262
   umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters) +26
   umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +148

[SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader]
   umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +261
   Umbraco.Concierge.LockUnLock.BusinessLogic.Ticket.GetActiveTicketsFromUser(Int32 UserID) in d:\TeamCity\buildAgent\work\ae600be68c84b35e\Umbraco.Concierge V4\Businesslogic\CheckInCheckout\Ticket.cs:243
   Umbraco.Concierge.plugins.Concierge.CheckInOutOverView.bindTickets() in d:\TeamCity\buildAgent\work\ae600be68c84b35e\Umbraco.Concierge V4\plugins\Concierge\CheckInOutOverView.aspx.cs:32
   Umbraco.Concierge.plugins.Concierge.CheckInOutOverView.Page_Load(Object sender, EventArgs e) in d:\TeamCity\buildAgent\work\ae600be68c84b35e\Umbraco.Concierge V4\plugins\Concierge\CheckInOutOverView.aspx.cs:20
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25
   umbraco.BasePages.BasePage.OnLoad(EventArgs e) +19
   System.Web.UI.Control.LoadRecursive() +71
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3064

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272

Copy Link

Mila 60 posts 79 karma points

Feb 28, 2012 @ 20:56

I fixed my problem by getting a concierge new version:

http://nightly.umbraco.org/UmbracoConcierge/2.0.2/

Now, it's working fine :D

Copy Link

is working on a reply...

Flag this post as spam?

Error Invalid object name 'ConciergeLockUnLock' after install

Invalid object name 'ConciergeLockUnLock'.