欢迎来到,我们已经为1000多家客户提供专业的软件服务!
技术电话:010-84986180 手机:13720089039
用友升级后无法执行脚本
2023-11-07 11:04:00 来源: 浏览:6

在有问题的年度执行以下脚本降级后再升级试一下:

update accinformation set cvalue='8.216',cdefault='8.216' where cname='versionflag'

drop table rpt_flddef,rpt_fltdef,rpt_glbdef,rpt_grpdef,rpt_reldef,rpt_folder,rpt_itmdef

select * into rpt_flddef from UFDATA_999_2011..rpt_flddef
select * into rpt_fltdef  from UFDATA_999_2011..rpt_fltdef
select * into rpt_glbdef  from UFDATA_999_2011..rpt_glbdef
select * into rpt_grpdef  from UFDATA_999_2011..rpt_grpdef
select * into rpt_reldef from UFDATA_999_2011..rpt_reldef
select * into rpt_folder from UFDATA_999_2011..rpt_folder
select * into rpt_itmdef from UFDATA_999_2011..rpt_itmdef

 

然后在企业管理器中,找到rpt_flddef,右键点击,设计表,删除CurGroupCol,CurSubTotalCol (每个年度都要操作)

然后进入系统管理进行sql数据升级

友情链接