Re: SQR 4701 Error

[eddy vasile <evasile@HOTMAIL.COM>]

The process scheduler has SYSADM rights. The client login "should have"
limited rights. Any SQR that refrences USER_TABLES instead of ALL_TABLES
will return null results when run from the SQR icon and valid results when
run from the proc scheduler. There are other issues as well (e.g. the proc
scheduler may define the -i switch differently, thus other SQCs are included
which your -i path may be ignoring).

>From: "Veso M. Lukovic" <VMLukovi@STVINCENT.ORG>
>Reply-To: SQR-USERS@list.iex.net
>To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
>Subject: Re: SQR 4701 Error
>Date: Mon, 4 Oct 1999 11:32:09 -0500
>
>Hey all.. I am having a similar problem.  My user is actually able to run
>process scheduler (on the client) and have the SQR run and print, but when
>running from the SQR icon, gets the following message:
>
>(SQR 5528) ORACLE ORLON error -3121 in cursor 0:
>    Error while trying to retrieve text for error ORA-03121
>(SQR 4701) Can't log on to the database
>
>The Oracle client tnsnames file and client softwar are correct (can use
>SQLPlus fine).
>
>I am mostly baffled as to why process scheduler worked, but not the SQR
>icon..  I tried cutting and pasting the parameters from the process
>scheduler job, but still have same error.
>
>
>I am running on Oracle 7.3.2.4, PeopleSoft HRMS 7.02.  Novell client.. by
>the way, this error appeared after the workstation folks did a Y2K
>downgrade.. sorry, I mean upgrade :-)
>
>I am not sure exactly what they did, but I will try to find out, and add
>any other information to this mailing..
>
>Thanks in advance for your help!  I do really need it an appreciate all in
>this group!
>
>
>
>=============================
>Veso Lukovic
>PeopleSoft Systems
>St. Vincent Hospital
>Indianapolis IN.
>vmlukovi@stvincent.org
>=============================
>
>
> >>> "John A. Hayes" <owner@HSS-USA.COM> 09/29/99 03:43PM >>>
>Mark,
>
>Just an FYI:  You can add a tns_admin key to the Oracle section of the
>registry to point to a central tnsnames.ora file.  This way you get out of
>maintaining the tnsnames.ora on each workstation.
>
>----------------------------------------------
>Hayes Systems Solutions, Inc.  Canoga Park, CA
>mailto:owner@hss-usa.com
>http://www.hss-usa.com
>----------------------------------------------
>
>At 02:52 PM 9/29/99 -0500, you wrote:
> >[Mark A. Clements]
> >
> >SQR's launched from process scheduler can run either on the server or the
> >client.  The way we do things here, the user logs into a three tier
> >environment
> >to do all of their PeopleSoft processing, but when they launch an SQR, it
> >actually spins off a two-tier process on their workstation unless they
>specify
> >that the process run on the server.  I have a hunch that is what is
>happening
> >to you.  In that case, the sql*net connection and tns names must be
>maintained
> >on each workstation.
> >
> >Could that be the problem?
> >
> >-Mark
> >
> >They run it from within PeopleSoft, from the menu. I assume it is three
> >tier, the database resides in Ottawa, and we are 3500 miles west of
>there.
> >The error happens after the PeopleSoft login, the users are able to
> >edit/retrieve data within the form, it is running the 'canned' reports
>that
> >generates the error.
> >
> >Lorne Gottschewski
> >Programmer
> >WTIS
> >19 Wing. CFB Comox
> >----- Original Message -----
> >From: Mark Clements <Clements@UWPLATT.EDU>
> >To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
> >Sent: Wednesday, September 29, 1999 11:53 AM
> >Subject: Re: SQR 4701 Error
> >
> >
> > > [Mark A. Clements]
> > >
> > > Are they running the report from a PeopleSoft panel or from workbench?
>  It
> >also
> > > makes a difference if they are running in 2 or 3 tier modes.
> > >
> > >
> > > -Mark
> > >
> > > I have several work stations that use PeopleSoft (v7) and I have
>recently
> >added
> > > an Oracle 8.0.5 Application written with Oracle Developer 6 on those
> >machines.
> > > Ever scince,  the user can  loggon to peopleSoft, but is unable to run
>a
> >report
> > > without getting the following:
> > > SQRW V3.0.18.1.1  (SQR 4701) Can't logon to database.
>
>----------------------------------------------
>Hayes Systems Solutions, Inc.  Canoga Park, CA
>mailto:owner@hss-usa.com
>http://www.hss-usa.com
>----------------------------------------------

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com