Octopus Server Errors

Legacy Uncategorised
1

I am running Windows Server 2008 x86
I have VS 2010 & VS 2008 installed with SP1 for both
I am using TeamCity to build

If there is any more information you need, feel free to use my email.
Thanks.

After Installation, on opening Octopus Tools and error dialog is presented:
Error: Could not load file or assembly
’Microsoft.Web.Administration, Version=7.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35’ or one of its dependencies.
The System cannot find the file specified.

After pressing “OK” the configuration window loads up. Under this everything works but installing the Portal.

Also on running the Octopus Server I get errors:

Setting SDK environment relative to C:\Program Files\Microsoft SDKs\Windows\v6.1
.
Targeting Windows Server 2008 x86 DEBUG

C:\Program Files\Microsoft SDKs\Windows\v6.1>cd \Octopus\Octopus\Server

C:\Octopus\Octopus\Server>Octopus.Server.exe
Starting server Octopus in interactive mode

  • Octopus

This mode is used for debugging and testing. To start the Windows Service,
use this command:

Octopus.Server.exe /start

If the service is not installed, use the MSI to install it.

The following appSettings are defined:

  • Logging.Level
  • Tasks.ExecutionThreads
  • Deployment.PackageCache
    Server is running

An unexpected error occurred while attempting to retrieve and execute a task: CR
EATE DATABASE statement not allowed within multi-statement transaction.
System.Data.SqlClient.SqlException (0x80131904): CREATE DATABASE statement not a
llowed within multi-statement transaction.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolea
n 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 cm
dHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, Tds
ParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName,
Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult res
ult, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at System.Data.SqlClient.SqlProviderServices.<>c__DisplayClassa.b__7(SqlConnection conn)
at System.Data.SqlClient.SqlProviderServices.UsingConnection(SqlConnection sq
lConnection, Action1 act) at System.Data.SqlClient.SqlProviderServices.UsingMasterConnection(SqlConnect ion sqlConnection, Action1 act)
at System.Data.SqlClient.SqlProviderServices.DbCreateDatabase(DbConnection co
nnection, Nullable1 commandTimeout, StoreItemCollection storeItemCollection) at System.Data.Objects.ObjectContext.CreateDatabase() at System.Data.Entity.Internal.DatabaseOperations.Create(ObjectContext object Context) at System.Data.Entity.Database.Create() at System.Data.Entity.CreateDatabaseIfNotExists1.InitializeDatabase(TContext
context)
at System.Data.Entity.Internal.InternalContext.<>c__DisplayClass5.b__3()
at System.Data.Entity.Internal.InternalContext.PerformInitializationAction(Ac
tion action)
at System.Data.Entity.Internal.InternalContext.PerformDatabaseInitialization(
)
at System.Data.Entity.Internal.LazyInternalContext.b__4(I
nternalContext c)
at System.Data.Entity.Internal.RetryAction1.PerformAction(TInput input) at System.Data.Entity.Internal.LazyInternalContext.InitializeDatabaseAction(A ction1 action)
at System.Data.Entity.Internal.LazyInternalContext.InitializeDatabase()
at System.Data.Entity.Internal.InternalContext.ExecuteSqlCommand(String sql,
Object[] parameters)
at System.Data.Entity.Database.ExecuteSqlCommand(String sql, Object[] paramet
ers)
at Octopus.Core.Persistance.DataContext.ExecuteProcedure(String storedProcedu
re, Object[] parameters) in c:\TeamCity\buildAgent\work\93ea602cb1d1c3f2\source
Octopus.Core\Persistance\DataContext.cs:line 27
at Octopus.Server.Tasks.TaskQueue.<>c__DisplayClass6.b__5() in
c:\TeamCity\buildAgent\work\93ea602cb1d1c3f2\source\Octopus.Server\Tasks\TaskQue
ue.cs:line 124
at Octopus.Core.Persistance.UnitOfWork.Within(Action action) in c:\TeamCity\b
uildAgent\work\93ea602cb1d1c3f2\source\Octopus.Core\Persistance\UnitOfWork.cs:li
ne 62
at Octopus.Server.Tasks.TaskQueue.TakeNextTask(IUnitOfWork unitOfWork, IDataC
ontext context) in c:\TeamCity\buildAgent\work\93ea602cb1d1c3f2\source\Octopus.S
erver\Tasks\TaskQueue.cs:line 121
at Octopus.Server.Tasks.TaskQueue.ExecuteNextTask() in c:\TeamCity\buildAgent
\work\93ea602cb1d1c3f2\source\Octopus.Server\Tasks\TaskQueue.cs:line 62
at Octopus.Server.Tasks.TaskQueue.PollForMoreWorkOnBackgroundThread(Object st
ate) in c:\TeamCity\buildAgent\work\93ea602cb1d1c3f2\source\Octopus.Server\Tasks
\TaskQueue.cs:line 41
An unexpected error occurred while attempting to retrieve and execute a task: CR
EATE DATABASE statement not allowed within multi-statement transaction.
System.Data.SqlClient.SqlException (0x80131904): CREATE DATABASE statement not a
llowed within multi-statement transaction.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolea
n 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 cm
dHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, Tds
ParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName,
Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult res
ult, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at System.Data.SqlClient.SqlProviderServices.<>c__DisplayClassa.b__7(SqlConnection conn)
at System.Data.SqlClient.SqlProviderServices.UsingConnection(SqlConnection sq
lConnection, Action1 act) at System.Data.SqlClient.SqlProviderServices.UsingMasterConnection(SqlConnect ion sqlConnection, Action1 act)
at System.Data.SqlClient.SqlProviderServices.DbCreateDatabase(DbConnection co
nnection, Nullable1 commandTimeout, StoreItemCollection storeItemCollection) at System.Data.Objects.ObjectContext.CreateDatabase() at System.Data.Entity.Internal.DatabaseOperations.Create(ObjectContext object Context) at System.Data.Entity.Database.Create() at System.Data.Entity.CreateDatabaseIfNotExists1.InitializeDatabase(TContext
context)
at System.Data.Entity.Internal.InternalContext.<>c__DisplayClass5.b__3()
at System.Data.Entity.Internal.InternalContext.PerformInitializationAction(Ac
tion action)
at System.Data.Entity.Internal.InternalContext.PerformDatabaseInitialization(
)
at System.Data.Entity.Internal.LazyInternalContext.b__4(I
nternalContext c)
at System.Data.Entity.Internal.RetryAction1.PerformAction(TInput input) at System.Data.Entity.Internal.LazyInternalContext.InitializeDatabaseAction(A ction1 action)
at System.Data.Entity.Internal.LazyInternalContext.InitializeDatabase()
at System.Data.Entity.Internal.InternalContext.ExecuteSqlCommand(String sql,
Object[] parameters)
at System.Data.Entity.Database.ExecuteSqlCommand(String sql, Object[] paramet
ers)
at Octopus.Core.Persistance.DataContext.ExecuteProcedure(String storedProcedu
re, Object[] parameters) in c:\TeamCity\buildAgent\work\93ea602cb1d1c3f2\source
Octopus.Core\Persistance\DataContext.cs:line 27
at Octopus.Server.Tasks.TaskQueue.<>c__DisplayClass6.b__5() in
c:\TeamCity\buildAgent\work\93ea602cb1d1c3f2\source\Octopus.Server\Tasks\TaskQue
ue.cs:line 124
at Octopus.Core.Persistance.UnitOfWork.Within(Action action) in c:\TeamCity\b
uildAgent\work\93ea602cb1d1c3f2\source\Octopus.Core\Persistance\UnitOfWork.cs:li
ne 62
at Octopus.Server.Tasks.TaskQueue.TakeNextTask(IUnitOfWork unitOfWork, IDataC
ontext context) in c:\TeamCity\buildAgent\work\93ea602cb1d1c3f2\source\Octopus.S
erver\Tasks\TaskQueue.cs:line 121
at Octopus.Server.Tasks.TaskQueue.ExecuteNextTask() in c:\TeamCity\buildAgent
\work\93ea602cb1d1c3f2\source\Octopus.Server\Tasks\TaskQueue.cs:line 62
at Octopus.Server.Tasks.TaskQueue.PollForMoreWorkOnBackgroundThread(Object st
ate) in c:\TeamCity\buildAgent\work\93ea602cb1d1c3f2\source\Octopus.Server\Tasks
\TaskQueue.cs:line 41

2

Hi Patrick,

My apologies, Tender marked this as spam for some reason so I’ve only just seen it.

The first issue looks to be that IIS 7 isn’t installed on the server, or that the IIS administrative tools aren’t installed. Could you send me a list of the enabled features under the IIS role in Windows Server?

The second error looks to be related to the Octopus database not being created (EF is trying to create it automatically). During the Octopus setup, did you run the “save and test” button on the Database tab?

Paul

3

The first issue (IIS not installed) could really use a friendly error message. Just hit this too :slight_smile:

4

Nick, was that when installing the Octopus Server or the Tentacle?

Paul

5

Server