KB003608

Issue Description

After upgrading to K2 Five (5.3) April 2020 Cumulative Update, an error occurs when you execute the Activity Instance Destination SmartObject.

Error Message

The following error occurs: “SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM”

Resolution

The fix is available in the following K2 versions:

1. Ensure you have the correct K2 version and/or Cumulative Update installed. See KB001893 to see what Fix Pack level you have installed.
2. Download the latest Fix Pack using the links in the table above for the version you require.
3. Install the Fix Pack to apply the fix.

Considerations

This issue occurred due to changes made previously to improve the accuracy of the Activity Instance Destination SmartObject. After installing the Fix Pack, you now have the option to use the old behavior.

Follow these steps to make use of the old behavior:

1. Stop the K2 Host Server.
2. Execute the following query on the K2 database:

   DECLARE @XML NVARCHAR(MAX)

   DECLARE @GUID NVARCHAR(MAX)

   SELECT @GUID = [Guid] FROM [K2].[SmartBroker].[ServiceInstance] WHERE [name] = 'WorkflowReportingService'

   SET @XML = <service><key name="Behavior">pre-aidid</key> </service>'

   UPDATE [K2].[SmartBroker].[ServiceObject] SET [ServiceKeysXML] = @XML WHERE [ServiceInstanceGuid] = @GUID AND [Name] = 'ActivityInstanceDestination'

3. Start the K2 Host Server.
4. If you used the Activity Instance Destination SmartObject in a workflow, change the filter to use the Activity Display name instead of the Activity name and ensure the activities are executing as the K2 Service account.