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

["Bob Buford" <Bob.Buford@ccci.org>]

I noticed that when you first showed the path - the subfolder \Data
Files\ was included.  But on the error report it shows as \Data.  Also
the ( & ) were stripped out.  Could there be some DOS limitations that
the Process Scheduler is abiding by that do not do well with spaces
and other odd characters in the path?

Try using a path that abides by the older DOS limitations and see if
that makes a difference.

Bob

-----Original Message-----
From: Joe [mailto:jej1216@hotmail.com] 
Sent: Monday, February 05, 2007 10: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=hmem
> tagline_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