Clearing out crypto keys

Options
david.matheson
david.matheson
edited April 19, 2012 in Documentum #1

Hi all.  I have recently upgraded my content server to 6.7 SP1.  In one of my environments on SQL Server 2008, I am trying to clear out my crypto keys from the database.  In the past I have used:

UPDATE dm_docbase_config_s SET i_crypto_key = ' ';UPDATE dm_docbase_config_s SET i_ticket_crypto_key = ' ';DELETE dm_sysobject_s WHERE r_object_id = (SELECT r_object_id FROM dm_public_key_certificate_s WHERE key_type = 1);DELETE dm_sysobject_r WHERE r_object_id = (SELECT r_object_id FROM dm_public_key_certificate_s WHERE key_type = 1);DELETE dm_public_key_certificate_s WHERE key_type = 1 ;DELETE dm_sysobject_s WHERE r_object_id = (SELECT r_object_id FROM dm_cryptographic_key_s WHERE key_type = 1);DELETE dm_sysobject_r WHERE r_object_id = (SELECT r_object_id FROM dm_cryptographic_key_s WHERE key_type = 1);DELETE dm_cryptographic_key_s WHERE key_type = 1;UPDATE dm_type_s SET views_valid = 0;DELETE dmi_object_type WHERE r_object_id = (SELECT r_object_id from dmi_vstamp_s where i_application = 'dm_docbase_config_crypto_key_init');DELETE dmi_vstamp_s WHERE i_application = 'dm_docbase_config_crypto_key_init';DELETE dmi_object_type WHERE r_object_id = (SELECT r_object_id from dmi_vstamp_s where i_application = 'dm_docbase_config_ticket_crypto_key_init');DELETE dmi_vstamp_s WHERE i_application = 'dm_docbase_config_ticket_crypto_key_init';DELETE dm_public_key_certificate_s;DELETE dm_cryptographic_key_s;

For some reason this results in:

2012-04-18T15:51:08.0880003100[1172]0000000000000000[DM_SESSION_E_INIT_FAILURE1]error:  "Failure to complete Server Configuration initialization."2012-04-18T15:51:08.1040003100[1172]0000000000000000[DM_SERVER_I_START_ID]info:  "Docbase ECM_STAGING was not successfully opened. Docbase id: (989870)"

Has anyone cleared out crypto keys in the new version of content server?

Tagged:

Comments

Categories