Topic
Symptoms

When upgrading from 5.6 to 5.7, there were errors logged during the execution of the script: webhooksScheduler.inject.sql
 

Script execute failed: System.Exception: Script execution exception: System.Data.SqlClient.SqlException (0x80131904): Error converting data type nvarchar to datetime.

Diagnosis:

• Execution of the script individually shows the error:

Msg:8114, Level 16, State 5, Procedure Eventbus.aUpdateSchedule, Line 0
Error converting data type nvarchar to datetime

Resolution

Labs has provided a new inject script for the error "Error converting data type nvarchar to datetime".
Please download it and follow the steps below:

1.Go to the location for the extracted K2 5.7 installer below:
Extracted Loc]\Nintex Automation (5.7) (5.0008.1000.0)\Installation\Apps\K2 blackpearl Server.zip\Data\SourceCode.Data.EventbusScheduler\SourceCode.Data.EventbusScheduler\Schema Objects\Schemas\EventBus\Scripts
2.Copy the script into the area and choose to copy and replace the current script.
3.Copy and replace the script from the drop location in step 2 if the WebhooksScheduler.inject.sql script exists in the below location:
Install Loc]\K2\Setup\Apps\K2 blackpearl Server.zip\Data\SourceCode.Data.EventbusScheduler\SourceCode.Data.EventbusScheduler\Schema Objects\Schemas\EventBus\Scripts
4.Rerun the installer with configure from the extracted location.