Cannot delete software package error SDM000148.

Document ID : KB000099211
Last Modified Date : 01/06/2018
Show Technical Document Details
Question:
Working on EM, trying to delete a SDlib package that has already been removed from SS and DM libraries.
Getting  following error message:
Removal of software that has been delivered to a Scalability Server Library is not allowed [SDM000148].
Environment:
Products
  • CA Client Automation

Releases
  • CA Client Automation:Release:14.0
  • CA Client Automation:Release:1401
  • CA Client Automation:Release:1402

Components
  • DESKTOP AND SERVER MANAGEMENT:DTSVMG
  • CA Client Automation:BITCM
  • CA Software Delivery:TNGSDO
Answer:
Please open a Support Case to request this fix T55L073.
----
PRODUCT: Desktop and Server Management                   RELEASE: R14

PROB #:  0         FN: T55L073    FT: D5J        DATE:    02 Nov 2017 
STARTRAK PRODUCT NAME: DTSVMG (Star Problem Product)

PROBLEM SYMPTOM: WIN-SW PKG DELETE FAILS ON EM                     
                 ----------------------------------------------------
                 ITCM r14 SP1. When trying to delete a software
                 package from the ITCM Enterprise manager--
                 "Removal of software that has been delivered to a
                 Scalability Server Library is not allowed
                 [SDM000148]"
-------
 
Additional Information:
SQL query to delete the package :

-- Delete staging/unstaging records for specified "Software Title"

delete from usd_applic where status in (4,13) and actproc in (select objectid from usd_actproc where rsw in (select objectid from usd_rsw where itemname='Software Title') and itemname in ('delivery proc', 'undelivery proc'))

* Make sure to take backup of the MDB database before executing the above SQL query. 
* Replace the 'Software Title' section in the query with the name of the package which you are trying to delete.