[emsg-dars] Re: DARS: SAPR queue has stalled.
- From: Keith Talbot <talbotk@xxxxxxxxxxxxxxxxx>
- To: emsg-dars@xxxxxxxxxxxxx
- Date: Fri, 05 Jan 2007 09:50:49 -0700
All,
The DARS real-time feed failed this morning. I have restarted it.
A RT-SAPR was requested for student S01389350 at 8:59. An empty file was
received from SIS. By manually re-requesting the SIS file, with no other
changes, a file arrived at 9:25. This time it had a single entry for the
degree program and nothing else.
This is a familiar, although infrequent pattern of events.
Should this occur again and I'm not around I have put two stored
procedures on the DARS server to do one of two things.
sis_real_redo - This will re-request any waiting real-time SAPR
requests. Often the data will arrive the second time.
sis_real_clear - This will set any waiting real-time SAPR requests as if
they had been completed. The data will not be updated.
The files arrive into this folder. \\DARS\C$\DARSREAL. A copy is always
placed in .\Received. For non-zero length files after processing the
file is placed in .\Completed.
Cheers
Keith
sqlserver@xxxxxxxxxxxxxxxxxx wrote:
The SAPR queue, SAPR_STATUS, on server DARS, has pending real-time records over
5 minutes old. The real-time process may have stalled.
----------------------------------------------------------------------
You are currently subscribed to receive system alert messages sent to
the EMSG DARS list.
You can send email to the list using the address:
emsg-dars@xxxxxxxxxxxxx
You can unsubscribe from the list using the address:
emsg-dars-request@xxxxxxxxxxxxx with 'unsubscribe' in the subject.
If you need assistance, contact the list owners at:
emsg-dars-moderators@xxxxxxxxxxxxx
--
Keith Talbot - 626-4955 - Enrollment Management Systems Group
1618 E Helen St, PO Box 210409, Tucson AZ 85721-0409
---------------------------------------------------------------
Keith's guide to British English -> Jumper = Sweater ("jersey",
"pullover" & "cardigan" are some of the many words for sweater)
---------------------------------------------------------------
----------------------------------------------------------------------
You are currently subscribed to receive system alert messages sent to
the EMSG DARS list.
You can send email to the list using the address:
emsg-dars@xxxxxxxxxxxxx
You can unsubscribe from the list using the address:
emsg-dars-request@xxxxxxxxxxxxx with 'unsubscribe' in the subject.
If you need assistance, contact the list owners at:
emsg-dars-moderators@xxxxxxxxxxxxx
Other related posts:
