ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

CA PPM: Cannot XOG Project Allocation for a particular Resource. Receive FATAL error: Project Object read failed. ORA-00920: invalid relational operator


Article ID: 17991


Updated On:


CA Identity Manager CA Identity Governance CA Identity Portal Clarity PPM SaaS Clarity PPM On Premise



Cannot XOG Project Allocation for a particular Resource.

Output file shows:

<Description>Project Object read failed</Description>
- <Exception>
- <![CDATA[ java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00920: invalid relational operator

Steps to Recreate:

  1. Use provided file 'prj_projects_alloc_act_etc_read.xml" with the filters projectID and resourceID. ie:

    <Filter name="projectID" criteria="EQUALS">myproject</Filter>
    <Filter name="resourceID" criteria="EQUALS">admin</Filter>

  2. Execute the XOG to extract allocation data of a specific resource against a specific project. Check output file.

    Expected Results:
    Should provide the allocation information of that resource against the particular project

    Results Observed:
    XOG operation provides a FATAL error

    Keywords: XOG, Project, Allocation, FATAL, error, filter


Workaround: None

This has been documented as CLRT-75364 and it is targeted for resolution in future release


Release: ESPCLA99000-13.3-Clarity-Extended Support Plus


Please Update This Required Field