IBM Support

duplicate users in license collection in mongodb are consuming App points

Troubleshooting


Problem

The number of app points consumed is greater than the number of app points assigned to the users. This issue can occur after a new environment was created using the same MongoDB. After the environment was re-created and the old MongoDB data was reused, the same users were created with different entitlements, resulting in duplicate entries being generated in the MongoDB license collection.

Symptom

A duplicate entry for the user present in the MongoDB license collection.

To resolve the issue login into MongoDB pod. Access the MongoDB pod. You can refer to the below documentation.
https://www.ibm.com/support/pages/node/7011393
Once logged into the MongoDB pod, run the following command to view the available databases:
Use the ibm-sls_sls_licensing collection to check the user entry in collection.
image-20250223224758-2
To search for a specific user in the licenses collection in MongoDB, use the following query:

In this case, we’re searching for the user "mongotesting2".

 db.licenses.find({"username": "mongotesting2" })

From the results, we see that the "mongotesting2" user was created on 09-12-2024
Owner: "tripti-aff590b3"
ProductId: "MAS-Admin-Base"
image-20250223231121-3
In the image below, we’re searching for duplicate user entries using the following query:
db.licenses.find()
From the results, we see duplicate entry for the "mongotesting2" user, created on 10-12-2024
Owner: "tripti-e6d62635"
ProductId: "MAS-Admin-Premium"
image-20250223234635-2
For the duplicate user "mongotesting2", the licenseId remains the same, but the owner and productId values are different:
  • First Entry:

    • Created On: 09-12-2024
    • Owner: "tripti-aff590b3"
    • ProductId: "MAS-Admin-Base"
  • Second Entry:

    • Created On: 10-12-2024
    • Owner: "tripti-e6d62635"
    • ProductId: "MAS-Admin-Premium"

This confirms that the user has duplicate entries with different ownership and productId.

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"ARM Category":[{"code":"a8m3p000000hAeeAAE","label":"Maximo Application Suite-\u003ECore"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"},{"Product":{"code":"SSRHPA","label":"IBM Maximo Application Suite"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}},{"Product":{"code":"SSWT9A","label":"IBM Control Desk"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
18 September 2025

UID

ibm17180697