出现错误后已经按照步骤进行了注册表重新注入，以及压缩修复数据库
但是重新升级后依旧提示错误！
恳求解决方案！
upgrade.log 内如如下：
------------------------------------------
add column eba sell_duration INT default 0
--OK
add column eba touch_duration INT default 0
--OK
update eba set last_sell_date='20000101' where last_sell_date='' or last_sell_date is null
--ERROR -100
--ERMSG 列名 'last_sell_date' 无效。
update eba set last_touch_date='20000101' where last_touch_date='' or last_touch_date is null
--NOT DONE, PRE ERROR
delete from app_para where para_id='soft_product_ver'
--NOT DONE, PRE ERROR
insert into app_para(para_id,para_value,note_info,warn_msg) values('soft_product_ver','20140403','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
oit upgrade to 20140403 over
Oit_Upgrade_20140418
update res_composing set emf_process_id='' where emf_process_id is null
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
drop index res_composing res_composing_pri
--NOT DONE, PRE ERROR
create unique index res_composing_pri on res_composing(res_id,sub_res_id,emf_process_id)
--NOT DONE, PRE ERROR
delete from app_para where para_id='soft_product_ver'
--NOT DONE, PRE ERROR
insert into app_para(para_id,para_value,note_info,warn_msg) values('soft_product_ver','20140418','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
oit upgrade to 20140418 over
Base_Upgrade_20140424
add column rep_chart bottom_label_direct char(1)
--NOT DONE, PRE ERROR
add column rep_chart chart_width INT default 0
--NOT DONE, PRE ERROR
add column rep_chart chart_height INT default 0
--NOT DONE, PRE ERROR
Oit_Upgrade_20140424
add column sup mio_method_id CHAR(1)
--NOT DONE, PRE ERROR
delete from app_para where para_id='soft_product_ver'
--NOT DONE, PRE ERROR
insert into app_para(para_id,para_value,note_info,warn_msg) values('soft_product_ver','20140424','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
oit upgrade to 20140424 over
delete from app_para where para_id='soft_product_ver'
--NOT DONE, PRE ERROR
insert into app_para(para_id,para_value,note_info,warn_msg) values('soft_product_ver','20140430','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
oit upgrade to 20140430 over
Oit_Upgrade_20140506
delete from app_grid_fmt_def where col_id='dept_name' and fmt_id in (select fmt_id from app_grid_fmt where owner_fmt_id='emp')
--NOT DONE, PRE ERROR
update app_grid_fmt_def set col_id='dept_name' where col_id='dept_id' and fmt_id in (select fmt_id from app_grid_fmt where owner_fmt_id='emp')
--NOT DONE, PRE ERROR
delete from app_grid_fmt_def where col_id='dept_post_name' and fmt_id in (select fmt_id from app_grid_fmt where owner_fmt_id='emp')
--NOT DONE, PRE ERROR
update app_grid_fmt_def set col_id='dept_post_name' where col_id='dept_post' and fmt_id in (select fmt_id from app_grid_fmt where owner_fmt_id='emp')
--NOT DONE, PRE ERROR
alter column evm_io ass_num DECIMAL(14,4) NULL
--NOT DONE, PRE ERROR
alter column evm_v_item ass_num DECIMAL(14,4) NULL
--NOT DONE, PRE ERROR
alter column evm_account beg_num DECIMAL(14,4) NULL
--NOT DONE, PRE ERROR
alter column evm_account a_num DECIMAL(14,4) NULL
--NOT DONE, PRE ERROR
alter column evm_account b_num DECIMAL(14,4) NULL
--NOT DONE, PRE ERROR
alter column evm_account_sep num DECIMAL(14,4) NULL
--NOT DONE, PRE ERROR
alter column evm_account_sep_cycle num DECIMAL(14,4) NULL
--NOT DONE, PRE ERROR
alter column evm_init ass_num DECIMAL(14,4) NULL
--NOT DONE, PRE ERROR
alter column evm_init a_num DECIMAL(14,4) NULL
--NOT DONE, PRE ERROR
alter column evm_init b_num DECIMAL(14,4) NULL
--NOT DONE, PRE ERROR
delete from app_para where para_id='soft_product_ver'
--NOT DONE, PRE ERROR
insert into app_para(para_id,para_value,note_info,warn_msg) values('soft_product_ver','20140506','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
oit upgrade to 20140506 over
Base_Upgrade_20140515
create table tbx_sms_list ( rec_id INT default 0 , create_user_id VARCHAR(8) , remote_nbr VARCHAR(20) , msg VARCHAR(200) , create_date CHAR(8) , create_time CHAR(6) , allow_beg_time_stamp CHAR(14) , exceed_minute INT default 0 , state CHAR(1) , send_date CHAR(8) , send_time CHAR(6) , sms_type VARCHAR(8) )
--NOT DONE, PRE ERROR
create unique index tbx_sms_list_pri on tbx_sms_list(rec_id)
--NOT DONE, PRE ERROR
create table tbx_sms_to_send ( rec_id INT default 0 )
--NOT DONE, PRE ERROR
create unique index tbx_sms_to_send_pri on tbx_sms_to_send(rec_id)
--NOT DONE, PRE ERROR
delete from app_para where para_id='soft_product_ver'
--NOT DONE, PRE ERROR
insert into app_para(para_id,para_value,note_info,warn_msg) values('soft_product_ver','20140515','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
oit upgrade to 20140515 over
Oit_Upgrade_20140521
add column wage_work_price beg_num DECIMAL(10,2) default 0
--NOT DONE, PRE ERROR
add column wage_work_price end_num DECIMAL(10,2) default 0
--NOT DONE, PRE ERROR
add column wage_work_price ext_1 VARCHAR(80)
--NOT DONE, PRE ERROR
add column wage_work_price ext_2 VARCHAR(80)
--NOT DONE, PRE ERROR
add column wage_work_price ext_3 VARCHAR(80)
--NOT DONE, PRE ERROR
add column wage_work_price ext_4 VARCHAR(80)
--NOT DONE, PRE ERROR
add column wage_work_price ext_5 VARCHAR(80)
--NOT DONE, PRE ERROR
add column wage_work_price ext_6 VARCHAR(80)
--NOT DONE, PRE ERROR
add column wage_work_price ext_7 VARCHAR(80)
--NOT DONE, PRE ERROR
add column wage_work_price ext_8 VARCHAR(80)
--NOT DONE, PRE ERROR
delete from app_para where para_id='soft_product_ver'
--NOT DONE, PRE ERROR
insert into app_para(para_id,para_value,note_info,warn_msg) values('soft_product_ver','20140521','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
oit upgrade to 20140521 over
Oit_Upgrade_20140528
add column evm_cash_subject_map ab_flag CHAR(1)
--NOT DONE, PRE ERROR
update evm_cash_subject_map set ab_flag='A'
--NOT DONE, PRE ERROR
delete from ebs_vr_item_attr where attr_val='' or attr_val is null
--NOT DONE, PRE ERROR
delete from app_para where para_id='soft_product_ver'
--NOT DONE, PRE ERROR
insert into app_para(para_id,para_value,note_info,warn_msg) values('soft_product_ver','20140528','产品版本标识','不允许修改,修改后会导致系统无法正常运行')
--NOT DONE, PRE ERROR
commit
--NOT DONE, PRE ERROR
oit upgrade to 20140528 over |
