tag:support.hglabhq.com,2012-10-18:/discussions/problems/155-hosted-installation-with-sql-server-2012HgLab: Discussion 2013-05-28T14:38:46Ztag:support.hglabhq.com,2012-10-18:Comment/270312322013-05-28T02:41:46Z2013-05-28T02:41:46ZHosted Installation with Sql Server 2012<div><p>Justin,</p>
<p>What is the problem specifically?</p></div>Anton Gogolevtag:support.hglabhq.com,2012-10-18:Comment/270312322013-05-28T10:10:16Z2013-05-28T10:10:16ZHosted Installation with Sql Server 2012<div><p>Sorry, I forgot to include the stack trace. Also, does mercurial
need to<br>
be installed on the shared hosting server or does hglab handle
that<br>
internally?</p>
<p>HgLab.Core.Framework.Db.DbMigrationException: Cannot upgrade
to<br>
'0.1.450' ---> HgLab.Core.Framework.Db.DbMigrationException:
Cannot execute '</p>
<p>ALTER TABLE [dbo].[Milestone] DROP CONSTRAINT<br>
[FK_Milestone_ProjectID_Project_ID]; DROP TABLE
[dbo].[Milestone];</p>
<p>' ---> System.Data.SqlClient.SqlException:
'FK_Milestone_ProjectID_Project_ID' is not a constraint. Could not
drop constraint. See previous errors.<br>
at System.Data.SqlClient.SqlConnection.OnError(SqlException
exception, Boolean breakConnection, Action<code>1
wrapCloseInAction) at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection, Action</code>1
wrapCloseInAction)<br>
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)<br>
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream,<br>
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject<br>
stateObj, Boolean& dataReady)<br>
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
methodName, Boolean async, Int32 timeout)<br>
at
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource<code>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</code>1
migrationVersions)<br>
in
d:\Projects\hglab\src\HgLab.Core\Framework\Db\DbSchemaMigration.cs:line<br>
65<br>
at
HgLab.Core.Framework.Db.DbSchemaMigration.UpgradeDatabase(Version
currentVersion, Version targetVersion) in<br>
d:\Projects\hglab\src\HgLab.Core\Framework\Db\DbSchemaMigration.cs:line<br>
53<br>
at
HgLab.Areas.Dashboard.Controllers.SetupController.Setup(SetupModel
model) in
d:\Projects\hglab\src\HgLab\Areas\Dashboard\Controllers\SetupController.cs:line<br>
51</p></div>Justin Wisetag:support.hglabhq.com,2012-10-18:Comment/270312322013-05-28T12:16:51Z2013-05-28T12:16:51ZHosted Installation with Sql Server 2012<div><p>Justin,</p>
<p>Thanks for the stacktrace. Is this a fresh installation?</p>
<p>Yeah, HgLab doesn't need Mercurial to operate - everything's
built in.</p></div>Anton Gogolevtag:support.hglabhq.com,2012-10-18:Comment/270312322013-05-28T14:01:21Z2013-05-28T14:01:21ZHosted Installation with Sql Server 2012<div><p>Yes, this is a fresh install. I can try a beta version if need
be as well.</p></div>Justin Wisetag:support.hglabhq.com,2012-10-18:Comment/270312322013-05-28T14:38:46Z2013-05-28T14:38:46ZHosted Installation with Sql Server 2012<div><p>Justin,</p>
<p>There's no separate beta version per se: HgLab is beta
itself.</p>
<p>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.</p></div>Anton Gogolev