[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: SQR 4701 Error

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 
----------------------------------------------