Return
-
Title
When installing the Blackberry report pack you receive the following error - Error Description -
Description
When installing the Blackberry report pack you receive the following error -
error: failed to execute the database creation script
Error code = 2147217900
Error message = IDispatch error #3092
Error source = Mocrosoft OLE DB Provider for SQL Server
Error Description = Invalid column name 'CustomFilterDescription'
 -
Resolution
1. Launch SQL Server Management Studio.
2. Connect to the SQL Server that is hosting the MessageStats Database (for example, Server Type = Database Engine, Server Name = SQL Server Name and Authentication = either Windows Authentication or SQL Server Authentication.
3. Expand SQL Server Name.
4. Expand Databases.
5. Right click the MessageStats Database and select New Query.
Paste the following query into the empty query windoowÂUse Messagestats
/****** Object: Table [dbo].[T_ParameterQuery] Script Date: 12/2/2002 10:10:18 AM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T_ParameterQuery]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[T_ParameterQuery]
GOCREATE TABLE [dbo].[T_ParameterQuery] (
[FieldID] [int] NOT NULL ,
[DataSources] [nvarchar] (512) NULL ,
[Name] [nvarchar] (50) NULL ,
[Title] [nvarchar] (255) NULL ,
[Description] [ntext] NULL ,
[Type] [int] NULL ,
[Source] [nvarchar] (50) NULL ,
[ValueQuery] [nvarchar] (512) NULL ,
[FormatString] [nvarchar] (512) NULL ,
[Parameter] [nvarchar] (50) NULL ,
[AllowBrowse] [int] NULL ,
[ReadyDataSources] [nvarchar] (512) NULL ,
[DefaultFilterSettingName] [nvarchar] (50) NULL ,
[DefaultFilterSettingDescription] [nvarchar] (50) NULL ,
[DefaultFilterSettingDisplayName] [nvarchar] (50) NULL ,
[AllowedFilters] [nvarchar] (10) NULL ,
[CustomFilterDescription] [nvarchar] (512) NULL
) ON [PRIMARY]
GOALTER TABLE [dbo].[T_ParameterQuery] ADD
CONSTRAINT [PK_T_ParameterQuery] PRIMARY KEY NONCLUSTERED
(
[FieldID]
) ON [PRIMARY]
GOÂ6. Click on Execute or press F5 to execute the query.ÂAfter the query finishes please try intalling the Blackberry Report pack again.