When Project managers try to create a New instance of Status Report from Project - Properties - 'Status Report' page the following error message is generated: 'Error 500 - Internal Server Error'
The Clarity app-ca.log file does contain the following error messages;
AutoNumber Limit Reached when generating the next number for object 'cop_prj_statusrpt' + attribute 'name' using scheme defined in partition
java.sql.SQLException: [CA Clarity][Oracle JDBC Driver]
ORA-06512: at "CLARITY DB.CMN_AUTONUM_GET_NEXT_SP", line 194
ORA-06512: at line 1
The Alphanumeric auto number segment in the attribute 'Name' - Auto Numbering tab of the 'Status Report' object was not set to auto-extend = true and value was set to "00". This value had reached to its maximum i.e. "ZZ".
Because auto-extend was false, when system tried to fetch next value it reported AUTONUMBER SCHEME EXAUSTED error which is an expected behavior from product.