Home : LABCAL_GENONCEADAY Facility Setting
Q14294 - INFO: LABCAL_GENONCEADAY Facility Setting

LABCAL_GENONCEADAY Facility Setting instructs Lab Cal to generate new Samples only once per day.  Setting should be used in situations where users have a large number of samples which causes the calendar to take a long time to display. 

With this setting on, the first user to start Lab Cal (i.e. go to Data Manager, Lab Cal) on a day will generate any samples that need to be placed on the calendar.  Subsequent users that start Lab Cal on that day will not generate samples (greatly reduces load time). 

To set Lab Cal to only generate samples once per day:

Use SQL Console and execute the following statement to add the flag to the Facility's Settings table. 

  • SQL Server: INSERT INTO Settings Values ('SUPER',GETDATE(),'LABCAL_GENONCEADAY','12312014')
  • Oracle: INSERT INTO Settings Values ('SUPER',SYSDATE,'LABCAL_GENONCEADAY','12312014')


  • Users should also check the number of off calendar open samples.  Lab Cal anayzes all open samples when loading the calendar (whether they fall in the date range of the calendar or not) to update the Sample Status (Pending, Received, Analyzed...).  Old Samples should be closed.  On the Lab Cal Calendar check the Old Samples button for a count.   
  • The date of the last Sample Generation is stored as a string in the SETTINGS table.  The format of the date must be mmddyyyy and optionally can contain the hh:mm:ss.  Example:

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?


Tell us why you rated the content this way. (optional)
Approved Comments...
No user comments available for this article.
Created on 1/9/2015 4:06 PM.
Last Modified on 3/25/2015 8:24 AM.
Last Modified by Scott Dorner.
Article has been viewed 1472 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article