用友U8升级到U8 12.1提示错误,对象名 'fitemss97' 无效。

升级错误提示:这个打开错误的脚本

数据库名: UFDATA_004_2013

F:\U8SOFT\Admin\SQLFILE8710\Main\Ufdata\Structure\Data_PRV_CM_mix_NL.sql
错误信息:
-2147217865
对象名 'fitemss97' 无效。
执行如下语句时出错:
/****** Object:  View dbo.vwCM_Pay    Script Date: 2003-07-31 15:03:54 ******/
ALTER     VIEW dbo.vwCM_Pay
AS
SELECT ID, GUID,lngRowID, dtPayDate,dblPayRatio, dblPayCurrency,strSettleStyleID, strPayFactor,strExp, dblTotalCurrency,
      dblExecCurrency, dblTotalQuantity,dblExecQuqantity, CONVERT(Money, tsTime) AS tsTime, strContractID,
      CM_Contract_Pay.cItemCode,cItemName,iItemPercent,CM_Contract_Pay.cStageGroupCode,
      CM_Contract_Pay.cStageCode,cStageName,dtStageExpectedEndDate
FROM dbo.CM_Contract_Pay 
left join fitemss97 on CM_Contract_Pay.cItemCode=fitemss97.cItemCode

left join CM_Stage on CM_Contract_Pay.cStageCode=CM_Stage.cStageCode

********************以上错误经过分析是对应的数据库年度缺少fitemss97,fitemss97 class,fitemss97 sub三个表

从其他可以升级的年度,没有升级的数据库复制三个表即可.

或者执行下面脚本及可以.

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER ON
GO
SET NUMERIC_ROUNDABORT OFF
GO

SET XACT_ABORT ON
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO
BEGIN TRANSACTION
GO
PRINT N'Creating [dbo].[fitemss97] table'
GO
CREATE TABLE [dbo].[fitemss97] (
   [I_id] [int] NOT NULL IDENTITY (1, 1),
   [citemcode] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL,
   [citemname] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL,
   [bclose] [bit] NULL,
   [citemccode] [varchar] (22) COLLATE Chinese_PRC_CI_AS NOT NULL,
   [iotherused] [int] NULL,
   [dEndDate] [datetime] NULL
) 
GO
IF @@TRANCOUNT = 0 BEGIN TRANSACTION
GO
IF (@@ERROR <> 0) AND (@@TRANCOUNT > 0) ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT > 0
      COMMIT TRANSACTION
GO
ALTER TABLE [dbo].[fitemss97] ADD CONSTRAINT [PK_fitemss97] PRIMARY KEY CLUSTERED ([I_id]) 
GO
IF (@@ERROR <> 0) AND (@@TRANCOUNT > 0) ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT > 0
      COMMIT TRANSACTION
GO

IF @@TRANCOUNT = 0 BEGIN TRANSACTION
GO

PRINT N'Creating [dbo].[fitemss97class] table'
GO
CREATE TABLE [dbo].[fitemss97class] (
   [i_id] [int] NOT NULL IDENTITY (1, 1),
   [cItemCcode] [varchar] (22) COLLATE Chinese_PRC_CI_AS NOT NULL,
   [cItemCname] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL,
   [iItemCgrade] [tinyint] NOT NULL,
   [bItemCend] [bit] NOT NULL
) 
GO
IF @@TRANCOUNT = 0 BEGIN TRANSACTION
GO
IF (@@ERROR <> 0) AND (@@TRANCOUNT > 0) ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT > 0
      COMMIT TRANSACTION
GO
ALTER TABLE [dbo].[fitemss97class] ADD CONSTRAINT [PK_fitemss97class] PRIMARY KEY CLUSTERED ([i_id]) 
GO
IF (@@ERROR <> 0) AND (@@TRANCOUNT > 0) ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT > 0
      COMMIT TRANSACTION
GO

IF @@TRANCOUNT = 0 BEGIN TRANSACTION
GO

PRINT N'Creating [dbo].[fitemss97sub] table'
GO
CREATE TABLE [dbo].[fitemss97sub] (
   [I_id] [int] NOT NULL IDENTITY (1, 1),
   [citemcode] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL,
   [citemname] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL,
   [iclose] [int] NULL,
   [dEndDate] [datetime] NULL
) 
GO
IF @@TRANCOUNT = 0 BEGIN TRANSACTION
GO
IF (@@ERROR <> 0) AND (@@TRANCOUNT > 0) ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT > 0
      COMMIT TRANSACTION
GO
ALTER TABLE [dbo].[fitemss97sub] ADD CONSTRAINT [PK_fitemss97sub] PRIMARY KEY CLUSTERED ([I_id]) 
GO
CREATE UNIQUE NONCLUSTERED INDEX [PrimaryKey] ON [dbo].[fitemss97sub] ([citemcode]) 
GO
IF (@@ERROR <> 0) AND (@@TRANCOUNT > 0) ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT > 0
      COMMIT TRANSACTION
GO

PRINT 'Script deployment completed'
GO