Return-Path: X-Original-To: apmail-manifoldcf-user-archive@www.apache.org Delivered-To: apmail-manifoldcf-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 79BAE18954 for ; Wed, 23 Mar 2016 12:41:59 +0000 (UTC) Received: (qmail 75343 invoked by uid 500); 23 Mar 2016 12:41:59 -0000 Delivered-To: apmail-manifoldcf-user-archive@manifoldcf.apache.org Received: (qmail 75290 invoked by uid 500); 23 Mar 2016 12:41:59 -0000 Mailing-List: contact user-help@manifoldcf.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@manifoldcf.apache.org Delivered-To: mailing list user@manifoldcf.apache.org Received: (qmail 75280 invoked by uid 99); 23 Mar 2016 12:41:59 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 23 Mar 2016 12:41:59 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 5BA7D1A46D5 for ; Wed, 23 Mar 2016 12:41:58 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.179 X-Spam-Level: * X-Spam-Status: No, score=1.179 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx2-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id 6nGs4dMncJ3l for ; Wed, 23 Mar 2016 12:41:54 +0000 (UTC) Received: from mail-wm0-f43.google.com (mail-wm0-f43.google.com [74.125.82.43]) by mx2-lw-eu.apache.org (ASF Mail Server at mx2-lw-eu.apache.org) with ESMTPS id 57C455F2ED for ; Wed, 23 Mar 2016 12:41:54 +0000 (UTC) Received: by mail-wm0-f43.google.com with SMTP id l68so22241112wml.1 for ; Wed, 23 Mar 2016 05:41:54 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to; bh=lLxcU6sCGpptfVo1mlZLWtMtUeD6LkAbSicd/ZDtS+w=; b=illCeFKsFXMi4xq2DyCWe0dbDzrMV4F+cgMKFOUB9N8b3is3TTlVr3MzEUvmdH131r QCdczJkCVvKrt5VUEdtn32stwO6cWFiXYCeV/QxTJNEpJMpwvZeQF91FpqZM0ti0mox7 8tZPoX1YQgxwVxXBBOFbIKcB1c2r+ONoF6WrWGQ98ahXLwZ2rkmvKE1L+cYsPYUH1FpP N14u6MEMxbejQDf5Nomo+zCLasIgbZ2yH2Jast9cCb67abDUN4PvsMK78+G8AB6hcVnI PrK717+1eHOwMJATEfPcFG8zYKBkMU5N8+cDjxJ7SSSRiWlLh1iFyNDHffB1MBpK1X01 qsBg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to; bh=lLxcU6sCGpptfVo1mlZLWtMtUeD6LkAbSicd/ZDtS+w=; b=FF+tWg/s9DfgnrC7S2m1ueRS+j47M8qJzo34AxOWrVeDEtFo3+/Sv+MbPyLlJvatr5 rcWi/vqMsrIufwZVpSufQrphev4AVu5Nb83hQAtJuI8GXTMi+Bo5wnSvB2vBuMV9NX81 L2NZWkECG80WgqTIdbyZRifs+6SbTNWxEtL/kFWVKWCSkFY+sQZeapC7dYzo485l8J8Q u0EtsjUkh8FrBw+KO6Wd2FYRqiTFnBsohK0/i91BZ1MQyaM7Ftgdj7R4AxQ15LZz0hcd kazNNL0hBPiK/1NG2pNY7D1MVVLRCjpOKNH31MuS2dxUwcmEB1EUFczsZustGDVj9LOu 8qfg== X-Gm-Message-State: AD7BkJIImIKWASmHmXEPnWOb+o7l50FoDvQ6bxWer1BkrqxdJWQion4G5VWyo+2sh0YZsPf2exj0FWWGWUWMsA== MIME-Version: 1.0 X-Received: by 10.28.101.133 with SMTP id z127mr3827747wmb.84.1458736914003; Wed, 23 Mar 2016 05:41:54 -0700 (PDT) Received: by 10.194.170.196 with HTTP; Wed, 23 Mar 2016 05:41:53 -0700 (PDT) In-Reply-To: References: Date: Wed, 23 Mar 2016 13:41:53 +0100 Message-ID: Subject: Re: Documentum - unable to index metadata From: Radek Sklenicka To: user@manifoldcf.apache.org Content-Type: multipart/alternative; boundary=001a114b741e947e06052eb6a736 --001a114b741e947e06052eb6a736 Content-Type: text/plain; charset=UTF-8 Hi Karl, "select attr_name FROM dmi_dd_attr_info" really returns duplicates - we're looking into that. Is there also a DQL query (or function) used by ManifoldCF that we can try to check what/if attributes are being returned for a particular record? We have trace logs from DFC and it looks like the attributes are being returned from the content server. Could you please help us decode the logs - where to look/verify if attributes are handed over to ManifoldCF? Can we deduce from the logs attached below that the attributes are transferred from DFC to ManifoldCF? Many thanks, Radek 2016-03-22 13:29:26.008 [RMI TCP Connection(1823)-127.0.0.1] [EXIT] .com.documentum.fc.client.DfTypedObject@36b9ba.getLiteType ==> AspectedLiteType@110eb5e{name=do_domep_project_hse, typeVersion=0, cacheVStamp=178498, attributes={asp_herencia.atr_isnew, asp_herencia.atr_niveles, asp_herencia.atr_tipo, asp_herencia.i_partition}, superType=LiteType@2045f2{name=do_domep_project_hse, typeVersion=32, cacheVStamp=178498, attributes={atr_audit_type, atr_speciality, atr_emergency_related}, superType=LiteType@a67471{name=do_domep_project, typeVersion=32, cacheVStamp=178486, attributes={atr_uwi, atr_well_name, atr_usi, atr_survey_name}, superType=LiteType@f74077{name=do_domep_base, typeVersion=27, cacheVStamp=178438, attributes={atr_confidential_level, atr_owner_area, atr_logical_code, atr_original_reference_id, atr_revision, atr_entity, atr_author, atr_doc_type, atr_category_doc, atr_subcat_doc, atr_discipline, atr_subdiscipline, atr_language, atr_physical_document, atr_physical_code, atr_warehouse, atr_retention, atr_digital_media, atr_internal, atr_country, atr_basin, atr_environment, atr_acreage, atr_abstract, atr_doc_creation_date, atr_title, atr_collection, atr_is_collection, atr_is_principal, atr_is_anexo, atr_id_collection, atr_is_relation, atr_field, atr_original_revision, atr_remarks, atr_keywords, atr_principal_folder_id, atr_original_version, atr_be_name, atr_be_ref, atr_be_short_name, atr_issued_for_code, atr_issued_for_description, atr_subbasin, atr_be_type_id, atr_comment, atr_status, atr_prepared_by, atr_preparation_date, atr_verified_by, atr_verification_date, atr_approved_by, atr_approval_date, atr_workflow}, superType=LiteType@19390bd{name=do_general, typeVersion=6, cacheVStamp=167968, attributes={negocio, attr_is_gdcom}, superType=LiteType@16658e8{name=dm_document, typeVersion=2, cacheVStamp=52034, attributes={}, superType=LiteType@6aac49{name=dm_sysobject, typeVersion=3, cacheVStamp=0, attributes={object_name, r_object_type, title, subject, authors, keywords, a_application_type, a_status, r_creation_date, r_modify_date, r_modifier, r_access_date, a_is_hidden, i_is_deleted, a_retention_date, a_archive, a_compound_architecture, a_link_resolved, i_reference_cnt, i_has_folder, i_folder_id, r_composite_id, r_composite_label, r_component_label, r_order_no, r_link_cnt, r_link_high_cnt, r_assembled_from_id, r_frzn_assembly_cnt, r_has_frzn_assembly, resolution_label, r_is_virtual_doc, i_contents_id, a_content_type, r_page_cnt, r_content_size, a_full_text, a_storage_type, i_cabinet_id, owner_name, owner_permit, group_name, group_permit, world_permit, i_antecedent_id, i_chronicle_id, i_latest_flag, r_lock_owner, r_lock_date, r_lock_machine, log_entry, r_version_label, i_branch_cnt, i_direct_dsc, r_immutable_flag, r_frozen_flag, r_has_events, acl_domain, acl_name, a_special_app, i_is_reference, r_creator_name, r_is_public, r_policy_id, r_resume_state, r_current_state, r_alias_set_id, a_effective_date, a_expiration_date, a_publish_formats, a_effective_label, a_effective_flag, a_category, language_code, a_is_template, a_controlling_app, r_full_content_size, a_extended_properties, a_is_signed, a_last_review_date, i_retain_until, r_aspect_name, i_retainer_id, i_partition, i_is_replica, i_vstamp}}}}}}}} 2016-03-22 13:29:26.010 [RMI TCP Connection(1820)-127.0.0.1] [RPC_EXIT] ......RPC: applyForObject ==> TypedData@144302b[id=098c1b38809921b1, type=do_domep_project_well_wd, readOnly=false, autoFill=true, fetchTimestamp=0, values=[object_name=DSC00683.JPG, r_object_type=do_domep_project_well_wd, title=, subject=, authors=[], keywords=[], a_application_type=, a_status=, r_creation_date=2/11/2016 8:35:45 AM, r_modify_date=3/7/2016 11:17:37 AM, r_modifier=admdcmt, r_access_date=3/16/2016 12:23:59 PM, a_is_hidden=F, i_is_deleted=F, a_retention_date=nulldate, a_archive=F, a_compound_architecture=, a_link_resolved=F, i_reference_cnt=1, i_has_folder=T, i_folder_id=[0b8c1b3880991ad3], r_composite_id=[], r_composite_label=[], r_component_label=[], r_order_no=[], r_link_cnt=0, r_link_high_cnt=0, r_assembled_from_id=0000000000000000, r_frzn_assembly_cnt=0, r_has_frzn_assembly=F, resolution_label=, r_is_virtual_doc=0, i_contents_id=068c1b388064051a, a_content_type=jpeg, r_page_cnt=1, r_content_size=949228, a_full_text=T, a_storage_type=repo, i_cabinet_id=0c8c1b38806aee30, owner_name=Domep controlador 00010, owner_permit=7, group_name=, group_permit=1, world_permit=1, i_antecedent_id=0000000000000000, i_chronicle_id=098c1b38809921b1, i_latest_flag=T, r_lock_owner=, r_lock_date=nulldate, r_lock_machine=, log_entry=, r_version_label=[1.0, CURRENT], i_branch_cnt=0, i_direct_dsc=F, r_immutable_flag=F, r_frozen_flag=F, r_has_events=F, acl_domain=admdocum, acl_name=domep_ac_en_02080, a_special_app=, i_is_reference=F, r_creator_name=Domep controlador 00010, r_is_public=F, r_policy_id=468c1b38809c6e47, r_resume_state=-1, r_current_state=0, r_alias_set_id=0000000000000000, a_effective_date=[], a_expiration_date=[], a_publish_formats=[], a_effective_label=[], a_effective_flag=[], a_category=, language_code=, a_is_template=F, a_controlling_app=, r_full_content_size=949228, a_extended_properties=[], a_is_signed=F, a_last_review_date=nulldate, i_retain_until=nulldate, r_aspect_name=[asp_herencia], i_retainer_id=[], i_partition=0, i_is_replica=F, i_vstamp=4, negocio=E&P, attr_is_gdcom=F, atr_confidential_level=Internal Use, atr_owner_area=OFICINA DE E, atr_logical_code=IQEXPEOMKUR000WEL2016000063, atr_original_reference_id=[], atr_revision=, atr_entity=[], atr_author=[Domep controlador 00010], atr_doc_type=Reporting, atr_category_doc=Geology, atr_subcat_doc=Progress Report, atr_discipline=GEOLOGY, atr_subdiscipline=[], atr_language=[ENGLISH], atr_physical_document=F, atr_physical_code=[], atr_warehouse=, atr_retention=YES, atr_digital_media=F, atr_internal=YES, atr_country=[XYZ], atr_basin=[XYZZ], atr_environment=, atr_acreage=[], atr_abstract=, atr_doc_creation_date=5/22/2006 8:31:43 AM, atr_title=WELL BARAM 1 PHOTOS FIELD 06, atr_collection=[], atr_is_collection=F, atr_is_principal=F, atr_is_anexo=F, atr_id_collection=[], atr_is_relation=F, atr_field=[], atr_original_revision=, atr_remarks=, atr_keywords=[], atr_principal_folder_id=0b8c1b3880991ad3, atr_original_version=, atr_be_name=BARAM 1, atr_be_ref=IQWEL000008, atr_be_short_name=BA 1, atr_issued_for_code=, atr_issued_for_description=, atr_subbasin=[], atr_be_type_id=8, atr_comment=, atr_status=Draft, atr_prepared_by=[], atr_preparation_date=nulldate, atr_verified_by=[], atr_verification_date=nulldate, atr_approved_by=[], atr_approval_date=nulldate, atr_workflow=, atr_well_name=BARAM 1, atr_uwi=IQ010004432, atr_borehole_name=[BARAM 1], atr_ubhi=[IQ01000443200], atr_borehole_alias=[], atr_borehole_short_name=[], atr_sample_type=[], atr_analysis_type=[], asp_herencia.atr_isnew=F, asp_herencia.atr_niveles=0, asp_herencia.atr_tipo=[], asp_herencia.i_partition=0, r_object_id=098c1b38809921b1, _KEEP_LOCK_=F, _FREEZE_COMPONENTS_=F, _THAW_COMPONENTS_=F, _CONTENTS_CHANGED_=F, _DIST_SAVE_AS_NEW_=F]] On 11 March 2016 at 15:33, Radek Sklenicka wrote: > Thanks Karl, we'll verify that. > > -Radek > > On 11 March 2016 at 14:21, Karl Wright wrote: > >> Hi Radek, >> >> This is the DQL query that is run: >> >> String strDQL = "select attr_name FROM dmi_dd_attr_info where >> type_name = '" + docType + "' order by attr_name asc"; >> >> Karl >> >> >> On Fri, Mar 11, 2016 at 8:19 AM, Karl Wright wrote: >> >>> Hi Radek, >>> >>> The Document Types page runs a DQL query to populate the document >>> types. The fact that you get duplicates means that something may be >>> corrupt with your Document instance. It's possible that for some reason >>> the instance is set up with multiple records that each have the same name >>> but different key values. >>> >>> Documentum used to have a little web app that allowed you to execute DQL >>> queries. I'd experiment to see what was leading to the duplication. The >>> fact that you can't get any metadata during crawling is almost certainly >>> related. >>> >>> Thanks, >>> Karl >>> >>> >>> On Fri, Mar 11, 2016 at 8:10 AM, Radek Sklenicka < >>> radek.sklenicka@gmail.com> wrote: >>> >>>> Hello, >>>> >>>> We are not able to pull metadata from one of our Documentum instances >>>> (it is 6.7) >>>> Interestingly, on the Job > Document Types page each metadata field is >>>> displayed 3 times in the metadata boxes - could this be an issue? >>>> Screenshots: >>>> http://take.ms/mJhPh >>>> http://take.ms/AMZF0 >>>> We have quite a long list of document types and it takes minutes to >>>> load the Document Types page. >>>> >>>> Also, we can successfully pull metadata from our testing Documentum (it >>>> is 7.1), and I noticed that there is a difference in connector logs between >>>> the two: >>>> >>>> 1.) here we are able to pull metadata: >>>> >>>> DEBUG 2016-03-10 03:50:08,051 (Worker thread '3') - DCTM: Document >>>> 090007c28000569d has version label: >>>> 11+authors+object_name+owner_name+owner_permit+r_creation_date+r_creator_name+r_modifier+r_modify_date+r_object_id+r_object_type+title++0+DEAD_AUTHORITY+1.0_0_ >>>> http://localhost/webtop/ >>>> DEBUG 2016-03-10 03:50:08,052 (Worker thread '3') - DCTM: Inside >>>> processDocuments >>>> >>>> >>>> 2.) NOT able to pull metadata: >>>> >>>> DEBUG 2016-03-10 14:58:22,908 (Worker thread '22') - DCTM: Document >>>> 098c1b3880991f48 has version label: 0++0+DEAD_AUTHORITY+_4_ >>>> http://localhost/webtop >>>> DEBUG 2016-03-10 14:58:22,908 (Worker thread '22') - DCTM: Inside >>>> processDocuments >>>> >>>> >>>> Any ideas will be appreciated. >>>> >>>> Thank you, >>>> >>>> Radek >>>> >>>> >>> >> > --001a114b741e947e06052eb6a736 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi Karl,

"select attr_n= ame FROM dmi_dd_attr_info" really returns duplicates - we're looki= ng into that.

Is there also a DQL query (or functi= on) used by ManifoldCF that we can try to check what/if attributes are bein= g returned for a particular record?

We have trace = logs from DFC and it looks like the attributes are being returned from the = content server.
Could you please help us decode the logs - where = to look/verify if attributes are handed over to ManifoldCF?
Can w= e deduce from the logs attached below that the attributes are transferred f= rom DFC to ManifoldCF?

Many thanks,
= Radek


2016-03-22 13:29:26.008 = <USER_DTESTER|s9(21.0)|SM@14660772> =C2=A0[RMI TCP Connection(1823)-1= 27.0.0.1] [EXIT] =C2=A0 =C2=A0 =C2=A0.com.documentum.fc.client.DfTypedObjec= t@36b9ba.getLiteType =3D=3D> AspectedLiteType@110eb5e{name=3Ddo_domep_pr= oject_hse, typeVersion=3D0, cacheVStamp=3D178498, attributes=3D{asp_herenci= a.atr_isnew, asp_herencia.atr_niveles, asp_herencia.atr_tipo, asp_herencia.= i_partition}, superType=3DLiteType@2045f2{name=3Ddo_domep_project_hse, type= Version=3D32, cacheVStamp=3D178498, attributes=3D{atr_audit_type, atr_speci= ality, atr_emergency_related}, superType=3DLiteType@a67471{name=3Ddo_domep_= project, typeVersion=3D32, cacheVStamp=3D178486, attributes=3D{atr_uwi, atr= _well_name, atr_usi, atr_survey_name}, superType=3DLiteType@f74077{name=3Dd= o_domep_base, typeVersion=3D27, cacheVStamp=3D178438, attributes=3D{atr_con= fidential_level, atr_owner_area, atr_logical_code, atr_original_reference_i= d, atr_revision, atr_entity, atr_author, atr_doc_type, atr_category_doc, at= r_subcat_doc, atr_discipline, atr_subdiscipline, atr_language, atr_physical= _document, atr_physical_code, atr_warehouse, atr_retention, atr_digital_med= ia, atr_internal, atr_country, atr_basin, atr_environment, atr_acreage, atr= _abstract, atr_doc_creation_date, atr_title, atr_collection, atr_is_collect= ion, atr_is_principal, atr_is_anexo, atr_id_collection, atr_is_relation, at= r_field, atr_original_revision, atr_remarks, atr_keywords, atr_principal_fo= lder_id, atr_original_version, atr_be_name, atr_be_ref, atr_be_short_name, = atr_issued_for_code, atr_issued_for_description, atr_subbasin, atr_be_type_= id, atr_comment, atr_status, atr_prepared_by, atr_preparation_date, atr_ver= ified_by, atr_verification_date, atr_approved_by, atr_approval_date, atr_wo= rkflow}, superType=3DLiteType@19390bd{name=3Ddo_general, typeVersion=3D6, c= acheVStamp=3D167968, attributes=3D{negocio, attr_is_gdcom}, superType=3DLit= eType@16658e8{name=3Ddm_document, typeVersion=3D2, cacheVStamp=3D52034, att= ributes=3D{}, superType=3DLiteType@6aac49{name=3Ddm_sysobject, typeVersion= =3D3, cacheVStamp=3D0, attributes=3D{object_name, r_object_type, title, sub= ject, authors, keywords, a_application_type, a_status, r_creation_date, r_m= odify_date, r_modifier, r_access_date, a_is_hidden, i_is_deleted, a_retenti= on_date, a_archive, a_compound_architecture, a_link_resolved, i_reference_c= nt, i_has_folder, i_folder_id, r_composite_id, r_composite_label, r_compone= nt_label, r_order_no, r_link_cnt, r_link_high_cnt, r_assembled_from_id, r_f= rzn_assembly_cnt, r_has_frzn_assembly, resolution_label, r_is_virtual_doc, = i_contents_id, a_content_type, r_page_cnt, r_content_size, a_full_text, a_s= torage_type, i_cabinet_id, owner_name, owner_permit, group_name, group_perm= it, world_permit, i_antecedent_id, i_chronicle_id, i_latest_flag, r_lock_ow= ner, r_lock_date, r_lock_machine, log_entry, r_version_label, i_branch_cnt,= i_direct_dsc, r_immutable_flag, r_frozen_flag, r_has_events, acl_domain, a= cl_name, a_special_app, i_is_reference, r_creator_name, r_is_public, r_poli= cy_id, r_resume_state, r_current_state, r_alias_set_id, a_effective_date, a= _expiration_date, a_publish_formats, a_effective_label, a_effective_flag, a= _category, language_code, a_is_template, a_controlling_app, r_full_content_= size, a_extended_properties, a_is_signed, a_last_review_date, i_retain_unti= l, r_aspect_name, i_retainer_id, i_partition, i_is_replica, i_vstamp}}}}}}}= }=C2=A0



2016-03-22 1= 3:29:26.010 <USER_DTESTER|s5(17.0)|SM@16366401> =C2=A0[RMI TCP Connec= tion(1820)-127.0.0.1] [RPC_EXIT] =C2=A0......RPC: applyForObject =3D=3D>= TypedData@144302b[id=3D098c1b38809921b1, type=3Ddo_domep_project_well_wd, = readOnly=3Dfalse, autoFill=3Dtrue, fetchTimestamp=3D0, values=3D[object_nam= e=3DDSC00683.JPG, r_object_type=3Ddo_domep_project_well_wd, title=3D, subje= ct=3D, authors=3D[], keywords=3D[], a_application_type=3D, a_status=3D, r_c= reation_date=3D2/11/2016 8:35:45 AM, r_modify_date=3D3/7/2016 11:17:37 AM, = r_modifier=3Dadmdcmt, r_access_date=3D3/16/2016 12:23:59 PM, a_is_hidden=3D= F, i_is_deleted=3DF, a_retention_date=3Dnulldate, a_archive=3DF, a_compound= _architecture=3D, a_link_resolved=3DF, i_reference_cnt=3D1, i_has_folder=3D= T, i_folder_id=3D[0b8c1b3880991ad3], r_composite_id=3D[], r_composite_label= =3D[], r_component_label=3D[], r_order_no=3D[], r_link_cnt=3D0, r_link_high= _cnt=3D0, r_assembled_from_id=3D0000000000000000, r_frzn_assembly_cnt=3D0, = r_has_frzn_assembly=3DF, resolution_label=3D, r_is_virtual_doc=3D0, i_conte= nts_id=3D068c1b388064051a, a_content_type=3Djpeg, r_page_cnt=3D1, r_content= _size=3D949228, a_full_text=3DT, a_storage_type=3Drepo, i_cabinet_id=3D0c8c= 1b38806aee30, owner_name=3DDomep controlador 00010, owner_permit=3D7, group= _name=3D, group_permit=3D1, world_permit=3D1, i_antecedent_id=3D00000000000= 00000, i_chronicle_id=3D098c1b38809921b1, i_latest_flag=3DT, r_lock_owner= =3D, r_lock_date=3Dnulldate, r_lock_machine=3D, log_entry=3D, r_version_lab= el=3D[1.0, CURRENT], i_branch_cnt=3D0, i_direct_dsc=3DF, r_immutable_flag= =3DF, r_frozen_flag=3DF, r_has_events=3DF, acl_domain=3Dadmdocum, acl_name= =3Ddomep_ac_en_02080, a_special_app=3D, i_is_reference=3DF, r_creator_name= =3DDomep controlador 00010, r_is_public=3DF, r_policy_id=3D468c1b38809c6e47= , r_resume_state=3D-1, r_current_state=3D0, r_alias_set_id=3D00000000000000= 00, a_effective_date=3D[], a_expiration_date=3D[], a_publish_formats=3D[], = a_effective_label=3D[], a_effective_flag=3D[], a_category=3D, language_code= =3D, a_is_template=3DF, a_controlling_app=3D, r_full_content_size=3D949228,= a_extended_properties=3D[], a_is_signed=3DF, a_last_review_date=3Dnulldate= , i_retain_until=3Dnulldate, r_aspect_name=3D[asp_herencia], i_retainer_id= =3D[], i_partition=3D0, i_is_replica=3DF, i_vstamp=3D4, negocio=3DE&P, = attr_is_gdcom=3DF, atr_confidential_level=3DInternal Use, atr_owner_area=3D= OFICINA DE E, atr_logical_code=3DIQEXPEOMKUR000WEL2016000063, atr_original_= reference_id=3D[], atr_revision=3D, atr_entity=3D[], atr_author=3D[Domep co= ntrolador 00010], atr_doc_type=3DReporting, atr_category_doc=3DGeology, atr= _subcat_doc=3DProgress Report, atr_discipline=3DGEOLOGY, atr_subdiscipline= =3D[], atr_language=3D[ENGLISH], atr_physical_document=3DF, atr_physical_co= de=3D[], atr_warehouse=3D, atr_retention=3DYES, atr_digital_media=3DF, atr_= internal=3DYES, atr_country=3D[XYZ], atr_basin=3D[XYZZ], atr_environment=3D= , atr_acreage=3D[], atr_abstract=3D, atr_doc_creation_date=3D5/22/2006 8:31= :43 AM, atr_title=3DWELL BARAM 1 PHOTOS FIELD 06, atr_collection=3D[], atr_= is_collection=3DF, atr_is_principal=3DF, atr_is_anexo=3DF, atr_id_collectio= n=3D[], atr_is_relation=3DF, atr_field=3D[], atr_original_revision=3D, atr_= remarks=3D, atr_keywords=3D[], atr_principal_folder_id=3D0b8c1b3880991ad3, = atr_original_version=3D, atr_be_name=3DBARAM 1, atr_be_ref=3DIQWEL000008, a= tr_be_short_name=3DBA 1, atr_issued_for_code=3D, atr_issued_for_description= =3D, atr_subbasin=3D[], atr_be_type_id=3D8, atr_comment=3D, atr_status=3DDr= aft, atr_prepared_by=3D[], atr_preparation_date=3Dnulldate, atr_verified_by= =3D[], atr_verification_date=3Dnulldate, atr_approved_by=3D[], atr_approval= _date=3Dnulldate, atr_workflow=3D, atr_well_name=3DBARAM 1, atr_uwi=3DIQ010= 004432, atr_borehole_name=3D[BARAM 1], atr_ubhi=3D[IQ01000443200], atr_bore= hole_alias=3D[], atr_borehole_short_name=3D[], atr_sample_type=3D[], atr_an= alysis_type=3D[], asp_herencia.atr_isnew=3DF, asp_herencia.atr_niveles=3D0,= asp_herencia.atr_tipo=3D[], asp_herencia.i_partition=3D0, r_object_id=3D09= 8c1b38809921b1, _KEEP_LOCK_=3DF, _FREEZE_COMPONENTS_=3DF, _THAW_COMPONENTS_= =3DF, _CONTENTS_CHANGED_=3DF, _DIST_SAVE_AS_NEW_=3DF]]=C2=A0



On 11 March 2016 at 15:33, Radek Sklenicka <radek= .sklenicka@gmail.com> wrote:
Thanks Karl, we'll verify that.

-Radek

<= div class=3D"gmail_quote">On 11 March 2016 at 14:21, Karl Wright <daddyw= ri@gmail.com> wrote:
Hi Radek,

This is the DQL query that is run:<= /div>

=C2=A0 =C2=A0 =C2=A0 String strDQL =3D "= select attr_name FROM dmi_dd_attr_info where type_name =3D '" + do= cType + "' order by attr_name asc";

Karl

<= br>
On Fri, Mar 11, 2016 at 8:19 AM, Karl Wright = <daddywri@gmail.com> wrote:
Hi Radek,

The Document Types page ru= ns a DQL query to populate the document types.=C2=A0 The fact that you get = duplicates means that something may be corrupt with your Document instance.= =C2=A0 It's possible that for some reason the instance is set up with m= ultiple records that each have the same name but different key values.

Documentum used to have a little web app that allowed = you to execute DQL queries.=C2=A0 I'd experiment to see what was leadin= g to the duplication.=C2=A0 The fact that you can't get any metadata du= ring crawling is almost certainly related.

Thanks,=
Karl


On Fri, Mar 11, 2016 at 8:10 AM, Radek S= klenicka <radek.sklenicka@gmail.com> wrote:
Hello,

=
We are not able to pull metadata from one of our Documentum instances = (it is 6.7)
Interestingly, on the Job > Document Types page ea= ch metadata field is displayed 3 times in the metadata boxes - could this b= e an issue?
Screenshots:
We have = quite a long list of document types and it takes minutes to load the Docume= nt Types page.

Also, we can successfully pull meta= data from our testing Documentum (it is 7.1), and I noticed that there is a= difference in connector logs between the two:

1.)= here we are able to pull metadata:

DEBUG 2016-03-= 10 03:50:08,051 (Worker thread '3') - DCTM: Document 090007c2800056= 9d has version label: 11+authors+object_name+owner_name+owner_permit+r_crea= tion_date+r_creator_name+r_modifier+r_modify_date+r_object_id+r_object_type= +title++0+DEAD_AUTHORITY+1.0_0_http://localhost/webtop/
DEBUG 2016-03-10 03:50:0= 8,052 (Worker thread '3') - DCTM: Inside processDocuments


2.) NOT able to pull metadata:
DEBUG 2016-03-10 14:58:22,908 (Worker thread '22') - DC= TM: Document 098c1b3880991f48 has version label: 0++0+DEAD_AUTHORITY+_4_ http://localhost/webtop=
DEBUG 2016-03-10 14:58:22,908 (Worker thread '22') -= DCTM: Inside processDocuments


Any = ideas will be appreciated.

Thank you,
Radek





--001a114b741e947e06052eb6a736--