Re: Designer/2000 - Help! ... Cannot create Application System

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Tue, 11 Apr 2000 13:36:56 +0200
Message-ID: <8cv2ov$8rm$1_at_porthos.nl.uu.net>

Well,

I know the doc isn't very clear - did you grant to the role, or to the owner of the
Designer tables?
I use this (replace des2kv6_owner to your own):

GRANT EXECUTE ON SYS.DBMS_LOCK        TO D2KV6_OWNER;
GRANT EXECUTE ON SYS.DBMS_PIPE        TO D2KV6_OWNER;
GRANT create sequence TO D2KV6_OWNER;

GRANT create synonym TO D2KV6_OWNER;
GRANT create table TO D2KV6_OWNER;

--
-- Also used but normally granted to public:
--
GRANT EXECUTE ON SYS.DBMS_ALERT       TO D2KV6_OWNER;
GRANT EXECUTE ON SYS.DBMS_LOCK        TO D2KV6_OWNER;
GRANT EXECUTE ON SYS.DBMS_PIPE        TO D2KV6_OWNER;
GRANT EXECUTE ON SYS.DBMS_SHARED_POOL TO D2KV6_OWNER;
GRANT EXECUTE ON SYS.DBMS_SQL         TO D2KV6_OWNER;
GRANT EXECUTE ON SYS.STANDARD         TO D2KV6_OWNER;
GRANT EXECUTE ON SYS.DBMS_STANDARD    TO D2KV6_OWNER;
GRANT EXECUTE ON SYS.DBMS_TRANSACTION TO D2KV6_OWNER;
GRANT EXECUTE ON SYS.DBMS_UTILITY     TO D2KV6_OWNER;

hth,
--
Kind Regards,
Frank
<tomvamos_at_my-deja.com> wrote in message news:8ckqil$lvm$1_at_nnrp1.deja.com...


> Yep ... I followed all the 'repos_owner' instructions very specifically.


>

>

> In article <8ckl81$fra$1_at_nnrp1.deja.com>,

>   derwin_at_my-deja.com wrote:

> > You did do the sys grants to DBMS_PIPE and DBMS_LOCKS right? Those

> > are a must.

> >

> > In article <8ckh4t$bob$1_at_nnrp1.deja.com>,

> >   tomvamos_at_my-deja.com wrote:

> > > Hi Joel,

> > > Thanks for the advice, but all the checks are OK: the required

> > > privileges are there and there are no invalid pacakages. I recreated

> > > the repos. but the same thing happens.

> > > Do you have any other suggestions?

> > >

> > > In article <38ECA900.6A7C2268_at_canadapost.ca>,

> > >   Joel Racicot <joel.racicot_at_canadapost.ca> wrote:

> > > > Tom,

> > > >

> > > > Check to make sure that you granted all the required privileges to

> > the

> > > > repository owner when you created the repository orignally, then

> > check

> > > > for any invalid or missing packages.

> > > >

> > > > It sounds like you have an invalid package.

> > > >

> > > > Hope this helps.

> > > >

> > > > Joel

> > > >

> > > > tomvamos_at_my-deja.com wrote:

> > > >

> > > > > Hi there,

> > > > > I have a Designer/2000 error I can't get round

> > > > > regardless of how many times I've reinstalled and

> > > > > recreated. Please help if you can.

> > > > >

> > > > > Having created a repository, I go in to Designer

> > > > > and try to create an Application System by simply

> > > > > typing a name and pressing 'Create' in

> > > > > the 'Application System' dialog. However, I

> > > > > always get the following error:

> > > > >

> > > > > ORA-01403: no data found

> > > > >

> > > > > .. which comprises of (please excuse the block of

> > > > > text) :

> > > > >

> > > > > RME-00011: Operation 'INS' on

> > > > > ci_application_systems has failed

> > > > > RME-02124: Failed to execute SQL statement: begin

> > > > > :errcnt := rmmes.getsize;

> > > > > rmmes.getall(:errutil,: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

> > > > >

> > > > > Can anyone explain / help with this problem?

> > > > > Thanks in advance ...

> > > > >

> > > > > Tom Vamos

> > > > >

> > > > > Sent via Deja.com http://www.deja.com/

> > > > > Before you buy.

> > > >

> > > >

> > >

> > > Sent via Deja.com http://www.deja.com/

> > > Before you buy.

> > >

> >

> > Sent via Deja.com http://www.deja.com/

> > Before you buy.

> >

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.

Received on Tue Apr 11 2000 - 13:36:56 CEST