Security Error: Database error [CMM001300]

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

Symptom

In DSM Explorer when updating the permissions of a Security Profile, following error appears after a timeout of 10 minutes :
 
Security Error: Database error [CMM001300]
 
This error occurs for class "Asset Group".
Others classes could be updated without problem.

 

asset_group2.jpg

 

 

Cause:

When permissions on class "Asset Group" is updated, a lot of SQL requests are executed in order to update all groups in the database.
This could take several minutes if there are a lot of groups in the database.
Sometimes the execution time of the SQL requests could exceed 10 minutes. In this case, a timeout occurs and the SQL requests are roll-backed.

 

 

Resolution :

On ITCM Domain Manager execute following command in order to increase the timeout value (default value is 10).
Example for a timeout of 20 minutes :
 
ccnfcmda -cmd SetParameterValue -ps itrm/database -pn CommandTimeout -v 20
 
And try again to update the Permission of "Asset Group" class.
 
 
Remark :
Before release ITCM 12.9, a fix must be applied on the ITCM Domain in order to recognize the parameter itrm/database/CommandTimeout.
 
 ITCM 12.5 SP1
 T5J1310
 ITCM 12.5 SP1 C1
 T5J1258
 ITCM 12.8
 T5J1301
 ITCM 12.8 FP1
 T5J1349
 ITCM 12.9
 The fix is included in this version
 
 
Contact CA Technical Support to get the fix.

 

Once the fix applied on ITCM DOMAIN, execute the ccnfcmda command in order to set a value for CommandTimeout.