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

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
 

Environment

Release:
Component: PPMENV

Cause

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

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.