SAP reconciliation troubleshooting

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-28-2023 12:15 PM
Hello all,
Could you provide me with some advices in order to troubleshoot the sap reconciliation?? I recently connect a SAP instance with SAM, but the reconciliation didn´t catch the used sap user licenses.
In one hand, I created an entitlement using the automatically created (by the integration with sap) software model. I'm sure the software model has the product=Named User.
In the other hand, I have many records pulled from SAP instance integration. These records represent the licenses used coming from SAP and are stored in the "samp_sap_system_user" table. These records are related to the same "Named user type"(validated with sys_id) (I'm hidding the personal info)
Finally, in the reconciliation result the licenses required appears a 0, and in my understanding it means that reconciliation process didn´t count the licenses used coming from "samp_sap_system_user" table
Hope you can help me.
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-30-2023 06:37 PM
To troubleshoot the issue, you can follow these steps:
- Check the reconciliation settings:
Ensure that the reconciliation task is configured correctly to process the licenses from the "samp_sap_system_user" table. You can do this by checking the "Reconciliation Tasks" settings in your ServiceNow instance:
- Navigate to "Software Asset" > "Reconciliation Tasks."
- Look for the SAP reconciliation task and open it.
- Check if the "Data source table" is set to "samp_sap_system_user."
- Verify if the "Matcher" and "Matcher type" are configured correctly to match records from the "samp_sap_system_user" table with the entitlement records.
- Validate the relationship between the Software Model and the records in the "samp_sap_system_user" table:
Ensure that the records in the "samp_sap_system_user" table are linked to the correct Software Model, which represents the Named User licenses.
- Check the Software Model in the "Software Models" list and verify if it has the correct "Product."
- Open a few records from the "samp_sap_system_user" table and confirm that the "Software Model" field is set to the correct Named User license Software Model.
- Check the Entitlement configuration:
Verify if the entitlement you created is configured correctly.
- Navigate to "Software Asset" > "Entitlements."
- Open the Entitlement you created for the Named User licenses.
- Ensure that the "Software Model" field is set to the correct Named User license Software Model.
- Check if the "License metric" is set to "Named User" or an appropriate metric for SAP user licenses.
- Verify if the "Start date" and "End date" are within the range of the reconciliation period.
- Verify the Allocation Rules:
Allocation rules are used to allocate licenses to users based on specific criteria. Ensure that the allocation rules are configured correctly for the Named User licenses.
- Navigate to "Software Asset" > "Allocation Rules."
- Check if there is an allocation rule for the Named User licenses.
- Verify if the allocation rule is set to allocate licenses based on the correct criteria, such as the user's organization, location, or department.
- Review the Reconciliation Logs:
Reconciliation logs can provide valuable information on any issues encountered during the reconciliation process.
- Navigate to "Software Asset" > "Reconciliation Results."
- Open the reconciliation result for the SAP instance.
- Check the "Licenses required" field to see if it is still showing 0.
- Review the "Details" and "Messages" tabs for any error messages or warnings related to the reconciliation process.
By following these steps, you should be able to identify and resolve the issue with the SAP reconciliation not catching the used SAP user licenses. If the problem persists, consider reaching out to ServiceNow support for further assistance.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-02-2023 02:01 PM
Hi Duggi,
Thanks for the information. I tried to validate the info you mentioned, however, I can´t found in my instance the Reconciliation Task you mentioned in Reconciliation settings(I also tried in a demo instance with SAM).
Could you provide me with additional info to navigate directly to this task?
- Navigate to "Software Asset" > "Reconciliation Tasks."
- Look for the SAP reconciliation task and open it.
- Check if the "Data source table" is set to "samp_sap_system_user."
Thanks in advance!