WHMCS - Remove Multiple wrong/old subscription

Please find the steps to resolve the issue of associating account in WHMCS.

1.       Check the following for the active product instance in WHMCS admin portal and update them accordingly. 

• Subscription Id,
  
• Status, (Active status)
  
• Next Due Date
  

 

2.       Remove any existing entry for the subscription ID in the [AzurePackSubscriptionsInfo] table

 

Sample Query:   delete from [DBName].[API].[AzurePackSubscriptionsInfo] where Id = <Id to delete>

 

3.       Click the Associate Account button.  This should create a new entry in the [AzurePackSubscriptionsInfo] table with the appropriate SubscriptionId and ProductInstanceId (ProductInstanceId will be present in the AddtionalInfoJson column)

• Related Articles

• How to enable additional users to see WAP Subscription Resources?

  In Windows Azure Pack you can make a user as a co-admin for a given subscription. This will allow them to view and manage resources under that subscription. For example say you have a project team and you want all the members of the project team to ...

• Invoices from Usage and Billing Solutionin WAP is not sent to WHMCS portal

  If the invoices are generated in WHMCS portal with zero amount for the previous month, please delete them and ensure the below steps.   Open ‘CloudAssert.WAP.Billing.AgentService.exe.config’ file located at ‘C:\Program Files\ CloudAssertBilling\ ...

• VMs Count and Duplicate display of Vms Issue in WAP VConnect

  If Duplicate VMs are displayed , please do the follow checks in VConnect. Check VMConfig Table of VConnect for Virtual Machine details of the Subscription . If table contains duplicate VMs for same Subscription, look for the Current State , Desired ...

• Error message: Error creating VM. Operation 'CreateVM CustomizationOp' failed. Error executing customization script.. Error message: Set-NetworkAdapter The network "Name of the NetworkAdapter" doesn't exist on the host. . Error Code: -1

  Root Cause: The value for the Network may be incorporated with a wrong value. For example, you may provided Network Adapter which is not listed/available in VCenter.   Resolution: Navigate to  WAP Admin Portal --> VConnect--> Connections--> Choose a ...

• Different Type of Credits available in Cloud Assert Usage and Billing Solution

    TYPES OF CREDITS IN BILLING SOLUTION Billing solution for Microsoft Azure Stack allows the administrator to set credits for the tenants. There are five types of credits, they are as follows: Recurring Credit  One-Time Credit User Credit Unit Credit ...