Groups | Blog | Home
all groups > sql server notification services > may 2005 >

sql server notification services : The generator failed to schedule a quantum.


Balaji Ramachandran
5/9/2005 2:58:05 AM
Hi,

As the quantum clock was far behind the realtime clock, i tried to sync them
using the following statements

exec NSUpdateGeneratorActivationState 3
go
--setting the quantumtime to realtime clock
exec NSSetQuantumClockDate '2005-05-09 15:14:28.547' --getdate()
go
exec NSUpdateGeneratorActivationState 3

When I schedule a notification, I am getting the following error in the
event log.
How do I resolve this?


Event Type: Error
Event Source: NotificationServices
Event Category: None
Event ID: 4020
Date: 5/9/2005
Time: 3:14:19 PM
User: N/A
Computer: BILLPAY-BALAJI
Description:
<NotificationServicesEvent>
<Description>
The generator failed to schedule a quantum.
</Description>
<Context>
<EventParameters>
<ApplicationName>Spider</ApplicationName>
</EventParameters>

<SqlServerError>
Source: .Net SqlClient Data Provider
Number: 50000
State: 1
Class: 16
Server:
Message: 4016: The quantum end time is later than the current real clock
time. Notification Services cannot process events that occur in the future.
Procedure: NSScheduleQuantum1
Line Number: 151
</SqlServerError>

</Context>
<Description>
4016: The quantum end time is later than the current real clock time.
Notification Services cannot process events that occur in the future.
</Description>
<Instance>SpiderInstance</Instance>
<ApplicationName>Spider</ApplicationName>
<Component>Generator</Component>
<Thread>17</Thread>
</NotificationServicesEvent>

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.





Shyam Pather [MSFT]
5/9/2005 12:53:11 PM
Balaji,
Quantum clock time (as well as all other times) in the NS databases are
represented in UTC. You have set yours to local-time, which, after you apply
the UTC conversion, is in the future. You need to set your clock to the
current UTC time - GETUTCDATE() will give you this.

Also, you should not call this internal NSUpdateGeneratorActivationState
procedures directly. Use nscontrol disable instead.
Thanks
-shyam

--
Learn more about SQL-NS:
http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/
---------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
---------------------------------------------
[quoted text, click to view]

AddThis Social Bookmark Button