Hello,
I am running in to an issue where I am unable to edit/delete/unpublish certain request offerings.
http://i.imgur.com/0DFLm9G.png
When attempting to delete a request offering I receive the following error:
Date: 5/23/2016 10:41:00 AM
Application: System Center Service Manager
Application Version: 7.5.3079.0
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.51590052e73c44afa0ce9cf30b13ff5e|1.0.0.0|Offering8f0626d0b8c942ea95528ae8d3b8e1ef|3|RequestOffering'
not present in collection. Delete operation failed.
When attempting to edit/unpublish a RO I get the following error message:
Editing a requesting offering.
Date: 5/23/2016 10:42:29 AM
Application: Edit Request Offering
Application Version: 7.5.3079.0
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.51590052e73c44afa0ce9cf30b13ff5e|1.0.0.0|Offering8f0626d0b8c942ea95528ae8d3b8e1ef|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.51590052e73c44afa0ce9cf30b13ff5e|1.0.0.0|Offering8f0626d0b8c942ea95528ae8d3b8e1ef|3|RequestOffering'
not present in collection. Update operation failed.
I looked up the issue on Technet and someone else had the same error.
https://social.technet.microsoft.com/Forums/systemcenter/en-US/03773f44-0b3e-499c-8a38-be0f3e5db808/cant-edit-unpublish-or-delete-a-couple-request-offerings?forum=systemcenterservicemanager
https://social.technet.microsoft.com/Forums/systemcenter/en-US/1a7f794a-649b-49c7-9b1f-4f594d276114/cannot-edit-unpublish-or-delete-a-request-offering?forum=portals
So I first attempted to delete the RO from the command line using SMLets, but I get the following error:
Get-SCSMRequestOffering -Displayname "Create a New Distribution Group" | Remove-SCSMRequestOffering
Get-SCSMRequestOffering : The pipeline has been stopped.
At line:1 char:1
+ Get-SCSMRequestOffering -Displayname "Create a New
Distribution Group" | Remove- ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+
CategoryInfo : InvalidArgument:
(DisplayName = '...ribution Group':String) [Get-SCSMRequestOffering],
PipelineStoppedException
+
FullyQualifiedErrorId : bad generic criteria,SMLets.GetSCSMRequestOfferingCommand
Remove-SCSMRequestOffering : Database error.
MPInfra_p_ManagementPackInstall failed with exception:
Specified argument was out of the range of valid values.
Parameter name: Item
'1|ManagementPack.51590052e73c44afa0ce9cf30b13ff5e|1.0.0.0|Offering8f0626d0b8c942ea95528ae8d3b8e1ef|3|RequestOffering'
not present in collection. Delete operation failed.
At line:1 char:74
+ Get-SCSMRequestOffering -Displayname "Create a New
Distribution Group" | Remove- ...
+
~~~~~~~
+
CategoryInfo : NotSpecified: (:)
[Remove-SCSMRequestOffering], ManagementPackException
+
FullyQualifiedErrorId :
Microsoft.EnterpriseManagement.Common.ManagementPackException,SMLets.RemoveSCSMRequestOfferingCommand
After this attempt I exported the management pack where we save the request offerings and found that there is no reference to the request offering, Offering8f0626d0b8c942ea95528ae8d3b8e1ef. So edited the XML file to have it's reference, but i attempt to
reimport it gives an error messsage:
The management pack import failed. Errors (1):The client has been disconnected from the server. Please call ManagementGroup.Reconnect() to reestablish the connection.
PS C:\Users\palomins-2> Import-SCSMManagementPack -ManagementPack "D:\ManPacks\Edited\ManagementPack.51590052e73c44afa0ce9cf30b13ff5e.xml"
Import-SCSMManagementPack : The client has been disconnected from the server. Please call ManagementGroup.Reconnect()to reestablish the connection.At line:1 char:1+ Import-SCSMManagementPack -ManagementPack "D:\ManPacks\Edited\ManagementPack.515 ...+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [Import-SCManagementPack], ServerDisconnectedException + FullyQualifiedErrorId : Microsoft.EnterpriseManagement.Common.ServerDisconnectedException,SMLets.ImportManagemen tPackCommand
Same when trying it from commandline.
Any thoughts?
