Software Asset Management : Entitlement Creation : "purchased rights" in alm_license is limited by "integer" field type, while customer can have huge value that can only be contained by "Long" type - Support and Troubleshooting

Software Asset Management : Entitlement Creation : "purchased rights" in alm_license is limited by "integer" field type, while customer can have huge value that can only be contained by "Long" type Issue Software Asset Management : Entitlement Creation : "purchased rights" in "alm_license" table is limited by "integer" field type, while customer can have huge value that can only be contained by "Long" type

Release This issue will be available for all Software asset management (SAM) customer's and are creating entitlement with purchase rights going beyond the integer limit of "2,147,483,647"

Cause This issue will be available for all Software asset management (SAM) customer's and are creating entitlement with purchase rights going beyond the integer limit of "2,147,483,647".

Open Entitlement page Create entitlement with purchased rights more than "2,147,483,647" , it will get changed to ""2,147,483,647" as the data type is = Integer.

Resolution To Remediate the above issue, customers need to replace the below table's columns from "Int" to "Long".

Below are the steps to be followed, based on the customer who is implementing the changes.

Category 1 For new customer's which are starting SAM journey and are planning to use the large quantity as purchase rights with quantity more than "2,147,483,647".

Steps : they can simply change table's column - data type from "Int" to "Long" , if the data is not available in this columns of tables. If data is available it will not allow direct updates from UI.

Note : If data deletion / recreation is not possible, Kindly follow the steps provided in Category 2.

Category 2 Customer who are already live and wants to uptake new large quantity number for future use.

Steps : For the tables they want to change the column from "Int" to "Long"

Created a temp column with "Long" data type Copied values from actual - "Int" column to temp - "Long" column Clear actual column values Changed the data type of column of actual column from "Int" to "Long" Copy back the values from temp column to actual column. Delete the temp column. Save. Please find the list of tables and columns which are required to be changed as part of "Integer" to "Long" and it's application for both category 1 and 2 customers.

SAP License Metric Measurement - "samp_sap_license_metric_measurement"

Column Name :

Usage SAP engine Usage - "samp_sap_sw_client_access"

Column Name :

Usage Import Set table - "imp_samp_sap_license_metric_measurement "

Note : imp_samp_sap_license_metric_measurement - usage column is string so no change required.

Entitlement Table - "alm_license"

Column Names :

Active rights Purchased rights Number of packs Quantity Rights per license pack Total units Allocations available

License Metric Results - "samp_license_metric_result"

Column Names :

Allocated in Use Allocated not in use Allocations needed Licenses available Not allocated Not allocated in use Rights consumed Rights needed Rights Owned Rights Used Rights Available Unlicensed SAP users Remediation Options - "samp_remediation_option"

Column Names :

Rights Needed Actionable rights Rights Not allocated Unlicensed installs Unlicensed options Unlicensed rights Unlicensed sap users Rights Used By Table - "samp_entitlement_result"

Column Names :

Allocated in Use Not allocated in use Allocations needed Allocated not in use Rights Used Rights Needed By Table - "samp_remediation_result'

Column Name :

Rights Needed

Receiving Slip Line - "proc_rec_slip_item"

Column Name :

Quantity Purchased order Line Items - "proc_po_item"

Column Names :

Ordered Quantity Received quantity Remaining quantity

Related Links Customer's should ensure the below jobs / process to be stoped while performing the steps for changing the data type from "Int" to "Long".

Reconciliation job Entitlement creation manual / Automated / playbook Entitlement Import job SAP Import Data jobs Note: If customer's faces any issues while following the above steps, Kindly reach out to ServiceNow support team for help and guidance.