Hello,

I created a new request offering and published it. After publishing I noticed a text change I needed to make so I re-opened the offering and changed the text. Upon click OK to save the change I got an error.

Date: 9/8/2015 11:35:06 AM

Application: Edit Request Offering

Application Version: 7.5.3079.367

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.aa5ba3bd25c0457083e17505dba89476|1.0.0.0|Offeringc120bcda1a794d7e8e74d0bc22862fce|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.aa5ba3bd25c0457083e17505dba89476|1.0.0.0|Offeringc120bcda1a794d7e8e74d0bc22862fce|3|RequestOffering' not present in collection. Update operation failed.

When trying to delete the offering I get this error.

Date: 9/8/2015 11:44:11 AM

Application: System Center Service Manager

Application Version: 7.5.3079.367

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.aa5ba3bd25c0457083e17505dba89476|1.0.0.0|Offeringc120bcda1a794d7e8e74d0bc22862fce|3|RequestOffering' not present in collection. Delete operation failed.

I made a copy of the offering and the copy works fine.
Anybody know how I can delete this corrupted offering?

• Edited by Kinneyorama 15 hours 7 minutes ago

Hey Kinneyorma,

You have two (maybe three) options here: 

1. Export the Management Pack that contains the Request Offering, find the Request Offering and delete the code from the XML. Save it and re-import it.

2. Use Powershell to attempt to remove the Request Offering, you will need to install SMLets to use this code.

Get-SCSMRequestOffering -displayname "<Request Offering Name>" | Remove-SCSMRequestOffering

3. I would recommend contacting MS Support for this, but you can delete the Request Offering from the database directly. This would be a last step and only done with MS Support assistance.

Good luck, let me know how you go.

Thanks.