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:
- Have a Clarity implementation with Standard and Credit Rule GL Allocation Detail rows configured
- 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:
- Extract and copy the script XML file to your Clarity application server in the $CLARITY_HOME directory
- Open a command prompt window, navigate to the directory where the file is saved and execute the following command
dbpatch -install -file <filename> -apply
- Proceed with the upgrade to Clarity 13.3
Keywords: CLARITYKB, CLRT-71791, clarity13upgrade.