Error while using ExpandRecurrence function from production sql server

[shashidhar ch]

Hello all,
we are facing problem in production server when using ExpandReurrence_UDF. dll ,Telerik.Web.UI.RecurrenceEngine.dll and ExpandRecurrence funciton to get the recurrences from server.
we have referred below a site and followed the same procedure. 
http://blogs.telerik.com/TsvetomirTsonev/Posts/08-08-04/working_with_radscheduler_recurring_appointments_on_sql_server.aspx

then it is working fine in local database server which is sqlserver 2008 and OS windows server 2003.
but when we try to our clients prodcution server which is sqlserver 2008 and OS windows server 2007
we are getting blow issue,

A .NET Framework error occurred during execution of user-defined routine or aggregate "ExpandRecurrence":
System.NullReferenceException: Object reference not set to an instance of an object.
System.NullReferenceException:
   at Telerik.Web.UI.RecurrenceRule.TryParse(String input, RecurrenceRule& rrule)
   at UserDefinedFunctions.ExpandRecurrence(String recurrenceRule, SqlDateTime rangeStart, SqlDateTime rangeEnd)

Any suggestions would be highly appriciable,
Please help us it is very very urgent.

thnaks
Shashi

[Peter]

Hi shashidhar ch,

Please, make sure you have Enabled CLR Integration on the production server.


Kind regards,
Peter
the Telerik team

[shashidhar ch]

When I am using ExpandRecurrence function with SQL Server ( ExpandReurrence_UDF. dll )  i am not getting valid events  with weekly recurrence rule.other events are working fine. i have followed the below link
http://blogs.telerik.com/TsvetomirTsonev/Posts/08-08-04/working_with_radscheduler_recurring_appointments_on_sql_server.aspx

When i am  sending parameters like
 start date  = 12/2/2010  and 
 end date  = 12/2/2010 and
 Intervel = 2  and  weekday = FR,SA,SU
 Maxoccurrence = 6

it is giving wrong events. like  (
12/3/2010 (correct)
12/4/2010 (correct)
12/12/2010 (wrong)

12/17/2010 (correct)
12/18/2010 (correct)
12/26/2010 (wrong)

expected result :
12/3/2010
12/4/2010
12/5/2010

12/17/2010
12/18/2010
12/19/2010

Please help me in this issues.

Thanks & Regards
Shashi

[Peter]

Hello shashidhar,

Similar issue has been discussed in this forum thread -
http://www.telerik.com/community/forums/aspnet-ajax/scheduler/recurrencerule-and-timezoneoffset.aspx


All the best,
Peter
the Telerik team