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

["Lynds,Rick" <rlynds@mwdh2o.com>]

Denise,

I might try doing some things like...
1. Using -s and praying that something shows up on the log - especially the
generated SQL
2. Placing quotes around the table name (why that would become a problem, I
have NO idea)
3. Having a DBA check to see if there is activity on the database while it
is running.
4. Changing the number or rows (another one I can't see having an effect)

This seems weird - Good Luck!

Rick

-----Original Message-----
From: White, Denise [mailto:DEWhite@vicr.com]
Sent: Thursday, January 15, 2004 12: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