Designer Error: "no data found" when creating new application

[karanikas]

Need some Designer help. I have an Oracle 8.1.6 instance on the same
WinNT box with a fresh install of Designer 6.0.3.9.0. When I try to
create my first test application as the repository owner, I get the
following error:

RME-00011: Operation 'INS' on ci_application_systems has failed
RME-02124: Failed to execute SQL statement: begin
:errcnt := rmmes.getsize;
rmmes.getallerrutil,:errcode,
:errp0,:errp1,:errp2,:errp3,
:errp4,:errp5,:errp6,:errp7); end;
RME-02105: Oracle error occurred...
ORA-01403: no data found
ORA-06512: at "REPOS_OWNER.RMMES", line 157
ORA-06512: at line 3

ORA-01403: no data found

Here are the priviledges that the repository owner has:
SQL> l
1 select owner, table_name, grantor , privilege from user_tab_privs
2* where grantor in ('SYS','SYSTEM')
SQL> /

OWNER TABLE_NAME GRANTOR PRIVILEGE
--------------- ------------------------------ ---------- --------------
-
SYS DBMS_LOCK SYS EXECUTE
SYS DBMS_PIPE SYS EXECUTE
SYS DBA_ROLLBACK_SEGS SYS SELECT
SYS DBA_SEGMENTS SYS SELECT
SYS DBMS_SHARED_POOL SYS EXECUTE
SYS DBMS_ALERT SYS EXECUTE
SYS DBMS_SQL SYS EXECUTE
SYS STANDARD SYS EXECUTE
SYS DBMS_STANDARD SYS EXECUTE
SYS DBMS_TRANSACTION SYS EXECUTE
SYS DBMS_UTILITY SYS EXECUTE

11 rows selected.

SQL>

I am stumped. I have actually been through the whole install twice now
with the same results.

ANY help would be GREATLY appreciated!!

Thanks!
Pete

pete_karanikas@hotmail.com

 

[johnsod]

I think both the repository owner and the application
owner need to have dba role privileges, and manager rights
in the application.

I'm confused by your sql:

select owner, table_name, grantor , privilege
from user_tab_privs
where grantor in ('SYS','SYSTEM')

I think you want to change grantor to grantee in both places
and change the ('SYS','SYSTEM') to the names of your
repository owner(s).

It would not be a good idea to use SYS or SYSTEM as your
repository owner.

The seeded repository that comes with designer uses the
user REPOS as the repository owner.

You should create a separate user APP or something like that
for your APPLICATION Owner.

Login to Designer as the REPOS user, then use the REPOSITORY
ADMINISTRATION tool to set up the APP user as a manager.
Reconcile,Exit.

Login to Designer as APP, open the RON, create your application.

 

[JFlack]

First of all, neither the Repository Owner nor any Application Owner needs the DBA Role, and I suggest strongly that you don't grant that role to any user that doesn't need it. The Designer installation guide is very clear about what privileges these users need. The Repository Owner, but not any other Designer user, needs SELECT on a few of the DBA_ and V$ views, which must be granted directly by SYS. I suggest that you recheck the privileges listed in the Installation Guide against the ones actually granted, just to be sure.

However, if you have successfully installed the repository, I doubt that privileges are your problem. If the owner didn't have the right privileges, there will be error messages all over the installation logs. Instead, you might check init.ora parameters against the requirements in the installation guide. Check that you have big enough public rollback segments too. Seems to me that I got similar error messages when I created my first application, and it turned out to be one of these.