Software specified is not unique [SDM000105]

Document ID : KB000045487
Last Modified Date : 14/02/2018
Show Technical Document Details

Symptoms :

Some SD Packages are not visible in the DSM Explorer under Software/Software Package Library/All Software.
When trying to create the package following error appears :
 
"Software specified is not unique [SDM000105]"
 
1.jpg

The SD package seems to be present in database, but it is not visible in DSM Explorer

 

The following query could be used to verify whether the package is present in the database (replace value for @SW_NAME and @SW_VERSION) :

DECLARE @SW_NAME VARCHAR(255)
DECLARE @SW_VERSION VARCHAR(255)
SET @SW_NAME='TEST'
SET @SW_VERSION='60'
  
SELECT * FROM usd_rsw
WHERE itemname=@SW_NAME and itemversion=@SW_VERSION
 

 

 

Resolution :

There are 2 possible causes of package not being visible in the DSM Explorer:

 

- Access rights problem.

Use this query to find out the rights the user has on the package in question.

Replace @SW_NAME, @SW_VERSION and @USER_NAME with appropriate values 

 

DECLARE @SW_NAME VARCHAR(255)
DECLARE @SW_VERSION VARCHAR(255)
DECLARE @USER_NAME VARCHAR(255)
SET @SW_NAME='TEST'
SET @SW_VERSION='60'
SET @USER_NAME='%Administrator%'
 
SELECT u.label 'User Name', p.name 'Security Profile', a.ace, a.security_level
FROM ca_object_ace a, ca_security_profile p, ca_link_dis_user_sec_profile l, ca_discovered_user u
WHERE object_def_uuid=(SELECT objectid FROM usd_rsw WHERE itemname=@SW_NAME and itemversion=@SW_VERSION)
and p.security_profile_uuid=a.security_profile_uuid and p.type<100
and l.security_profile_uuid=p.security_profile_uuid and l.user_uuid=u.user_uuid
and u.label like @USER_NAME
 
 
Example :

2.jpg

See TEC1685044 for explanation about column ace

User Administrator belongs to Security profile 'Everyone', 'winnt://domain_test/users' and 'winnt://domain_test/administrators'
It has :
- ace=0 : no rights on SD package "TEST 60" via Security Profile 'Everyone'
- ace=65 : Read rights on SD package "TEST 60" via Security Profile 'winnt://domain_test/users'
- ace=255 : Full Control on SD package "TEST 60" via Security Profile 'winnt://domain_test/administrators'
 
It is a Union of the rights so user Administrator has Full Control rights on SD Package "TEST 60"
 

 

- Package has lost its link with "All Software" folder

This query returns the list of packages which have no links to the "All Software" folder:

 
SELECT r.itemname, r.itemversion 
FROM usd_rsw r, usd_swfold f 
WHERE f.name='$SOFTWAREFOLDER_%ALLSW%' and r.objectid not in (SELECT sw FROM usd_link_swg_sw WHERE swg=f.objectid) 
 

If this query returns 1 or more rows, contact CA Support in order to get a query to add the lost links in the database.