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.
Release : 1403
Component : DESKTOP AND SERVER MANAGEMENT
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.
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)