Software Catalog: Internal error - Exception caught by Server" and SD error code 36.

Products

• CA Client Automation - Asset Management
• CA Client Automation - IT Client Manager
• CA Client Automation
• CA Client Automation - Software Delivery
• CA Client Automation - Remote Control
• CA Client Automation - Asset Intelligence
• CA Client Automation - Desktop Migration Manager
• CA Client Automation - Patch Manager

Issue/Introduction

In CA DSM Software Delivery catalog, the problem is that when we go on "Add software" for instance and click next to "choose software to order" and we get error "Internal error - Exception caught by Server" and SD error code 36. 

Environment

Release : 1403

Component : DESKTOP AND SERVER MANAGEMENT

Cause

A corruption in data in MDB database: 

A Software Group Catalog is linked to a group and a Software Group Catalog is linked to a group.
Normally when the group is deleted the associated Software Group Catalog should have aux set to 0x00000000000000000000000000000000
But sometimes if a problem occurs during deletion of a Group, aux in table usd_swfold still contain reference to deleted group.

to detect this, you need to run the below query:

SELECT * FROM usd_swfold where aux<>0x00000000000000000000000000000000 and aux not in (select group_uuid from ca_group_def)

If it doesn't  return 0 row, so this means you have corrupted data.

Resolution

Execute this SQL Query :  

SELECT * FROM usd_swfold where aux<>0x00000000000000000000000000000000 and aux not in (select group_uuid from ca_group_def)
It should return 0 row.

If it returns one or more rows, execute this :
UPDATE usd_swfold SET aux=0x00000000000000000000000000000000 where aux<>0x00000000000000000000000000000000 and aux not in (select group_uuid from ca_group_def)