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

[Arun Kumar <arunkumar13@yahoo.com>]

Oops.. I misunderstood your question earlier...

I think its security... when sqr is kicked by the process scheduler .. its 
probably using the local system user account on the NT server.

If its using the local system user account, It probably doesnt have access 
across servers in the network.





----- Original Message ----
From: Arun Kumar <arunkumar13@yahoo.com>
To: This list is for discussion about the SQR database reporting language from 
Hyperion Solutions. <sqr-users@sqrug.org>
Sent: Saturday, February 3, 2007 12:53:12 PM
Subject: Re: [sqr-users] UNC path works in SQRW but not in PeopleSoft


Doesnt all the sqr's need to be in one of the four designated sqr directory in 
people soft?

Process scheduler can only search these directories for the sqr.


----- Original Message ----
From: Larry Roux <lroux@syr.edu>
To: sqr-users@sqrug.org
Sent: Saturday, February 3, 2007 8:43:29 AM
Subject: Re: [sqr-users] UNC path works in SQRW but not in PeopleSoft


Check the file ownership.  Is it the same as the PS id? (Not the OPRID
of the person running the process, but the PS ID).  You can just make
sure the file ownership is the same as other PS files on the same
server.  


Larry Roux
Information Systems
Syracuse University
lroux@syr.edu

>>> shdhra@yahoo.com 02/02/07 6:39 PM >>>
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

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



---------------------------------
Food fight? Enjoy some healthy debate
in the Yahoo! Answers Food & Drink Q&A.

_______________________________________________
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



____________________________________________________________________________________
8:00? 8:25? 8:40? Find a flick in no time 
with the Yahoo! Search movie showtime shortcut.
http://tools.search.yahoo.com/shortcuts/#news

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


 
____________________________________________________________________________________
We won't tell. Get more on shows you hate to love 
(and love to hate): Yahoo! TV's Guilty Pleasures list.
http://tv.yahoo.com/collections/265 

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