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

Document ID : KB000102713
Last Modified Date : 19/06/2018
Show Technical Document Details
Issue:
CA 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.
 
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.