U890升级U10最难错误，怎么解决求高人知道！！！

用友软件（15209

数据库名: UFDATA_011_2008
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,fa_Cards.lusedmonths,fa_Cards.sworkunit,fa_Cards.dbltransindeprtcard,fa_Cards.ivouchsnextmonthact,fa_Cards.stranstypenum,fa_Cards.stransdeptenum,fa_Cards.slockedby
FROM ((((((((fa_Cards INNER JOIN fa_Q_YXKP_NEW ON fa_Cards.sCardID = fa_Q_YXKP_NEW.sCardID)
INNER JOIN fa_AssetTypes ON fa_Cards.sTypeNum = fa_AssetTypes.sNum))
LEFT JOIN fa_Depreciations ON fa_Cards.sDeprMethodID = fa_Depreciations.sID)
LEFT JOIN fa_Origins ON fa_Cards.sOrgID = fa_Origins.sID)
LEFT JOIN fa_Status ON fa_Cards.sStatusID = fa_Status.sID)
LEFT JOIN fa_WorkLoad ON fa_Cards.sCardNum = fa_WorkLoad.sCardNum and fa_WorkLoad.iyear=dbo.Fa_GetLoginYear()))
INNER JOIN fa_DeprTransactions ON fa_Cards.sCardNum = fa_DeprTransactions.sCardNum and fa_DeprTransactions.iyear = dbo.Fa_GetLoginYear()

用友软件（15209

:L:L:L:L:L:L:L:L:L:L:L怎么没有人回答啊！！！

lihuaren007

这个问题我也遇到了，不知道怎样解决！如果按照提示修改数据库的话，只会无休止的报错，我郁闷啊！

wozengcong

lihuaren007 发表于 2011-11-15 17:21

                               
登录/注册后可看大图

这个问题我也遇到了，不知道怎样解决！如果按照提示修改数据库的话，只会无休止的报错，我郁闷啊！

和我以前一样也是越改越多越麻烦啊

用友软件（15209

那你们最后是怎么处理的！

wgf5551112

找到，FA-CARDS表，所有任务，生成脚本，然后复制到查询分析器里执行下就可以了

用友软件（15209

wgf5551112 发表于 2011-12-20 23:08

                               
登录/注册后可看大图

找到，FA-CARDS表，所有任务，生成脚本，然后复制到查询分析器里执行下就可以了

哥们你说的方法我试过了，要是修改的话会一直报错下去！！！

用友软件（15209

还是没有好的处理方案！！！！