T6升级U8错误

a455603208

数据库名: UFDATA_001_2003
D:\U8SOFT\Admin\SQLFILE10000\Main\Ufdata\Structure\DATA_STR_FA_MIX_NL.sql
错误信息:
-2147217865
对象名 'dbo.Fa_GetLoginYear' 无效。
执行如下语句时出错:

CREATE VIEW [dbo].[fa_Q_Cards_New_PM] AS
SELECT fa_AssetTypes.sName AS sTypeName, fa_AssetTypes.sUnit,
fa_Depreciations.sName AS sMethodName, fa_Origins.sName AS sOrgName, fa_Status.sName AS sStatusName,
fa_WorkLoad.dblWork0, fa_WorkLoad.dblWorkT0, fa_WorkLoad.dblWork1, fa_WorkLoad.dblWorkT1,
fa_WorkLoad.dblWork2, fa_WorkLoad.dblWorkT2, fa_WorkLoad.dblWork3, fa_WorkLoad.dblWorkT3,
fa_WorkLoad.dblWork4, fa_WorkLoad.dblWorkT4, fa_WorkLoad.dblWork5, fa_WorkLoad.dblWorkT5,
fa_WorkLoad.dblWork6, fa_WorkLoad.dblWorkT6, fa_WorkLoad.dblWork7, fa_WorkLoad.dblWorkT7,
fa_WorkLoad.dblWork8, fa_WorkLoad.dblWorkT8, fa_WorkLoad.dblWork9, fa_WorkLoad.dblWorkT9,
fa_WorkLoad.dblWork10, fa_WorkLoad.dblWorkT10, fa_WorkLoad.dblWork11, fa_WorkLoad.dblWorkT11,
fa_WorkLoad.dblWork12, fa_WorkLoad.dblWorkT12, fa_WorkLoad.dblPerDepr0, fa_WorkLoad.dblPerDepr1,
fa_WorkLoad.dblPerDepr2, fa_WorkLoad.dblPerDepr3, fa_WorkLoad.dblPerDepr4, fa_WorkLoad.dblPerDepr5,
fa_WorkLoad.dblPerDepr6, fa_WorkLoad.dblPerDepr7, fa_WorkLoad.dblPerDepr8, fa_WorkLoad.dblPerDepr9,
fa_WorkLoad.dblPerDepr10, fa_WorkLoad.dblPerDepr11, fa_WorkLoad.dblPerDepr12, fa_WorkLoad.dblDeprWorkThisYear,
fa_DeprTransactions.dblInputValue, fa_DeprTransactions.dblInputDeprTotal, fa_DeprTransactions.dblInputBV,
fa_DeprTransactions.dblInputBVRate, fa_DeprTransactions.dblInputCanWork, fa_DeprTransactions.dblInputWorkTotal,
fa_DeprTransactions.lInputLife, fa_DeprTransactions.lInputDeprMonths, fa_DeprTransactions.dblDepr0, fa_DeprTransactions.dblDeprRate0, fa_DeprTransactions.dblDeprT0, fa_DeprTransactions.lDeprMonths0,
fa_DeprTransactions.lUsedMonths0, fa_DeprTransactions.dblDepr1, fa_DeprTransactions.dblDeprRate1, fa_DeprTransactions.dblDeprT1, fa_DeprTransactions.lDeprMonths1, fa_DeprTransactions.lUsedMonths1, fa_DeprTransactions.dblDepr2, fa_DeprTransactions.dblDeprRate2, fa_DeprTransactions.dblDeprT2, fa_DeprTransactions.lDeprMonths2, fa_DeprTransactions.lUsedMonths2, fa_DeprTransactions.dblDepr3, fa_DeprTransactions.dblDeprRate3, fa_DeprTransactions.dblDeprT3, fa_DeprTransactions.lDeprMonths3, fa_DeprTransactions.lUsedMonths3, fa_DeprTransactions.dblDepr4, fa_DeprTransactions.dblDeprRate4, fa_DeprTransactions.dblDeprT4, fa_DeprTransactions.lDeprMonths4, fa_DeprTransactions.lUsedMonths4, fa_DeprTransactions.dblDepr5, fa_DeprTransactions.dblDeprRate5, fa_DeprTransactions.dblDeprT5, fa_DeprTransactions.lDeprMonths5, fa_DeprTransactions.lUsedMonths5, fa_DeprTransactions.dblDepr6, fa_DeprTransactions.dblDeprRate6, fa_DeprTransactions.dblDeprT6, fa_DeprTransactions.lDeprMonths6, fa_DeprTransactions.lUsedMonths6, fa_DeprTransactions.dblDepr7, fa_DeprTransactions.dblDeprRate7, fa_DeprTransactions.dblDeprT7, fa_DeprTransactions.lDeprMonths7, fa_DeprTransactions.lUsedMonths7, fa_DeprTransactions.dblDepr8, fa_DeprTransactions.dblDeprRate8, fa_DeprTransactions.dblDeprT8, fa_DeprTransactions.lDeprMonths8, fa_DeprTransactions.lUsedMonths8, fa_DeprTransactions.dblDepr9, fa_DeprTransactions.dblDeprRate9, fa_DeprTransactions.dblDeprT9, fa_DeprTransactions.lDeprMonths9, fa_DeprTransactions.lUsedMonths9, fa_DeprTransactions.dblDepr10, fa_DeprTransactions.dblDeprRate10, fa_DeprTransactions.dblDeprT10, fa_DeprTransactions.lDeprMonths10, fa_DeprTransactions.lUsedMonths10, fa_DeprTransactions.dblDepr11, fa_DeprTransactions.dblDeprRate11, fa_DeprTransactions.dblDeprT11, fa_DeprTransactions.lDeprMonths11, fa_DeprTransactions.lUsedMonths11, fa_DeprTransactions.dblDepr12, fa_DeprTransactions.dblDeprRate12, fa_DeprTransactions.dblDeprT12, fa_DeprTransactions.lDeprMonths12, fa_DeprTransactions.lUsedMonths12, fa_DeprTransactions.dblMonthValue0, fa_DeprTransactions.dblMonthValue1, fa_DeprTransactions.dblMonthValue2, fa_DeprTransactions.dblMonthValue3, fa_DeprTransactions.dblMonthValue4, fa_DeprTransactions.dblMonthValue5, fa_DeprTransactions.dblMonthValue6, fa_DeprTransactions.dblMonthValue7, fa_DeprTransactions.dblMonthValue8, fa_DeprTransactions.dblMonthValue9, fa_DeprTransactions.dblMonthValue10, fa_DeprTransactions.dblMonthValue11, fa_DeprTransactions.dblMonthValue12, fa_DeprTransactions.dblDeprThisYear,
fa_cards.scardid,fa_Cards.sCardNum,fa_cards.sassetnum,fa_Cards.sassetname,fa_Cards.loptid,fa_Cards.iopttype,fa_Cards.inewtype,fa_Cards.szwvouchertype,fa_Cards.szwvouchernum,fa_Cards.sdeptnum,fa_cards.sDeptNames,fa_Cards.stypenum,fa_Cards.sorgid,fa_Cards.sorgaddid,fa_Cards.sorgdisposeid,fa_Cards.sdisposereason,fa_Cards.sstatusid,fa_Cards.sdeprmethodid,fa_Cards.scurrency,fa_Cards.sdeprsubjectnum,fa_Cards.sdeprsubjectname,fa_Cards.sprojectnum,fa_Cards.sprojectname,fa_Cards.sstyle,fa_Cards.dblbuildarea,fa_Cards.lbuildnum,fa_Cards.lmachinnum,fa_Cards.dblmachinw,fa_Cards.ssite,fa_Cards.llife,fa_Cards.dstartdate,fa_Cards.dinputdate,fa_Cards.dtransdate,fa_Cards.ddisposedate,fa_Cards.iinputperiod,fa_Cards.idisposeperiod,fa_Cards.dblfcvalue,fa_Cards.dblexchangerate,fa_Cards.soperator,fa_Cards.sdisposer,fa_Cards.dblnetvalueact,fa_Cards.ldeprmonthsact,fa_Cards.dblcanworkact,fa_Cards.dbllegacy,fa_Cards.svouchernum,fa_Cards.sevaluatenum,fa_Cards.dblvalue,fa_Cards.dbldecdeprt,fa_Cards.dbldecdepr,fa_Cards.dbldecdeprrate,fa_Cards.dblbv,fa_Cards.dblbvrate,fa_Cards.dblcanwork,fa_Cards.dblperdepr
哪位大侠见过上面的升级错误；数据已经是从T6升级工具中输出U8的

37724861

用书生的脚本可以解决

lxz329198398

书生威武啊  去找书生吧

lihuaren007

从升级好的数据，导出fa_card的脚本，到升级不成功的数据，删掉，重新生成这个fa_card应该可以了，做之前备份，我之前好像是这样子处理的！

hangbing5530

可联系我Ｑ1113713506解决