Failed to configure database. Violation of PRIMARY KEY constraint. Cannot insert duplicate key in object 'Culture'.

Products

• IT Management Suite

Issue/Introduction

Failed to configure database when running the NS Setup Wizard to create a new database.

Violation of PRIMARY KEY constraint. Cannot insert duplicate key in object 'Culture'.

Priority: 1

Date: 3/13/2009 1:43:25 PM

Tick Count: 3321515

Host Name: ************

Process: aexsvc.exe (1240)

Thread ID: 3248

Module: AltirisNativeHelper.dll

Source: Altiris.NS.ItemManagement.ItemHelper

Description: System.Data.SqlClient.SqlException caught in ImportSqlNodes. Reason: System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK__Culture__7A672E12'. Cannot insert duplicate key in object 'Culture'.

The statement has been terminated.

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at Altiris.NS.ItemManagement.ItemHelper.ImportSqlNodes(XmlNodeList nodes). SQL:

set nocount on

insert into Culture values ('ar','','Arabic', '1', '1', '0')

insert into Culture values ('ar-SA','ar','Arabic (Saudi Arabia)', '1025', '1', '1')

insert into Culture values ('ar-IQ','ar','Arabic (Iraq)', '2049', '1', '2')

insert into Culture values ('ar-EG','ar','Arabic (Egypt)', '3073', '1', '3')

insert into Culture values ('ar-LY','ar','Arabic (Libya)', '4097', '1', '4')

insert into Culture values ('ar-DZ','ar','Arabic (Algeria)', '5121', '1', '5')

insert into Culture values ('ar-MA','ar','Arabic (Morocco)', '6145', '1', '6')

insert into Culture values ('ar-TN','ar','Arabic (Tunisia)', '7169', '1', '7')

insert into Culture values ('ar-OM','ar','Arabic (Oman)', '8193', '1', '8')

insert into Culture values ('ar-YE','ar','Arabic (Yemen)', '9217', '1', '9')

insert into Culture values ('ar-SY','ar','Arabic (Syria)', '10241', '1', '10')

insert into Culture values ('ar-JO','ar','Arabic (Jordan)', '11265', '1', '11')

insert into Culture values ('ar-LB','ar','Arabic (Lebanon)', '12289', '1', '12')

insert into Culture values ('ar-KW','ar','Arabic (Kuwait)', '13313', '1', '13')

insert into Culture values ('ar-AE','ar','Arabic (U.A.E.)', '14337', '1', '14')

insert into Culture values ('ar-BH','ar','Arabic (Bahrain)', '15361', '1', '15')

insert into Culture values ('ar-QA','ar','Arabic (Qatar)', '16385', '1', '16')

insert into Culture values ('bg','','Bulgarian', '2', '2', '0')

insert into Culture values ('bg-BG','bg','Bulgarian (Bulgaria)', '1026', '2', '1')

insert into Culture values ('ca','','Catalan', '3', '3', '0')

insert into Culture values ('ca-ES','ca','Catalan (Catalan)', '1027', '3', '1')

insert into Culture values ('zh-CHS','','Chinese (Simplified)', '4', '4', '0')

insert into Culture values ('zh-TW','zh-CHT','Chinese (Taiwan)', '1028', '4', '1')

insert into Culture values ('zh-CN','zh-CHS','Chinese (People''s Republic of China)', '2052', '4', '2')

insert into Culture values ('zh-HK','zh-CHT','Chinese (Hong Kong S.A.R.)', '3076', '4', '3')

insert into Culture values ('zh-SG','zh-CHS','Chinese (Singapore)', '4100', '4', '4')

insert into Culture values ('zh-MO','zh-CHS','Chinese (Macau S.A.R.)', '5124', '4', '5')

insert into Culture values ('zh-CHT','','Chinese (Traditional)', '31748', '4', '31')

insert into Culture values ('cs','','Czech', '5', '5', '0')

insert into Culture values ('cs-CZ','cs','Czech (Czech Republic)', '1029', '5', '1')

insert into Culture values ('da','','Danish', '6', '6', '0')

insert into Culture values ('da-DK','da','Danish (Denmark)', '1030', '6', '1')

insert into Culture values ('de','','German', '7', '7', '0')

insert into Culture values ('de-DE','de','German (Germany)', '1031', '7', '1')

insert into Culture values ('de-CH','de','German (Switzerland)', '2055', '7', '2')

insert into Culture values ('de-AT','de','German (Austria)', '3079', '7', '3')

insert into Culture values ('de-LU','de','German (Luxembourg)', '4103', '7', '4')

insert into Culture values ('de-LI','de','German (Liechtenstein)', '5127', '7', '5')

insert into Culture values ('el','','Greek', '8', '8', '0')

insert into Culture values ('el-GR','el','Greek (Greece)', '1032', '8', '1')

insert into Culture values ('en','','English', '9', '9', '0')

insert into Culture values ('en-US','en','English (United States)', '1033', '9', '1')

insert into Culture values ('en-GB','en','English (United Kingdom)', '2057', '9', '2')

insert into Culture values ('en-AU','en','English (Australia)', '3081', '9', '3')

insert into Culture values ('en-CA','en','English (Canada)', '4105', '9', '4')

insert into Culture values ('en-NZ','en','English (New Zealand)', '5129', '9', '5')

insert into Culture values ('en-IE','en','English (Ireland)', '6153', '9', '6')

insert into Culture values ('en-ZA','en','English (South Africa)', '7177', '9', '7')

insert into Culture values ('en-JM','en','English (Jamaica)', '8201', '9', '8')

insert into Culture values ('en-CB','en','English (Caribbean)', '9225', '9', '9')

insert into Culture values ('en-BZ','en','English (Belize)', '10249', '9', '10')

insert into Culture values ('en-TT','en','English (Trinidad and Tobago)', '11273', '9', '11')

insert into Culture values ('en-ZW','en','English (Zimbabwe)', '12297', '9', '12')

insert into Culture values ('en-PH','en','English (Republic of the Philippines)', '13321', '9', '13')

insert into Culture values ('es','','Spanish', '10', '10', '0')

insert into Culture values ('es-MX','es','Spanish (Mexico)', '2058', '10', '2')

insert into Culture values ('es-ES','es','Spanish (Spain)', '3082', '10', '3')

insert into Culture values ('es-GT','es','Spanish (Guatemala)', '4106', '10', '4')

insert into Culture values ('es-CR','es','Spanish (Costa Rica)', '5130', '10', '5')

insert into Culture values ('es-PA','es','Spanish (Panama)', '6154', '10', '6')

insert into Culture values ('es-DO','es','Spanish (Dominican Republic)', '7178', '10', '7')

insert into Culture values ('es-VE','es','Spanish (Venezuela)', '8202', '10', '8')

insert into Culture values ('es-CO','es','Spanish (Colombia)', '9226', '10', '9')

insert into Culture values ('es-PE','es','Spanish (Peru)', '10250', '10', '10')

insert into Culture values ('es-AR','es','Spanish (Argentina)', '11274', '10', '11')

insert into Culture values ('es-EC','es','Spanish (Ecuador)', '12298', '10', '12')

insert into Culture values ('es-CL','es','Spanish (Chile)', '13322', '10', '13')

insert into Culture values ('es-UY','es','Spanish (Uruguay)', '14346', '10', '14')

insert into Culture values ('es-PY','es','Spanish (Paraguay)', '15370', '10', '15')

insert into Culture values ('es-BO','es','Spanish (Bolivia)', '16394', '10', '16')

insert into Culture values ('es-SV','es','Spanish (El Salvador)', '17418', '10', '17')

insert into Culture values ('es-HN','es','Spanish (Honduras)', '18442', '10', '18')

insert into Culture values ('es-NI','es','Spanish (Nicaragua)', '19466', '10', '19')

insert into Culture values ('es-PR','es','Spanish (Puerto Rico)', '20490', '10', '20')

insert into Culture values ('fi','','Finnish', '11', '11', '0')

insert into Culture values ('fi-FI','fi','Finnish (Finland)', '1035', '11', '1')

insert into Culture values ('fr','','French', '12', '12', '0')

insert into Culture values ('fr-FR','fr','French (France)', '1036', '12', '1')

insert into Culture values ('fr-BE','fr','French (Belgium)', '2060', '12', '2')

insert into Culture values ('fr-CA','fr','French (Canada)', '3084', '12', '3')

insert into Culture values ('fr-CH','fr','French (Switzerland)', '4108', '12', '4')

insert into Culture values ('fr-LU','fr','French (Luxembourg)', '5132', '12', '5')

insert into Culture values ('fr-MC','fr','French (Principality of Monaco)', '6156', '12', '6')

insert into Culture values ('he','','Hebrew', '13', '13', '0')

insert into Culture values ('he-IL','he','Hebrew (Israel)', '1037', '13', '1')

insert into Culture values ('hu','','Hungarian', '14', '14', '0')

insert into Culture values ('hu-HU','hu','Hungarian (Hungary)', '1038', '14', '1')

insert into Culture values ('is','','Icelandic', '15', '15', '0')

insert into Culture values ('is-IS','is','Icelandic (Iceland)', '1039', '15', '1')

insert into Culture values ('it','','Italian', '16', '16', '0')

insert into Culture values ('it-IT','it','Italian (Italy)', '1040', '16', '1')

insert into Culture values ('it-CH','it','Italian (Switzerland)', '2064', '16', '2')

insert into Culture values ('ja','','Japanese', '17', '17', '0')

insert into Culture values ('ja-JP','ja','Japanese (Japan)', '1041', '17', '1')

insert into Culture values ('ko','','Korean', '18', '18', '0')

insert into Culture values ('ko-KR','ko','Korean (Korea)', '1042', '18', '1')

insert into Culture values ('nl','','Dutch', '19', '19', '0')

insert into Culture values ('nl-NL','nl','Dutch (Netherlands)', '1043', '19', '1')

insert into Culture values ('nl-BE','nl','Dutch (Belgium)', '2067', '19', '2')

insert into Culture values ('no','','Norwegian', '20', '20', '0')

insert into Culture values ('nb-NO','no','Norwegian (Bokml) (Norway)', '1044', '20', '1')

insert into Culture values ('nn-NO','no','Norwegian (Nynorsk) (Norway)', '2068', '20', '2')

insert into Culture values ('pl','','Polish', '21', '21', '0')

insert into Culture values ('pl-PL','pl','Polish (Poland)', '1045', '21', '1')

insert into Culture values ('pt','','Portuguese', '22', '22', '0')

insert into Culture values ('pt-BR','pt','Portuguese (Brazil)', '1046', '22', '1')

insert into Culture values ('pt-PT','pt','Portuguese (Portugal)', '2070', '22', '2')

insert into Culture values ('ro','','Romanian', '24', '24', '0')

insert into Culture values ('ro-RO','ro','Romanian (Romania)', '1048', '24', '1')

insert into Culture values ('ru','','Russian', '25', '25', '0')

insert into Culture values ('ru-RU','ru','Russian (Russia)', '1049', '25', '1')

insert into Culture values ('hr','','Croatian', '26', '26', '0')

insert into Culture values ('hr-HR','hr','Croatian (Croatia)', '1050', '26', '1')

insert into Culture values ('sr-SP-Latn','hr','Serbian (Latin) (Serbia)', '2074', '26', '2')

insert into Culture values ('sr-SP-Cyrl','hr','Serbian (Cyrillic) (Serbia)', '3098', '26', '3')

insert into Culture values ('sk','','Slovak', '27', '27', '0')

insert into Culture values ('sk-SK','sk','Slovak (Slovakia)', '1051', '27', '1')

insert into Culture values ('sq','','Albanian', '28', '28', '0')

insert into Culture values ('sq-AL','sq','Albanian (Albania)', '1052', '28', '1')

insert into Culture values ('sv','','Swedish', '29', '29', '0')

insert into Culture values ('sv-SE','sv','Swedish (Sweden)', '1053', '29', '1')

insert into Culture values ('sv-FI','sv','Swedish (Finland)', '2077', '29', '2')

insert into Culture values ('th','','Thai', '30', '30', '0')

insert into Culture values ('th-TH','th','Thai (Thailand)', '1054', '30', '1')

insert into Culture values ('tr','','Turkish', '31', '31', '0')

insert into Culture values ('tr-TR','tr','Turkish (Turkey)', '1055', '31', '1')

insert into Culture values ('ur','','Urdu', '32', '32', '0')

insert into Culture values ('ur-PK','ur','Urdu (Islamic Republic of Pakistan)', '1056', '32', '1')

insert into Culture values ('id','','Indonesian', '33', '33', '0')

insert into Culture values ('id-ID','id','Indonesian (Indonesia)', '1057', '33', '1')

insert into Culture values ('uk','','Ukrainian', '34', '34', '0')

insert into Culture values ('uk-UA','uk','Ukrainian (Ukraine)', '1058', '34', '1')

insert into Culture values ('be','','Belarusian', '35', '35', '0')

insert into Culture values ('be-BY','be','Belarusian (Belarus)', '1059', '35', '1')

insert into Culture values ('sl','','Slovenian', '36', '36', '0')

insert into Culture values ('sl-SI','sl','Slovenian (Slovenia)', '1060', '36', '1')

insert into Culture values ('et','','Estonian', '37', '37', '0')

insert into Culture values ('et-EE','et','Estonian (Estonia)', '1061', '37', '1')

insert into Culture values ('lv','','Latvian', '38', '38', '0')

insert into Culture values ('lv-LV','lv','Latvian (Latvia)', '1062', '38', '1')

insert into Culture values ('lt','','Lithuanian', '39', '39', '0')

insert into Culture values ('lt-LT','lt','Lithuanian (Lithuania)', '1063', '39', '1')

insert into Culture values ('fa','','Farsi', '41', '41', '0')

insert into Culture values ('fa-IR','fa','Farsi (Iran)', '1065', '41', '1')

insert into Culture values ('vi','','Vietnamese', '42', '42', '0')

insert into Culture values ('vi-VN','vi','Vietnamese (Viet Nam)', '1066', '42', '1')

insert into Culture values ('hy','','Armenian', '43', '43', '0')

insert into Culture values ('hy-AM','hy','Armenian (Armenia)', '1067', '43', '1')

insert into Culture values ('az','','Azeri', '44', '44', '0')

insert into Culture values ('az-AZ-Latn','az','Azeri (Latin) (Azerbaijan)', '1068', '44', '1')

insert into Culture values ('az-AZ-Cyrl','az','Azeri (Cyrillic) (Azerbaijan)', '2092', '44', '2')

insert into Culture values ('eu','','Basque', '45', '45', '0')

insert into Culture values ('eu-ES','eu','Basque (Basque)', '1069', '45', '1')

insert into Culture values ('mk','','FYRO Macedonian', '47', '47', '0')

insert into Culture values ('mk-MK','mk','FYRO Macedonian (Former Yugoslav Republic of Macedonia)', '1071', '47', '1')

insert into Culture values ('af','','Afrikaans', '54', '54', '0')

insert into Culture values ('af-ZA','af','Afrikaans (South Africa)', '1078', '54', '1')

insert into Culture values ('ka','','Georgian', '55', '55', '0')

insert into Culture values ('ka-GE','ka','Georgian (Georgia)', '1079', '55', '1')

insert into Culture values ('fo','','Faroese', '56', '56', '0')

insert into Culture values ('fo-FO','fo','Faroese (Faroe Islands)', '1080', '56', '1')

insert into Culture values ('hi','','Hindi', '57', '57', '0')

insert into Culture values ('hi-IN','hi','Hindi (India)', '1081', '57', '1')

insert into Culture values ('ms','','Malay', '62', '62', '0')

insert into Culture values ('ms-MY','ms','Malay (Malaysia)', '1086', '62', '1')

insert into Culture values ('ms-BN','ms','Malay (Brunei Darussalam)', '2110', '62', '2')

insert into Culture values ('kk','','Kazakh', '63', '63', '0')

insert into Culture values ('kk-KZ','kk','Kazakh (Kazakhstan)', '1087', '63', '1')

insert into Culture values ('ky','','Kyrgyz', '64', '64', '0')

insert into Culture values ('ky-KZ','ky','Kyrgyz (Kyrgyzstan)', '1088', '64', '1')

insert into Culture values ('sw','','Swahili', '65', '65', '0')

insert into Culture values ('sw-KE','sw','Swahili (Kenya)', '1089', '65', '1')

insert into Culture values ('uz','','Uzbek', '67', '67', '0')

insert into Culture values ('uz-UZ-Latn','uz','Uzbek (Latin) (Uzbekistan)', '1091', '67', '1')

insert into Culture values ('uz-UZ-Cyrl','uz','Uzbek (Cyrillic) (Uzbekistan)', '2115', '67', '2')

insert into Culture values ('tt','','Tatar', '68', '68', '0')

insert into Culture values ('tt-RU','tt','Tatar (Russia)', '1092', '68', '1')

insert into Culture values ('pa','','Punjabi', '70', '70', '0')

insert into Culture values ('pa-IN','pa','Punjabi (India)', '1094', '70', '1')

insert into Culture values ('gu','','Gujarati', '71', '71', '0')

insert into Culture values ('gu-IN','gu','Gujarati (India)', '1095', '71', '1')

insert into Culture values ('ta','','Tamil', '73', '73', '0')

insert into Culture values ('ta-IN','ta','Tamil (India)', '1097', '73', '1')

insert into Culture values ('te','','Telugu', '74', '74', '0')

insert into Culture values ('te-IN','te','Telugu (India)', '1098', '74', '1')

insert into Culture values ('kn','','Kannada', '75', '75', '0')

insert into Culture values ('kn-IN','kn','Kannada (India)', '1099', '75', '1')

insert into Culture values ('mr','','Marathi', '78', '78', '0')

insert into Culture values ('mr-IN','mr','Marathi (India)', '1102', '78', '1')

insert into Culture values ('sa','','Sanskrit', '79', '79', '0')

insert into Culture values ('sa-IN','sa','Sanskrit (India)', '1103', '79', '1')

insert into Culture values ('mn','','Mongolian', '80', '80', '0')

insert into Culture values ('mn-MN','mn','Mongolian (Mongolia)', '1104', '80', '1')

insert into Culture values ('gl','','Galician', '86', '86', '0')

insert into Culture values ('gl-ES','gl','Galician (Galician)', '1110', '86', '1')

insert into Culture values ('kok','','Konkani', '87', '87', '0')

insert into Culture values ('kok-IN','kok','Konkani (India)', '1111', '87', '1')

insert into Culture values ('syr','','Syriac', '90', '90', '0')

insert into Culture values ('syr-SY','syr','Syriac (Syria)', '1114', '90', '1')

insert into Culture values ('div','','Divehi', '101', '101', '0')

insert into Culture values ('div-MV','div','Divehi (Maldives)', '1125', '101', '1')

insert into Culture values ('','','Invariant Language (Invariant Country)', '127', '127', '0')

set nocount off

 

 

 

if (object_id('dbo.trgUpdateCulture') is not null) and

(objectproperty(object_id('dbo.trgUpdateCulture'), 'IsTrigger') = 1)

drop trigger trgUpdateCulture

 

if (object_id('dbo.trgUpdateString') is not null) and

(objectproperty(object_id('dbo.trgUpdateString'), 'IsTrigger') = 1)

drop trigger trgUpdateString

if (object_id('dbo.StringCache') is not null) and

(objectproperty(object_id('dbo.StringCache'), 'IsTable') = 1)

drop table dbo.StringCache

Cause

The Finnish_Swedish_CI_AI collation seems to be causing this issue.

Resolution

A different SQL Server collation needs to be used.

Altiris NS 6.x is tested with an English install of SQL Server with the collation of SQL_Latin1_General_CP1_CS_AS.

Upon the creation of Altiris database, Altiris assumes the current SQL collation as per the Master Database in SQL Server. Changing the collation of the Notification Server database, master database or tempdb, either concurrently or independently is not supported and will likely have adverse effects for Notification Server.

Any combination of Case-Insensitive, Case-Sensitive, Accent Insensitive, and Accent Sensitive is supported as a sort order for a given collation.

Issues have been found with the following collations and are not supported:

• Binary (BIN or BIN2) sort orders
• Any collation using CP850

Applies To
SQL Server 2005 Sp2 or SQL 2000 SP4 - SQL Server collation is Finnish_Swedish_CI_AI.

NS 6.0 Sp3 R9