search cancel

Service Catalog Offerings Are Not Showing in Service Point


Article ID: 254742


Updated On:


CA Service Management - Service Desk Manager


In Service Point, Service Catalog Offerings are NOT showing.

The issue persists even after rebuilding elastic search indexes.

After turning on DEBUG logging on Service Point per:

incidentMS_debug log shows the following 

DEBUG 2022-11-11 19:28:10 [] SdmGetObjectsActor                88 Found no records for factory (usm_offering), filter (offering_name='OFFERING' and status=1 and parent_id = -1)
DEBUG 2022-11-11 19:28:10 [] AuthenticationHelper             506 Failed to get offering object for parentDomainId: OFFERING. Multiple or no record found for this offering name.
DEBUG 2022-11-11 19:28:10 [] AuthenticationHelper             512 Content inside map data: {tenant_name=TENANT., domain_type=TE, login_domain=DOMAIN, role_id=catalogenduser, parent_tenant_id=TENANTID, id=NAME}
ERROR 2022-11-11 19:28:10 [] AuthenticationHelper             299 There is no offering created under the BU 
java.lang.ClassCastException: class java.lang.String cannot be cast to class java.lang.Integer (java.lang.String and java.lang.Integer are in module java.base of loader 'bootstrap')



Release : 17.3


In the DEBUG logs, the logs indicate there are no records found.

To verify this, run the following on the MDB:

select * from usm_offering
select * from usm_tenant_ext


After running 

select * from usm_offering
select * from usm_tenant_ext

We found the following:


The blacked out box contains the name of the offering, and the red circle has the status of the offering.

In this case, the status was set to 3 when the status needs to be set to 1 per the DEBUG log above

After correcting this, the offerings began to appear.