[sqr-users] SQR shows as Error

["abhay sachar" <sachar_abhay@hotmail.com>]

Hi,

I am running an SQR which does updates to Customer tables. It is a SQR 
Process, and has no report.
It is running Ok, I mean does the update and all - I've added 'show' 
statements in the code.
Those are showing the flow.

But while I run it in the Process Scheduler, it shows Run Status as Error. 
The Distribution status is Posted.
The Status of the SQR is showing as Error in the Process Monitor.

Any ideas on why this could be happening??

This is what it shows on the Message Log -

PeopleTools 8 - PSSQR
Copyright (c) 1988-2003 PeopleSoft, Inc.
All Rights Reserved

Database Type:                Oracle
Database Name:                CRMDEV84
Report Name:                  P_RF0054
Process Instance:             24359
Run Control ID:               11
Language Code:                ENG
Output Destination Type:      WEB
Output Destination Format:    PDF
Output Destination:           D:\psoft\CRMDEV84\appserv\prcs\CRMDEV84 
\log_output\SQR_P_RF0054_24359

Output Directory (SQOT):      
D:\psoft\CRMDEV84\appserv\prcs\CRMDEV84\log_output\SQR_P_RF0054_24359

Log Directory (SQLG):         
D:\psoft\CRMDEV84\appserv\prcs\CRMDEV84\log_output\SQR_P_RF0054_24359

SQR Flags:                    -ZIFD:\psoft\crmdev84\SQR\PSSQRENG.INI

Log File (SQLF):              
D:\psoft\CRMDEV84\appserv\prcs\CRMDEV84\log_output\SQR_P_RF0054_24359\P_RF0054_24359.out

Include File (SQIN):          
D:\psoft\CRMDEV84\appserv\prcs\CRMDEV84\log_output\SQR_P_RF0054_24359\;D:\psoft\crmdev84\USER\SQR\;D:\psoft\crmdev84\SQR\;\;\

File (FILE_1):                
D:\psoft\CRMDEV84\appserv\prcs\CRMDEV84\log_output\SQR_P_RF0054_24359\P_RF0054_24359.PDF

SQR Command = d:\psoft\CRMDEV84\bin\sqr\ORA\binw\sqrw 
D:\psoft\crmdev84\USER\SQR\P_RF0054.sqr */*@CRMDEV84   
-oD:\psoft\CRMDEV84\appserv\prcs\CRMDEV84\log_output\SQR_P_RF0054_24359\P_RF0054_24359.out
 
-xmb -xcb -xi  
-iD:\psoft\CRMDEV84\appserv\prcs\CRMDEV84\log_output\SQR_P_RF0054_24359\;D:\psoft\crmdev84\USER\SQR\;D:\psoft\crmdev84\SQR\;\;\
 
  -zifD:\psoft\crmdev84\SQR\PSSQR.INI  
"-fD:\psoft\CRMDEV84\appserv\prcs\CRMDEV84\log_output\SQR_P_RF0054_24359\P_RF0054_24359.PDF"
 
-PRINTER:PD    CRMDEV84 24359 ASACHAR 11

Thanks,
Abhay.

_________________________________________________________________
Choose what you want to read. Protect your mail from spam. 
http://server1.msn.co.in/sp04/hotmailspamcontrol/  Win the war in 9 steps!


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