RE: [sqr-users] SQR shows as Error

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

What is that for?

>From: James Womeldorf <jwomeldo@fastenal.com>
>Reply-To: "This list is for discussion about the SQR database 
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: "'This list is for discussion about the SQR database reporting 
>languagefrom Hyperion Solutions.'" <sqr-users@sqrug.org>
>Subject: RE: [sqr-users] SQR shows as Error
>Date: Fri, 12 Nov 2004 15:36:43 -0600
>
>I believe you need to call at the end of your program.
>
>Do Successful-Eoj           ! Eoj.sqc
>
>Jim
>
>-----Original Message-----
>From: sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org
>[mailto:sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org]On Behalf Of
>abhay sachar
>Sent: Friday, November 12, 2004 3:21 PM
>To: sqr-users@sqrug.org
>Subject: [sqr-users] SQR shows as Error
>
>
>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_RF00
>54_24359.out
>
>Include File (SQIN):
>D:\psoft\CRMDEV84\appserv\prcs\CRMDEV84\log_output\SQR_P_RF0054_24359\;D:\ps
>oft\crmdev84\USER\SQR\;D:\psoft\crmdev84\SQR\;\;\
>
>File (FILE_1):
>D:\psoft\CRMDEV84\appserv\prcs\CRMDEV84\log_output\SQR_P_RF0054_24359\P_RF00
>54_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_RF
>0054_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_R
>F0054_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
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users

_________________________________________________________________
NRIs - Free money transfer to India. Fly to India for free!  
http://acm.bridgeovertw.com/hdfc/qr/landingpage/sep04/index.htm?sitecode=610|394
 
Apply Now.


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