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

Description:

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

Solution:

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.

PRE-UPGRADE 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:
TEC606704.zip