Clarity

 View Only
  • 1.  Error when xogging new rate matrix

    Posted Oct 19, 2015 02:25 PM

    I am getting an error when i try to xog in a brand new rate matrix and was wondering if anyone has experienced this.

     

    The weirdest part is, the rate matrix is actually SUCCESSFULLY created.

     

    ERROR:

    <Exception><

    ![CDATA[

     

     

     

    1. java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20219: A row already exists with this information on

    ORA-06512: at "PAC_MNT_MATRIX_ROW_INSERT_SP", line 208

    ORA-06512: at line 1

       </Records>

      <Statistics failureRecords="4530" insertedRecords="1" totalNumberOfRecords="1" updatedRecords="0"/>

      <Status elapsedTime="2 minutes 16.175999999999988 seconds " state="FAILURE"/>

    </XOGOutput>

     

     

    Steps to reproduce

    1. Xog out existing Rate Matrix
    2. Change the Rate Matrix name in the XML (xog file)
    3. Xog in the Rate Matrix

     

    Expected Results: Xog output displays state = "Success"

    Actuals results: Xog output displays state = "failure"



  • 2.  Re: Error when xogging new rate matrix

    Posted Oct 19, 2015 02:32 PM

    I believe I have caught part of the issue, but not sure why this is happening. When Looking at the rate matrix that I used to initially xog out, the UI is displaying 55300 records but the xml write file contains 10060 records. Any ideas on why this would be?



  • 3.  Re: Error when xogging new rate matrix
    Best Answer

    Posted Oct 19, 2015 02:37 PM

    This is apparently a defect in 13.2 and was resolved in a 13.3 patch. Defect Number : CLRT-75189

      




  • 4.  Re: Error when xogging new rate matrix

    Posted Oct 19, 2015 03:47 PM