用友升级后无法执行脚本

分享到:

2014-01-23 22:58:59

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

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数据升级

声明:此篇为用友服务中心文章,转载请标明出处链接:
  • 相关文章
  • 热门下载
  • 数据修复
  • 热门标签
合作伙伴