kljhg1 发表于 2014-1-20 22:44:10

用友T310.8P1升级账套报错iTaxUnitPrice解决方法

本帖最后由 kljhg1 于 2014-1-20 22:48 编辑


在升级账套某一年度时报错，ZPURRKDLIST这个表在视图里面，列名也在这个表里，
反正就是它没错，但是就是升级报失败，
用友数据库对比了一下数据库：
"","对象名","状态","名称"
"1","视图","缺","ST_WareHouseWarnInfoView"
"2","视图","缺","PurBillNoVerify"
"3","视图","缺","SA_KHQJDZD_Detail"
"4","视图","缺","PUR_ORDER_EX"
"5","视图","缺","MC_SendMsgView"
"6","视图","缺","AP_Cancel1ZJYCB"
"7","视图","缺","AR_Cancel1ZJYCB"
"8","视图","缺","MC_SendMsg_HistoryView"
"9","视图","缺","MC_SendMsg_DHistoryView"
"10","视图","缺","MC_SendMsg_HHistoryView"
"11","视图","缺","MatchVouchPLRK"
"12","视图","缺","MP_SOToMatchVoucher"
"13","视图","缺","CostDistributeInSQ"
"14","视图","缺","CostDistributeInList"
"15","视图","缺","CostDistributeInQ"
"16","视图","缺","Ap_DetailCust_V"
"17","视图","缺","Ap_SalBillCust_V"
"18","视图","缺","AR_ApVouch_V"
"19","视图","缺","Ap_CloseCust_V"
"20","视图","缺","V_OutNotBalance"
"21","视图","缺","AP_DetailZQ"
"22","视图","缺","Sa_BillAgeViewZQ"
"23","视图","缺","CJZF_Ap_Receive"
"24","视图","缺","Ap_DetailCust_ZQ"
"25","视图","缺","CJZF_Ap_Payment"
"26","视图","缺","Ap_DetailVend_ZQ"
"27","视图","缺","Ap_ViewNoVerifySBV_ZQ"
"28","视图","缺","RetBatch"
"29","视图","缺","PurRdrecordV"

以上只是单独 “视图”里面少的，反正很多啊，整个数据库少的更多，参考一下吧


解决方法：
1：USE UFDATA_001_2012
update accinformation set cvalue='8.216' where csysid='AA' and cid='99'
升级SQL数据吧，个人运气比较好，没报错直接就跳成功了！

2：打开账套后发现报错：
复制MC梦先生！
此方法留为自己备用，



zh3305 发表于 2014-1-20 22:56:11

没太明白怎么成功的..是因为以前补丁没打全的原因吗?

kljhg1 发表于 2014-1-20 22:59:24

zh3305 发表于 2014-1-20 22:56
没太明白怎么成功的..是因为以前补丁没打全的原因吗?

降低版本号，达到升级SQL成功，

zh3305 发表于 2014-1-20 23:00:28

kljhg1 发表于 2014-1-20 22:59
降低版本号，达到升级SQL成功，

这样也可以哦, 又学到一招了

37724861 发表于 2014-1-21 09:21:57

降低版本号，从低版本开始执行脚本而已

胖砸哦 发表于 2023-7-22 15:30:47

非常感谢您的分享，很有用哦

janyqi 发表于 2023-8-4 11:54:06

非常感谢您的分享，很有用哦

janyzjq 发表于 2023-8-4 14:34:56

非常感谢您的分享，很有用哦

janyzjq 发表于 2023-8-7 08:34:10

感谢分享

janyzjq 发表于 2023-8-8 08:15:56

感谢分享

janyqi 发表于 2023-8-8 08:16:03

感谢分享
页: [1]
查看完整版本: 用友T310.8P1升级账套报错iTaxUnitPrice解决方法