locked
remove RO directly from DB RRS feed

  • Question

  • Hello, i have a Request Offering that would not let me delete it from console nor with smlets.
    Is it enough to delete it from MT_System$RequestOffering or not?

    Error message:

    Date: 22.08.2016 15:15:44
    Application: Edit Request Offering
    Application Version: 7.5.3079.442
    Severity: Error
    Message: Database error. MPInfra_p_ManagementPackInstall failed with exception: 
    Specified argument was out of the range of valid values.
    Parameter name: Item '1|ManagementPack.94bcb15421544d1bba0a66e1c3f79027|1.0.0.0|Offering36a9955a0d3743d5be5b56db65a227a9|3|RequestOffering' not present in collection. Update operation failed.

    : Database error. MPInfra_p_ManagementPackInstall failed with exception: 
    Specified argument was out of the range of valid values.
    Parameter name: Item '1|ManagementPack.94bcb15421544d1bba0a66e1c3f79027|1.0.0.0|Offering36a9955a0d3743d5be5b56db65a227a9|3|RequestOffering' not present in collection. Update operation failed.

    Monday, August 22, 2016 12:17 PM

All replies

  • I would not suggest removing it directly from the database. There may be some reasons it cannot be deleted. Have you checked to confirm that it has been removed from all Service Offerings and Groups? If it has and you still can't delete it then your best option may be to remove it directly from the management pack. If you export out the management pack that contains the request offering, you should see it down in the Extensions > Request Offering section. If can remove the entire section for just that particular request offering, save, and import the edited MP back into Service Manager. As with anything of this type, I highly suggest making a full backup of your environment, and saving a copy of the unedited management pack before attempting this. 

    Matthew Dowst | Blog | Twitter

    Monday, August 22, 2016 12:59 PM
  • I can't find it within MP, i can't edit it, unpublishedd. but it works.
    Monday, August 22, 2016 1:21 PM
  • Where do you still see it, in the console or in the portal? If it is just in the portal, then I would suggest running IISReset on the portal server to recycle the application pools and restart the website. After doing that, check and see if it is removed from the portal.

    Matthew Dowst | Blog | Twitter

    Monday, August 22, 2016 3:59 PM
  • I see both: in the portal and in the console

    RO status is published and it not allow to change it..

    I've removed it from SO and form catalog  group but it doesn't help


    Monday, August 22, 2016 4:34 PM
  • What does it say when you try to delete it? Is there a specific error message? You can try to command below to set it back to draft status using the built-in PowerShell cmdlets.

    $RO = Get-SCClassInstance -class (Get-SCClass -Name System.RequestOffering) | ?{$_.DisplayName -eq 'Email Recovery'}
    $RO | %{$_.Status="System.Offering.StatusEnum.Draft";$_} | Update-SCClassInstance


    Matthew Dowst | Blog | Twitter

    Monday, August 22, 2016 8:25 PM
  • I've got the same (almost) error.

    When edit or try unpublishe, even with SMlets:

    Date: 23.08.2016 10:22:26
    Application: Edit Request Offering
    Application Version: 7.5.3079.442
    Severity: Error
    Message: Database error. MPInfra_p_ManagementPackInstall failed with exception: 
    Specified argument was out of the range of valid values.
    Parameter name: Item '1|ManagementPack.94bcb15421544d1bba0a66e1c3f79027|1.0.0.0|Offering36a9955a0d3743d5be5b56db65a227a9|3|RequestOffering' not present in collection. Update operation failed.

    : Database error. MPInfra_p_ManagementPackInstall failed with exception: 
    Specified argument was out of the range of valid values.
    Parameter name: Item '1|ManagementPack.94bcb15421544d1bba0a66e1c3f79027|1.0.0.0|Offering36a9955a0d3743d5be5b56db65a227a9|3|RequestOffering' not present in collection. Update operation failed.

    When delete:

    Date: 23.08.2016 10:22:51
    Application: System Center Service Manager
    Application Version: 7.5.3079.442
    Severity: Error
    Message: Query to adapter 'dataportal:EnterpriseManagementObjectProjectionWriteAdapter' failed.

    : Database error. MPInfra_p_ManagementPackInstall failed with exception: 
    Specified argument was out of the range of valid values.
    Parameter name: Item '1|ManagementPack.94bcb15421544d1bba0a66e1c3f79027|1.0.0.0|Offering36a9955a0d3743d5be5b56db65a227a9|3|RequestOffering' not present in collection. Delete operation failed.
     


    Tuesday, August 23, 2016 8:17 AM