Re: (SQR 5703) Error opening the sqr log file (PeopleSoft SQR)

[Ben Stevens <surreal@SPEAKEASY.ORG>]

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