Service Catalog Offerings Are Not Showing in Service Point
search cancel

Service Catalog Offerings Are Not Showing in Service Point


Article ID: 254742


Updated On:


CA Service Management - Service Desk Manager CA Service Desk Manager CA Service Catalog


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: 

Turning on logging for xFlow

incidentMS_debug log shows the following 

[] SdmGetObjectsActor                88 Found no records for factory (usm_offering), filter (offering_name='OFFERING' and status=1 and parent_id = -1)
[] AuthenticationHelper             506 Failed to get offering object for parentDomainId: OFFERING. Multiple or no record found for this offering name.
[] AuthenticationHelper             512 Content inside map data: {tenant_name=TENANT., domain_type=TE, login_domain=DOMAIN, role_id=catalogenduser, parent_tenant_id=TENANTID, id=NAME}
[] 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.x


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

We found the following:


The blacked out box contains the name of the Business Unit, 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.