Error running DQL from DA and IDQL

jaanwari
jaanwari Member
edited October 2, 2014 in Documentum #1

Recently we applied the following patches in our development environment:

Patch levelApplication
Path 08
  • CS 7.1
  • DA 7.1
  • DFS
Path 06
  • BPS
  • BPM
  • BAM
Path 05
  • xCP Viewer Services

After applying I started getting errors when trying to execute DQL. I tried both DA and IDQL but in both cases it throws the errors related to missing xCP Classes:

DA

java.lang.NoClassDefFoundError: com/emc/xcp/artifact/model/artifact/DataModel

DA-DQL-Error.png


IDQL

java.lang.ClassNotFoundException: com.emc.xcp.expressions.functions.AspectFunctions

IDQL-Error.png

Any solution to fix this issue?


Thanks,

Jahangir


Tagged:

Best Answer

  • jaanwari
    jaanwari Member
    edited October 2, 2014 #2 Answer ✓

    Was able to resolve this issue by doing the following:

    • Cleared Documentum cache by deleting contents of %DOCUMENTUM%\cache
    • Delete bpm_infra.jar found in da\WEB-INF\lib\ folder

Answers

  • Alvaro_de_Andres
    edited September 30, 2014 #3

    It's been said several times that DA is missing xCP jar files related to xcp aspects, just throw the missing jars into WEB-INF/lib (and/or documentum/shared I guess) and it should work...

  • PanfilovAB
    PanfilovAB Member
    edited September 30, 2014 #4

    It's been said several times that DA is missing xCP jar files related to xcp aspects

    No.


    [dmadmin@docu71dev01 ~]$ echo $CLASSPATH
    /u01/documentum/cs/shared/dfc/log4j.jar:/u01/documentum/cs/shared/dfc/dfc.jar:/u01/documentum/cs/product/7.1/bin:/u01/documentum/cs/shared/config:/u01/documentum/cs/product/7.1/dctm-server.jar:/u01/documentum/cs/shared/dctm.jar:
    [dmadmin@docu71dev01 ~]$ iapi
    Please enter a docbase name (docubase): xcp21
    Please enter a user (dmadmin):
    Please enter password for dmadmin:


            EMC Documentum iapi - Interactive API interface
            (c) Copyright EMC Corp., 1992 - 2013
            All rights reserved.
            Client Library Release 7.1.0020.0120


    Connecting to Server using docbase xcp21
    [DM_SESSION_I_SESSION_START]info:  "Session 01022428800537fc started for user dmadmin."


    Connected to Documentum Server running Release 7.1.0050.0194  Linux64.Oracle
    Session id is s0
    API> ?,c,select r_type_name from dmi_type_info where any default_aspects='defaultdatatypeaspect'
    r_type_name
    ---------------------------
    bv_document
    bv_client
    bv_folder
    bv_client_request
    bv_contract
    bv_dossier
    xbv_clientattrpackage
    test21_xtestcontent
    xbv_dict_request_kind
    xbv_folder
    ap_test
    bv_additional_agreement
    bv_client_record
    bv_contract_dossier
    bv_interim_doc
    xbv_document
    (16 rows affected)

    API> create,c,ap_test
    ...
    09022428800b1fd3
    API> save,c,l
    ...
    OK
    API> ?,c,create ap_test object set object_name='test'
    object_created
    ----------------
    09022428800b1fd4
    (1 row affected)

    API>

  • Alvaro_de_Andres
    edited October 1, 2014 #5

    At least in 7.0 jar files bundled with DA where different/older/missing than the ones bundled with xCP, I assume (I want to believe ) $DOCUMENTUM_SHARED has the latest/fully working ones and probably IDQL problem is just a matter of classpath configuration. However I still think the DA error is due to missing/older versions jar files

  • PanfilovAB
    PanfilovAB Member
    edited October 1, 2014 #6

    That is true about 7.0/2.0 stack, but in my 7.1/2.1 environment all components do work smoothly w/o copying jars.

  • jaanwari
    jaanwari Member
    edited October 1, 2014 #7

    Similar to Panfilov before applying the patch I had no issue running DQL without copying jars in CS7.1 and xCP 2.1.

    Only after applying the patch I started running into class not found errors.

  • jaanwari
    jaanwari Member
    edited October 2, 2014 #8 Answer ✓

    Was able to resolve this issue by doing the following:

    • Cleared Documentum cache by deleting contents of %DOCUMENTUM%\cache
    • Delete bpm_infra.jar found in da\WEB-INF\lib\ folder