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

[Arun Kumar <arunkumar13@yahoo.com>]

I like this idea.. Atleast for trouble shooting purposes..

Open the file locally,run it process scheduler to confirm its the 
right/security issue.


----- Original Message ----
From: the dragon <ceprn@hotmail.com>
To: sqr-users@sqrug.org
Cc: jej1216@hotmail.com
Sent: Monday, February 5, 2007 10:51:35 AM
Subject: Re: [sqr-users] UNC path works in SQRW but not in PeopleSoft

An alternative solution is to have the file placed on the Process scheduker 
server and pull it from there.

peace,
clark 'the dragon' willis



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

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

>Once again, what's the error message you're getting?
>
>
>
>
>----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
>

_________________________________________________________________
>From predictions to trailers, check out the MSN Entertainment Guide to the 
Academy Awards® 
http://movies.msn.com/movies/oscars2007/?icid=ncoscartagline1


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







 
____________________________________________________________________________________
Sucker-punch spam with award-winning protection. 
Try the free Yahoo! Mail Beta.
http://advision.webevents.yahoo.com/mailbeta/features_spam.html

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