Home Community Uploads

Cireson Partners, Customers and Community members share your customizations and examples here to help benefit the community as a whole to earn Kudos and badges.


All files and projects located here are provided and come "as-is" and without any warranty or support. Use at your own risk. Your use of Community Uploads is subject to our Terms of Use.

Cireson does not and will not support or maintain these enhancements, extensions, and scripts.

For Team Cireson uploads click here.

Cachebuilder does not sync Request offerings - GetRequestOfferingRow Error

Patrick_HammerPatrick_Hammer Member IT Monkey ✭
edited October 2023 in Community Uploads

Our Cachebuilder does not sync correct. So one Request offering did not sync.

We have the following error in the cachebuilder log:

ERROR [ 21]: GetRequestOfferingRow failed with error: An item with the same key has already been added.

You also have an diffrence in the Request offering tables between. You can check that with this sql statement:

SELECT bs.Value, Title_7AE4D8A8_00C8_DF5A_347D_A336D5D875BF, ro.*

                  FROM MT_System$RequestOffering ro

                   LEFT JOIN BlobStorage bs ON bs.BlobId = ro.Image_2B8C0BE4_F0FA_C6DD_4D92_5854C513CD67

                  INNER JOIN BaseManagedEntity bme ON bme.BaseManagedEntityId = ro.BaseManagedEntityId

                  INNER JOIN EnumType e ON e.EnumTypeId = ro.Status_17348DC0_DB86_81C4_DC59_5EE105DAF50A AND e.EnumTypeName = 'System.Offering.StatusEnum.Published'

                  WHERE bme.IsDeleted = 0

               and Title_7AE4D8A8_00C8_DF5A_347D_A336D5D875BF not in ( SELECT Title

 FROM [servicemanagement].[dbo].[RequestOffering])


  • Options
    Patrick_HammerPatrick_Hammer Member IT Monkey ✭

    In the Page definition of the Management Pack some of the prompt IDs are doubled. To remove this error, you have to make the PromptId Unique. As far as I see now, there are no side effects.

    So you have to do these steps:

    1. Make these PromptIds Unique
    2. Import the management pack
    3. Resync the Cachbuilde Service Katalog

    Wrong page definition:

     <Page Name="PageName">

    <Prompt PromptId="4c587e26-fbf4-43a6-8b5b-ed414eb17c11" />

    <Prompt PromptId="4c587e26-fbf4-43a6-8b5b-ed414eb17c11" />

    How do you get this?

    When you are editing the Add Prompt of the Layout section in the Request Offering it can be, that some prompts are multiple. If you want to use one of these prompts, you have to do this afterwards.

Sign In or Register to comment.