upgrade from 2.6.3 to 3.0.1 windows sqlserver 2012

Added by Antonio Peta about 6 years ago

Problem with upgrade bitnami redmine-3.0.1-0 from bitnami-redmine 2.6.3 on windows server 2008 r2 and sqlserver 2012

In environment Windows 2008 and sqlsever 2012 redmine 2.6.3 works perfectly.... but the upgrade to version 3.0.1-0 redmine I get the following error:
  
Started POST "/ redmine / projects / pwf / issues" for 127.0.0.1 at 3/30/2015 13:22:12 +0200
Processing by IssuesController # created as HTML
  Parameters: {"utf8" => "✓" "authenticity_token"=>"xxxxxxxxxx", "Issue" => {"is_private" => "0", "tracker_id" => "15", "subject" => "ssss", "description" => "ssss", "status_id" => "1" , "priority_id" => "4", "assigned_to_id" => "84", "fixed_version_id" => "", "parent_issue_id" => "", "start_date" => "", "due_date" => "" , "estimated_hours" => "", "done_ratio" => "0", "custom_field_values" => {"1" => "ALL", "71" => "To be determined"}}, "was_default_status" => "1", "commit" => "Create", "project_id" => "pwf"}
  Current user: sist01 (id = 84)

TinyTds :: Error: Error converting data type nvarchar to datetime2 .: EXEC sp_executesql N'INSERT INTO [issues] ([project_id], [author_id], [tracker_id], [status_id] [subject] [description], [priority_id ], [assigned_to_id], [updated_on], [created_on]) OUTPUT INSERTED. [id] VALUES ( 0, 1, 2, 3 4 5 6 7 8 9) ', N' 0 int, int 1, 2 int, int 3, 4 nvarchar (255), 5 nvarchar (max), 6 int, int 7, 8 datetime2 , 9 datetime2 ', 0 = 67 = 84 1, 2 = 15, 3 = 1 4 = N'ssss', 5 = N'ssss', 6 = 4 7 = 84, 8 = N'2015-03-30 13:22:12 +0200 ', 9 = N'2015-03-30 13:22:12 +0200'
Completed 500 Internal Server Error in 118ms

ActiveRecord :: StatementInvalid (TinyTds :: Error: Error converting data type nvarchar to datetime2 .: EXEC sp_executesql N'INSERT INTO [issues] ([project_id], [author_id], [tracker_id], [status_id], [subject], [ description], [priority_id], [assigned_to_id], [updated_on], [created_on]) OUTPUT INSERTED. [id] VALUES ( 0, 1, 2, 3 4 5 6 7 , 8 9) ', N' 0 int, int 1, 2 int, int 3, 4 nvarchar (255), 5 nvarchar (max), 6 int, int 7, 8 datetime2, 9 datetime2 ', 0 = 67, 1 = 84, 2 = 15 , 3 = 1 4 = N'ssss', 5 = N'ssss', 6 = 4 7 = 84, 8 = N'2015-03-30 13:22:12 +0200 ', 9 = N'2015-03-30 13:22:12 +0200'):
  app / models / issue.rb: 174: in `create_or_update '
  app / controllers / issues_controller.rb: 141: in `created '

Can anyone help?
thanks

Replies (4)

RE: upgrade from 2.6.3 to 3.0.1 windows sqlserver 2012 - Added by Chris Dalley about 6 years ago

I have the same issue, I will keep an eye out for you, also.

RE: upgrade from 2.6.3 to 3.0.1 windows sqlserver 2012 - Added by Antonio Peta about 6 years ago

no no luck and no answer unfortunately.
at the time I stay with version 2.6.3 that works perfectly with sqlserver 2014 express

RE: upgrade from 2.6.3 to 3.0.1 windows sqlserver 2012 - Added by Chris Dalley about 6 years ago

Antonio Peta wrote:

no no luck and no answer unfortunately.
at the time I stay with version 2.6.3 that works perfectly with sqlserver 2014 express

I'm about to try upgrading 2.4 to 3.0.1 again :) Wish me luck.

(1-4/4)