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