用友U872升级U890报错，请大家帮下帮出出解决的主意，谢谢，在线等。

xdi3

数据库名: UFDATA_003_2009
D:\U890\Admin\SQLFILE8900\Main\Ufdata\Structure\DATA_STR_BG_MIX_NL.sql
错误信息:
-2147217900
对象名 'UFDATA_200_2009.dbo.BG_CtrlRulesMaster' 无效。
执行如下语句时出错:
--BG_CtrlRule视图在871中已经存在，872不删除
--不存在公式表，则需要升级（备份原有表数据）。否则清理这些临时表
if not exists(select * from dbo.sysobjects where name = 'BG_BudgetFormula' and xtype = 'U')
begin
if exists(select top 1 * from BG_Form)
begin
  --备份数据
  --精度
  select * into BG_UnitDigitCount_Tmp from BG_UnitDigitCount
  --版版
  select * into BG_Version_Tmp from BG_Version
  --预算假设
  select * into BG_Hypothesis_Tmp from BG_Hypothesis
  --项目类型
  select * into BG_ItemType_Tmp from BG_ItemType
  --预算项目
  select * into BG_Item_Tmp from BG_Item
  --预算类型
  select * into BG_Genre_Tmp from BG_Genre
  --预算表
  select * into BG_Form_Tmp from BG_Form
  --预算表构成
  select * into BG_Forms_Tmp from BG_Forms
  --录入点表
  select * into BG_ItemInputForms_Tmp from BG_ItemInputForms
  --分析表
  select * into BG_AnalyseForms_Tmp from BG_AnalyseForms
  --查询表
  select * into BG_QueryForms_Tmp from BG_QueryForms
  --预算数据
  select * into BG_FormData_Tmp from BG_FormData
  select * into BG_FormBgDatas_Tmp from BG_FormBgDatas
  --历史数据
  select * into BG_HistoryData_Tmp from BG_HistoryData
  --实际数
  select * into BG_FormFactDatas_Tmp from BG_FormFactDatas
  --控制规则
  select * into BG_CtrlObject_Tmp from BG_CtrlObject
  select * into BG_CtrlRule_Tmp from BG_CtrlRule
  select * into BG_CtrlRuleMapRelation_Tmp from BG_CtrlRuleMapRelation
  --控制实际数
  select * into BG_CtrlFactDatas_Tmp from BG_CtrlFactDatas
  --超预算审批金额权限
  select * into BG_MoneyAuth_Tmp from BG_MoneyAuth
  --集团日志
  select * into BG_MutualLog_Tmp from BG_MutualLog
  --调整单
  --select * into BG_RegulateBill_Tmp from BG_RegulateBill
  --select * into BG_RegulateBills_Tmp from BG_RegulateBills
  --select * into BG_RegulateEffect_Tmp from BG_RegulateEffect
  --抽取作业
  select * into BG_FetchJobs_Tmp from BG_FetchJobs
  --抽取日志
  select * into BG_FetchLog_Tmp from BG_FetchLog
  --升级预算机构
  select * into BG_Organ_Tmp from BG_Organ
  --升级执行数公式
  select * into BG_Formula_Tmp from BG_Formula
end
end
else
begin
if exists(select top 1 * from BG_Form)
begin
  if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BG_AnalyseForms_Tmp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
  drop table [dbo].[BG_AnalyseForms_Tmp]
  if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BG_CtrlFactDatas_Tmp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
  drop table [dbo].[BG_CtrlFactDatas_Tmp]
  if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BG_CtrlObject_Tmp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
  drop table [dbo].[BG_CtrlObject_Tmp]
  if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BG_CtrlRuleMapRelation_Tmp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
  drop table [dbo].[BG_CtrlRuleMapRelation_Tmp]
  if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BG_FetchJobs_Tmp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
  drop table [dbo].[BG_FetchJobs_Tmp]
  if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BG_FetchLog_Tmp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
  drop table [dbo].[BG_FetchLog_Tmp]
  if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BG_FormBgDatas_Tmp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
  drop table [dbo].[BG_FormBgDatas_Tmp]
  if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BG_FormData_Tmp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
  drop table [dbo].[BG_FormData_Tmp]
  if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BG_FormFactDatas_Tmp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
  drop table [dbo].[BG_FormFactDatas_Tmp]
  if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BG_Form_Tmp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
  drop table [dbo].[BG_Form_Tmp]
  if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BG_Forms_Tmp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
  drop table [dbo].[BG_Forms_Tmp]
  if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BG_Genre_Tmp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
  drop table [dbo].[BG_Genre_Tmp]
  if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BG_HistoryData_Tmp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
  drop table [dbo].[BG_HistoryData_Tmp]
  if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BG_Hypothesis_Tmp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
  drop table [dbo].[BG_Hypothesis_Tmp]
  if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BG_ItemInputForms_Tmp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
  drop table [dbo].[BG_ItemInputForms_Tmp]
  if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BG_ItemType_Tmp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
  drop table [dbo].[BG_ItemType_Tmp]
  if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BG_MoneyAuth_Tmp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
  drop table [dbo].[BG_MoneyAuth_Tmp]
  if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BG_MutualLog_Tmp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
  drop table [dbo].[BG_MutualLog_Tmp]
  if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BG_Organ_Tmp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
  drop table [dbo].[BG_Organ_Tmp]
  if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BG_QueryForms_Tmp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
  drop table [dbo].[BG_QueryForms_Tmp]
  if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BG_UnitDigitCount_Tmp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
  drop table [dbo].[BG_UnitDigitCount_Tmp]
  if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BG_Version_Tmp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
  drop table [dbo].[BG_Version_Tmp]
  if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BG_Formula_Tmp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
  drop table [dbo].[BG_Formula_Tmp]
end
end

效率测试报告：开始升级UFDATA_003_2009数据库
Data_STR_PB_DR_NL.SQL，2010-10-19 09:41:29 -- 2010-10-19 09:41:29，0小时0分钟0秒。
Data_STR_PB_mix_NL.SQL，2010-10-19 09:41:29 -- 2010-10-19 09:41:37，0小时0分钟8秒。
Data_STR_PB_Vou_NL.SQL，2010-10-19 09:41:37 -- 2010-10-19 09:41:38，0小时0分钟1秒。
DATA_STR_WF_MIX_NL.SQL，2010-10-19 09:41:38 -- 2010-10-19 09:41:39，0小时0分钟1秒。
DATA_STR_PB_EAI_NL.SQL，2010-10-19 09:41:39 -- 2010-10-19 09:41:39，0小时0分钟0秒。
data_str_pb_uap_nl.SQL，2010-10-19 09:41:39 -- 2010-10-19 09:41:40，0小时0分钟1秒。
data_str_pb_as_nl.SQL，2010-10-19 09:41:40 -- 2010-10-19 09:41:44，0小时0分钟4秒。
data_str_pb_flow_nl.SQL，2010-10-19 09:41:44 -- 2010-10-19 09:41:44，0小时0分钟0秒。
Data_STR_SR_mix_NL.SQL，2010-10-19 09:41:44 -- 2010-10-19 09:41:44，0小时0分钟0秒。
data_str_ss_mix_nl.SQL，2010-10-19 09:41:44 -- 2010-10-19 09:41:45，0小时0分钟1秒。
data_str_wa_mix_nl.SQL，2010-10-19 09:41:45 -- 2010-10-19 09:41:45，0小时0分钟0秒。
Data_STR_HR_TM_mix_NL.SQL，2010-10-19 09:41:45 -- 2010-10-19 09:41:48，0小时0分钟3秒。
data_str_ht_mix_nl.SQL，2010-10-19 09:41:48 -- 2010-10-19 09:41:49，0小时0分钟1秒。
data_str_pr_mix_nl.SQL，2010-10-19 09:41:49 -- 2010-10-19 09:41:49，0小时0分钟0秒。
data_str_hb_mix_nl.SQL，2010-10-19 09:41:49 -- 2010-10-19 09:41:50，0小时0分钟1秒。
data_str_hm_mix_nl.SQL，2010-10-19 09:41:50 -- 2010-10-19 09:41:51，0小时0分钟1秒。
data_str_wm_mix_nl.SQL，2010-10-19 09:41:51 -- 2010-10-19 09:41:54，0小时0分钟3秒。
DATA_STR_FA_MIX_NL.SQL，2010-10-19 09:41:54 -- 2010-10-19 09:42:04，0小时0分钟10秒。
DATA_STR_CR_MIX_NL.SQL，2010-10-19 09:42:04 -- 2010-10-19 09:42:05，0小时0分钟1秒。
Data_STR_CM_mix_NL.SQL，2010-10-19 09:42:05 -- 2010-10-19 09:42:06，0小时0分钟1秒。
data_str_cm_log_nl.SQL，2010-10-19 09:42:06 -- 2010-10-19 09:42:07，0小时0分钟1秒。
data_str_ed_mix_nl.SQL，2010-10-19 09:42:07 -- 2010-10-19 09:43:26，0小时1分钟19秒。
Data_STR_NE_mix_NL.SQL，2010-10-19 09:43:26 -- 2010-10-19 09:43:26，0小时0分钟0秒。
Data_STR_NB_Mix_NL.SQL，2010-10-19 09:43:26 -- 2010-10-19 09:43:26，0小时0分钟0秒。
    升级起始时间：2010-10-19 09:41:20，结束时间：2010-10-19 09:43:27，0小时2分钟7秒。

xdi3

这个是003帐套里面的2009年度帐升级时出现的错误，其它年度的都正常升上去了。另外，其它帐套也有这个情况，而且出现的问题都是一样的，也都有一两个年度账升不上去，但都不一定是2009年的，有2008年或其它年度的。

xdi3

升级完成后都会提示这句话。

yufei

有没有ID为23的数据库啊！！

wxllove615

到视图里找到BG_CtrlRulesMaster' 这种视图，删除，然后将同帐套其他年度的视图复制过来！

wxllove615

还有这张BG_CtrlRule，一并删除！

zjlm

同意楼上的做法。直接删除哪张ctrlrule的视图，然后在已经升级好的数据库里将这张视图创建过来~

xiaogangvan

赞成楼上所说！！！

xdi3

谢谢大家的回答，但是，我试了以后，还是不行，还是同样的报错，真是奇怪，期待大家的其他解法。