用友修改UFSYSTEM最大单据号SQL语句_免费下载.doc

用友修改ufsystem最大单据号sql语句故障1：在保存任何单据时，出现用友单据保存提示违反了primary key约束*不能在对象*中插入重复键。新增单据保存失败的情况时，在sql查询器中，执行以下语句，就能解决。故障2:不能在具有唯一索引aardrecord_pk的对象rdrecord中插入重复键的行。 不能在具有唯一索引aardrecords_pk的对象rdrecords中插入重复键的行。故障3：发货单（销售发票）不能保存，提示操作过程中发生资源共享冲突，可能单据号重复update ua_identity set ifatherid=(select max(dlid)from ufdata_008_2013.dispatchlist),ichildid=(select max(idlsid)from ufdata_008_2013.dispatchlists) where cacc_id=008 and cvouchtype=dispatch update ufsystem.ua_identity set ifatherid=(select case when max(sbvid) is not null then max(sbvid) else 0 end as id from ufdata_008_2013.salebillvouch),ichildid=(select case when max(autoid) is not null then max(autoid) else 0 end as autoid from ufdata_008_2013.salebillvouchs)where cacc_id=008 and cvouchtype=billvouch goupdate ufsystem.ua_identity set ifatherid=(select case when max(poid) is not null then max(poid) else 0 end as id from ufdata_008_2013.po_pomain),ichildid=(select max(id) as autoid from ufdata_008_2013.po_podetails)where cacc_id=008 and cvouchtype=pomain goupdate ufsystem.ua_identity set ifatherid=(select case when max(id) is not null then max(id) else 0 end as id from ufdata_008_2013.justinvouch),ichildid=(select case when max(autoid) is not null then max(autoid) else 0 end as autoid from ufdata_008_2013.justinvouchs)where cacc_id=008 and cvouchtype=jugoupdate ufsystem.ua_identity set ifatherid=(select case when max(id) is not null then max(id) else 0 end as id from ufdata_008_2013.pu_arrivalvouch),ichildid=(select case when max(autoid) is not null then max(autoid) else 0 end as autoid from ufdata_008_2013.pu_arrivalvouchs)where cacc_id=008 and cvouchtype=puarrivalgoupdate ufsystem.ua_identity set ifatherid=(select case when max(id) is not null then max(id) else 0 end as id from ufdata_008_2013.pu_appvouch),ichildid=(select case when max(autoid) is not null then max(autoid) else 0 end as autoid from ufdata_008_2013.pu_appvouchs)where cacc_id=008 and cvouchtype=puappgoupdate ufsystem.ua_identity set ifatherid=(select case when max(pbvid)is not null then max(pbvid) else 0 end as id from ufdata_008_2013.purbillvouch),ichildid=(select case when max(id) is not null then max(id) else 0 end as autoid from ufdata_008_2013.purbillvouchs)where cacc_id=008 and cvouchtype=purbillgoupdate ufsystem.ua_identity set ifatherid=(select case when max(psvid)is not null then max(psvid) else 0 end as id from ufdata_008_2013.pursettlevouch),ichildid=(select case when max(id) is not null then max(id) else 0 end as autoid from ufdata_008_2013.pursettlevouchs)where cacc_id=008 and cvouchtype=purstidgoupdate ufsystem.ua_identity set ifatherid=(select case when max(id) is not null then max(id) else 0 end as id from ufdata_008_2013.sa_quomain),ichildid=(select case when max(autoid) is not null then max(autoid) else 0 end as autoid from ufdata_008_2013.sa_quodetails)where cacc_id=008 and cvouchtype=quomaingoupdate ufsystem.ua_identity set ifatherid=(select case when max(id)is not null then max(id) else 0 end as id from ufdata_008_2013.so_somain),ichildid=(select case when max(isosid) is not null then max(isosid) else 0 end as isosid from ufdata_008_2013.so_sodetails)where cacc_id=008 and cvouchtype=somaingoupdate ufsystem.ua_identity set ifatherid=(select case when max(iid)is not null then max(iid) else 0 end as id from ufdata_008_2013.ap_closebill),ichildid=(select case when max(id)is not null then max(id) else 0 end as autoid from ufdata_008_2013.ap_closebills)where cacc_id=008 and cvouchtype=skgoupdate ufsystem.ua_identity set ifatherid=(select case when max(id)is not null then max(id) else 0 end as id from ufdata_008_2013.transvouch),ichildid=(select case when max(autoid)is not null then max(autoid) else 0 end as autoid from ufdata_008_2013.transvouchs)where cacc_id=008 and cvouchtype=trgoupdate ufsystem.ua_identity set ifatherid=(select case when max(id)is not null then max(id) else 0 end as id from ufdata_008_2013.expensevouch),ichildid=(select case when max(autoid)is not null then max(autoid) else 0 end as autoid from ufdata_008_2013.expensevouchs)where cacc_id=008 and cvoucht