Clarity Upgrade fails with ORA-20000: ORU-10027: buffer overflow, limit of 1000000

book

Article ID: 102713

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

Clarity PPM Upgrade fails with an error as follows:
 
6/12/18 1:11 PM (ExecTask) java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20000: ORU-10027: buffer overflow, limit of 1000000
 

Cause

This is caused by customizations on customer's database that have not been removed prior to upgrade.
 

Environment

Release:
Component: PPMENV

Resolution

 Any custom database tables, views, functions, procedures and other objects should be dropped before you start the upgrade.
Once the upgrade completes, and you confirm it's working as expected, you may recreate your custom objects.