Hosted Installation with Sql Server 2012

Justin Wise's Avatar

Justin Wise

28 May, 2013 01:26 AM

I'm having trouble getting hglab up and running in a hosted environment. I think it might have something to do with the SQL 2012 server, but I'm not sure. Could you give some advice.

  1. Support Staff 1 Posted by Anton Gogolev on 28 May, 2013 02:41 AM

    Anton Gogolev's Avatar

    Justin,

    What is the problem specifically?

  2. 2 Posted by Justin Wise on 28 May, 2013 10:10 AM

    Justin Wise's Avatar

    Sorry, I forgot to include the stack trace. Also, does mercurial need to
    be installed on the shared hosting server or does hglab handle that
    internally?

    HgLab.Core.Framework.Db.DbMigrationException: Cannot upgrade to
    '0.1.450' ---> HgLab.Core.Framework.Db.DbMigrationException: Cannot
    execute '

    ALTER TABLE [dbo].[Milestone] DROP CONSTRAINT
    [FK_Milestone_ProjectID_Project_ID];
    DROP TABLE [dbo].[Milestone];

    ' ---> System.Data.SqlClient.SqlException:
    'FK_Milestone_ProjectID_Project_ID' is not a constraint.
    Could not drop constraint. See previous errors.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException
    exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.SqlInternalConnection.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.SqlCommand.RunExecuteNonQueryTds(String
    methodName, Boolean async, Int32 timeout)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1
    completion, String methodName, Boolean sendToPipe, Int32 timeout,
    Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at HgLab.Core.Framework.Db.DbSchemaMigration.ApplyMigration(SqlTransaction
    sqlTransaction, SqlConnection sqlConnection, String migration) in
    d:\Projects\hglab\src\HgLab.Core\Framework\Db\DbSchemaMigration.cs:line
    95
       --- End of inner exception stack trace ---
       at HgLab.Core.Framework.Db.DbSchemaMigration.ApplyMigration(SqlTransaction
    sqlTransaction, SqlConnection sqlConnection, String migration) in
    d:\Projects\hglab\src\HgLab.Core\Framework\Db\DbSchemaMigration.cs:line
    100
       at HgLab.Core.Framework.Db.DbSchemaMigration.UpgradeDatabase(SqlTransaction
    sqlTransaction, SqlConnection sqlConnection, Version migrationVersion)
    in d:\Projects\hglab\src\HgLab.Core\Framework\Db\DbSchemaMigration.cs:line
    76
       --- End of inner exception stack trace ---
       at HgLab.Core.Framework.Db.DbSchemaMigration.UpgradeDatabase(SqlTransaction
    sqlTransaction, SqlConnection sqlConnection, Version migrationVersion)
    in d:\Projects\hglab\src\HgLab.Core\Framework\Db\DbSchemaMigration.cs:line
    81
       at HgLab.Core.Framework.Db.DbSchemaMigration.UpgradeDatabase(SqlTransaction
    sqlTransaction, SqlConnection sqlConnection, List`1 migrationVersions)
    in d:\Projects\hglab\src\HgLab.Core\Framework\Db\DbSchemaMigration.cs:line
    65
       at HgLab.Core.Framework.Db.DbSchemaMigration.UpgradeDatabase(Version
    currentVersion, Version targetVersion) in
    d:\Projects\hglab\src\HgLab.Core\Framework\Db\DbSchemaMigration.cs:line
    53
       at HgLab.Areas.Dashboard.Controllers.SetupController.Setup(SetupModel
    model) in d:\Projects\hglab\src\HgLab\Areas\Dashboard\Controllers\SetupController.cs:line
    51

  3. Support Staff 3 Posted by Anton Gogolev on 28 May, 2013 12:16 PM

    Anton Gogolev's Avatar

    Justin,

    Thanks for the stacktrace. Is this a fresh installation?

    Yeah, HgLab doesn't need Mercurial to operate - everything's built in.

  4. 4 Posted by Justin Wise on 28 May, 2013 02:01 PM

    Justin Wise's Avatar

    Yes, this is a fresh install. I can try a beta version if need be as well.

  5. Support Staff 5 Posted by Anton Gogolev on 28 May, 2013 02:38 PM

    Anton Gogolev's Avatar

    Justin,

    There's no separate beta version per se: HgLab is beta itself.

    As for the issue, this looks like a SQL Server 2012-specific issue. I'll try to reproduce it and will ping you back ASAP.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

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

03 Aug, 2022 01:49 PM
05 Jul, 2022 07:01 PM
28 Mar, 2022 04:42 PM
21 Jan, 2022 10:43 AM
20 Jan, 2022 10:45 AM

 

18 Jan, 2022 10:15 AM
19 Mar, 2021 06:13 PM
01 Mar, 2021 02:51 PM
01 Jan, 2021 02:19 AM
28 Aug, 2020 08:34 AM
23 Jun, 2020 08:29 AM