ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 199242

calendar_today

Updated On:

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. 

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.

Environment

Release : 1403

Component : DESKTOP AND SERVER MANAGEMENT

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)

Attachments