[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: (SQR 5703) Error opening the sqr log file (PeopleSoft SQR)
Thanks Rod.
The fix to this problem is the destination directory (-f ) cannot be named
TEMP:
-fC:\ps\temp\ - no
-fc:\temp\ - no
-fc:\winnt\temp\ - no
-fc:\sqr_kruft\ - works
I'm unable to reproduce this error on Win 2000 SP1.
Seems something happens in Win2000 SP2.
happy coding, thanks.
-b
-----Original Message-----
From: Discussion of SQR, Brio Technology's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Rod Wright
Sent: Wednesday, July 18, 2001 9:22 AM
To: SQR-USERS@list.iex.net
Subject: Re: (SQR 5703) Error opening the sqr log file (PeopleSoft SQR)
Hi Ben,
You may want to search the archives on the message board. While I'm not a
W2K user, I seem to remember some messages in the past 2 weeks dealing with
this issue. I believe one suggestion had something to do with setting
environment variables for the PC.
HTH,
Rod
Ben Stevens <surreal@SPEAKEASY.ORG>@list.iex.net> on 07/17/2001 05:20:55 PM
Please respond to sqr-users@list.iex.net
Sent by: "Discussion of SQR, Brio Technology's database
reporting language" <SQR-USERS@list.iex.net>
To: SQR-USERS@list.iex.net
cc:
Subject: Re: (SQR 5703) Error opening the sqr log file (PeopleSoft SQR)
Thanks for your email.
\orawin95\bin contains the NT executables for the Oracle Client. It is
there due to the lazy and clueless Netware Application Admins who rule this
little serfdom with the Netware Application Launcher (NAL). The Oracle
client and tools run fine from this obsolete location.
c:\temp exists, with full permissions for Everyone and SYSTEM.
I found this article from my archives:
Problem: After applying a security patch (security bulletin MS01-017) dated
April 2, 2001 customers are no longer able to send any SQR output to their
c:\temp directory. This only affects SQR 4.3.4. SQR version 6.1.1 and 6.1.4
are not affected.
You will aloso get this error when trying to send the log file to the temp
directory. (SQR 5703) Error opening the sqr log file
Solution: At this time there is only a work around you must send the output
to any other directory other than c:\temp. PeoplesSoft is looking into a
more permenent fix and will notify cusotmers when we have more information.
I tried switching the output directory from c:\temp to c:\ps\temp and even
c:\winnt\temp. Same error message (SQR 5703)
Any other guesses/hints?
-----Original Message-----
From: Discussion of SQR, Brio Technology's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Cullina, Adam
Sent: Tuesday, July 17, 2001 4:01 PM
To: SQR-USERS@list.iex.net
Subject: Re: (SQR 5703) Error opening the sqr log file (PeopleSoft SQR)
I would suggest you might not have a \orawin95\bin anymore... perhaps an
\orant\
I don't think c:\temp\ is a stock directory in Windows 2000 either.
c:\winnt\temp exists by defaults, but I think c:\temp\ only exists if you
(or another application) creates it.
Not SURE about either, but it would be worth checking.
Adam
-----Original Message-----
From: Ben Stevens [mailto:surreal@SPEAKEASY.ORG]
Sent: Tuesday, July 17, 2001 3:29 PM
To: SQR-USERS@list.iex.net
Subject: (SQR 5703) Error opening the sqr log file (PeopleSoft SQR)
Hi, hello. I'm working on a PeopleSoft upgrade, and as usual I'm batching
many of the .DMS and .SQR scripts together to run unattended. Everything
was fine until my Windows 95 workstation was upgraded to Windows 2000.
Now,
the batch file fails when I try to run an SQR on the command line.
Does anyone have any insight why this batch file would run on Windows 95,
but not on Windows 2000?
Thanks
benj (surreal@speakeasy.org)
An example is sysaudit.bat:
setlocal
rem ============= edit below for db information ==========
SET DBNAME=HR75UPG
rem ============= edit below for db login ================
SET DBLOGIN=SYSADM
SET DBPASSWD=SYSADM
rem ============= edit below for PS login
SET PSLOGIN=PS
SET PSPASSWD=PS
rem ============= edit below for SQR constants ===========
SET SQREXE=Q:\APPS\Hr75\HR751\sqrbinw\sqrw.exe
SET SQRLOC=Q:\APPS\HR75\HR751\SQR
SET DIRLIST=-iQ:\APPS\hr75\hr751\sqr\
SET ALLMAXES=-mq:\APPS\hr75\hr751\sqr\allmaxes.max
SET SQRINI=-ZIFQ:\APPS\hr75\hr751\sqr\pssqr.ini
rem ============= edit below for Data Mover constants ====
SET DMSEXE=Q:\APPS\Hr75\HR751\bin\CLIENT\WINX86\PSDMT.EXE
SET DMSLOC=Q:\APPS\HR75\HR751\SCRIPTS
rem ============= local drive, change to dbbin directory
c:
cd \orawin95\bin
rem ====================== for SQL's
rem ===START /W C:\ORAWIN95\BIN\SQLPLUS.EXE %DBLOGIN%/%DBPASSWD%@%DBNAME%
@%DMSLOC%\XXXXSCRIPTNAMEXXXX.SQL
rem ====================== for SQRs
rem ===SET SQRPROG=XXXXXXX
rem ===IF EXIST C:\TEMP\%SQRPROG%.LOG PAUSE
rem ===IF EXIST C:\TEMP\%SQRPROG%.LIS PAUSE
rem ===START /W %SQREXE% %SQRLOC%\%SQRPROG%.SQR
%DBLOGIN%/%DBPASSWD%@%DBNAME% %DIRLIST% -EC:\TEMP\%SQRPROG%.ERR
%ALLMAXES% -fC:\TEMP\%SQRPROG%.LIS %SQRINI% -Oc:\temp\%SQRPROG%.log
rem ===if EXIST C:\TEMP\%SQRPROG%.ERR PAUSE
rem ====================== for data mover
rem ===SET DMSSCRIPT=XXXXXXX
rem ===IF EXIST C:\TEMP\%DMSSCRIPT%.LOG PAUSE
rem ===IF EXIST C:\TEMP\%DMSSCRIPT%.LIS PAUSE
rem ===START /W %DMSEXE% -SS NO -CT ORACLE -CD %DBNAME% -CO %PSLOGIN% -CP
%PSPASSWD% -FP %DMSLOC%\%DMSSCRIPT%.DMS
rem ======================for restart
REM goto restart
:restart
set | more
pause
rem ====================== SYSAUDIT.SQR
SET SQRPROG=SYSAUDIT
IF EXIST C:\TEMP\%SQRPROG%.LOG PAUSE
IF EXIST C:\TEMP\%SQRPROG%.LIS PAUSE
rem START /WAIT Q:\APPS\Hr75\HR751\sqrbinw\sqrw.exe
Q:\APPS\HR75\HR751\SQR\SYSAUDIT.SQR
SYSADM/SYSADM@HR75UPG -iQ:\APPS\hr75\hr751\sqr\ -EC:\TEMP\SYSAUDIT.ERR -mq:
\
APPS\hr75\hr751\sqr\allmaxes.max -fC:\TEMP\SYSAUDIT.LIS -ZIFQ:
\APPS\hr75\hr7
51\sqr\pssqr.ini -Oc:\temp
START /W %SQREXE% %SQRLOC%\%SQRPROG%.SQR %DBLOGIN%/%DBPASSWD%@%DBNAME%
%DIRLIST% -EC:\TEMP\%SQRPROG%.ERR %ALLMAXES% -fC:\TEMP\%SQRPROG%.LIS
%SQRINI% -Oc:\temp\%SQRPROG%.log
if EXIST C:\TEMP\%SQRPROG%.ERR PAUSE