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

["Beller, Jay" <jbeller@LBISOFTWARE.COM>]

Ben,

We've encountered this problem after moving to Win2k and the simplest
solution right now is to use a directory whose name is not "temp" - you can
even use c:\SQRtemp, just not "temp".

-----Original Message-----
From: Ben Stevens [mailto:surreal@SPEAKEASY.ORG]
Sent: Tuesday, July 17, 2001 4: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