error on Installing hglab

Alexander's Avatar

Alexander

29 Nov, 2013 04:27 AM

Could not perform Setup to version 1.0.1.0

HgLab.Core.Framework.Servicing.ServicingException: Could not perform Setup to version 1.0.1.0 ---> HgLab.Core.Framework.Servicing.ServicingException: Could not execute DbMigrationTask for running version 0.0 and target version 1.0.1.0 ---> HgLab.Core.Framework.Servicing.Db.DbMigrationException: Cannot upgrade to '0.1.450' ---> HgLab.Core.Framework.Servicing.Db.DbMigrationException: Cannot execute 'insert into Setting
values ((select coalesce(max(ID), 0) + 1 from [Setting] where ID < 10000), N'application', N'instance-identifier', replace(lower(newid()), '-', '')); insert into SchemaInfo values (20121217075632);

' ---> System.Data.SqlClient.SqlException: Subqueries are not allowed in this context. Only scalar expressions are allowed. в System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) в System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) в System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) в System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) в System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) в System.Data.SqlClient.SqlCommand.ExecuteNonQuery() в HgLab.Core.Framework.Servicing.Db.DbSchemaMigration.ApplyMigration(SqlTransaction sqlTransaction, SqlConnection sqlConnection, String migration) в d:\projects\hglab\src\HgLab.Core\Framework\Servicing\Db\DbSchemaMigration.cs:строка 95 --- Конец трассировки внутреннего стека исключений --- в HgLab.Core.Framework.Servicing.Db.DbSchemaMigration.ApplyMigration(SqlTransaction sqlTransaction, SqlConnection sqlConnection, String migration) в d:\projects\hglab\src\HgLab.Core\Framework\Servicing\Db\DbSchemaMigration.cs:строка 103 в HgLab.Core.Framework.Servicing.Db.DbSchemaMigration.UpgradeDatabase(SqlTransaction sqlTransaction, SqlConnection sqlConnection, Version migrationVersion) в d:\projects\hglab\src\HgLab.Core\Framework\Servicing\Db\DbSchemaMigration.cs:строка 76 --- Конец трассировки внутреннего стека исключений --- в HgLab.Core.Framework.Servicing.Db.DbSchemaMigration.UpgradeDatabase(SqlTransaction sqlTransaction, SqlConnection sqlConnection, Version migrationVersion) в d:\projects\hglab\src\HgLab.Core\Framework\Servicing\Db\DbSchemaMigration.cs:строка 83 в HgLab.Core.Framework.Servicing.Db.DbSchemaMigration.UpgradeDatabase(SqlTransaction sqlTransaction, SqlConnection sqlConnection, List1 migrationVersions) в d:\projects\hglab\src\HgLab.Core\Framework\Servicing\Db\DbSchemaMigration.cs:строка 65 в HgLab.Core.Framework.Servicing.Db.DbSchemaMigration.UpgradeDatabase(Version currentVersion, Version targetVersion) в d:\projects\hglab\src\HgLab.Core\Framework\Servicing\Db\DbSchemaMigration.cs:строка 53 в HgLab.Core.Framework.Servicing.Impl.DbMigrationTask.InternalExecute(Version runningVersion, Version targetVersion) в d:\projects\hglab\src\HgLab.Core\Framework\Servicing\Impl\DbMigrationTask.cs:строка 12 в HgLab.Core.Framework.Servicing.Task.Execute(Version runningVersion, Version targetVersion) в d:\projects\hglab\src\HgLab.Core\Framework\Servicing\Task.cs:строка 21 --- Конец трассировки внутреннего стека исключений --- в HgLab.Core.Framework.Servicing.Task.Execute(Version runningVersion, Version targetVersion) в d:\projects\hglab\src\HgLab.Core\Framework\Servicing\Task.cs:строка 30 в HgLab.Core.Framework.Servicing.Impl.ServicingManagerService.ExecuteTaskSequence(IEnumerable1 taskSequence, Version runningVersion, Version targetVersion) в d:\projects\hglab\src\HgLab.Core\Framework\Servicing\Impl\ServicingManagerService.cs:строка 64 в HgLab.Core.Framework.Servicing.Impl.ServicingManagerService.PerformSetup(String fullName, String login, String emailAddress, String password) в d:\projects\hglab\src\HgLab.Core\Framework\Servicing\Impl\ServicingManagerService.cs:строка 84 --- Конец трассировки внутреннего стека исключений --- в HgLab.Core.Framework.Servicing.Impl.ServicingManagerService.PerformSetup(String fullName, String login, String emailAddress, String password) в d:\projects\hglab\src\HgLab.Core\Framework\Servicing\Impl\ServicingManagerService.cs:строка 93 в HgLab.Areas.Dashboard.Controllers.ServicingController.Setup(SetupModel model) в d:\projects\hglab\src\HgLab\Areas\Dashboard\Controllers\ServicingController.cs:строка 77

  1. Support Staff 1 Posted by Anton Gogolev on 02 Dec, 2013 08:01 AM

    Anton Gogolev's Avatar

    Alexander,

    What version of SQL Server are you using?

  2. 2 Posted by Alexander on 02 Dec, 2013 01:26 PM

    Alexander's Avatar

    Anton,

    Everything works fine, my mistake. I tried to use SQL Server 2005.
    But if you use NHibernate, why not use other versions of SQL Server оr other DataBases?

  3. Support Staff 3 Posted by Anton Gogolev on 02 Dec, 2013 01:30 PM

    Anton Gogolev's Avatar

    I'm planning on adding support for other database servers/engines in
    upcoming versions. For now, HgLab only works with SQL Server 2008 (and
    later) primarily due to my limited resources. Plus, NHibernate is only one
    part of the question; there's also database migration aspect that has to be
    addressed as well.

  4. 4 Posted by Alexander on 02 Dec, 2013 03:55 PM

    Alexander's Avatar

    Anton, thanks for clarifying.

    I have some non public information about vulnerability in your licensing system, please contact me by e-mail in profile.

    PS Я так понимаю русский для Вас родной, можно ли написать по русски?

  5. Anton Gogolev closed this discussion on 03 Dec, 2013 12:51 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

Recent Discussions

18 Jan, 2025 05:02 PM
13 Jan, 2025 10:42 AM
29 Nov, 2024 10:00 AM
12 Jan, 2023 12:25 PM
10 Jan, 2023 04:49 PM