ORA-01403 in Oracle9iDesigner when adding process steps

BFLEERAC
BFLEERAC used Ask the Experts™
on
The following error occurs when I try to add process steps to the process model.
I successfully added organization units to the model.
The repository is in a working order.
The repository is stored in an Oracle9i database.

Do I need additional access rights here ? , I found on the net that the instance needs a bit of tuning maybe ?
 
RME-00020: Internal API error - ORA-01403: no data found
RME-00011: Operation 'ins' on FUNCTION has failed
RME-00222: Failed to dispatch operation to Repository

Regards
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
you need to set up some privileges to your repository user:

grant execute on dbms_lock to repos_owner;
grant execute on dbms_pipe to repos_owner;
grant create table to repos_owner;
grant create view to repos_owner;
grant create procedure to repos_owner;
grant create synonym to repos_owner;
grant create sequence to repos_owner;
grant select on sys.v_$nls_parameters to repos_owner with grant option;
grant select on sys.v_$parameter to repos_owner;
grant select on dba_rollback_segs to repos_owner;
grant select on dba_segments to repos_owner;
grant create any synonym to repos_owner;
grant drop any synonym to repos_owner;

where repos_owner is the username of the repository owner
You can read this in Chapter 2 from
Oracle RepositoryDesigner Installation Guide

file:///x:/<OracleDesigner>/CDOC72/rep_insgde/igch2_65.htm#InstallinganewRepository
Helena Markováprogrammer-analyst

Commented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Accept graf27's comment as answer.

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Henka
EE Cleanup Volunteer

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial