A customer encountered the error below when deploying a new version of an application.
It was determined that the SQL Server account used as the DB Administrative Account needed the "Control Server" securable/permission. Once this permission was added, the promotion was successful.
Timestamp: 05/21/2013 02:34:01 PM Application: Storage Controlling Services Version 1 4cffcc32-3d96-41c2-8263-1017fc958f9a SessionId: 2ec2d374-43c2-e211-864f-90b11c1862ab SessionActive: false ProviderName: Apprenda, Inc 00000000-0000-4000-0000-000000000001 Tenant: Apprenda, Inc 00000000-0000-4000-0000-000000000001 User: 7051fd78-7145-e211-8803-90b11c1862b3 Error event created by Apprenda.SaaSGrid.Data.Services.StorageManager from machine MACHINENAME. -----------------LogMessage----------------- The Storage Manager encountered an unexpected error during the creation of an application partition for the application 58a276a4-43c2-e211-864f-90b11c1862ab belonging to provider c5040e79-d1aa-4e5b-ac56-7f0656ffe4c8. -----------------EndLogMessage----------------- -----------------SurfaceException (System.NullReferenceException)----------------- Object reference not set to an instance of an object. Server stack trace: at Microsoft.SqlServer.Management.Smo.ResourceGovernor.get_Enabled() at Apprenda.Database.SqlServer2005.SqlServer.IsResourceGovernorAvailble() at System.Lazy`1.CreateValue() Exception rethrown at [0]: at Microsoft.SqlServer.Management.Smo.ResourceGovernor.get_Enabled() at Apprenda.Database.SqlServer2005.SqlServer.IsResourceGovernorAvailble() at System.Lazy`1.CreateValue() at System.Lazy`1.LazyInitValue() at Apprenda.Database.SqlServer2005.SqlServer.StopThrottling(String name) at Apprenda.Database.SqlServer2005.SqlServerDatabase.Undeploy() at Apprenda.SaaSGrid.Data.AbstractADP.CreateSharedTables(ApplicationCreateInstruction instruction) at Apprenda.SaaSGrid.Data.IsolatedDatabaseADP.Create(ApplicationCreateInstruction instruction) at Apprenda.SaaSGrid.Data.Services.StorageManager.CreateApplicationPartition(BasicDataPartitionParametersDTO sourceParameters, ApplicationCreateInstructionDTO instructionDTO, Dictionary`2 predefinedTableNames, FileSystemUri provisionedSchema) -----------------EndSurfaceException-----------------
Comments