Project

General

Profile

Actions

Defect #13986

closed

db:migrate on MSSQL 2012 fails with error

Added by Kyle Butler over 12 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Database
Target version:
-
Start date:
Due date:
2013-05-19
% Done:

0%

Estimated time:
Resolution:
Cant reproduce
Affected version:

Description

==  CreateJournals: migrating =================================================
-- create_table(:journals, {:force=>true})
   -> 0.2627s
   -> -1 rows
-- create_table(:journal_details, {:force=>true})
   -> 0.2675s
   -> -1 rows
-- add_index("journals", ["journalized_id", "journalized_type"], {:name=>"journals_journalized_id"})
   -> 0.1291s
   -> -1 rows
-- add_index("journal_details", ["journal_id"], {:name=>"journal_details_journal_id"})
   -> 0.1290s
   -> -1 rows
rake aborted!
An error has occurred, this and all later migrations canceled:

TinyTds::Error: Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier.: EXEC sp_executesql N'SELECT [issue_histories].* FROM [issue_histories]'/opt/redmine-2.3.1/db/migrate/007_create_journals.rb:31:in `up'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)

Actions #1

Updated by Daniel Felix over 12 years ago

Hi,

this seems to be a misconfiguration of your server.

Please take a look at: http://dirk.net/2010/09/18/sql-server-with-freetds-unicode-data-error/

I hope this helps. Can I close this issue for you, as this isn't Redmine related.

Best regards,
Daniel

Actions #2

Updated by Daniel Felix over 12 years ago

  • Due date set to 2013-05-19
  • Status changed from New to Needs feedback
Actions #3

Updated by Kyle Butler over 12 years ago

So does this step need to be modified then? I did exactly as it states.

http://www.redmine.org/projects/redmine/wiki/RedmineInstall#Step-3-Database-connection-configuration

There's no mention of the /etc/freetds/freetds.conf or the /etc/odbc.ini in the Redmine documentation I was following - does this supersede the database.yml, or does the connection info need to be in two separate places?

Actions #4

Updated by Go MAEDA over 5 years ago

  • Status changed from Needs feedback to Closed
  • Resolution set to Cant reproduce
Actions

Also available in: Atom PDF