This article provides a fix for error message related to the resources of BlackBerry UDS activation.
This article applies to MachPanel v4.9.20 only.
ERR MSG: Cannot sell packages. Available resources are less than requested packages. Please upgrade you plan or buy related Add-ons.
This error message appears showing the resources for BlackBerry UDS activations, which is not supported in 4.9.20. See the snapshot below:
- Please stop all the services from the MachPanel Configuration studio.
- Now, login to the SQL Management studio using sa user name and password.
- Right-click on MachPanel_db node, and then select New Query.
- Copy & paste the code as given below and execute.
- Now, restart all the services.
Note: This script needs to be executed every time a new service plan is made and sold or resources of the existing plan are modified/changed. Plus after applying the fix the provisioning will again return an error that “OU already exists” and operation can only be successful after deleting the OU from AD.
Code Snippet
DECLARE @CompanyId int
DECLARE GetAllCompanies Cursor FOR select CompanyId from tblCompanies
OPEN GetAllCompanies
FETCH NEXT FROM GetAllCompanies INTO @CompanyId
WHILE (@@FETCH_STATUS = 0)
BEGIN
Update HB_tblPackagesDetail set ResourceQuantity = '0' where ResourceID =
(Select ResourceID from HB_tblResources where ResourceInternalID = '515' and CompanyId = @CompanyId)
Update HB_tblPackagesSolddetail set ResourceQuantity = '0' where ResourceID =
(Select ResourceID from HB_tblResources where ResourceInternalID = '515' and CompanyId = @CompanyId)
Update HB_tblAddonsSoldDetail set ResourceQuantity = '0' where ResourceID =
(Select ResourceID from HB_tblResources where ResourceInternalID = '515' and CompanyId = @CompanyId)
Update HB_tblAddonTypeDetail set ResourceQuantity = '0' where ResourceID =
(Select ResourceID from HB_tblResources where ResourceInternalID = '515' and CompanyId = @CompanyId)
FETCH NEXT FROM GetAllCompanies INTO @CompanyId
END
CLOSE GetAllCompanies
DEALLOCATE GetAllCompanies
GO
<