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 Tuesday, September 08, 2015 4:06 PM

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.

• Proposed as answer by Firat YASAR 20 hours 27 minutes ago
• Marked as answer by Kinneyorama 18 hours 11 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.

• Proposed as answer by Firat YASAR Wednesday, September 09, 2015 10:45 AM
• Marked as answer by Kinneyorama Wednesday, September 09, 2015 1:00 PM

Thank you for the reply. The powershell options were my first try before I posted and they did not work. I will be opening a MS Support ticket soon to have them take a look at the database. After that I'll remove the offerings left over data in the Management Pack.