[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: "Bartlett, Dwain" <dbartlett@state.mt.us>
- Date: Fri, 12 Nov 2004 15:36:16 -0700
- Delivery-date: Fri, 12 Nov 2004 17:37:24 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- Thread-index: AcTJBOAgWcxwBlGbSJK9igiNyrYFNQAAxZYQ
- Thread-topic: [sqr-users] SQR shows as Error
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