读取套帐[001是否集团版套帐时失败,可能是数据库没有没升级

renzhi6016

读取套帐[001是否集团版套帐时失败,可能是数据库没有没升级

在将用友V821升级到V852时，先将备份文件引入均正常，在升级SQL数据时，只出现了成本管理库错误，其他均正常，但升级后的数据库，在登录时，出现“读取套帐[001］是否集团版套帐时失败,可能是数据库没有没升级”，不知道是何原因？怎么解决啊？急求帮助！！

sxfht

重新升级数据后正常，升级前执行： -------------------------------------------------------------------------------------------
CREATE view caq_serviceprice as select max(iperiod) as iperiod, max(cprocedureid) as cprocedureid, sum(itotalamo)/sum(iqua) as price from ca_samoct group by cprocedureid
go
-------------------------------------------------------------------------------------------
CREATE view caq_predepdata as select '专用' as cType,a.iperiod,a.cdeptid,0 as amotypeno,'0' as amotype , a.cmatid as amoid,a.iqua as curqua,a.imatqua as curamo,b.irestqua as endqua, b.iprice * b.irestqua as endamo from ca_mabsw a left join ca_enmmc b on a.cdeptid=b.cdeptid and a.cmatid=b.cmatid and a.iperiod = b.iperiod where a.cppid is null union SELECT '共用' ,a.iperiod, a.cdeptid, 0 AS amotypeno, '0' AS amotype, a.cmatid AS amoid, a.iqua AS curqua, a.imatqua AS curamo, b.irestqua AS endqua,b.iprice * b.irestqua AS endamo FROM ca_mabsw a LEFT JOIN ca_enmom b ON a.cdeptid = b.cdeptid AND a.cmatid = b.cmatid AND a.iperiod = b.iperiod where a.cppid is not null Union select '废品' ,max(a.iperiod),max(b.cdepcode),1,'0','-1',0,sum(irecamo),0,0 from ca_waspr a,productstructureex b where a.cppid = b.cpspcode group by cdepcode Union select '' ,iperiod,cdeptid,2,'3',camoid,0,imanamo,0,0 from ca_manct Union select '' ,a.iperiod,a.cdeptid,3,'2',a.cprocedureid,a.iqua,a.iqua* b.price,0,0 from ca_asscw a , caq_serviceprice b where a.iperiod=b.iperiod and a.cprocedureid=b.cprocedureid Union select '' ,max(iperiod),max(cdeptid),4,'4',max(cothamoid),0,sum(iothamo),0,0 from ca_onlia group by cdeptid,iperiod,cothamoid Union select '' ,iperiod,cdeptid,5,'1','',0,iDirectPay,0,0 from ca_dirma
go
-------------------------------------------------------------------------------------------
CREATE VIEW ca_inventory AS SELECT Inventory.cInvCode, Inventory.cInvName, Inventory.cInvStd,Inventory.iInvRCost, Inventory.cInvCCode, ComputationUnit.cComUnitName AS cInvM_Unit,InventoryClass.cInvCName FROM Inventory LEFT OUTER JOIN InventoryClass ON Inventory.cInvCCode = InventoryClass.cInvCCode LEFT OUTER JOIN ComputationUnit ON Inventory.cComunitCode = ComputationUnit.cComunitCode
go
-------------------------------------------------------------------------------------------
CREATE view caq_amoname as select distinct 1 as amotypeno,'0' as amotype,'材料费用' as amotypename,b.cinvcode as amoid, b.cinvname as amoname,b.cinvccode as cinvccode ,b.cinvcname as cinvcname, b.cinvstd as cinvstd,b.cinvm_unit as cunit from ca_amoct a,ca_inventory b where a.camoid= b.cinvcode Union select 2 as amotypeno,'0','材料费用','-1','废品回收','','','','' Union select 3 as amotypeno,'3','制造费用',camoid,camoname,'','','','' from caq_manufacture Union select 4 as amotypeno,'2','辅助费用',cprocedureid,cprocedurename,'','','','' from ca_predf where bisauxi<>0 Union select 5 as amotypeno,'4','其他费用',camoid,camoname,'','','','' from caq_others Union select 6 as amotypeno,'1','人工费用','','直接人工','','','',''
go
-------------------------------------------------------------------------------------------
CREATE view caq_depdata as select a.iperiod as 期间,a.cdeptid as 部门编码,b.cdepname as 部门名称, a.amotypeno as 费用类型序号,a.amotype as 费用类型编码,c.amotypename as 费用类型名称, a.cType as 材料类别, c.cinvccode as 存货分类编码,c.cinvcname as 存货分类名称, a.amoid as 费用明细编码,c.amoname as 费用明细名称, a.curqua as 本期发生数量, a.curamo as 本期发生金额, a.endqua as 期末盘存数量,a.endamo as 期末盘存金额 from caq_predepdata a,department b,caq_amoname c Where a.cdeptid = b.cDepCode and a.amotype=c.amotype and a.amoid=c.amoid
go
-------------------------------------------------------------------------------------------
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CA_IDMAC]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CA_IDMAC] GO CREATE TABLE [dbo].[CA_IDMAC] ( [cOutID] [varchar] (5) COLLATE Chinese_PRC_CI_AS NOT NULL , [cOutName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [bType] [bit] NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[CA_IDMAC] ADD CONSTRAINT [aaaaaCA_IDMAC_PK] PRIMARY KEY NONCLUSTERED ( [cOutID] ) ON [PRIMARY]
GO

quanxiaojing

你搜索一下我的帖子，里面有这个问题，已经解决了，希望能帮到你

renzhi6016

我试了，不行。总共两个年度的帐第二年度的和正常，第一年的出现那个问题，改过后还是不行，升级时提示成本管理出现错误，改过后升级还会出现其他的错误，都是成本模块的，是不是这个升级的问题啊？谢谢！

renzhi6016

在我的机子上还有问题，换了个机子可以了，谢谢你！真是帮大忙了，搞的头都大了。

[ 本帖最后由 renzhi6016 于 2007-10-26 12:07 编辑 ]

renzhi6016

非常感谢你的回复！用你的法子把问题解决了，再次谢谢，感觉你真是太厉害了，向你学习！！呵呵！谢谢！

dongguaren

6# 我试试..

zhaoqiongyu

怎么样看到帖子呢?我找不到,帮忙指点