XOG FATAL Exception when trying to update a Resource OBS with an OBS Unit that does not exist and it has apostrophe.

Document ID : KB000072386
Last Modified Date : 28/02/2018
Show Technical Document Details
Issue:
Steps to Reproduce:
1. In the UI create a regular OBS 'myobs' and associated with Resource Object.
Add a Unit, for example:
Name= O'Connor,Mary
ID=O'Connor
 
2. In Application side Open a Resource and for the OBS 'myobs' select /O'Connor,Briget
 
3. XOG it out. XOG back in without changing anything. XOG output shows:
 
- <XOGOutput xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/status.xsd">
<Object type="resource" />
<Status elapsedTime="3.555 seconds" state="SUCCESS" />
<Statistics failureRecords="0" insertedRecords="0" totalNumberOfRecords="1" updatedRecords="1" />
<Records />
</XOGOutput>
 
Record is updating fine. OBS Unit with apostrophe exists in Clarity
 
4. Edit the input file and use an OBS Unit that does not exist and be sure it has apostrophe, like Test' Level". Example, my file has:
 
<OBSAssocs complete="false">
<OBSAssoc id="myobs" name="myobs" unitPath="/Test' Level"/>
</OBSAssocs>
 
XOG it in.
 
Check XOG output
 
 
Expected Result:  
XOG output should show a message indicating that the OBS unit does not exist 
 
Actual Result:  
XOG FATAL Exception. This record has not been inserted 
 
XOG output:
 
<XOGOutput xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/status.xsd">
  <Object type="resource"/>
  <Status elapsedTime="0.718 seconds" state="FAILURE"/>
  <Statistics failureRecords="1" insertedRecords="-1" totalNumberOfRecords="1" updatedRecords="1"/>
  <Records>
    <Record>
      <KeyInformation>
        <column name="resourceId">myname</column>
        <column name="lastName">mylastname</column>
        <column name="externalSource">NIKU</column>
        <column name="externalId"/>
      </KeyInformation>
      <ErrorInformation>
        <Severity>FATAL</Severity>
        <Description>This record has not been inserted</Description>
        <Exception><![CDATA[
com.niku.xql2.eval.ParseException: Encountered "Level" at line 1, column 38.
Was expecting one of:
    ")" ...
    "," ...
    "?" ...
    "+" ...
    "-" ...
    "*" ...
    "/" ...
    "=" ...
    "!=" ...
    "<>" ...
    ">" ...
    ">=" ...
    "<" ...
    "<=" ...
    "or" ...
    "and" ...
    "not" ...
    "is" ...
    "like" ...
    
at
 
Environment:
CA PPM 14.2, 14.3
Cause:
Caused by defect CLRT-78943
 
Resolution:
Fixed in CA PPM 14.4