Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> Software Development for Windows Vista >> Windows Workflow Foundation

Bug in SqlTrackingService

Is there anyone who uses the tracking service to track dynamicaly inserted activities? Because of the column limit of 2000 in the AddedActivity Table, an Deserialization Exception occurs when getting the WorkflowDefinition from the SqlTrackingWorkflowInstance if the serialized Activitiy has more then 2000 Characters. I have tried to extend the column to nvarchar(max) but this doesn't help.

Can anybody help me? (netfx RC1)

Thomas

[453 byte] By [TommyR] at [2007-12-24]
«« Change the number of fixed posts showiing at msdn.microsoft.com/xna
»» Virtual drives (iso games)
# 1

How big (string length) is the serialized form of the activity that you're adding? Could you trap the sql in SqlProfiler and post the serialized form of the activity in the call to stored proc InsertAddedActivity?

Thanks,
Joel West
MSFTE - SDE in WF runtime and hosting

This posting is provided "AS IS" with no warranties, and confers no rights

JoelWest at 2007-8-31 > top of Msdn Tech,Software Development for Windows Vista,Windows Workflow Foundation...
# 2

Joel,

The length is not deterministic because of dynamic information in the activity. I have adapted every occurance of nvarchar(2000) and changed it to nvarchar(max) in the Tables of the SqlTrackingStore Database and also the parameters in the stored procedures (including Partitioning) and now it works fine. I think you should change this in the scripts shipping with netfx.

Best regards,

Thomas

TommyR at 2007-8-31 > top of Msdn Tech,Software Development for Windows Vista,Windows Workflow Foundation...
Software Development for Windows Vista
Windows Workflow Foundation

Software Development for Windows Vista Hot Topic

Software Development for Windows Vista New Topic

Software Development for Windows Vista

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified