U8.52升级U10报错帮看下啊!!
860升级关闭了系统数据库连接
重新打开了系统数据库连接
开始读取升级列表
结束读取升级列表
开始事务
数据库名: UFDATA_056_2010
C:\U8SOFT\Admin\SQLFILE8600\Main\Ufdata\DSTR860_HR_HM.sql
错误信息:
-2147217900
对象'PK_hr_hi_person' 依赖于 列'cPsn_Num'。
执行如下语句时出错:
/*=============================================================*/
/* 脚本名称: U8人事信息管理8.60建库脚本 */
/* DBMS name: Microsoft SQL Server 2000 */
/* Created on: 2004-6-28 */
/* Created by: 王皓,赵勐 */
/*=============================================================*/
-----------------从851A升级到数据库860----------------------------
if not exists(select id from sysobjects where name='hr_hi_person' and type='U')
begin
-----------------从851A升级到数据库852----------------------------
--删除hr_hi_assist表 此表已去掉不再使用
if exists (select 1
fromsysobjects
whereid = object_id('hr_hi_assist')
and type = 'U')
drop table hr_hi_assist
---删除试图
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR21')
and type = 'V')
drop view hr_v_HR21
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR21_show')
and type = 'V')
drop view hr_v_HR21_show
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR22')
and type = 'V')
drop view hr_v_HR22
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR22_show')
and type = 'V')
drop view hr_v_HR22_show
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR23')
and type = 'V')
drop view hr_v_HR23
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR23_show')
and type = 'V')
drop view hr_v_HR23_show
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR24')
and type = 'V')
drop view hr_v_HR24
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR24_show')
and type = 'V')
drop view hr_v_HR24_show
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR25')
and type = 'V')
drop view hr_v_HR25
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR25_show')
and type = 'V')
drop view hr_v_HR25_show
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR26')
and type = 'V')
drop view hr_v_HR26
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR26_show')
and type = 'V')
drop view hr_v_HR26_show
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR27')
and type = 'V')
drop view hr_v_HR27
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR28')
and type = 'V')
drop view hr_v_HR28
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR31')
and type = 'V')
drop view hr_v_HR31
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR31_show')
and type = 'V')
drop view hr_v_HR31_show
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR32')
and type = 'V')
drop view hr_v_HR32
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR32_show')
and type = 'V')
drop view hr_v_HR32_show
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR33')
and type = 'V')
drop view hr_v_HR33
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR33_show')
and type = 'V')
drop view hr_v_HR33_show
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR41')
and type = 'V')
drop view hr_v_HR41
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR41_show')
and type = 'V')
drop view hr_v_HR41_show
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR42')
and type = 'V')
drop view hr_v_HR42
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR42_show')
and type = 'V')
drop view hr_v_HR42_show
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR43')
and type = 'V')
drop view hr_v_HR43
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR33_show')
and type = 'V')
drop view hr_v_HR43_show
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR41')
and type = 'V')
drop view hr_v_HR41
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR41_show')
and type = 'V')
drop view hr_v_HR41_show
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR42')
and type = 'V')
drop view hr_v_HR42
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR42_show')
and type = 'V')
drop view hr_v_HR42_show
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR43')
and type = 'V')
drop view hr_v_HR33
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR43_show')
and type = 'V')
drop view hr_v_HR43_show
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR51')
and type = 'V')
drop view hr_v_HR51
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR51_show')
and type = 'V')
drop view hr_v_HR51_show
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR52')
and type = 'V')
drop view hr_v_HR52
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR52_show')
and type = 'V')
drop view hr_v_HR52_show
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR53')
and type = 'V')
drop view hr_v_HR53
if exists (select 1
fromsysobjects
whereid = object_id('hr_v_HR53_show')
and type = 'V')
drop view hr_v_HR53_show
--------------------------------职务职能---------------------------------
/*==============================================================*/
/* Database name:U8_HR_OM */
/* DBMS name: Microsoft SQL Server 2000 */
/* Created on: 2004-02-17 12:29:29 */
/*==============================================================*/
if exists (select 1
fromsysobjects
whereid = object_id('hr_om_calCtrl')
and type = 'U')
drop table hr_om_calCtrl
if exists (select 1
fromsysobjects
whereid = object_id('hr_om_changeInfo')
and type = 'U')
drop table hr_om_changeInfo
if exists (select 1
fromsysobjects
whereid = object_id('hr_om_corpctrl')
and type = 'U')
drop table hr_om_corpctrl
if exists (select 1
fromsysobjects
whereid = object_id('hr_om_deptctrl')
and type = 'U')
drop table hr_om_deptctrl
if exists (select 1
fromsysobjects
whereid = object_id('hr_om_duty')
and type = 'U')
drop table hr_om_duty
if exists (select 1
fromsysobjects
whereid = object_id('hr_om_dutydesc')
and type = 'U')
drop table hr_om_dutydesc
if exists (select 1
fromsysobjects
whereid = object_id('hr_om_dutygoal')
and type = 'U')
drop table hr_om_dutygoal
if exists (select 1
fromsysobjects
whereid = object_id('hr_om_dutypower')
and type = 'U')
drop table hr_om_dutypower
if exists (select 1
fromsysobjects
whereid = object_id('hr_om_dutyresp')
and type = 'U')
drop table hr_om_dutyresp
if exists (select 1
fromsysobjects
whereid = object_id('hr_om_equipment')
and type = 'U')
drop table hr_om_equipment
if exists (select 1
fromsysobjects
whereid = object_id('hr_om_job')
and type = 'U')
drop table hr_om_job
if exists (select 1
fromsysobjects
whereid = object_id('hr_om_jobCtrl')
and type = 'U')
drop table hr_om_jobCtrl
if exists (select 1
fromsysobjects
whereid = object_id('hr_om_jobcont')
and type = 'U')
drop table hr_om_jobcont
if exists (select 1
fromsysobjects
whereid = object_id('hr_om_jobdesc')
and type = 'U')
drop table hr_om_jobdesc
if exists (select 1
fromsysobjects
whereid = object_id('hr_om_jobdevpro')
and type = 'U')
drop table hr_om_jobdevpro
if exists (select 1
fromsysobjects
whereid = object_id('hr_om_jobgoal')
and type = 'U')
drop table hr_om_jobgoal
if exists (select 1
fromsysobjects
whereid = object_id('hr_om_jobpower')
and type = 'U')
drop table hr_om_jobpower
if exists (select 1
fromsysobjects
whereid = object_id('hr_om_jobresp')
and type = 'U')
drop table hr_om_jobresp
if exists (select 1
fromsysobjects
whereid = object_id('hr_om_jobsuperv')
and type = 'U')
drop table hr_om_jobsuperv
if exists (select 1
fromsysobjects
whereid = object_id('hr_om_jobtraining')
and type = 'U')
drop table hr_om_jobtraining
if exists (select 1
fromsysobjects
whereid = object_id('hr_om_succession')
and type = 'U')
drop table hr_om_succession
/*==============================================================*/
/* Table: hr_om_calCtrl */
/*==============================================================*/
create table hr_om_calCtrl (
pk_hr_om_calCtrl UFUID not null,
dyear char(4) null,
cDepCode varchar(12) null,
cJobCode varchar(20) null,
ictrlNumber int null,
iRealNumber int null,
iDiffNumber int null,
constraint PK_HR_OM_CALCTRL primary key(pk_hr_om_calCtrl)
)
帮忙顶下~~~~~~~~~~~~~~~~~~~~~~~ -2147217900 这个错误代码的错误你看看U8帮助,先按照帮助处理这个错误,然后再执行升级。升级的时候数据库的连接数不要太多,比如不要同时升级多个帐套那种。
然后在进行升级,看错误信息。这次报错没给出具体报错代码啊: -2147217900 这个错误代码的错误你看看U8帮助,先按照帮助处理这个错误,然后再执行升级。升级的时候数据库的连接数不要太多,比如不要同时升级多个帐套那种。
页:
[1]