Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Microsoft SQL Server Новый топик    Ответить
 Ошибка СУБД  [new]
napor
Member

Откуда:
Сообщений: 1
В 1С УПП 8.0 (Платформа 8.0.18.2. Релиз УПП 1.2.5.1) на MS SQL Server 2000 SP3 при добавлении / корректировке значения в 3-х справочниках (Организации, Контрагенты и Физические лица) появляется сообщение 1С: "Ошибка СУБД: Microsoft OLE DB Provider for SQL Server: Only text pointers are allowed in work tables, never text, ntext, or image columns. The query processor produced a query plan that required a text, ntext, or image column in a work table. HRESULT=80040E14, SQLSTATE=42000, native=8626".

При этом на сервере MS SQL 2000 выполняется транзакция:
exec sp_executesql N'SELECT
ISNULL(CASE
WHEN #V8TblAli1_Q_000_T_001._Q_001_F_000RRef IS NOT NULL
THEN 0x08
END, #V8TblAli2_Q_000_T_002._Q_002_F_002_TYPE) f_1,
ISNULL(CASE
WHEN #V8TblAli1_Q_000_T_001._Q_001_F_000RRef IS NOT NULL
THEN CAST(N'''' AS NVARCHAR(50))
END, CASE
WHEN #V8TblAli2_Q_000_T_002._Q_002_F_002_TYPE IS NOT NULL AND #V8TblAli2_Q_000_T_002._Q_002_F_002_TYPE IN (0x01,0x05,0x08)
THEN #V8TblAli2_Q_000_T_002._Q_002_F_002_S
END) f_2,
ISNULL(#V8TblAli1_Q_000_T_001._Q_001_F_000RRef, CASE
WHEN #V8TblAli2_Q_000_T_002._Q_002_F_002_TYPE IS NOT NULL AND #V8TblAli2_Q_000_T_002._Q_002_F_002_TYPE IN (0x01,0x05,0x08)
THEN #V8TblAli2_Q_000_T_002._Q_002_F_002_RRRef
END) f_3,
CASE
WHEN #V8TblAli1_Q_000_T_001._Q_001_F_000RRef IS NULL
THEN #V8TblAli2_Q_000_T_002._Q_002_F_001RRef
ELSE #V8TblAli1_Q_000_T_001._Q_001_F_002RRef
END f_4,
CASE
WHEN #V8TblAli1_Q_000_T_001._Q_001_F_000RRef IS NULL
THEN CASE
WHEN #V8TblAli2_Q_000_T_002._Q_002_F_000_TYPE = 0x01 OR
#V8TblAli2_Q_000_T_002._Q_002_F_000_TYPE = 0x08 AND #V8TblAli2_Q_000_T_002._Q_002_F_000_RTRef IS NOT NULL AND #V8TblAli2_Q_000_T_002._Q_002_F_000_RRRef IS NOT NULL
THEN #V8TblAli2_Q_000_T_002._Q_002_F_000_TYPE
ELSE NULL
END
ELSE CASE
WHEN 0x937b000d884f5d5e11d8e0bb42dbad6f IS NOT NULL
THEN 0x08
ELSE NULL
END
END f_5,
CASE
WHEN #V8TblAli1_Q_000_T_001._Q_001_F_000RRef IS NULL
THEN CASE
WHEN #V8TblAli2_Q_000_T_002._Q_002_F_000_TYPE = 0x08
THEN #V8TblAli2_Q_000_T_002._Q_002_F_000_RTRef
WHEN #V8TblAli2_Q_000_T_002._Q_002_F_000_TYPE IS NULL OR
#V8TblAli2_Q_000_T_002._Q_002_F_000_TYPE NOT IN (0x01,0x08)
THEN NULL
ELSE 0x00000000
END
ELSE CASE
WHEN 0x937b000d884f5d5e11d8e0bb42dbad6f IS NOT NULL
THEN 0x0000004E
ELSE NULL
END
END f_6,
CASE
WHEN #V8TblAli1_Q_000_T_001._Q_001_F_000RRef IS NULL
THEN CASE
WHEN #V8TblAli2_Q_000_T_002._Q_002_F_000_TYPE = 0x08
THEN #V8TblAli2_Q_000_T_002._Q_002_F_000_RRRef
WHEN #V8TblAli2_Q_000_T_002._Q_002_F_000_TYPE IS NULL OR
#V8TblAli2_Q_000_T_002._Q_002_F_000_TYPE NOT IN (0x01,0x08)
THEN NULL
ELSE 0x00000000000000000000000000000000
END
ELSE 0x937b000d884f5d5e11d8e0bb42dbad6f
END f_7,
ISNULL(#V8TblAli2_Q_000_T_002._Q_002_F_004, CAST(N'''' AS NVARCHAR(1))) f_8,
ISNULL(#V8TblAli2_Q_000_T_002._Q_002_F_005, CAST(N'''' AS NVARCHAR(1))) f_9,
ISNULL(#V8TblAli2_Q_000_T_002._Q_002_F_006, CAST(N'''' AS NVARCHAR(1))) f_10,
ISNULL(#V8TblAli2_Q_000_T_002._Q_002_F_007, CAST(N'''' AS NVARCHAR(1))) f_11,
ISNULL(#V8TblAli2_Q_000_T_002._Q_002_F_008, CAST(N'''' AS NVARCHAR(1))) f_12,
ISNULL(#V8TblAli2_Q_000_T_002._Q_002_F_009, CAST(N'''' AS NVARCHAR(1))) f_13,
ISNULL(#V8TblAli2_Q_000_T_002._Q_002_F_010, CAST(N'''' AS NVARCHAR(1))) f_14,
ISNULL(#V8TblAli2_Q_000_T_002._Q_002_F_011, CAST(N'''' AS NVARCHAR(1))) f_15,
ISNULL(#V8TblAli2_Q_000_T_002._Q_002_F_012, CAST(N'''' AS NVARCHAR(1))) f_16,
ISNULL(#V8TblAli2_Q_000_T_002._Q_002_F_013, CAST(N'''' AS NVARCHAR(1))) f_17,
ISNULL(#V8TblAli2_Q_000_T_002._Q_002_F_003, CAST(N'''' AS NVARCHAR(1))) f_18,
ISNULL(#V8TblAli2_Q_000_T_002._Q_002_F_014, CAST(N'''' AS NVARCHAR(1))) f_19,
ISNULL(#V8TblAli2_Q_000_T_002._Q_002_F_015, 0x00) f_20,
CASE
WHEN #V8TblAli1_Q_000_T_001._Q_001_F_000RRef IS NULL
THEN _Enum784._EnumOrder
ELSE _Enum784_1._EnumOrder
END _sf_1,
ISNULL(#V8TblAli1_Q_000_T_001._Q_001_F_001, CASE
WHEN #V8TblAli2_Q_000_T_002._Q_002_F_002_TYPE = 0x08
THEN _Reference17._Description
ELSE CAST(NULL AS NVARCHAR(100))
END) _sf_2
FROM
(
SELECT
_Reference17_Q_001_T_001._IDRRef _Q_001_F_000RRef,
_Reference17_Q_001_T_001._Description COLLATE Cyrillic_General_CI_AS _Q_001_F_001,
_Reference17_Q_001_T_001._Fld926RRef _Q_001_F_002RRef
FROM
_Reference17 _Reference17_Q_001_T_001 WITH(NOLOCK)
WHERE
_Reference17_Q_001_T_001._Fld927RRef = @P1
) #V8TblAli1_Q_000_T_001
FULL OUTER JOIN (
SELECT
_InfoReg13566_Q_002_T_001._Fld13567_TYPE _Q_002_F_000_TYPE,
_InfoReg13566_Q_002_T_001._Fld13567_RTRef _Q_002_F_000_RTRef,
_InfoReg13566_Q_002_T_001._Fld13567_RRRef _Q_002_F_000_RRRef,
_InfoReg13566_Q_002_T_001._Fld13568RRef _Q_002_F_001RRef,
_InfoReg13566_Q_002_T_001._Fld13569_TYPE _Q_002_F_002_TYPE,
_InfoReg13566_Q_002_T_001._Fld13569_S COLLATE Cyrillic_General_CI_AS _Q_002_F_002_S,
_InfoReg13566_Q_002_T_001._Fld13569_RRRef _Q_002_F_002_RRRef,
_InfoReg13566_Q_002_T_001._Fld13570 COLLATE Cyrillic_General_CI_AS _Q_002_F_003,
_InfoReg13566_Q_002_T_001._Fld13571 COLLATE Cyrillic_General_CI_AS _Q_002_F_004,
_InfoReg13566_Q_002_T_001._Fld13572 COLLATE Cyrillic_General_CI_AS _Q_002_F_005,
_InfoReg13566_Q_002_T_001._Fld13573 COLLATE Cyrillic_General_CI_AS _Q_002_F_006,
_InfoReg13566_Q_002_T_001._Fld13574 COLLATE Cyrillic_General_CI_AS _Q_002_F_007,
_InfoReg13566_Q_002_T_001._Fld13575 COLLATE Cyrillic_General_CI_AS _Q_002_F_008,
_InfoReg13566_Q_002_T_001._Fld13576 COLLATE Cyrillic_General_CI_AS _Q_002_F_009,
_InfoReg13566_Q_002_T_001._Fld13577 COLLATE Cyrillic_General_CI_AS _Q_002_F_010,
_InfoReg13566_Q_002_T_001._Fld13578 COLLATE Cyrillic_General_CI_AS _Q_002_F_011,
_InfoReg13566_Q_002_T_001._Fld13579 COLLATE Cyrillic_General_CI_AS _Q_002_F_012,
_InfoReg13566_Q_002_T_001._Fld13580 COLLATE Cyrillic_General_CI_AS _Q_002_F_013,
_InfoReg13566_Q_002_T_001._Fld13581 COLLATE Cyrillic_General_CI_AS _Q_002_F_014,
_InfoReg13566_Q_002_T_001._Fld13582 _Q_002_F_015,
_InfoReg13566_Q_002_T_001._Fld13583RRef _Q_002_F_016RRef,
_InfoReg13566_Q_002_T_001._Fld13584_TYPE _Q_002_F_017_TYPE,
_InfoReg13566_Q_002_T_001._Fld13584_RTRef _Q_002_F_017_RTRef,
_InfoReg13566_Q_002_T_001._Fld13584_RRRef _Q_002_F_017_RRRef
FROM
_InfoReg13566 _InfoReg13566_Q_002_T_001 WITH(NOLOCK)
WHERE
_InfoReg13566_Q_002_T_001._Fld13567_TYPE = @P2 AND _InfoReg13566_Q_002_T_001._Fld13567_RTRef = @P3 AND _InfoReg13566_Q_002_T_001._Fld13567_RRRef = @P4
) #V8TblAli2_Q_000_T_002
ON #V8TblAli2_Q_000_T_002._Q_002_F_002_TYPE = 0x08 AND 0x00000011 = 0x00000011 AND #V8TblAli1_Q_000_T_001._Q_001_F_000RRef = #V8TblAli2_Q_000_T_002._Q_002_F_002_RRRef
LEFT OUTER JOIN _Enum784 _Enum784_1 WITH(NOLOCK)
ON #V8TblAli1_Q_000_T_001._Q_001_F_002RRef = _Enum784_1._IDRRef
LEFT OUTER JOIN _Reference17 WITH(NOLOCK)
ON CASE
WHEN #V8TblAli2_Q_000_T_002._Q_002_F_002_TYPE = 0x08
THEN #V8TblAli2_Q_000_T_002._Q_002_F_002_RRRef
WHEN #V8TblAli2_Q_000_T_002._Q_002_F_002_TYPE IS NULL OR
#V8TblAli2_Q_000_T_002._Q_002_F_002_TYPE NOT IN (0x08)
THEN NULL
ELSE 0x00000000000000000000000000000000
END = _Reference17._IDRRef
LEFT OUTER JOIN _Enum784 WITH(NOLOCK)
ON #V8TblAli2_Q_000_T_002._Q_002_F_001RRef = _Enum784._IDRRef
ORDER BY
CASE
WHEN #V8TblAli1_Q_000_T_001._Q_001_F_000RRef IS NULL
THEN _Enum784._EnumOrder
ELSE _Enum784_1._EnumOrder
END,
ISNULL(#V8TblAli1_Q_000_T_001._Q_001_F_001, CASE
WHEN #V8TblAli2_Q_000_T_002._Q_002_F_002_TYPE = 0x08
THEN _Reference17._Description
ELSE CAST(NULL AS NVARCHAR(100))
END)
SELECT @@TRANCOUNT', N'@P1 varbinary(16),@P2 varbinary(1),@P3 varbinary(4),@P4 varbinary(16)', 0x98DE77660628F6714B1A3FBB89EC2487, 0x08, 0x0000004E, 0x937B000D884F5D5E11D8E0BB42DBAD6F

Как можно исправить данную ошибку?
10 май 07, 14:08    [4120804]     Ответить | Цитировать Сообщить модератору
 Re: Ошибка СУБД  [new]
Knyazev Alexey
Member

Откуда: Екб -> Мск
Сообщений: 10234
Блог
Поиск
10 май 07, 14:11    [4120820]     Ответить | Цитировать Сообщить модератору
 Re: Ошибка СУБД  [new]
Albatross
Member

Откуда:
Сообщений: 997
да уж, весьма странные 1С генерит запросы
10 май 07, 17:28    [4122363]     Ответить | Цитировать Сообщить модератору
 Re: Ошибка СУБД  [new]
Glory
Member

Откуда:
Сообщений: 104760
napor

Как можно исправить данную ошибку?

Исключить из запроса text, ntext, or image columns
10 май 07, 17:30    [4122375]     Ответить | Цитировать Сообщить модератору
Между сообщениями интервал более 1 года.
 Re: Ошибка СУБД  [new]
itar59
Member

Откуда:
Сообщений: 3
а попроще, для "чайников"?
25 ноя 09, 18:22    [7978792]     Ответить | Цитировать Сообщить модератору
Все форумы / Microsoft SQL Server Ответить