Overview
On-Premise customers may run into a challenge where they cannot view License Components and Allotments in the Admin Console (Admin Console > System > Management > License Information).
You may see errors like below in the SBS logs:
- ERROR com.jivesoftware.community.license.metering.impl.MeteringEncryptionProvider - There was an error with Encryption Algorithm or the data is not encrypted with the same algorithm.
- DEBUG com.jivesoftware.community.license.metering.impl.MeteringDaoImpl - No status bean found for Thu Aug 05 00:00:00 BST 2021, marketplace, occupiedseats.
- Error finalising cipher data: mac check in GCM failed
This happens because the Licensing page is unable to load data from the jivemetering table. This could have been caused by an incorrect license being applied recently.
This article helps solve the above issue.
Prerequisites
The database should be backed up, as the solution involves a destructive action on the database. Take special care about this on Production servers.
Solution
This involves truncating the jivemetering table to remove any corrupt entries. You should backup the database and involve your DBA in this operation.
SQL Commands to execute on the SBS database:
- Check count of lines in the table:
select count(*) from jivemetering;
(Should return non-Zero value) - Delete the entries:
delete from jivemetering;
- Commit changes:
commit;
- Check count of lines in the table:
select count(*) from jivemetering
; (Should return Zero)
Testing
Navigate to Admin Console > System > Management > License Information.
You should be able to see License Allotments and Components.
Comments
0 comments
Please sign in to leave a comment.