Precisely Speaking
May 21, 2012, 07:32:10 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: So what's news with you?  Tell us about it in "Getting To Know You"!
 
   Home   Help Calendar Login Register  
Pages: [1]   Go Down
  Print  
Author Topic: DDF.DEFN output & the scheduler  (Read 390 times)
DonQuixote
Rock Star
*****
Posts: 108


To Dream the Impossible Dream...


« on: August 09, 2011, 02:17:41 PM »

I have two GRIM processes that after selecting the data runs the Data Definition Tool.
They are exactly the same; except one uses the PRODUCT file and the other the NS.PRODUCT file.
I 'Scheduled' the reports in the Job Scheduler for 8:30pm. 
The scheduler says they run successfully but I only get output for the PRODUCT process and no output for the NS.PRODUCT. (yes, I gave the output different names).   
I make no entries in the GRIM selection criteria; so I should be selecting the entire file.
If I manually run the NS.PRODUCT process it works and if I 'schedule it' during the day while I am here it also works.
What great beast is destroying my nightly output?  How can I hunt what I cannot see.
Logged
Tom Pellitieri
Rock Star
*****
Posts: 171


Tom Pellitieri - Toledo, Ohio


« Reply #1 on: August 10, 2011, 06:26:24 AM »

Did you review the _PH_ entry for each job?  In Scheduler Inquiry (or Maintenance), locate the job and press F7-Last _PH_ to see the phantom output log.  The first lines will show you the entry, e.g.,

PH ID is u10171745_39292

You can view or edit the items in the _PH_ file once you know which one is associated with your job.
Logged
DonQuixote
Rock Star
*****
Posts: 108


To Dream the Impossible Dream...


« Reply #2 on: August 10, 2011, 07:46:58 AM »

Thank you for showing me the log!!!
As luck would have it, just as I was ready to give up ... it worked.
The only thing I did was change the output name from PPGNSPRODUCT to PPG_NS_PRODUCT. 
I cannot imagine calling something a windmill/ogre/giant makes any difference. lol.
My guess is somewhere there is code removing that particular name.  I have search in PROGS, DEVPROGS, USER-FORMS, DEVPROCESS, and even the dictionary of NS.PRODUCT. Where else should I be searching?
In my experience when programmers name there variables reserved words (or even close to it) unpredictable things happen;  but this is different.  I will keep my eye on the situation.
Logged
precisonline
President/Chief Technologist
Administrator
Rock Star
*****
Posts: 1532



WWW
« Reply #3 on: August 13, 2011, 04:26:31 PM »

So John did you determine that the output was really being deleted?
Logged

-Kevin
Accidents "happen"; success, however, is planned and executed.
Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.7 | SMF © 2006-2008, Simple Machines LLC Valid XHTML 1.0! Valid CSS!