Johnny's K2 Blog

Cool Things about the Publishing Event Wizard

johnny — Tue, 18 Nov 2008 04:27:00 GMT

Ever notice that this little wizard in K2 blackpearl could do quite a lot of things with the new Content Management features in MOSS 2007? [For the uninitiated, the features of the now defunct Content Management Server 2002 were merged into MOSS 2007...(read more)

Silverlight 2 and K2

johnny — Tue, 18 Nov 2008 02:58:00 GMT

Here's a good blog post by Scott Guthrie on Silverlight 2. The latest K2 Silverlight Web Designer in blackpoint is also featured in the post. Cool stuff. :) http://weblogs.asp.net/scottgu/archive/2008/11/16/update-on-silverlight-2-and-a-glimpse-of-silverlight-3.asp...(read more)

Finding Duplicate SPNs

johnny — Thu, 06 Nov 2008 03:37:00 GMT

Sam pointed out that Microsoft had a nifty little script which helped you to find duplicate SPNs. http://k2underground.com/forums/thread/27093.aspx This would be pretty useful for troubleshooting purposes when other people are messing around with your...(read more)

K2 Tips and Tricks (and Gotchas) in 0807

johnny — Tue, 14 Oct 2008 03:36:00 GMT

Here's a couple of tips and tricks (and warnings) in 0807 that I noted while using it over these few days. When opening a new or current K2 process, occasionally you might not see the Process/Activity Data and Workflow Context Browser panes in the K2...(read more)

0807 Re-released!

johnny — Thu, 09 Oct 2008 04:25:00 GMT

New version of K2 0807 has been re-released on the customer portal. New version is 4.8210.2.0. This version contains the following critical fixes. KB000301 - Error when using a K2 Process with a Document View Enabled KB000302 - The Event Instance Report...(read more)

0807 and InfoPath Client Event Template

johnny — Mon, 29 Sep 2008 16:17:00 GMT

As many of you may know, 0807 just got released last week and there's a whole bunch of snazzy stuff inside. However, take note that there is currently a known issue that can cause some problems for those working with Form Services. For a new 0807 process...(read more)

0807 RTM has been released!

johnny — Thu, 25 Sep 2008 03:13:00 GMT

Just to let everyone know that the new K2 blackpearl 0807 has been released on the customer portal . This is a milestone release as this includes a big bunch of performance and stability enhancements. New features are the Out-of-Office components and...(read more)

0807 Public Beta Released!

johnny — Wed, 03 Sep 2008 02:11:00 GMT

Just to let you know. The public beta for 0807 has hit the customer portal site ( http://portal.k2workflow.com ). So if you are marked as a beta user, you will be able to download and test drive this from the downloads section under beta components. If...(read more)

Difference in RepairError behavior in K2.net 2003 and K2 blackpearl

johnny — Tue, 19 Aug 2008 09:08:00 GMT

I saw this response from Blake ( http://k2underground.com/forums/thread/25502.aspx ) and I thought it interesting that the RepairError behaviour has changed. I did some research on this and I thought it would be nice to share out my findings on the key...(read more)

Quick Tip: How to connect a line back to the same activity

johnny — Thu, 31 Jul 2008 05:29:00 GMT

As most people would know, it's a pretty simple exercise in K2.net 2003 to draw a line back to the same activity. You just have to pick the "U" shaped line type and draw it directly. This is pretty useful for cases where you want to do ad-hoc approval...(read more)

Differences between "Plan just once" and "Plan per destination"

johnny — Sat, 26 Jul 2008 10:17:00 GMT

There are some of us who come from a K2.net 2003 background and we tend to bring the concepts of K2.net 2003 destination rules and Destination Queues along with us when we use K2 blackpearl. I was no exception to this.

However, while having a discussion with some of the labs guys on a feature request, I discovered my understanding of how slots and the various destination rule options work was totally wrong!

Yes, K2 blackpearl and K2.net 2003 destination rules work quite differently.

Take this example:

I have a client activity where I want to do a voting scenario. I want to route it to a pool of 5 users. I want my item to be approved when 2 of them approve it or 1 of them rejects it.

Now in K2.net 2003, you would set 5 users into your destination rules and set 2 slots in your activity. Now, when this activity instance is created; in the worklist table, you would see that 5 records in the worklist table will get created (i.e. one for each user). As soon as the first two users action on their workitems, the other 3 workitems in the other 3 user's worklist will get expired. Now, that isn't too efficient if the number of users increases in the destination pool. e.g. a call center can have maybe a 100 operators serving workitems. Of course in K2.net 2003, there is a way to work around it by using the optimization for the destination queues. This allows you to create a single entry in the worklist table for a destination queue. So in the worklist table, you would see that the item is assigned to the queue name instead of the user name. The item will be assigned at the point where the first user picks up the workitem.

Now in K2 blackpearl, if you have the same scenario. This varies depending on which option is being used in the client event options.

Plan Just Once - This option instantiates only one activity instance regardless of the number of slots.

So it would look something like this.

ActivityInstanceDest 1

|____ Slot 1

|____ Slot 2

Note that as there is only one activity instance, any events in the activity will only fire once regardless of the number of slots.

So you will note that you cannot:

Assign the destination user in the notification email.
You cannot get the User and Action Result properties from the ActivityInstanceDest object.

The whole reason here is that events and succeeding rule in the activity instance will only fire once. So the results of the users are actually stored in the slots collection. However, what is interesting is that there is intelligence in the succeeding rule logic. If you have your succeeding rules to complete if 2 or more slots approve or at least one slot rejects. The succeeding rule will fire as soon as 2 of the slots have Action Result = Approve or 1 slot has Action Result = Reject. Note that for the "Plan Just Once" option, the succeeding rule will always fire the SetSucceedingRuleTrue handler in the code for the Succeeding Rule. The SetSucceedingRuleFalse handler will never fire.

Plan Per Destination - This option instantiates one activity instance per slot.

So it would look something like this.

ActivityInstanceDest 1

|____ Slot 1

ActivityInstanceDest 2

|____ Slot 2

Note in this case, any events in the activity will only fire based on the number of instances (in this case it is 2). Also there is a one to one relationship between the ActInstDest and SlotInstance objects.

So you will note that destination user in the notification email functions as expected and the the User and Action Result properties from the ActivityInstanceDest object are populated as well.

So in the same example above, if you have your succeeding rules to complete if 2 or more slots approve or at least one slot rejects. If the first user approves, the succeeding rule will fire the first time. However, as the succeeding rule condition has not been met, the SetSucceedingRuleFalse handler will fire first. Now if a second user either approves or rejects, the succeeding rule will fire again. This time the SetSucceedingRuleTrue handler will fire.

Last Thoughts

Now after digesting all this, you can probably see that there is a performance benefit in K2 blackpearl when dealing with large number of users. For a destination rule pointing to a hundred users while working on a activity with 2 slots. Only two slot records get created versus 100 worklist records in K2.net 2003. User resolve their worklist at runtime and slots are assigned to users in real-time as well. Isn't this great? :)

0807 Early Impressions

johnny — Sat, 26 Jul 2008 09:47:00 GMT

[Updated 2 Sep 2008]

Been trying out the betas of 0807 and I must say there are a couple of pleasing changes from 0803.

K2 reports - improvement in performance overall due to moving the paging/filtering from the web server end to the database backend.
K2 Workspace

Archiving works seamlessly now. :)

Create a blank database in SQL Server Management Console
Go to the Archival node, specify the source database as K2ServerLog and the destination as the newly created DBs.
Specify the To and From dates and then run the Archival! It's that simple.

Permissions listing has been enhanced. Columns can now be sorted ascending or descending.
Enhanced dialog for adding user/group permissions
Workspace Node

Additional setting for the workspace to control the display items per page for users.

User Managers Node

Additional setting to specify the limit for the number of users returned for the URM service. Default is 100.
Additional place to add other trusted domains for users. -> No more fudging in the database.
Additional options in the UI to resolve nested groups and also other AD query related settings. -> No more fudging in the database.

K2 designer for Visual Studio

Much improved memory usage - I was able to create up a process with 100+ activities and memory consumption was slight above 600MB. Nice!
Wizards are also a lot zippier.

Out of Office feature is now in

The cool thing is that it uses the delegation feature. So the workitems can be seen on both your worklist and your delegate. You can even have a couple of people to be your delegate.
Out of office settings can be managed by users directly from the worklist or by the administrator from the management console. Very nice!

Installer has a number of improvements - The one I like is that it now creates the SPNs on the FQDN name of the K2 farm now. Nice!
K2.net 2003 Interopt (going RTM in 0807) - My colleague DC has been testing out a bit for a migration project and there were a couple of issues since Build 002. However, it's pretty cool that in Build 010 most of the stuff is now working (even for K2.net 2003 VB processes). You can edit the Interopt Activity wizards to change the destination rules and also edit the Destination Queues from the "K2.net 2003 Destination Queue Property Wizard" on the Process Wizard Strip on the top of the canvas (though the editing code only made it into Build 011).

There's probably a ton of other fixes and enhancements as well but these are the more noticeable improvements just from playing around with it for a few days.

Updating Batch Action/Outcome results back into InfoPath form

johnny — Mon, 21 Jul 2008 03:12:00 GMT

I got posed this question the other day and I thought this might be useful to share.

The scenario is that when do a batch selection or quick approval action from the worklist, the outcome is not recorded into the form's audit history. Of course, the process audit history will have it but in certain cases, the user does not have access to the process history information.

So if we wanted to store the outcome in the InfoPath form data, basically we have to update the value directly within the succeeding rules of the client activity.

Here's an example. Edit the code of your succeedin rule. You can get the final outcome by putting this snippet of code inside the succeeding rule. See portions in red. The text in green is the variables you need to change to your own form and namespace.

using System.Xml;

…

public void Main(Project_282cb15964ee4ab397715563ff6641a6.SucceedingRuleContext_369ef228d5e54527b7116b0583eabd22 K2)

{

if (SucceedingRuleHelper.AnyOutcomesEvaluatedSuccessfully(K2))

{

AllInfoPathTasksFinished(K2);

K2.SucceedingRule = true;

XmlDocument xmlDoc = new XmlDocument();

xmlDoc.LoadXml(K2.ProcessInstance.XmlFields["TestForm"].Value);

XmlNamespaceManager namespaceManager = new XmlNamespaceManager(xmlDoc.NameTable);

namespaceManager.AddNamespace("my", xmlDoc.DocumentElement.GetNamespaceOfPrefix("my"));

xmlDoc.SelectSingleNode("my:myFields/my:myDataField", namespaceManager).InnerText = K2.ActivityInstance.DataFields["Outcome"].Value.ToString();

K2.ProcessInstance.XmlFields["TestForm"].Value = xmlDoc.OuterXml;

}

else

{

InfoPathTaskFinished(K2);

K2.SucceedingRule = false;

}

Addendum:

If you are using the "Plan Just Once" option, you should note that there is only one Activity Instance created with 1 or more slots tied to it (See my article on this). So if you want to enumerate through the list of actions, here's a code snippet to do this.

for (int i = 0; i < K2.ActivityInstanceDestination.ActivityInstance.WorklistSlots.Count; i++)

{

Console.WriteLine("Action Result: " + K2.ActivityInstanceDestination.ActivityInstance.WorklistSlots[i].DataFields["Action Result"].Value.ToString());

Console.WriteLine("Destination User: " + K2.ActivityInstanceDestination.ActivityInstance.WorklistSlots[i].User.Name.ToString());

}

Upgrading from SP1 installation with non-standard paths to 0803

johnny — Thu, 17 Jul 2008 07:35:00 GMT

Tried this out with a customer over the past 2 days where we were trying to do an upgrade for a 2 node K2 server farm (K2 Host Server and Workspace together) with a SQL cluster backend.

Typically if the installation is done on a standard path configuration, it should go pretty smooth. However, the caveat here was that they installed SP1 on E: drive.

This causes the following issues:

After running the installer, the configuration manager does not start automatically.
If you try to run the configuration manager manually, the configuration manager thinks it is a new setup and will prompt you to install everything afresh.

To get around this, you need to do the following:

Modify the configuration.config file in E:\Program Files\K2 blackpearl\Configuration. Note the following connection string inside. You need to modify localhost to the correct database server name.

<add key="connectionString" value="server=localhost;database=hostserver;integrated security=sspi;" />

Re-run the configuration manager manually.
Now it will run the upgrade process instead of installing new databases.

Now there's one more issue here that you need to take note of. Due to the path issue, the upgrader doesn't run the SQL update scripts correctly. This means that after the configuration manager finishes, the K2 databases are still not upgraded. You can check the database version number from the K2Server database in the _Setting table. The version field should be 4.7285.1.0 (SP1).

At this point do not panic! There is a workaround to fix this by manually running the database upgrade scripts in the SQL Management Studio.

These scripts can be found in E:\Program Files\K2 blackpearl\Configuration\Script. However, you will need to do a bit of search and replace in some of these files before you can run them.

Make a copy of the following 6 files before modifying them.

HostServerAlter.sql - (with relevant placeholders replaced like)

[NETBIOSNAME]
[NETLDAP]

K2ServerAlter.sql
K2ServerLogAlter.sql
HostServerReconfigure.sql – (with relevant placeholders replaced like)

[NETBIOSNAME]
[NETLDAP]
[K2SQLUMDBSQLSERVER]
[K2SQLUMDBNAME]

K2Reconfigure.sql – (with relevant placeholders replaced like)

[LBHOSTSERVERNAME]
[HOSTSERVERPORT]
[ADMINUSER]
[USERSNAME]

K2LogReconfigure.sql

Note the subitems are the tags to be replaced. The values can be obtained from the HostServer database in the Configuration table.

One final point here. Before doing any upgrade, do a full backup of the servers and also the databases (shut down the K2 servers on both nodes before doing the backup).

This will give you the peace of mind that you can always roll back if something doesn't go right.

I hope this makes it easier for anybody trying to do an upgrade from SP1 to 0803 where they install in non-default paths.

Tip of the Day: Freeing up memory used in K2 Designer for Visual Studio

johnny — Thu, 29 May 2008 04:40:00 GMT

During the course of designing a process and running the designer for a while (I am using build 0803), you might find that your designer is taking up a lot of memory. Sometimes you would normally close and reopen the designer to start afresh.

However, note that you can try this trick where you can minimize the window and your devenv.exe process memory usage should drop dramatically. My process memory usage dropped from 200-300MB to 20MB.

Hope some of you will find this useful. Cheers!