remove RO directly from DB

All replies

• 

  

  0

  Sign in to vote

  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

  • Proposed as answer by Andreas BaumgartenMVP Monday, August 22, 2016 2:41 PM

  Monday, August 22, 2016 12:59 PM
• 

  

  0

  Sign in to vote

  I can't find it within MP, i can't edit it, unpublishedd. but it works.

  Monday, August 22, 2016 1:21 PM
• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  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

  
  

  • Edited by Nikolas Page Monday, August 22, 2016 5:04 PM

  Monday, August 22, 2016 4:34 PM
• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  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.
   

  
  

  • Edited by Nikolas Page Tuesday, August 23, 2016 8:18 AM

  Tuesday, August 23, 2016 8:17 AM