04.07.2013 10:40
Кристалл версии 5.2.80.14. При передаче из центрума в кристалл в магазине не грузятся справочники, в логах следующая ошибка:

02.07.2013 11:26:22.968 DEBUG: Поток транспорта Справочников.-1.TransGood: putXML
02.07.2013 11:26:25.578 ERROR: Поток транспорта Справочников.-1.TransGood: stopPut: Cannot find either column "master" or the user-defined function or aggregate "master.dbo.fn_getBinaryFromBase64String", or the name is ambiguous.
02.07.2013 11:26:25.578 ERROR: Поток транспорта Справочников.-1 Ошибка обработки Поток транспорта Справочников.-1.TransGood: Поток транспорта Справочников.-1.TransGood: stopPutData - PUT Exception
02.07.2013 11:26:44.812 ERROR: Поток мониторинга: InitTransport error: Connection refused: connect
04.07.2013 11:30
Вы вероятно всего переставляли SET?
Сообщите пожалуйста после чего данная проблема началась?
Опишите алгоритм Ваших действий.
04.07.2013 11:58
SET не переставляли, только обновляли. Раньше он работал автономно и цены грузились локально, а теперь новые цены грузятся через центрум.
04.07.2013 12:49
попробуйте выполнить скрип по БД Master
use master
GO
IF OBJECT_ID('dbo.fn_getBinaryFromBase64String') IS NOT NULL
DROP FUNCTION dbo.fn_getBinaryFromBase64String
GO
IF EXISTS(SELECT * FROM sys.assemblies WHERE name = 'asbly_base64')
DROP ASSEMBLY asbly_base64
GO

DECLARE @Path nvarchar(1024), @Path1 nvarchar(1024)

BEGIN TRY
SELECT @Path = REPLACE(physical_name,
'MSSQL\DATA\master.mdf',
'MSSQL\Binn\')
FROM master.sys.database_files
WHERE name = 'master';

CREATE ASSEMBLY asbly_base64
FROM @Path+'base.dll'
WITH PERMISSION_SET = SAFE;

END TRY
BEGIN CATCH
SELECT @Path1 = @Path
SELECT @Path = NULL
EXECUTE xp_regread 'HKEY_LOCAL_MACHINE', 'SOFTWARE\Crystal-Service\RETAIL', 'AppPath', @Path OUTPUT
SELECT @Path = @Path + '\Data\Dll\'
IF @Path IS NOT NULL BEGIN
CREATE ASSEMBLY asbly_base64
FROM @Path+'base.dll'
WITH PERMISSION_SET = SAFE;
END
ELSE
RAISERROR('Файл "base.dll" должен находится в папке %s. Поместите файл в папку и запустите скрипт повторно.',16,1,@Path1);
END CATCH

GO
sp_configure 'clr enabled', 1
reconfigure with override
GO


CREATE FUNCTION dbo.fn_getBinaryFromBase64String( @s nvarchar(max) )
RETURNS varbinary(max)
AS EXTERNAL name asbly_base64.Sample.ConvertBase64ToBinary
GO
04.07.2013 16:40
помогло?
05.07.2013 09:09
При запуске скрипта вываливается ошибка.

Версия SQL 2005 Express

6512, 16, 27, 22

Failed to initialize the Common Language Runtime (CLR) v2.0.50727 with HRESULT 0x80131522. You need to restart SQL server to use CLR integration features.

Configuration option 'clr enabled' changed from 1 to 1. Run the RECONFIGURE statement to install.

6528, 16, 1, fn_getBinaryFromBase64String, 3

Assembly 'asbly_base64' was not found in the SQL catalog of database 'master'.
05.07.2013 09:22
попробуйте этот:
USE [master]
GO

/****** Object: SqlAssembly [asbly_base64] Script Date: 04.07.2013 12:41:26 ******/
CREATE ASSEMBLY [asbly_base64]
FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C010300BD2105500000000000000000E00002210B0108000004000000060000000000006E2300000020000000400000000040000020000000020000040000000000000004000000000000000080000000020000000000000300408500001000001000000000100000100000000000001000000000000000000000001823000053000000004000009802000000000000000000000000000000000000006000000C00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E7465787400000074030000002000000004000000020000000000000000000000000000200000602E7273726300000098020000004000000004000000060000000000000000000000000000400000402E72656C6F6300000C0000000060000000020000000A000000000000000000000000000040000042000000000000000000000000000000005023000000000000480000000200050080200000980200000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000133002001C00000001000011000214FE0116FE010B072D0500140A2B0902280300000A0A2B00062A1E02280400000A2A42534A4201000100000000000C00000076322E302E35303732370000000005006C000000F4000000237E000060010000D800000023537472696E67730000000038020000080000002355530040020000100000002347554944000000500200004800000023426C6F620000000000000002000001471502000900000000FA0133001600000100000004000000020000000200000001000000040000000200000001000000010000000100000000000A0001000000000006002A00230006006D004D0006008D004D000600BD00230000000000010000000000010001000100100013000000050001000100502000000000960031000A000100782000000000861847001000020000000100B0001100470014001900470010002100C5000A000900470010002E000B001F002E00130028001900048000000000000000000000000000000000AB00000002000000000000000000000001001A000000000000000000003C4D6F64756C653E00626173652E646C6C0053616D706C65006D73636F726C69620053797374656D004F626A65637400436F6E76657274426173653634546F42696E617279002E63746F720053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C697479417474726962757465006261736500626173653634537472696E6700436F6E766572740046726F6D426173653634537472696E670000000003200000000000234D504CF385434F8D380AD37C3F2C530008B77A5C561934E0890500011D050E0320000104200101080507021D05020801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F777301004023000000000000000000005E2300000020000000000000000000000000000000000000000000005023000000000000000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF25002040000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001001000000018000080000000000000000000000000000001000100000030000080000000000000000000000000000001000000000048000000584000003C02000000000000000000003C0234000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000000000000000000000000000000003F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B0049C010000010053007400720069006E006700460069006C00650049006E0066006F0000007801000001003000300030003000300034006200300000002C0002000100460069006C0065004400650073006300720069007000740069006F006E000000000020000000300008000100460069006C006500560065007200730069006F006E000000000030002E0030002E0030002E003000000034000900010049006E007400650072006E0061006C004E0061006D006500000062006100730065002E0064006C006C00000000002800020001004C006500670061006C0043006F0070007900720069006700680074000000200000003C00090001004F0072006900670069006E0061006C00460069006C0065006E0061006D006500000062006100730065002E0064006C006C0000000000340008000100500072006F006400750063007400560065007200730069006F006E00000030002E0030002E0030002E003000000038000800010041007300730065006D0062006C0079002000560065007200730069006F006E00000030002E0030002E0030002E003000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000C000000703300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
WITH PERMISSION_SET = SAFE

GO

SET ANSI_NULLS OFF
GO

SET QUOTED_IDENTIFIER OFF
GO

CREATE FUNCTION [dbo].[fn_getBinaryFromBase64String](@s [nvarchar](max))
RETURNS [varbinary](max) WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [asbly_base64].[Sample].[ConvertBase64ToBinary]
GO
05.07.2013 14:01
Сообщение 6528, уровень 16, состояние 1, процедура fn_getBinaryFromBase64String, строка 2
Assembly 'asbly_base64' was not found in the SQL catalog of database 'master'.
05.07.2013 14:04
в общем второй скрипт дает тот же результат
05.07.2013 14:06
base.dll -поиском найдите и скопируйте в папку где лежат ses.mdf и ses.ldf (dll положите в папку DLL -если ее нет создайте ??:\Data\Dll\)
Часовой пояс GMT +3, время: 07:17.

Форум на базе vBulletin®
Copyright © Jelsoft Enterprises Ltd.
В случае заимствования информации гипертекстовая индексируемая ссылка на Форум обязательна.