[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] SQR shows as Error
- Subject: RE: [sqr-users] SQR shows as Error
- From: "abhay sachar" <sachar_abhay@hotmail.com>
- Date: Sat, 13 Nov 2004 04:14:52 +0530
- Bcc:
- Delivery-date: Fri, 12 Nov 2004 17:46:08 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Yeah, right. But I can't seem to find it in the folder where it should be.
I get an error if I use it in the code.
-Abhay
>From: "Bartlett, Dwain" <dbartlett@state.mt.us>
>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:16 -0700
>
>Why stdapi.sqc is delivered from PeopleSoft.
>
>Dwain Bartlett
>SABHRS Services Bureau, ITSD
>HR Systems Analyst
>(406) 444-0418
>dbartlett@state.mt.us
>
>
>-----Original Message-----
>From: abhay sachar [mailto:sachar_abhay@hotmail.com]
>Sent: Friday, November 12, 2004 3:02 PM
>To: sqr-users@sqrug.org
>Subject: RE: [sqr-users] SQR shows as Error
>
>
>Thanks guys but that didn't help either....
>
>This is what I have in the code -
>
>if #prcs_process_instance > 0
> do Update-Prcs-Run-Status
>end-if
>do Reset ! reset.sqc
>Do Successful-Eoj
>
>I can't use stdapi-init and stdapi-term as we do not have the stdapi.sqc
>
>available.
>
>This is what I have in the message log -
>
>1:49:06PM Process Request shows status of 'INITIATED' or 'PROCESSING'
>but
>no longer running
>1:49:12PM Published message with Pub ID of 20070 to request to have
>report
> added in folder GENERAL
>1:49:12PM Successfully posted generated files to the report repository
>
>Do I need to get the Process Scheduler server restarted?
>
>-Abhay.
>
>
> >From: "Larry Roux" <LRoux@syr.edu>
> >Reply-To: "This list is for discussion about the SQR database
> >reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
> >To: <sqr-users@sqrug.org>
> >Subject: RE: [sqr-users] SQR shows as Error
> >Date: Fri, 12 Nov 2004 16:51:30 -0500
> >
> >that calls stdapi-term. that procedure updates the run status in the
> >process scheduler tables. If you don't notify the process scheduler
> >that you are done via that call it will show an error since it doesn't
> >know if the SQR abended or if you just skipped the step to tell it when
> >the job finished.
> >
> >
> >
> >
> >Larry Roux
> >Syracuse University
> >lroux@syr.edu
> >
> >
> > >>> sachar_abhay@hotmail.com 11/12/2004 4:41:01 PM >>>
> >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_2435
>9\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?sitecod
>e=610|394
> >
> >Apply Now.
> >
> >
> >_______________________________________________
> >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
>
>_________________________________________________________________
>Instant personal loans. Celebrate this season with your family.
>http://acm.bridgeovertw.com/hdfc/pl/landingpage/sep04/index.htm?sitecode
>=611|395
>Apply.
>
>
>_______________________________________________
>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
_________________________________________________________________
Protect your PC! Call in the experts! http://www.msn.co.in/security/ Click
here now!
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users