Clearing Spool Jobs from a Red (Halted) Spooler - ChemStore by vaj19048


									                Clearing Spool Jobs from a Red (Halted) Spooler
                                 ChemStore G2181BA, Revision B.01.03

During the normal operation of ChemStore, the spooler that transfers data from the ChemStation
software to the ChemStore database can be halted by various errors and circumstances. In these
situations, the spooler icon in the system tray on the client turns red, and spool jobs accumulate in the
spool queue.

This document is intended to describe how to clear the spool queue of multiple jobs, while
maintaining data integrity and regulatory compliance.

First Step: Attempt to Resume the Spooler

1) Log into Windows (NT or 2000) as an administrator. This can be either a local or domain

2) Double-click on the spooler icon in the system tray (in the lower right-hand corner of the screen,
   next to the time). It looks like this:

3) You should now see a panel that looks like this:

 This document is believed to be accurate and up-to-date. However, Agilent Technologies, Inc. cannot assume responsibility for the use of this material.
         The information contained herein is intended for use by informed individuals who can and must determine its fitness for their purpose.

  a05319.doc                                           http://                                                      Page 1 of 4
4) In the ChemStore Spooler panel, click the Resume button. The spooler color should change to
   blue as the job is attempted. If the spooler completes this job, continue to observe the spooler to
   see if all the jobs spool properly. If the spooler color becomes red after being blue for a brief
   period, then there is a persistent error that is preventing the transfer.

5) Click on the Error… button, and observe the spooler error. There are a wide variety of errors that
   can be documented here. They generally fall into three classes: Connectivity, configuration, and
   wrong/missing data. We cannot effectively cover how to deal with these problems here, except to
   say that the general approach to troubleshooting for each of these classes is unique to the class.

   ♦ Connectivity errors (e.g. – Cannot connect to database!) are caused by network or operating
   system interruptions that disallow the spooler connection to the database. Administrative
   personnel must solve these problems within the network or operating system environment before
   the spooler can be successfully resumed.

   ♦ Configuration errors are usually related to initial installation or major system modification, such
   as upgrades or re-installation. Administrative personnel must also resolve these issues before the
   spooler can be successfully resumed.

   ♦ Wrong or missing data errors are related to contents of the spooled data. In many cases, the
   data may have to be re-processed, missing information included (e.g. custom field contents), or
   contents of spool files recovered from the encrypted data. However, the spooler can not be
   resumed unless the offending data is first cleared from the spooler. This can be done by anyone
   with administrative privileges on the NT file system on the client computer and ChemStore.

Second Step: Clearing Error-prone Spool Jobs

  a05319.doc                         http://                            Page 2 of 4
1) If you do not already have it displayed, open the spooler by clicking on the spooler icon in the
   system tray. You should have a panel that looks like this:

2) Note the name of the first job in the queue.

3) Bring up Windows Explorer: Right click on the Start button, and select Explore.

4) In the left-hand panel of the Explorer window, navigate to the \HPCHEM\CHEMSTOR\SPOOL
   folder, and open it by clicking on that folder.

5) In the right-hand panel of Explorer, find the folder which has the same name as the first job in the
   queue (noted above).

6) Create a copy of this folder by right-clicking on the folder, and selecting Copy.

7) In the left-hand panel of Explorer, right-click on the \HPCHEM\CHEMSTOR\TEMP folder, and
   select Paste. You have now created a backup copy of the data contained in the first spool job.

8) In the Spooler panel, highlight the first spool job, and click the Delete Job(s) button.
9) Attempt to resume the spooler by clicking the Resume button. The spooler color should turn blue
   while the spooler attempts to spool the second job.

10) If this is successful, allow it to continue. If it halts again, repeat steps 2 through 9 for the next
    spool job. Eventually, you will clear the entire spool queue in this fashion.

Third Step: What to Do with the Spool Jobs that Were Unsuccessful

  a05319.doc                            http://                               Page 3 of 4
The spool folders you now have placed into the \HPCHEM\CHEMSTOR\TEMP folder may or may not
have any value. By examining the contents of these folders, you should be able to determine the
data to which they are related. The subfolder names often contain method and data file names from
your analytical work. Date and time stamps can be used to further confirm the origin of these files.

Once the origin of the incomplete spool jobs has been determined, check whether the data to which
these files relate still resides on the client (usually in the data folders of the instrument on which they
were run, e.g. – C:\HPCHEM\1\DATA). If so, this data can be re-processed (taking into account the
errors that prevented it from spooling in the first place). If this is successful, then the related spool
folder in the \HPCHEM\CHEMSTOR\TEMP folder can be deleted.

If the original data does not reside on the client, then the ChemStore database should be queried to
determine if the data is already in the database. If it is, then the data can be reprocessed after
downloading it from the database.

In the rare case that the data does not exist on either the client or in the database, it may be
contained in the spool folder which is saved in the \HPCHEM\CHEMSTOR\TEMP folder. If this is the
case, please contact the Agilent Customer Assistance Center at 1-800-227-9770 for further

  a05319.doc                           http://                              Page 4 of 4

To top