用友U8更新到U8 12.1提示錯誤,對象名 'fitemss97' 無效。

更新錯誤提示:這個打開錯誤的腳本

資料庫名: UFDATA_004_2013

F:\U8SOFT\Admin\SQLFILE8710\Main\Ufdata\Structure\Data_PRV_CM_mix_NL.sql

錯誤資訊:

-2147217865

對象名 'fitemss97' 無效。

執行如下語句時出錯:

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