Security Error: Database error [CMM001300]

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


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.






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
 ITCM 12.5 SP1 C1
 ITCM 12.8
 ITCM 12.8 FP1
 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.