LEGACY CONTENT
This article refers to legacy products, components or features. Therefore, the content in this article is offered "as is" and will no longer be updated. This content does not infer that the product, component or feature is supported, or that the product, component or feature will continue to function as described herein.

Introduction

In K2 Workspace, a ‘SqlDateTime overflow’ error occurs when trying to run a report on a ‘Workflow Reporting SmartObject’ process list method containing an empty DateTime data field. This occurs when the Initial value 'Is Empty Date' checkbox was checked when the process data field was created in K2 Designer for Visual Studio.

Error Scenario Steps

Note: The steps below describe one scenario under which this error may occur. The steps are simplified and not all steps will be shown or described.
  1. Create a process with one DateTime process data field.
  2. Check the Initial Value checkbox 'Is Empty Date' before saving.
  3. Select the SmartObject Association on the process.
  4. Check the 'Create Workflow Reporting SmartObjects' checkbox, and deploy the process.
  5. Start a process instance (do not change the empty data field value)
  6. Open K2 Workspace > Reports
  7. When creating the report on the ‘Data Source’ screen, select the Primary Data Source > Workflow Reports > Workflow Solutions > Process > Process Process Instances SmartObject
  8. Click next and add the desired properties as columns
  9. Save the project.
  10. When generating the report the "SqlDateTime overflow" error will display

Error Messages

The following error message relates to this issue:
  • SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

Error Resolution

This Hotfix is contained within the latest K2 blackpearl 0807 Update. Install the update package to resolve the error.
The latest K2 blackpearl 0807 Update is available as an independent installation package which can be found here: https://portal.k2.com/downloads/bp/default.aspx.