Created On:  02 February 2011

Problem:

The error shown in the log file will be similar to those listed below:

Error(2,776): PLS-00201: identifier 'CONVERT_DATE' must be declared

Error(2,1654): PLS-00201: identifier 'PURGE_ATTACHMENTS' must be declared

Resolution:

The errors are due to the Oracle user account not having sufficient privileges to execute a StarTeam purge.

Please ensure the following permissions are explicitly set for the Oracle database user:
  • create procedure 
  • create sequence 
  • create session
  • create table 
  • create trigger
  • create type 
  • create view 
  • unlimited tablespace 
  • create any context 
  • drop any context
Incident #2499539