Re: [sqr-users] UNC path works in SQRW but not in PeopleSoft

["Jamie Harris" <JHarris@frederick.edu>]

Joe,

Figure out what username the Process Scheduler runs as in Peoplesoft
and make sure that it has access to the shared folder you're trying to
open the file in.   A quick test to see if that is your problem is to
share the folder and grant full access to everyone.  




-----------------------------------------------------
James Harris
Enterprise Application Analyst/Programmer
Information Technology Division
Frederick Community College 

-----------------------------------------------------

>>> "Joe" <jej1216@hotmail.com> 2/5/2007 10:19 AM >>>
Here's the error:

EH_SNU started at 2007-02-02 15:49:07.840
 Opening File ERNGL.955SJAN07.X1
Error Opening Interface File \\server1\shared1$\Interfaces\Data
Files\Patcom 
to PS (Fin) Revenue\Test\ERNGL.955SJAN07.X1

Error on line 149:
   (SQR 3301) Program stopped by user request.

SQR for PeopleSoft: Program Aborting.

I thought at first the spaces and parentheses in the folder path was
the 
issue, but that did not fix it:

 Opening File ERNGL.955SJAN07.X1
Error Opening Interface File 
\\server1\shared1$\Interfaces\Data\Patcom-PS-FIN-Revenue\Test\ERNGL.955SJAN07.X1


And again, this is when running it in Process Scheduler.  It works fine

using SQRW.

TIA,

jej1216

----- Original Message -----
From: "the dragon" <ceprn@hotmail.com>
To: <sqr-users@sqrug.org>
Sent: Saturday, February 03, 2007 8:05 PM
Subject: RE: [sqr-users] UNC path works in SQRW but not in PeopleSoft

> Once again, what's the error message you're getting?
>
>
>
> PSA: Salary <> Slavery. If you earn a salary, your employer is
renting 
> your services for 40 hours a week, not purchasing your soul. Your
time is 
> the only real finite asset that you have, and once used it can never
be 
> recovered, so don't waste it by giving it away.
>
> I work to live; I don't live to work.
>
> "Time is the coin of your life. It is the only coin you have, and
only you 
> can determine how it will be spent. Be careful lest you let other
people 
> spend it for you." -- Carl Sandburg (1878 - 1967)
>
> It is impossible to defeat an ignorant man in argument. -- William G.

> McAdoo
>
> Religion is regarded by the common people as true, by the wise as
false, 
> and by the rulers as useful. -- Seneca
>
> "I distrust those people who know so well what God wants them to do 
> because I notice it always coincides with their own desires." - Susan
B. 
> Anthony
>
>
>
>
> ----Original Message Follows----
>
> Yes, and the SQR kicks off with no problems, but there is an Open
File for
> reading Procedure - and that is where it cannot find the path/file.
>
> In SQRW, it finds the path/file correctly.
>
> -----Original Message-----
>
> Are you trying to run the sqr from Process Scheduler.
>
>
> Joe <jej1216@hotmail.com> wrote:
>   I know this is an SQR User Group, not PeopleSoft, but I'm hoping
for 
> help
> with experts in both here.
>
> I have an SQR that uses a UNC path to open an input file. It works
fine
> using SQRW on both my local PC and on the Server. However, when I put
the
> SQR into PeopleSoft and run it, I get an error that it cannot open
the
> interface file. The path quoted in the error message is the correct
path 
> and
> the filename is correct.
>
> Any suggestions on what to look at to troubleshoot this?
>
> TIA,
>
> Joe
>
> _________________________________________________________________
> Search for grocery stores. Find gratitude. Turn a simple search into

> something more. 
>
http://click4thecause.live.com/search/charity/default.aspx?source=hmemtagline_gratitude&FORM=WLMTAG

>
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org 
> http://www.sqrug.org/mailman/listinfo/sqr-users 
> 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users