RE: [sqr-users] Weird problem with load-lookup

["White, Denise" <DEWhite@vicr.com>]

Thanks Richard and Larry, the process scheduler had actually gone down when 
this problem first started, but it has since been restored and the job still 
would not run.  All other jobs, both scheduled and ad hoc, are running 
successfully on the process scheduler.  Also, that would not explain why the 
same thing happens with SQRW, since that does not use the process scheduler at 
all.  I should also say that I have the same problem whether running on the 
server or the client.

Denise M. White
Sr. Software Engineer
Vicor 
--__--__--

Message: 16
Date: Thu, 15 Jan 2004 15:52:32 -0500
From: "Larry Roux" <LRoux@syr.edu>
To: <sqr-users@sqrug.org>, <KnappR@umsystem.edu>
Subject: RE: [sqr-users] Weird problem with load-lookup
Reply-To: sqr-users@sqrug.org

Yes, I agree 100% with this one.  Either the process scheduler is stuck or not 
running.


******************************
Larry Roux
Syracuse University
lroux@syr.edu
*******************************

>>> KnappR@umsystem.edu 01/15/04 03:42PM >>>
The 'stuck in initiated' sounds like the process scheduler is not running. 

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu 


-----Original Message-----
From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On 
Behalf Of White, Denise
Sent: Thursday, January 15, 2004 2:13 PM
To: SQR Users Group (E-mail)
Subject: [sqr-users] Weird problem with load-lookup


Hi,

This makes no sense at all.  I have a program that has been running in 
production every weeknight since late October, and as of last Friday, it will 
no longer run.  I have managed to narrow the problem down to a load-lookup 
(when I remove the load-lookup, it runs successfully).  The job is run in 
PeopleSoft and retrieves data from ADP through a database link.

When the job is run from a PeopleSoft panel, it remains in Initiated status and 
never runs.  When I run it from SQRW, I get the icon for SQR in my task bar, 
but the DOS window never appears (it should appear with that message about 
hitting enter without entering anything that is standard for PSoft jobs and is 
generated by one of the copybooks).  Because of this, I am assuming that the 
job is failing to compile, and so never gets to the point where it starts to 
run.  I have made no modifications to the program recently.

I have confirmed that the database link to ADP works, and that I can do a 
regular begin-select of the same data using it and successfully display the 
data retrieved.  Does anyone have any idea why my load-lookup would suddenly 
fail to compile, when it has been doing so successfully for months?  Here is 
the code:

BEGIN-SETUP
#Include 'setup01a.sqc'
!  Load shift differentials from ADP database
   load-lookup
      name=shift_differential
      table=reports.v_employee@pay4win
      key=file#
      return_value=substr(datacontrol,4,1)
      rows=9999
      where='status in (''A'',''L'')'
END-SETUP

I guess I will have to give up and rewrite it using an array, since I find I 
can still select data with the database link, but I hate to admit defeat!

(SQR 4.3.2)

TIA!

Denise M. White
Sr. Software Engineer
Vicor 

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