CA Service Management

 View Only
Expand all | Collapse all

Ca Service Point - can't see catalog offerings

  • 1.  Ca Service Point - can't see catalog offerings

    Posted Apr 18, 2021 05:32 AM
    Edited by Jakub Kolacny Apr 18, 2021 06:48 AM
    Team,
    I've just installed the xFlow / Service Point, but I don't see the catalog offerings. All is the latest release 17.3.05.

    I see only the "More" button for the catalog offerings, but if I try to open the offerings, I get only the message that "There are no offerings that match your selection criteria". If I try to log in wit the same account to the catalog, I see offering without any problems.

    The catalog was installed after the xFlow and Search Server installation.

    I tried the Search Server initial load and index rebuild, deleting the browser cache, but it didn't help.

    Any suggestions?

    Thank you so much,
    Jakub


    Some screenshots:
    Service Point with the "More" button.



    Missing Catalog offerings in Service Point:


    Offerings in Catalog for the same user:


  • 2.  RE: Ca Service Point - can't see catalog offerings

    Posted Apr 19, 2021 02:24 AM
    Hi Jakub,
    how did you install xfLow/ServicePoint?
    Nearby the More-Button you also should see 5 default-categories.

    I think you should open a case for it.

    Regards,
    Peter

    ------------------------------
    Senior Technical Consultant
    Fujitsu Services
    ------------------------------



  • 3.  RE: Ca Service Point - can't see catalog offerings

    Posted Apr 19, 2021 03:00 AM
    Hi Peter,
    xFlow and Catalog were installed on top of the recently upgraded SDM implementation and the installation was quite straightforward: 
    1. Search Server 17.3 installation
    2. xFlow 17.3 installation
    3. Catalog 17.3 installation
    4. cumulative fix 17.3.05 for all of the components

    SDM and Catalog integration is set in the SDM Options Manager. In the Service Point configuration, the "Service Catalog" option is set to Yes.

    Is there anything else I should set up to access the Catalog offerings in the Service Point portal?

    Thank you,
    Jakub


    On the screenshots, there were no default SDM categories because I inactivated them - but I can set this without any problems.




  • 4.  RE: Ca Service Point - can't see catalog offerings

    Posted Apr 19, 2021 03:32 AM
    Hi Jakub,
    is it a fresh installation or an upgrade from a previous version?
    What happens, when switching from xFlow to ServicePoint-App? Are you asked for Catalog-login?

    What is shown, when you click on more-button?
    Waht happens if you type a service-Name and hit enter? 

    Did you have a look int post-installation steps of installation-guide?

    In Catalog's web.xml there must be configured CORS for the servers contacting catalog.

    But if you don't see services by clicking more-button it should be a problem with search-servers content.
    There is a switch for searchserver initial-load which sets how old data can be when loading to Searchserver:
    (Don't forget deleting/moving searchserver-index and recreate index-Dir before initial load).

    ...\SC\CASearchServer\search\config
    • Config.yml: dataload_limit: 5y

    Set it to 5y i.e. and try initial load again.
    Look at the outpoot whether errors are listed while doing initial load.

    Regards,
    Peter

    ------------------------------
    Senior Technical Consultant
    Fujitsu Services
    ------------------------------



  • 5.  RE: Ca Service Point - can't see catalog offerings

    Posted Apr 19, 2021 04:53 AM
      |   view attached
    Hi Peter,
    thank you so much for your suggestions...

    It looks like a problem with the Search Server - I've installed the Chrome plugin and it seems that the catalog_index is completely missing.



    and I also don't see the catalog object on the browser tab.


    I've tried to delete all the indices and run the initial load again, I've also tried to change the dataload_limit to 10 years (which increased the amount of data for the SDM index), but I still don't see the catalog_index after the initial load.

    Maybe the config.yml file is not correctly set - it looks like the sdm_index has some more definitions than catalog_index. Does anyone have the OOB config_yml file?

    The part of the configuration file:
    ...
    objects:
    sdm_index: nr, cnt, cr, KD, kdlinks, trending, pcat
    sdm_autocat_index: autocat
    catalog_index: service_offering, service_request
    sp_index: search_history,autocat_search

    # directive: index; mandatory
    # name of the elastic search index
    #index: sdm_index, sdm_autocat_index
    index: sdm_index, sdm_autocat_index, catalog_index, sp_index

    # name of the auto-categorization source and target indices
    autocat:
    source: sdm_index
    target: sdm_autocat_index

    # database connection
    ...

    The complete config.yml file is attached. I didn't change anything else than the dataload_limit.

    Thank you,
    Jakub

    Attachment(s)

    txt
    config.yml.txt   2 KB 1 version


  • 6.  RE: Ca Service Point - can't see catalog offerings

    Posted Apr 19, 2021 06:19 AM
    OK, I've found a possible root cause in the initial load log...

    ...
    [12:05:25,042][INFO ][loader.source ][main] Connection to the database was successfully established.
    [12:05:25,042][INFO ][loader.source ][main] Checking whether Service Catalog is installed in this Deployment.
    [12:05:25,129][INFO ][loader.source ][main] Status of Service Catalog installation :
    [12:05:25,129][INFO ][loader ][main] Skipping catalog
    [12:05:25,143][INFO ][loader ][main] reading index settings..
    ...

    So it seems that the Catalog installation was not successfully recorded in the DB... Any ideas what database tables should be updated or how to force the Search server to create the catalog index and load the data?

    The Catalog was installed on top of the previously upgraded SDM (the SDM was upgraded many times, the initial release was 11.2).

    Jakub


  • 7.  RE: Ca Service Point - can't see catalog offerings
    Best Answer

    Posted Apr 19, 2021 06:38 AM
    And this is the solution :)

    https://knowledge.broadcom.com/external/article/205022/unable-to-locate-service-catalog-offerin.html

    The catalog entry was missing in the al_cdb_configurationparameters table.

    The solution is to add Catalog entry to the table manually:
    USE [mdb]
    INSERT INTO [dbo].[al_cdb_configurationparameters]
    ([componentkey]
    ,[machinename]
    ,[configkey]
    ,[configvalue]
    ,[productcode]
    ,[last_update_date])
    VALUES
    ('ITSM','common','slcm.hostname','Catalog_Real_hostName',9,1552577972583)


    @Peter Schmidt thank you so much for your help!

    Jakub​


  • 8.  RE: Ca Service Point - can't see catalog offerings

    Posted Apr 20, 2021 01:26 AM
    Good morning Jakub,
    it shouldn't be neccessary to add columns manually to al_cdb*-tables after update/install.
    There went something wrong in the installation-/upgrade-process.

    I think that this should be handled by an Broadcom-CASE.
    Do we know what else went wrong?

    Or, after an upgrade-installation, you can (re-)integrate all installed components. This also should handle this.

    Regards,
    Peter

    ------------------------------
    Senior Technical Consultant
    Fujitsu Services
    ------------------------------



  • 9.  RE: Ca Service Point - can't see catalog offerings

    Posted Apr 21, 2021 03:56 AM
    Hi Peter,
    I tried the re-integration first, but it didn't solve the problem... 

    The Catalog installation was not a standard one - I had some issues while installing the catalog with the existing MDB so I installed a fresh Catalog with a separate MDB and then deployed the Catalog on the final MDB using the Catalog Configuration Utility. I think that this should be supported, but maybe the configuration utility didn't update all the necessary tables.

    Also, this is a demo installation so I don't need to solve everything - I'm pretty happy that everything works now.

    Jakub


  • 10.  RE: Ca Service Point - can't see catalog offerings

    Posted Apr 21, 2021 10:09 AM

    Hi Jakub,

    have you set the right settings here? Maybe this will help you out with your problem.



    Regards,
    Fabian




  • 11.  RE: Ca Service Point - can't see catalog offerings

    Posted Apr 21, 2021 10:09 AM
    Hi Jakub,

    maybe this will help. Try to set the setting like in the red rectangle.



    Regards,
    Fabian


  • 12.  RE: Ca Service Point - can't see catalog offerings

    Posted Apr 21, 2021 10:21 AM

    Hi Jakub,

    sorry for my posts. This posts are few days old but didn´t show up after I clicked on the post button.
    Sorry for the confusion. Just ignore the entries from my side.

    Regards,
    Fabian



    ------------------------------
    IT Consultant
    Fujitsu Technology Solutions GmbH
    ------------------------------