ERROR: Stored Procedure not found

0 Likes

Problem:

ERROR: Stored Procedure not found

Resolution:

Information in this Brief applies to:

  • StarTeam 5.3
  • Windows 2000, NT, XP

Problem

When creating a new view label or revision label, user gets an error that says: "Stored Procedure not found"

Workaround

If you look at the StarTeam Server.Log file, you will also see the following errors accompanied by above error:

-----------------------------------------------------------------------------------------------------------------------------------------

Exception thrown from : Class = CDBException, Code = 4294967295(0xffffffff),
Msg = ORA-01031: insufficient privileges
ORA-06512: at "STARTEAM.INSTALL_DATABASE_VIEWS", line 1
ORA-06512: at line 1

[Function Name] = CStDbStoredProcedure::Execute
19 10/31/2003 10:48:58 AM W Failed to install stored procedure.
20 10/31/2003 10:48:58 AM M Listening to port 49201
21 10/31/2003 10:48:58 AM M TCP/IP (Socket) protocol registered with the endpoint 49201
22 10/31/2003 10:48:58 AM M Light-weight RPC protocol registered with the endpoint StarTeamLRPC.
23 10/31/2003 10:48:58 AM M Interface registered.
24 10/31/2003 10:48:58 AM M RPC Server successfully started.
25 10/31/2003 10:48:58 AM M Server successfully initialized.
26 10/31/2003 10:50:48 AM M Connection made from workstation KOP0002A530B9E3.
27 10/31/2003 10:50:48 AM M User Kevin R. Naylor logged on from workstation KOP0002A530B9E3.
28 10/31/2003 12:17:28 PM E Exception thrown from : Class = CDBException, Code = 4294967295(0xffffffff),
Msg = ORA-06550: line 1, column 13:
PLS-00905: object STARTEAM.CREATE_LABEL is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

[Function Name] = CStDbStoredProcedure::Execute
29 10/31/2003 12:17:28 PM E Exception handled at CStServer::DoCommand: Class = CDBException, Code = 4294967295(0xffffffff),
Msg = ORA-06550: line 1, column 13:
PLS-00905: object STARTEAM.CREATE_LABEL is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
-----------------------------------------------------------------------------------------------------------------------------------------

The problem is that the Oracle schema user assigned to StarTeam does not have sufficient privilege to perform this operation.

To ensure that StarTeam Server can create labels and perform other operations successfully, make sure that the schema user has the following Oracle privileges:

_ create session
_ create table
_ create view
_ create procedure
_ create sequence
_ create trigger
_ unlimited tablespace

Old KB# 28474
Comment List
Related
Recommended