[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:43:35 +0530
- Bcc:
- Delivery-date: Fri, 12 Nov 2004 18:15:07 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
I can't find stdapi.sqc and there are other sqrs running without it. Our
system is already live.
What they do have is this -
begin-procedure terminate
if #prcs_process_instance > 0
do Update-Prcs-Run-Status
end-if
do Reset
end-procedure
I know that stdapi-init and term are needed and we had it in the last client
I was working on.
But here, it's not there.
But like I mentioned, I do have this in code -
if #prcs_process_instance > 0
do Update-Prcs-Run-Status
end-if
do Reset ! reset.sqc
Do Successful-Eoj
And Larry, you had mentioned that Successful-Eoj calls stdapi-term.
Also, I am calling the other sqc
setenv.sqc
(code)
#include 'sqlerr.sqc'
#include 'curdttim.sqc' ! Current Date and Time
#include 'datetime.sqc' ! Routines for date and time formatting
#include 'number.sqc' ! Routines to format numbers
#include 'prcsapi.sqc' ! Update Process Request API
#include 'prcsdef.sqc' ! Update Process Request variable declaration
#include 'tranctrl.sqc' ! Transaction control
#Include 'reset.sqc' !Reset printer procedure
#Include 'Eoj.sqc'
!#Include 'stdapi.sqc' !Update Process API
And the SQR is doing all the updates and stuff...
See this from the trace - (show statements' output)
In Main
In Get-Inactive-Addr
In Get-Active-Addr
In Update-Customer
Rows Updated = 1.000000
Rows Updated in bo_cm_profl_dtl = 1.000000
Thanks,
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 17:54:01 -0500
>
>The key is the first error. That means that either the SQR bombed
>(which you have confirmed, I surmise), or that the process scheduler is
>not being updated.
>
>I would find out where your stdapi.sqc is and use that. If that SQC is
>missing you will have lots of other bombing processes, as almost every
>PS sqr calls it.
>
>
>
>
>Larry Roux
>Syracuse University
>lroux@syr.edu
>
>
> >>> sachar_abhay@hotmail.com 11/12/2004 5:01:44 PM >>>
>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_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
> >
> >_______________________________________________
> >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
_________________________________________________________________
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