U890升级到U810报错：-2147217900 列名 'dopseq' 无效

sylovesy

日志记录如下：

数据库名: UFDATA_001_2010
D:\U8SOFT\Admin\SQLFILE10000\Main\Ufdata\Structure\data_str_hy_mix_nl.sql
错误信息:
-2147217900
列名 'dopseq' 无效。
执行如下语句时出错:


ALTER   VIEW [dbo].[HY_View_ListReport]
AS
select  a.moCode,a.moSeq,a.MoStatus,a.dopseq as opseq,b.cCode,b.ddate,  
a.InvCode,a.InvName,a.InvSpec,a.InvAddCode,  
a.opcode as copcode,a.description,b.cdepcode,b.cdepname,b.cpersoncode,b.cpersonname,  
b.cVenCode,b.cVenName,b.cvenabbName,convert(varchar(30),'') as itemClassCode,convert(varchar(30),'') as itemClassName,  
convert(varchar(30),'') as itemCode,convert(varchar(30),'') as itemName,a.moDeptCode,a.ModeptName,  
a.unitname as CINVM_UNIT,  
b.define_1 as cdefine1,b.define_2 as cdefine2,b.define_3 as cdefine3,  
b.define_4 as cdefine4,b.define_5 as cdefine5,b.define_6 as cdefine6,b.define_7 as cdefine7,  
b.define_8 as cdefine8,b.define_9 as cdefine9,b.define_10 as cdefine10,b.define_11 as cdefine11,  
b.define_12 as cdefine12,b.define_13 as cdefine13,b.define_14 as cdefine14,b.define_15 as cdefine15,  
b.define_16 as cdefine16,a.define_22 as cdefine22,a.define_23 as cdefine23,  
a.define_24 as cdefine24,a.define_25 as cdefine25,a.define_26 as cdefine26,  
a.define_27 as cdefine27,a.define_28 as cdefine28,a.define_29 as cdefine29,  
a.define_30 as cdefine30,a.define_31 as cdefine31,a.define_32 as cdefine32,  
a.define_33 as cdefine33,a.define_34 as cdefine34,a.define_35 as cdefine35,  
a.define_36 as cdefine36,a.define_37 as cdefine37,  
a.InvFree_1 as cfree1,a.InvFree_2 as cfree2,a.InvFree_3 as cfree3,a.InvFree_4 as cfree4,a.InvFree_5 as cfree5,  
a.InvFree_6 as cfree6,a.InvFree_7 as cfree7,a.InvFree_8 as cfree8,a.InvFree_9 as cfree9,a.InvFree_10 as cfree10,  
Hy_ListReport.ID,cVoucherType,cBodyID,fQuantity,mReceiveMoney,mUsedvouchMoney,mPurbillMoney,   
fJQuantity,mJMoney,fzQuantity,fzMoney,dRMonth,dUMonth,dPMonth ,b.cCreateUser,b.dCreatetime as dCreateDate,b.cModifyUser,  
b.dModifyTime as dModifyDate,b.crelsUser,b.drelstime as drelsdate,qualifiedQty as  fqualifiedQuantity,labScrapqty as fopScrapquantity ,matScrapQty as fmaScrapQuantity ,CONVERT(DECIMAL(38,10),NULL) as fInlostQuantity,ReworkQty as fRedoQuantity,  
N'1' as CREDORESPONSE,b.ddate as accMonth,d1.cDepCode  as cworkdepcode, d1.cdepname as cworkdepname,wcdesc as cworkcenter,hy_modetails.partid ,sfc_workcenter.wccode as wccode,vendor.iid as cvenauthid,inventory.iid as cinvauthid,   
a.ReworkJFQty as fReworkJFQty  ----added
,(CASE WHEN INO_ID>9999 THEN CAST(INO_ID AS NVARCHAR(10)) ELSE RIGHT('0000'  +CAST(INO_ID AS NVARCHAR(10)),4) END) AS CPZCODE
from Hy_ListReport  
LEFT JOIN GL_ACCVOUCH  ON  GL_ACCVOUCH.COUTNO_ID=HY_LISTREPORT.CPZID   
left join v_hy_receivedetail a on a.receiveDId=Hy_ListReport.cBodyID  
inner join hy_modetails  on a.hydid = hy_modetails.AutoId      
left join v_hy_receive b on a.receiveId=b.receiveId  
left join sfc_workcenter  on a.wcid=sfc_workcenter.wcid  
left join department as d1  on d1.cdepcode=sfc_workcenter.DeptCode  
left join vendor on vendor.cvencode=b.cvencode
left join inventory on inventory.cinvcode=a.invcode
where cVoucherType=N'收料单'  

union   
select   
a.cMoordercode as moCode,a.imoorderseq as moSeq,md.status as MoStatus,sd.opseq,b.cCode,b.ddate,  
a.cInvCode as invcode,a.cinvname as InvName,a.cinvstd as InvSpec,a.cinvaddcode as InvAddCode,  
a.copcode as copcode,a.CDESCRIPTION as description,b.cdepcode,b.cdepname,b.cpersoncode,b.cpersonname,  
b.cVenCode,b.cVenName,b.cvenabbName,convert(varchar(30),'') as itemClassCode,convert(varchar(30),'') as itemClassName,  
convert(varchar(30),'') as itemCode,convert(varchar(30),'') as itemName,md.MDeptCode as moDeptCode,department.cdepname  as ModeptName,  
CCOMUNITNAME as  CINVM_UNIT,  
b.cdefine1 as cdefine1,b.cdefine2 as cdefine2,b.cdefine3 as cdefine3,  
b.cdefine4 as cdefine4,b.cdefine5 as cdefine5,b.cdefine6 as cdefine6,b.cdefine7 as cdefine7,  
b.cdefine8 as cdefine8,b.cdefine9 as cdefine9,b.cdefine10 as cdefine10,b.cdefine11 as cdefine11,  
b.cdefine12 as cdefine12,b.cdefine13 as cdefine13,b.cdefine14 as cdefine14,b.cdefine15 as cdefine15,  
b.cdefine16 as cdefine16,a.cdefine22 as cdefine22,a.cdefine23 as cdefine23,  
a.cdefine24 as cdefine24,a.cdefine25 as cdefine25,a.cdefine26 as cdefine26,  
a.cdefine27 as cdefine27,a.cdefine28 as cdefine28,a.cdefine29 as cdefine29,  
a.cdefine30 as cdefine30,a.cdefine31 as cdefine31,a.cdefine32 as cdefine32,  
a.cdefine33 as cdefine33,a.cdefine34 as cdefine34,a.cdefine35 as cdefine35,  
a.cdefine36 as cdefine36,a.cdefine37 as cdefine37,  
a.cfree1 as cfree1,a.cfree2 as cfree2,a.cfree3 as cfree3,a.cfree4 as cfree4,a.cfree5 as cfree5,  
a.cfree6 as cfree6,a.cfree7 as cfree7,a.cfree8 as cfree8,a.cfree9 as cfree9,a.cfree10 as cfree10,  
Hy_ListReport.ID,cVoucherType,cBodyID,fQuantity,mReceiveMoney,mUsedvouchMoney,mPurbillMoney,   
fJQuantity,mJMoney,fzQuantity,fzMoney,dRMonth,dUMonth,dPMonth, b.cmaker as cCreateUser,b.dnmaketime as dCreateDate,b.cmodifier as cModifyUser,  
b.dModifyDate,b.cverifier as crelsUser,b.dverifydate as drelsdate,CONVERT(DECIMAL(38,10),NULL) as fqualifiedQuantity,fopScrapquantity,fmaScrapQuantity,fInlostQuantity,fRedoQuantity,  
convert(nvarchar(30),CREDORESPONSE)as CREDORESPONSE,b.ddate as accMonth,d1.cDepCode  as cworkdepcode,d1.cdepname as cworkdepname,sfc_workcenter.Description as cworkcenter ,a.partid,sfc_workcenter.wccode as wccode,b.cvenauthid as cvenauthid,a.cinvauthid as cinvauthid,   
CONVERT(DECIMAL(38,10),NULL) as fReworkJFQty ---added
,(CASE WHEN INO_ID>9999 THEN CAST(INO_ID AS NVARCHAR(10)) ELSE RIGHT('0000'  +CAST(INO_ID AS NVARCHAR(10)),4) END) AS CPZCODE
from Hy_ListReport  
LEFT JOIN GL_ACCVOUCH  ON  GL_ACCVOUCH.COUTNO_ID=HY_LISTREPORT.CPZID   
left join HYSCRAPREPORTBODY a on a.autoid=Hy_ListReport.cBodyID  
left join sfc_moroutingdetail sd on a.isourceautoid= sd.moroutingdid  
left join sfc_workcenter  on sd.wcid=sfc_workcenter.wcid  
left join HYSCRAPREPORTHEAD  b on a.id=b.id  
left join mom_orderdetail md on md.modid= sd.modid   
left join department on department.cdepcode=md.MDeptCode   
left join department as d1  on d1.cdepcode=sfc_workcenter.DeptCode  
where cVoucherType=N'不良品报告单'  
union   
select  a.cMoordercode as moCode,a.imoorderseq as moSeq,md.status as MoStatus,a.opseq,b.cCode,b.ddate,  
a.cInvCode as invcode,a.cinvname as InvName,a.cinvstd as InvSpec,a.cinvaddcode as InvAddCode,  
a.copcode,a.cdescription as description,b.cdepcode,b.cdepname,b.cpersoncode,b.cpersonname,  
b.cVenCode,b.cVenName,b.cvenabbName,convert(varchar(30),'') as itemClassCode,convert(varchar(30),'') as itemClassName,  
convert(varchar(30),'') as itemCode,convert(varchar(30),'') as itemName,md.MDeptCode as moDeptCode,department.cdepname as ModeptName,  
CINVM_UNIT,   
b.cdefine1 as cdefine1,b.cdefine2 as cdefine2,b.cdefine3 as cdefine3,  
b.cdefine4 as cdefine4,b.cdefine5 as cdefine5,b.cdefine6 as cdefine6,b.cdefine7 as cdefine7,  
b.cdefine8 as cdefine8,b.cdefine9 as cdefine9,b.cdefine10 as cdefine10,b.cdefine11 as cdefine11,  
b.cdefine12 as cdefine12,b.cdefine13 as cdefine13,b.cdefine14 as cdefine14,b.cdefine15 as cdefine15,  
b.cdefine16 as cdefine16,a.cdefine22 as cdefine22,a.cdefine23 as cdefine23,  
a.cdefine24 as cdefine24,a.cdefine25 as cdefine25,a.cdefine26 as cdefine26,  
a.cdefine27 as cdefine27,a.cdefine28 as cdefine28,a.cdefine29 as cdefine29,  
a.cdefine30 as cdefine30,a.cdefine31 as cdefine31,a.cdefine32 as cdefine32,  
a.cdefine33 as cdefine33,a.cdefine34 as cdefine34,a.cdefine35 as cdefine35,  
a.cdefine36 as cdefine36,a.cdefine37 as cdefine37,  
a.cfree1 as cfree1,a.cfree2 as cfree2,a.cfree3 as cfree3,a.cfree4 as cfree4,a.cfree5 as cfree5,  
a.cfree6 as cfree6,a.cfree7 as cfree7,a.cfree8 as cfree8,a.cfree9 as cfree9,a.cfree10 as cfree10,  
Hy_ListReport.ID,cVoucherType,cBodyID,fQuantity,mReceiveMoney,mUsedvouchMoney,mPurbillMoney,   
fJQuantity,mJMoney,fzQuantity,fzMoney,dRMonth,dUMonth,dPMonth, b.cmaker as cCreateUser,b.ddate as dCreateDate,b.cmodifier as cModifyUser,  
b.dModifyDate,b.cverifier as crelsUser,b.dverifydate as drelsdate,a.fvalidquantity as fqualifiedQuantity,a.fopScrapquantity,a.fmaScrapQuantity,a.fInlostQuantity,CONVERT(DECIMAL(38,10),NULL) as  fRedoQuantity,  
convert(varchar(30),'') as CREDORESPONSE,b.ddate as accMonth,d1.cDepCode  as cworkdepcode,d1.cdepname as cworkdepname,sfc_workcenter.Description as cworkcenter ,a.partid,sfc_workcenter.wccode as wccode,b.cvenauthid as cvenauthid,a.cinvauthid as cinvauthid,     
a.FREWORKJFQTY as fReworkJFQty    ---added
,(CASE WHEN INO_ID>9999 THEN CAST(INO_ID AS NVARCHAR(10)) ELSE RIGHT('0000'  +CAST(INO_ID AS NVARCHAR(10)),4) END) AS CPZCODE
from Hy_ListReport   
LEFT JOIN GL_ACCVOUCH  ON  GL_ACCVOUCH.COUTNO_ID=HY_LISTREPORT.CPZID
left join HY_USEDBODY  a on a.autoid=Hy_ListReport.cBodyID  
left join HY_USEDHEAD   b on a.id=b.id  
left join hy_modetails on a.ihyorderdid =hy_modetails.autoid
left join mom_order on  a.cmoordercode =mom_order.mocode
left join mom_orderdetail md on  mom_order.moid=md.moid and a.imoorderseq=md.sortseq  
--有可能存在对应的挂账单 无对应的加工单的情况
--left join sfc_moroutingdetail sd on hy_modetails.isourceautoid =sd.moroutingdid
left join sfc_moroutingdetail sd on md.modid =sd.modid and a.opseq=sd.opseq
left join sfc_workcenter  on sd.wcid=sfc_workcenter.wcid  
left join department on department.cdepcode=md.MDeptCode   
left join department as d1  on d1.cdepcode=sfc_workcenter.DeptCode  
where cVoucherType=N'挂账单'  

union   
select  hy_usedvouchs.cmoordercode as moCode,hy_usedvouchs.imoorderseq as  moSeq,md.status as MoStatus,a.opseq,b.cpbvcode as cCode,b.DPBVDATE as ddate,  
a.cInvCode as invcode,a.cinvname as InvName,a.cinvstd as InvSpec,a.cinvaddcode as InvAddCode,  
a.copcode,a.cdescription as description,b.cdepcode,b.cdepname,b.cpersoncode,b.cpersonname,  
b.cVenCode,b.cVenName,b.cvenabbName,convert(varchar(30),'') as itemClassCode,convert(varchar(30),'') as itemClassName,  
convert(varchar(30),'') as itemCode,convert(varchar(30),'') as itemName,md.MDeptCode as moDeptCode,department.cdepname as ModeptName,  
CINVM_UNIT,   
b.cdefine1 as cdefine1,b.cdefine2 as cdefine2,b.cdefine3 as cdefine3,  
b.cdefine4 as cdefine4,b.cdefine5 as cdefine5,b.cdefine6 as cdefine6,b.cdefine7 as cdefine7,  
b.cdefine8 as cdefine8,b.cdefine9 as cdefine9,b.cdefine10 as cdefine10,b.cdefine11 as cdefine11,  
b.cdefine12 as cdefine12,b.cdefine13 as cdefine13,b.cdefine14 as cdefine14,b.cdefine15 as cdefine15,  
b.cdefine16 as cdefine16,a.cdefine22 as cdefine22,a.cdefine23 as cdefine23,  
a.cdefine24 as cdefine24,a.cdefine25 as cdefine25,a.cdefine26 as cdefine26,  
a.cdefine27 as cdefine27,a.cdefine28 as cdefine28,a.cdefine29 as cdefine29,  
a.cdefine30 as cdefine30,a.cdefine31 as cdefine31,a.cdefine32 as cdefine32,  
a.cdefine33 as cdefine33,a.cdefine34 as cdefine34,a.cdefine35 as cdefine35,  
a.cdefine36 as cdefine36,a.cdefine37 as cdefine37,  
a.cfree1 as cfree1,a.cfree2 as cfree2,a.cfree3 as cfree3,a.cfree4 as cfree4,a.cfree5 as cfree5,  
a.cfree6 as cfree6,a.cfree7 as cfree7,a.cfree8 as cfree8,a.cfree9 as cfree9,a.cfree10 as cfree10,  
Hy_ListReport.ID,cVoucherType,cBodyID,fQuantity,mReceiveMoney,mUsedvouchMoney,mPurbillMoney,   
fJQuantity,mJMoney,fzQuantity,fzMoney,dRMonth,dUMonth,dPMonth, b.cpbvmaker as cCreateUser,b.dpbvdate as dCreateDate,b.creviser as cModifyUser,  
b.cModifyDate as dModifyDate,convert(varchar(30),'') as crelsUser,'' as drelsdate,CONVERT(DECIMAL(38,10),NULL) as fqualifiedQuantity,CONVERT(DECIMAL(38,10),NULL) as fopScrapquantity ,CONVERT(DECIMAL(38,10),NULL) as fmaScrapQuantity,
CONVERT(DECIMAL(38,10),NULL)as fInlostQuantity,CONVERT(DECIMAL(38,10),NULL) as fRedoQuantity,   
convert(varchar(30),'') as CREDORESPONSE,dPBVdate as accMonth,d1.cDepCode  as cworkdepcode, d1.cdepname as cworkdepname,sfc_workcenter.Description as cworkcenter,hy_usedvouchs.partid as partid,sfc_workcenter.wccode as wccode,b.cvenauthid as cvenauthid,a.cinvauthid as cinvauthid,         
CONVERT(DECIMAL(38,10),NULL) as fReworkJFQty ---added
,(CASE WHEN INO_ID>9999 THEN CAST(INO_ID AS NVARCHAR(10)) ELSE RIGHT('0000'  +CAST(INO_ID AS NVARCHAR(10)),4) END) AS CPZCODE
from Hy_ListReport           
LEFT JOIN GL_ACCVOUCH  ON  GL_ACCVOUCH.COUTNO_ID=HY_LISTREPORT.CPZID   
left join HY_BILLBODY  a on a.id=Hy_ListReport.cBodyID  
left join HY_BILLHEAD  b on a.PBVID=b.PBVID  
left join hy_usedvouchs on a.rdsid=hy_usedvouchs.autoid  
left join hy_modetails on a.ihyorderdid =hy_modetails.autoid
left join mom_order on  hy_usedvouchs.cmoordercode =mom_order.mocode
left join mom_orderdetail md on  mom_order.moid=md.moid and hy_usedvouchs.imoorderseq=md.sortseq  
--有可能存在对应的挂账单 无对应的加工单的情况
--left join sfc_moroutingdetail sd on hy_modetails.isourceautoid =sd.moroutingdid
left join sfc_moroutingdetail sd on md.modid =sd.modid and a.opseq=sd.opseq
left join sfc_workcenter  on sd.wcid=sfc_workcenter.wcid
left join department on department.cdepcode=md.MDeptCode   
left join department as d1  on d1.cdepcode=sfc_workcenter.DeptCode  
where cVoucherType=N'发票'  


效率测试报告：开始升级UFDATA_001_2010数据库
data_str_pb_wfmodel_nl.SQL，2012-2-28 16:09:57 -- 2012-2-28 16:10:03，0小时0分钟6秒。
data_str_pb_mommodel_nl.SQL，2012-2-28 16:10:03 -- 2012-2-28 16:10:06，0小时0分钟3秒。
data_str_pb_portalmodel_nl.SQL，2012-2-28 16:10:06 -- 2012-2-28 16:10:10，0小时0分钟4秒。
data_str_pb_ufsubmodel_nl.SQL，2012-2-28 16:10:10 -- 2012-2-28 16:10:10，0小时0分钟0秒。
Data_STR_PB_DR_NL.SQL，2012-2-28 16:10:10 -- 2012-2-28 16:10:11，0小时0分钟1秒。
Data_STR_PB_mix_NL.SQL，2012-2-28 16:10:11 -- 2012-2-28 16:10:15，0小时0分钟4秒。
Data_STR_PB_Vou_NL.SQL，2012-2-28 16:10:15 -- 2012-2-28 16:10:15，0小时0分钟0秒。
data_str_pb_uap_nl.SQL，2012-2-28 16:10:15 -- 2012-2-28 16:10:15，0小时0分钟0秒。
data_str_pb_as_nl.SQL，2012-2-28 16:10:15 -- 2012-2-28 16:10:27，0小时0分钟12秒。
data_str_pb_start_nl.SQL，2012-2-28 16:10:27 -- 2012-2-28 16:10:27，0小时0分钟0秒。
data_str_pb_dae_nl.SQL，2012-2-28 16:10:27 -- 2012-2-28 16:10:27，0小时0分钟0秒。
workflow_str_pb_mix_nl.SQL，2012-2-28 16:10:27 -- 2012-2-28 16:10:27，0小时0分钟0秒。
Data_STR_SR_mix_NL.SQL，2012-2-28 16:10:27 -- 2012-2-28 16:10:30，0小时0分钟3秒。
data_str_rt_mix_nl.SQL，2012-2-28 16:10:30 -- 2012-2-28 16:10:30，0小时0分钟0秒。
data_str_ss_mix_nl.SQL，2012-2-28 16:10:30 -- 2012-2-28 16:10:30，0小时0分钟0秒。
data_str_wa_mix_nl.SQL，2012-2-28 16:10:30 -- 2012-2-28 16:10:35，0小时0分钟5秒。
Data_STR_HR_TM_mix_NL.SQL，2012-2-28 16:10:35 -- 2012-2-28 16:10:40，0小时0分钟5秒。
Data_STR_HR_TR_mix_NL.SQL，2012-2-28 16:10:40 -- 2012-2-28 16:10:40，0小时0分钟0秒。
data_str_ht_mix_nl.SQL，2012-2-28 16:10:40 -- 2012-2-28 16:10:40，0小时0分钟0秒。
data_str_pr_mix_nl.SQL，2012-2-28 16:10:40 -- 2012-2-28 16:10:41，0小时0分钟1秒。
data_str_pf_mix_nl.SQL，2012-2-28 16:10:41 -- 2012-2-28 16:10:56，0小时0分钟15秒。
data_str_hb_mix_nl.SQL，2012-2-28 16:10:56 -- 2012-2-28 16:10:57，0小时0分钟1秒。
data_str_hm_mix_nl.SQL，2012-2-28 16:10:57 -- 2012-2-28 16:10:57，0小时0分钟0秒。
data_str_wm_mix_nl.SQL，2012-2-28 16:10:57 -- 2012-2-28 16:10:57，0小时0分钟0秒。
data_str_sg_mix_nl.SQL，2012-2-28 16:10:57 -- 2012-2-28 16:11:01，0小时0分钟4秒。
data_str_wh_mix_nl.SQL，2012-2-28 16:11:01 -- 2012-2-28 16:11:01，0小时0分钟0秒。
DATA_STR_FA_MIX_NL.SQL，2012-2-28 16:11:01 -- 2012-2-28 16:11:17，0小时0分钟16秒。
Data_STR_CM_mix_NL.SQL，2012-2-28 16:11:17 -- 2012-2-28 16:11:20，0小时0分钟3秒。
Data_STR_FD_mix_NL.SQL，2012-2-28 16:11:20 -- 2012-2-28 16:11:22，0小时0分钟2秒。
data_str_ed_mix_nl.SQL，2012-2-28 16:11:22 -- 2012-2-28 16:11:53，0小时0分钟31秒。
Data_STR_EQ_mix_NL.SQL，2012-2-28 16:11:53 -- 2012-2-28 16:11:58，0小时0分钟5秒。
Data_STR_NE_mix_NL.SQL，2012-2-28 16:11:58 -- 2012-2-28 16:11:59，0小时0分钟1秒。
Data_STR_NB_Mix_NL.SQL，2012-2-28 16:11:59 -- 2012-2-28 16:12:00，0小时0分钟1秒。
Data_STR_PM_mix_NL.SQL，2012-2-28 16:12:00 -- 2012-2-28 16:12:09，0小时0分钟9秒。
DATA_STR_BG_MIX_NL.SQL，2012-2-28 16:12:09 -- 2012-2-28 16:12:27，0小时0分钟18秒。
Data_STR_FM_mix_NL.SQL，2012-2-28 16:12:27 -- 2012-2-28 16:12:28，0小时0分钟1秒。
Data_STR_GL_mix_NL.SQL，2012-2-28 16:12:28 -- 2012-2-28 16:12:39，0小时0分钟11秒。
data_str_gf_mix_nl.SQL，2012-2-28 16:12:39 -- 2012-2-28 16:12:39，0小时0分钟0秒。
Data_STR_CA_mix_NL.SQL，2012-2-28 16:12:39 -- 2012-2-28 16:13:16，0小时0分钟37秒。
Data_STR_AP_mix_NL.SQL，2012-2-28 16:13:16 -- 2012-2-28 16:13:26，0小时0分钟10秒。
data_str_sc_mix_nl.SQL，2012-2-28 16:13:26 -- 2012-2-28 16:13:26，0小时0分钟0秒。
Data_STR_EX_mix_NL.SQL，2012-2-28 16:13:26 -- 2012-2-28 16:13:41，0小时0分钟15秒。
Data_STR_IM_mix_NL.SQL，2012-2-28 16:13:41 -- 2012-2-28 16:13:44，0小时0分钟3秒。
data_str_sa_mix_nl.SQL，2012-2-28 16:13:44 -- 2012-2-28 16:13:55，0小时0分钟11秒。
Data_STR_ST_mix_NL.SQL，2012-2-28 16:13:55 -- 2012-2-28 16:14:13，0小时0分钟18秒。
Data_STR_PU_mix_NL.SQL，2012-2-28 16:14:13 -- 2012-2-28 16:14:21，0小时0分钟8秒。
data_str_scm_mix_nl.SQL，2012-2-28 16:14:21 -- 2012-2-28 16:14:21，0小时0分钟0秒。
Data_STR_QM_mix_NL.SQL，2012-2-28 16:14:21 -- 2012-2-28 16:14:25，0小时0分钟4秒。
Data_STR_IA_mix_NL.SQL，2012-2-28 16:14:25 -- 2012-2-28 16:14:34，0小时0分钟9秒。
Data_STR_OM_mix_NL.SQL，2012-2-28 16:14:34 -- 2012-2-28 16:14:35，0小时0分钟1秒。
DATA_STR_PA_MIX_NL.SQL，2012-2-28 16:14:35 -- 2012-2-28 16:14:35，0小时0分钟0秒。
    升级起始时间：2012-2-28 16:09:56，结束时间：2012-2-28 16:14:49，0小时4分钟53秒。

sylovesy

是升级到U810.1 不是U810 求助有哪位好友知道，求解。

Syhwq

看看这个  可能对你有帮助https://www.oyonyou.com/home.php ... do=blog&id=3199

ym00

怎么解决的？

wpsdujin

建议先升级到U810.0；首先，安装u810.0软件及所有补丁后升级，然后再升级到U8 10.1

gyd601318367

这你解决了吗？怎么解决的？的我也遇到这问题了。着急啊。

xmzlwyq

我的好像没这个问题 是不是数据库的问题
数据库 不一样导致升级失败的可能性也有

比如说 u890 的sql2008  升级到U810.1的sql2005 当然sql2008原版 不是R2的话也会出问题

gyd601318367

我想知道这是怎么解决的我现在也遇到这个问题了。

hjq406

也遇到了如何处理