Symptoms

Provisioning of WAP subscriptions fails with the error:

Task ID 
2557134
Queue name  
aps_application_instance272 subscription_id1000782
Task name   
Provisioning "Context" for APS application Windows Azure Pack APS Package
Task description    
Provisioning resource 6f2a8027-abaf-4c88-bafb-70dcf25b1cdf of type "contexts" (http://sp.parallels.com/infrastructure/cloudos/context/1.0) for APS application Windows Azure Pack APS Package
Belongs to groups   
provide subscription 1000782
Subscription ID 
1000782
Queue status    
Failed
Start not earlier than  
Jun-24-2014 15:15
Method name 
taskExecuteWorkflow on SCREF:SaaSManagerTasks:0
Last execution output   
Internal error: SDK::Platform::blob Plesk::SaaS::SaaSManagerTasks_impl::taskExecuteWorkflow(const SDK::Platform::Properties&) : [APSC] [AZURE] {"Code":"ErrorFromUnderlyingNotificationSubscribers","Message":"One or more errors occurred while contacting the underlying notification subscribers. The operation may be partially completed.","Details":[]}.

Nothing specific is shown in /var/log/WAP/errors.log and /var/log/WAP/wap.log

Microsoft-WindowsAzurePack-MgmtSvc-Usage/Operational section of Event Viewer on WAP node shows many errors of the following type:

Log Name:      Microsoft-WindowsAzurePack-MgmtSvc-Usage/Operational
Source:        Microsoft-WindowsAzurePack-MgmtSvc-Usage
Date:          6/25/2014 7:32:31 AM
Event ID:      12
Task Category: (65522)
Level:         Error
Keywords:      None
User:          IIS APPPOOL\MgmtSvc-UsageCollector
Computer:      HV-WAPINT01.hvinfra.local
Description:
Error:
System.Data.SqlClient.SqlException (0x80131904): Error: 9002, Severity: 17, State: 2, Procedure GetSchedulerConfiguration, Line 15, Message: The transaction log for database 'Microsoft.MgmtSvc.Usage' is full due to 'LOG_BACKUP'. 
   at System.Data.SqlClient.SqlConnection.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.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
at System.Data.SqlClient.SqlDataReader.TryNextResult(Boolean& more)
at System.Data.SqlClient.SqlDataReader.NextResult()
at Microsoft.WindowsAzure.Server.Usage.Storage.ConfigurationStorageClient.<>c__DisplayClass6.<GetSchedulerConfigurationAsync>b__1(SqlDataReader reader)
   at Microsoft.WindowsAzure.Server.Common.SqlProcExecutor.<ExecuteReaderProcAsync>d__6`1.MoveNext()
.....

Cause

Issues on the side of WAP MSSQL database

Resolution

Please check the transaction log settings of MSSQL database Microsoft.MgmtSvc.Usage. The following Microsoft article could be useful: http://support.microsoft.com/kb/317375. If it does not help, please contact Microsoft support to get further assistance.

Internal content