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.