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

["Bill Beckner" <Bbeckner@icc.edu>]

We had a similar problem with the Application Servers executing COBOL
programs on a common server as well (all running in a Windows
environment).  

We modified the TUXEDO IPC Helper service on the App Server and Process
Scheduler so that it logged on as a network user (instead of as
LocalSystem user).  This network user has read/execute permissions to
the remote servers.  This did the trick!  Hope this helps you out!

--
William Beckner (Just call me "Bill")
PeopleSoft Application Development Manager
Technology Services
Illinois Central College, Rm L133 - East Peoria, IL  61635-0001
PH: (309) 694-8419 -- FAX: (309) 694-8995

-----Original Message-----
From: sqr-users-bounces+bbeckner=icc.edu@sqrug.org
[mailto:sqr-users-bounces+bbeckner=icc.edu@sqrug.org] On Behalf Of Joe
Sent: Monday, February 05, 2007 9:19 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: Re: [sqr-users] UNC path works in SQRW but not in PeopleSoft

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.955S
JAN07.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=hmemta
gline_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