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

book

Article ID: 17991

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL CA Identity Manager CA Identity Governance CA Identity Portal Clarity PPM SaaS - Application Clarity PPM On Premise

Issue/Introduction

Descriprtion:

Cannot XOG Project Allocation for a particular Resource.

Output file shows:

<Severity>FATAL</Severity>
<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

Solution:

Workaround: None

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



Environment

Release: ESPCLA99000-13.3-Clarity-Extended Support Plus
Component:

Resolution

Please Update This Required Field