Clarity: Upgrade to 13.3 fails due to unique constraint on the ODF_SSL_GL_ALL_DTL_PCT table

Document ID : KB000048471
Last Modified Date : 14/02/2018
Show Technical Document Details


When attempting to upgrade to Clarity 13.3, the upgrade fails with a unique constraint message due to records created for GL Allocation Detail Percentages

Steps to Reproduce:

  1. Have a Clarity implementation with Standard and Credit Rule GL Allocation Detail rows configured

  2. Upgrade to Clarity 13.3

Expected Result: Upgrade is successful.

Actual Result: Upgrade fails with a unique constraint error on the ODF_SSL_GL_ALL_DTL_PCT table


This is caused by an issue documented as CLRT-71791.

There may be duplicated data already existing in the table in a version prior to Clarity 13.3.

Therefore, it is recommended that before performing the upgrade action, please apply the attached script file using the following steps.


  1. Extract and copy the script XML file to your Clarity application server in the $CLARITY_HOME directory

  2. Open a command prompt window, navigate to the directory where the file is saved and execute the following command

    dbpatch -install -file <filename> -apply

  3. Proceed with the upgrade to Clarity 13.3

Keywords: CLARITYKB, CLRT-71791, clarity13upgrade.

File Attachments: