Consistency Checker

This page gives an overview of some of the inconsistencies and ther proposed solutions.

You can find solutions to most error codes by searching for the error code on https://knowledge.opentext.com

Trigger Consistency Checker

List running or scheduled jobs

SELECT r_object_id, object_name,run_mode, a_special_app,

start_date, a_last_invocation, a_last_completion,a_next_invocation

FROM dm_job

WHERE run_now = true

OR a_special_app = 'agentexec';

Trigger Consistency Checker

update dm_job object

set run_now = true

where object_name = 'dm_ConsistencyChecker'

Get Consistency Checker Job report

select * from dm_document where folder ('/Temp/Jobs/dm_ConsistencyChecker') order by r_creation_date desc

CC-0002

WARNING CC-0002: User 'xxx' is referenced in dm_group with id 'xxxxxxxxxxxxxxxx' but does not have a valid dm_user object

Remove user from group using API

fetch,c,xxxxxxxxxxxxxxxx

remove,c,l,users_names[x]

save,c,l

CC-0007

WARNING CC-0007: ACL object with r_object_id 'xxxxxxxxxxxxxxxx' has a non-existent user 'xxx'

remove missing user from ACL

fetch,c,xxxxxxxxxxxxxxxx

remove,c,l,r_accessor_name[x]

remove,c,l,r_accessor_permit[x]

remove,c,l,r_accessor_xpermit[x]

remove,c,l,r_is_group[x]

remove,c,l,r_permit_type[x]

remove,c,l,r_application_permit[x]

save,c,l

CC-0009

WARNING CC-0009: Sysobject with r_object_id 'xxxxxxxxxxxxxxxx' has acl_domain entry of 'xxx' which is not a valid user

CC-0011

WARNING CC-0011: Sysobject with r_object_id 'xxxxxxxxxxxxxxxx' belongs to non-existent ACL 'dm_xxxxxxxxxxxxxxxx'

Recreate the missing ACL. Often the acl exists, but has a different owner name.

CC-0020

WARNING CC-0020: Sysobject with r_object_id 'xxxxxxxxxxxxxxxx' references non-existent content with content id 'xxxxxxxxxxxxxxxx'

Replace missing content id with dummy content object

fetch,c,xxxxxxxxxxxxxxxx

set,c,l,i_contents_id

0000000000000000

save,c,l

CC-0086

ERROR CC-0086: Folder with r_object_id 'xxxxxxxxxxxxxxxx' needs to be renamed or merged with another folder. Please go through the server log for the date mentioned in the object_name 'dm_fix_me_0b01e240801873f2_2015-07-01 10:07:24' to find an error message that contains the r_object_id. The error message will list the name due to which this folder was renamed.

If a duplicate folder gets created symultainiously by dctm, the duplicate will be renamed.

To fix:

Check in the server log to find the error message about the duplicate folder creation (DM_FOLDER_E_RENAMED_FOLDER_INTERNALLY) corresponding to 'dm_fix_me_0b01c41394b31c73_2011-04-29 12:36:24'
There, you should be able to see the original folder name and r_object_id
Dump the fix_me folder 0b01c41394b31c73 to see if it contains any document (check r_link_cnt value).
If it is empty, you might delete it.
If documents are linked to it, you can either just rename the folder from 'dm_fix_me_0b01c41394b31c73_2011-04-29 12:36:24' to 'any_folder_name_you choose'

CC-0087

ERROR CC-0087: The type object for 'dm_extern_file' has attributes with duplicate identifier

ERROR CC-0087: The type object for 'dm_extern_free' has attributes with duplicate identifier

ERROR CC-0087: The type object for 'dm_extern_store' has attributes with duplicate identifier

ERROR CC-0087: The type object for 'dm_extern_url' has attributes with duplicate identifier

There are duplicate dindexes in the field attr_identifier

Find these duplicatate indexes and update them to the next available index

select * from dm_type where name = 'dm_extern_free'

select * from dm_type where name = 'dm_extern_file'

select * from dm_type where name = 'dm_extern_store'

select * from dm_type where name = 'dm_extern_url'

attr_identifier:

[0]: 1

[1]: 2

...

[21]: 59

[22]: 60

[23]: 61

[24]: 62

[25]: 63

[26]: 64

[27]: 22

...

[31]: 43

[32]: 60

[33]: 61

[34]: 62

[35]: 63

Index 32 needs to be set to 65

Index 33 needs to be set to 66

Index 34 needs to be set to 67

Index 35 needs to be set to 68

for index 32 i_position = -33, for index 33 i_position = -34, ...

update dm_type_r set attr_identifier = 65 where r_object_id = '030113988000013a' and i_position = -33;

update dm_type_r set attr_identifier = 66 where r_object_id = '030113988000013a' and i_position = -34;

update dm_type_r set attr_identifier = 67 where r_object_id = '030113988000013a' and i_position = -35;

update dm_type_r set attr_identifier = 68 where r_object_id = '030113988000013a' and i_position = -36;

Update the next_attr_identifier field of dm_store type to one higher than the highest value used in attr_identifier of dm_extern_free, dm_extern_file, dm_extern_store, dm_extern_url and dm_store

select * from dm_type where name = 'dm_store'

update dm_type_s set next_attr_identifier = 69 where r_object_id = '030113988000012d';

Google Sites

Report abuse