[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-Fixed..Thanks
- Subject: RE: [sqr-users] SQR shows as Error-Fixed..Thanks
- From: "abhay sachar" <sachar_abhay@hotmail.com>
- Date: Sat, 13 Nov 2004 05:50:40 +0530
- Bcc:
- Delivery-date: Fri, 12 Nov 2004 19:24:16 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Thanks, guys.
There is similar processing happening, it's just that the procedure names
and sqc names are different here.
Thanks for the directions, though.
-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 18:45:25 -0500
>
>What they may do is update the tables themselves. Look for a variable
>being set (ie #RUN_STATUS) or something that states whether to consider
>the SQR and error or a success.
>
>Also, make sure you are getting the #prcs_process_instance variable
>set. That usually gets set in the stdapi-init procedure so they must
>have a comparable one they are using.
>
>
>
>This is what one of ours might look like:
>
>#include 'setenv.sqc' ! Set Environment Procedure
>#include 'setup01.sqc' ! Database Specific Setup
>
>begin-program
> Do Init-DateTime
> Do Get-Current-DateTime
> Do StdAPI-Init
> if $prcs_process_instance = ''
> input $prcs_oprid 'Enter Operator-Id '
> let $prcs_oprid = RTRIM(UPPER($prcs_oprid), ' ')
> input $prcs_run_cntl_id 'Enter Run Control-Id '
> let $prcs_run_cntl_id = RTRIM(UPPER($prcs_run_cntl_id), ' ')
> end-if
> show 'the code would go here'
> Do stdapi-term
>end-program
>
>#Include 'curdttim.sqc' !Get-Current-DateTime procedure
>#Include 'datetime.sqc' !Routines for date and time formatting
>#Include 'stdapi.sqc' !Update Process API
>
>
>
>
>Larry Roux
>Syracuse University
>lroux@syr.edu
>
>
> >>> sachar_abhay@hotmail.com 11/12/2004 6:13:35 PM >>>
>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
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users
_________________________________________________________________
Life on the fast track! Get hooked to it!
http://server1.msn.co.in/sp04/tataracing/ Meet the champs!
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users