Ошибка

Выдаёт ошибку
Сообщение 2627, уровень 14, состояние 1, процедура prcCreateUVDSubscrToObject, строка 7
Violation of PRIMARY KEY constraint 'PK_Subscribtions'. Cannot insert duplicate key in object 'dbo.Subscriptions'. The duplicate key value is (5, 5, 0).
The statement has been terminated.


код


+

+ стена вызовов процедуры неизвестного текста с разными параметрами

EXECUTE [dbo].[prcCreateUVDSubscrToObject] 5,5 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 6,6 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 8,8 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 9,9 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 11,10 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 12,11 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 14,12 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 16,13 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 17,14 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 18,15 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 19,16 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 20,17 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 21,18 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 22,19 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 23,20 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 24,21 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 25,22 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 26,23 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 27,24 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 28,25 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 29,26 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 30,27 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 31,28 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 32,29 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 33,30 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 34,31 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 35,32 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 36,33 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 38,34 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 40,35 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 41,36 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 42,37 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 43,38 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 44,39 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 45,40 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 46,41 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 47,42 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 48,43 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 49,44 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 50,45 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 51,46 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 52,47 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 53,48 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 54,49 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 57,50 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 58,51 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 59,52 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 60,53 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 61,54 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 62,55 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 63,56 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 64,57 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 65,58 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 66,59 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 67,60 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 68,61 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 69,62 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 70,63 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 74,67 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 75,68 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 76,69 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 77,70 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 78,71 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 79,72 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 80,73 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 81,74 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 82,75 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 83,76 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 84,77 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 85,78 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 86,79 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 87,80 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 88,81 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 89,82 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 90,83 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 91,84 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 92,85 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 93,86 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 94,87 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 95,88 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 96,89 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 97,90 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 98,91 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 99,92 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 100,93 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 101,94 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 102,95 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 103,96 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 104,97 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 105,98 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 106,99 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 107,100 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 108,101 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 109,102 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 110,103 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 111,104 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 112,105 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 113,106 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 114,107 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 115,108 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 116,109 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 117,110 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 118,111 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 119,112 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 120,113 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 121,114 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 122,115 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 123,116 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 124,117 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 125,118 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 126,119 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 128,121 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 129,122 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 130,123 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 131,124 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 132,125 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 133,126 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 134,127 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 135,128 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 136,129 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 137,130 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 138,131 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 139,132 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 140,133 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 141,134 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 142,135 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 143,136 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 144,137 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 145,138 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 146,139 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 147,140 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 148,141 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 149,142 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 150,143 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 151,144 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 152,145 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 153,146 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 154,147 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 155,148 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 156,149 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 157,150 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 158,151 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 159,152 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 161,154 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 162,155 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 163,156 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 164,157 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 165,158 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 166,159 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 167,160 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 168,161 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 169,162 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 170,163 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 171,164 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 172,165 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 173,166 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 174,167 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 175,168 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 176,169 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 177,170 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 178,171 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 179,172 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 180,173 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 181,174 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 182,175 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 183,176 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 184,177 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 185,178 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 186,179 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 187,180 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 188,181 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 189,182 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 190,183 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 191,184 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 192,185 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 193,186 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 194,187 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 195,188 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 196,189 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 197,190 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 198,191 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 199,192 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 200,193 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 201,194 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 202,195 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 204,197 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 205,198 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 206,199 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 207,200 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 208,201 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 209,202 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 210,203 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 211,204 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 212,205 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 213,206 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 214,207 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 215,208 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 216,209 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 217,210 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 218,211 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 219,212 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 220,213 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 221,214 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 222,215 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 223,216 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 224,217 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 225,218 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 226,219 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 227,220 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 228,221 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 229,222 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 230,223 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 231,224 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 232,225 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 233,226 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 234,227 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 235,228 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 238,229 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 239,230 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 240,231 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 241,232 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 242,233 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 243,234 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 244,235 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 245,236 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 246,237 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 247,238 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 248,239 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 249,240 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 250,241 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 251,242 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 252,243 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 253,244 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 1236,1229 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 1237,1230 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 1238,1231 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 1239,1232 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 1240,1233 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 1241,1234 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 1242,1235 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 1243,1236 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 1244,1237 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 1245,1238 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 1246,1239 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 1247,1240 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 1248,1241 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 1249,1242 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 1250,1243 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 1251,1244 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 1252,1245 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 1253,1246 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 1254,1247 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 1255,1248 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 1256,1249 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 1257,1250 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 1258,1251 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 1259,1252 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 1260,1253 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 1261,1254 EXECUTE [dbo].[prcCreateUVDSubscrToObject] 1271,1261

И что не понятного в тексте ошибки?

football07,

Вы спросить чего-то хотели, или так, решили похвастаться ошибкой?

Гость333, Как исправить эту ошибку??Я просто только начал заниматься SQL

football07
Гость333, Как исправить эту ошибку??Я просто только начал заниматься SQL

Прочитать, перевести и понять текст ошибки. После исправится само собой.

Гавриленко Сергей Алексеевич, Просто можете написать, что нужно сделать?

football07
Гавриленко Сергей Алексеевич, Просто можете написать, что нужно сделать?

Освоить http://translate.google.com/

Гавриленко Сергей Алексеевич, Это значит, что у меня такой ключ уже есть в базе

football07
Гавриленко Сергей Алексеевич, Это значит, что у меня такой ключ уже есть в базе

Ну так не вставляйте ключ, который у вас уже есть в таблице.

football07
Гость333, Как исправить эту ошибку??Я просто только начал заниматься SQL

Дублирование ключа возникает либо 1) из-за того, что запись (5, 5, 0) уже есть в таблице до выполнения процедуры, а процедура пытается вставить такую запись ещё раз; либо 2) такой записи до выполнения процедуры нет, а процедура пытается вставить две (или более) записи с указанным значением ключа.

Для начала можно выяснить, какой у вас случай (1 или 2).