Client Automation - Software specified is not unique [SDM000105]

Products

• CA Client Automation - IT Client Manager
• CA Client Automation

Issue/Introduction

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]"

 

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

 

Environment

Client Automation - All versions.

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 :

See How to decode ace column of table ca_object_ace 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 Broadcom Support in order to get a query to add the lost links in the database.